JDBC Checker
From MediaWiki
This is a simple way of checking compatibility between JDBC driver and database with Ant. Ant has integrated support for access to SQL databases which is used by following build file
[dusan@woodoo JDBCChecker]$ cat build.xml <project name="JDBC Checker" default="check" basedir="."> <description> ANT build file which allows checking the compatibility between JDBC driver and database. </description> <target name="check"> <sql driver="<insert JDBC URL>" onerror="stop" url="<insert connection URL>" userid="<insert user name>" password="<insert password>"> <classpath> <pathelement path="<insert path to JDBC driver here>"/> </classpath> </sql> </target> </project>
Possible values of the JDBC URL are: jdbc.driver.OracleDriver
, oracle.jdbc.driver.OracleDriver
,... in the case of Oracle database or com.mysql.jdbc.Driver
,... in the case of MySQL database.
Possible values of the connection URL are: jdbc:oracle:thin:@machine_name:port_number:instance_name
for the Orace Type 4 JDBC Driver or jdbc:mysql://host_name:port/dbname
for the MySQL Connector/J JDBC Driver.
If ant check
command retrieves something like
[dusan@woodoo jdbc]$ ant check Buildfile: build.xml check: [sql] Executing commands [sql] 1 of 1 SQL statements executed successfully BUILD SUCCESSFUL Total time: 1 second
your JDBC driver is compatible with DB, otherwise it is not and you should change it.