db-torque-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Apache Wiki <wikidi...@apache.org>
Subject [Db-torque Wiki] Update of "GettingTorqueToWork" by Derek Walsh
Date Thu, 10 Aug 2006 07:59:48 GMT
Dear Wiki user,

You have subscribed to a wiki page or wiki category on "Db-torque Wiki" for change notification.

The following page has been changed by Derek Walsh:
http://wiki.apache.org/db-torque/GettingTorqueToWork

------------------------------------------------------------------------------
  
  That works!
  
+ 
+ = Creating tables for an MS SQL database =
+ 
+ If you try to use the command 'maven torque:create-db' to generate your database and tables
using MS SQL, you will get an error saying:
+ 
+ 
+ ----------------------
+ [torque-data-model] Using classpath
+ [torque-data-model] Generating to file D:\Downloads\mytorquetest\target\sql\create-db.sql
+ [echo]
+       Executing the create-db.sql script ...
+ 
+ [sql] Executing file: D:\Downloads\mytorquetest\target\sql\create-db.sql
+ [sql] [ERROR] Failed to execute: ECHO Not implemented
+ [sql] [ERROR] java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Incorrect
syntax near the keyword 'Not'.
+ [sql] 0 of 1 SQL statements executed successfully
+ -----------------------
+ 
+ 
+ Don't worry if you get this error, the way around it is to manually create the database
and then use the command 'maven torque:insert-sql' to create your tables
+ 

---------------------------------------------------------------------
To unsubscribe, e-mail: torque-dev-unsubscribe@db.apache.org
For additional commands, e-mail: torque-dev-help@db.apache.org


Mime
View raw message