Do you need to any specific to use sql task in ant 1.6.5? Is there a
work around ?
srikrishna
C:\projects\springapp>ant -verbose createTables
Apache Ant version 1.6.5 compiled on June 2 2005
Buildfile: build.xml
Detected Java version: 1.5 in: C:\bea92\jdk150_10\jre
Detected OS: Windows XP
parsing buildfile C:\projects\springapp\build.xml with URI =
file:///C:/projects
/springapp/build.xml
Project base dir set to: C:\projects\springapp
[property] Loading C:\projects\springapp\build.properties
Build sequence for target(s) `createTables' is [createTables]
Complete build sequence is [createTables, undeploy, loadData, build,
deploy, sta
rt, dropTables, printData, install, stop, reload, clean, list, usage,
clearData,
junit, deploywar, ]
createTables:
[echo] CREATE TABLES USING: org.hsqldb.jdbcDriver
jdbc:hsqldb:db/test
[sql] connecting to jdbc:hsqldb:db/test
[sql] Loading org.hsqldb.jdbcDriver using AntClassLoader with
classpath C
:\projects\springapp\war\WEB-INF\lib\commons-logging.jar;C:\projects\spr
ingapp\w
ar\WEB-INF\lib\hsqldb.jar;C:\projects\springapp\war\WEB-INF\lib\jstl.jar
;C:\proj
ects\springapp\war\WEB-INF\lib\log4j-1.2.14.jar;C:\projects\springapp\wa
r\WEB-IN
F\lib\spring.jar;C:\projects\springapp\war\WEB-INF\lib\standard.jar;C:\T
omcat 6.
0\lib\servlet-api.jar;C:\projects\springapp\war\WEB-INF\classes
BUILD FAILED
C:\projects\springapp\build.xml:114: Class Not Found: JDBC driver
org.hsqldb.jdb
cDriver could not be loaded
at
org.apache.tools.ant.taskdefs.JDBCTask.getDriver(JDBCTask.java:366)
at
org.apache.tools.ant.taskdefs.JDBCTask.getConnection(JDBCTask.java:30
4)
at
org.apache.tools.ant.taskdefs.SQLExec.execute(SQLExec.java:346)
at
org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:275)
at org.apache.tools.ant.Task.perform(Task.java:364)
at org.apache.tools.ant.Target.execute(Target.java:341)
at org.apache.tools.ant.Target.performTasks(Target.java:369)
at
org.apache.tools.ant.Project.executeSortedTargets(Project.java:1216)
