I'm trying to work with a new SQL server database. So, I look at the tutorial of torque and
I had a problem. When I'm trying to my table, it was ok for the first command (ant -f build-torque.xml
id-table-init-sql), but it doesn't work with the next command (ant -f build-torque.xml insert-sql).
I have the following message :
Buildfile: build-torque.xml
insert-sql:
[torque-sql-exec] Our new url -> jdbc:mssql://unis14:1433/devbib
BUILD FAILED
file:C:/sources/torque-3.0/build-torque.xml:323: java.sql.SQLException: No suita
ble Driver for jdbc:mssql://unis14:1433/devbib
I configured the build.properties as follow :
# -------------------------------------------------------------------
#
# D A T A B A S E S E T T I N G S
#
# -------------------------------------------------------------------
# JDBC connection settings. This is used by the JDBCToXML task that
# will create an XML database schema from JDBC metadata. These
# settings are also used by the SQL Ant task to initialize your
# Turbine system with the generated SQL.
#
# sameJavaName
# If true, the JDBC task will set the javaName attribute for the tables
# and columns to be the same as SQL name.
# -------------------------------------------------------------------
torque.database.createUrl = jdbc\:mssql\://unis14\:1433/mssql
torque.database.buildUrl = jdbc\:mssql\://unis14\:1433/devbib
torque.database.url = jdbc\:mssql\://unis14\:1433/devbib
torque.database.driver = com.thinweb.tds.Driver
torque.database.user = bib
torque.database.password = unis
torque.database.host = unis14
torque.sameJavaName = false
And the torque.properties
log4j.rootCategory = DEBUG, default
log4j.appender.default = org.apache.log4j.FileAppender
log4j.appender.default.file = ./torque.log
log4j.appender.default.layout = org.apache.log4j.SimpleLayout
torque.database.default=devbib
torque.database.bookstore.driver = com.microsoft.jdbc.sqlserver.SQLServerDriver
torque.database.bookstore.url = jdbc\:mssql\://unis14\:1433/devbib
torque.database.bookstore.username = bib
torque.database.bookstore.password = unis
Anyone had a similar problem or could help me? Thanks a lot...
Matthieu
---------------------------------
Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en français !
Testez le nouveau Yahoo! Mail
|