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: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to