JDBC Checker

From MediaWiki

Revision as of 09:26, 11 February 2008 (view source) Dusan (Talk | contribs) ← Older edit		Revision as of 09:31, 11 February 2008 (view source) Dusan (Talk | contribs) Newer edit →
Line 28:		Line 28:
	</target>		</target>
	</project>		</project>
		+
		+	Possible values of the JDBC URL are: <code>jdbc.driver.OracleDriver</code>, <code>oracle.jdbc.driver.OracleDriver</code>,... in the case of Oracle database or <code>com.mysql.jdbc.Driver</code>,... in the case of MySQL database.
		+
		+	Possible values of the connection URL are: <code>jdbc:oracle:thin:@machine_name:port_number:instance_name</code> for the Orace Type 4 JDBC Driver or <code>jdbc:mysql://host_name:port/dbname</code> for the MySQL Connector/J JDBC Driver.
		+
		+	If <code>ant check</code> 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.

---

Revision as of 09:31, 11 February 2008

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.