make sure your mysql connector is the right version to your driver class!
and you can use some ant debug tools to print the stracktrace of it's procession to make sure
your lib is in !
------------------
julying
2007-01-20
-------------------------------------------------------------
发件人：Farid Izem
发送日期：2007-01-20 06:39:24
收件人：user@ant.apache.org
抄送：
主题：Question about Classpath
Hi all,
I'm new to ant and i d'like to make a connexion to a mysql database.
To do that, i hava done the following scripts :
<project basedir="/projets/ESE/esepro02" default="mysql">
<description>
main project with many futures
</description>
<path id="projet.classpath">
<pathelement location="classes/" />
<pathelement location="lib/" />
</path>
<target name="mysql">
<sql
driver="com.mysql.jdbc.Driver"
url="jdbc:mysql//localhost:3306/BROWSE"
userid="XXXXX"
password="YYYYY"
><![CDATA[
show tables;
]]>
</sql>
</target>
</project>
But, i get the following error :
mysql:
BUILD FAILED
/LNXVOL01/projets/ESE/esepro02/build2.xml:19: Class Not Found: JDBC driver
com.mysql.jdbc.Driver could not be loaded
I try adding <classpath refid="projet.classpath" /> in the mysql task
without success, i get the following error :
Buildfile: build2.xml
mysql:
BUILD FAILED
/LNXVOL01/projets/ESE/esepro02/build2.xml:14: Problem: failed to create task
or type classpath
Cause: The name is undefined.
Action: Check the spelling.
Action: Check that any custom tasks/types have been declared.
Action: Check that any <presetdef>/<macrodef> declarations have taken place.
Can anyone help solving this issue with the classpath element.
I'm using ant 1.7.0 and JVM 1.5.0_10-b03
Kind Regards,
Farid
|