JDBC Checker
From MediaWiki
(Difference between revisions)
(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> | |
</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>