Thanks Adam.. this obviously solved the problem. -----Original Message----- From: Adam Murdoch [mailto:[EMAIL PROTECTED]] Sent: 08 February 2002 20:16 To: Ant Users List Subject: RE: Sql task ignoring classpath
> -----Original Message----- > From: Euan Guttridge [mailto:[EMAIL PROTECTED]] > Sent: Saturday, 9 February 2002 3:47 AM > To: '[EMAIL PROTECTED]' > Subject: Sql task ignoring classpath > > > Hi, > > Ant seems to be refusing to recognise my system classpath (W2K). > I am using > a jdbc:odbc driver in an SQL task, the driver is in the system classpath, > tested and confirmed. Even with the optional classpath attribute > in the SQL > task I still get the not found error: > > > D:\build_folder\ux_dev02\ant_buildfiles\dev2_to_staging2.xml:26: Class Not > Found > : JDBC driver sun.jdbc.odbc.JbdcOdbcDriver could not be loaded > > > <target name="sql"> > <sql > driver="sun.jdbc.odbc.JbdcOdbcDriver" ^^^^ Should be Jdbc, not Jbdc. Also, you don't need rt.jar in the classpath - you get that for free from the JVM. > url="jdbc:odbc:label_db" > userid="" > password="" > > > select * from *; > <classpath> > <pathelement location="d:\jdk_1.2.2\jre\lib\rt.jar"/> > </classpath> > </sql> > </target> > > > Thanks.. > > -- > To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> > For additional commands, e-mail: <mailto:[EMAIL PROTECTED]> -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]> -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
