You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ant.apache.org by Sr...@timeinc.com on 2007/08/13 18:49:39 UTC

Problem using sql task with ant 1.6.5

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)


Re: Problem using sql task with ant 1.6.5

Posted by ericswebber <er...@yahoo.com>.

Our build fails too, we are also attempting to use the java database,
hsqldb,  with Spring Framework 

ERROR MESSAGE:  java.sql.SQLException: No suitable Driver for
jdbc.hsqldb:db/test

Please let us know if you need the build.xml too, it is the standard spring
MVC getting started tutorial...

Here is the ant output.

C:\dl\java\spring\projects\springapp>ant createTables loadData printData
Buildfile: build.xml

createTables:
     [echo] CREATE TABLES USING: org.hsqldb.jdbcDriver jdbc.hsqldb:db/test

BUILD FAILED
C:\dl\java\spring\projects\springapp\build.xml:205: java.sql.SQLException:
No su
itable Driver for jdbc.hsqldb:db/test

Total time: 2 seconds
C:\dl\java\spring\projects\springapp>ant createTables loadData printData
Buildfile: build.xml

createTables:
     [echo] CREATE TABLES USING: org.hsqldb.jdbcDriver jdbc.hsqldb:db/test

BUILD FAILED
C:\dl\java\spring\projects\springapp\build.xml:205: java.sql.SQLException:
No su
itable Driver for jdbc.hsqldb:db/test

Total time: 9 seconds
C:\dl\java\spring\projects\springapp>


-- 
View this message in context: http://www.nabble.com/Problem-using-sql-task-with-ant-1.6.5-tf4262377.html#a12596421
Sent from the Ant - Users mailing list archive at Nabble.com.


---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@ant.apache.org
For additional commands, e-mail: user-help@ant.apache.org


Re: Problem using sql task with ant 1.6.5

Posted by Steve Loughran <st...@apache.org>.
Srikrishna_Parthasarathy@timeinc.com wrote:
> Do you need to any specific to use sql task in ant 1.6.5? Is there a
> work around ?
> 

It says C:\projects\springapp\build.xml:114: Class Not Found: JDBC driver
org.hsqldb.jdb

cDriver  could not be loaded



---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@ant.apache.org
For additional commands, e-mail: user-help@ant.apache.org