db-torque-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From torque-...@db.apache.org
Subject [DB Torque Wiki] Updated: GettingTorqueToWork
Date Wed, 09 Jun 2004 19:53:30 GMT
   Date: 2004-06-09T12:53:29
   Editor: 213.94.78.65 <>
   Wiki: DB Torque Wiki
   Page: GettingTorqueToWork
   URL: http://wiki.apache.org/db-torque/GettingTorqueToWork

   no comment

Change Log:

------------------------------------------------------------------------------
@@ -294,3 +294,19 @@
 
  5. Build the Maven plugin(see also http://db.apache.org/torque/maven-howto.html): change
into the directory src/generator and run "maven plugin:install". Maven complains about not
being able to download torque-gen-3.2-dev.jar. But as this file was already created, it can
be copied from src/generator/target/torque-gen-3.2-dev.jar to the .maven/repository/torque/jars
in the home directory of the user. Running "maven plugin:install" again seemed to create the
plugin.
 -- Thomas Fischer
+
+= Using Torque with an existing database schema =
+
+ 1. Verify that the JDBC driver and connection string is working - this can be easily done
using SQL Squirrel since it is a pure JDBC client. If you can connect to your database, browse
through your tables and view the JDBC metadata everything is fine. BTW SQL Squirrel also shows
the JDBC class being used (saves you some digging through the docs)
+
+ 2. Set the Torque.properties with settings from 1. and run the 'jdbc' target to create a
schema.xml
+
+ 3. It is time to look at the schema.xml since Torque might be confused about unknown column
types and default values using proprietary SQL functions. 
+
+ 4. A good idea is to consider using complex object types by setting <database defaultJavaType="object">.
This allows NULLable values within your Torque generated classes.
+
+ 5. Now it is time to run the 'om' and 'compile' target with the update schema.xml to generate
the database layer and check if it really compiles
+
+ 6. As a final step you can create HTML documentation using the 'doc' target
+
+-- Siegfried Goeschl

---------------------------------------------------------------------
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