[Db-torque Wiki] Update of "GettingTorqueToWork" by DowellGriffin

[Apache Wiki <wi...@apache.org>]

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 DowellGriffin:
http://wiki.apache.org/db-torque/GettingTorqueToWork

------------------------------------------------------------------------------
  -----
  a great hands on tutorial at http://users.volja.net/amanita1/
  
+ 
+ PROBLEM: jdbc (generate XML schema) task runs to completion, no errors but no tables are in the generated schema.xml
+ ENVRONMENT:  hsqlDB 1.7.2 and Torque GEN 3.2-rc1
+ 
+ Sample trace when problem exists:
+ 
+ [torque-jdbc-transform] Torque - JDBCToXMLSchema starting
+ [torque-jdbc-transform] Your DB settings are:
+ [torque-jdbc-transform] driver : org.hsqldb.jdbcDriver
+ [torque-jdbc-transform] URL : jdbc:hsqldb:hsql://localhost:1701/
+ [torque-jdbc-transform] user : sa
+ [torque-jdbc-transform] schema : ${torque.database.schema}
+ [torque-jdbc-transform] DB driver sucessfuly instantiated
+ 
+ SOLUTION:  
+ 
+ The clue is the schema name.  HSQLDB 1.7.2 and earlier apparently does not support schemas and the property file delivered with Torque has torque.database.schema commented out. I guess Torque finds no tables in some unknown schema and exits.  
+ 
+ Place empty assigment for the schema name into build.properties as such:
+ 
+ torque.database.schema = 
+ 
+ That works!
+ 

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