JDBC Checker

From MediaWiki

(Difference between revisions)
Jump to: navigation, search
(New page: 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 [...)
Line 25: Line 25:
             <!-- Uncomment in the case of Oracle database -->
             <!-- Uncomment in the case of Oracle database -->
             <!-- select 1; -->
             <!-- select 1; -->
-
    </sql>
+
            </sql>
   </target>
   </target>
   </project>
   </project>

Revision as of 18:10, 31 January 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 to check 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>
           select * from tab;
           </sql>
  </target>
  </project>
Personal tools