Hi Edwin, depending on your database you might need a few manual modifications.
In my case with Oracle 9i and Torque 3.1 I encountered the following problems yesterday +) the default value for TIMESTAMP (=SYSDATE) confuses Torque +) with BLOB no datatype is inserted which results in compile errors +) all my NUMBERs get mapped to Decimal even if INTEGER is appropriate +) you should add the database name to the <database> element in resulting XML schema file I consider writing a tiny XSLT to fix the thingies by using the ANT xsl task ... in this case I have complete round-trip engineering Cheers, Siegfried Goeschl -----Original Message----- From: Sperlich, Tino [mailto:[EMAIL PROTECTED] Sent: Thursday, January 29, 2004 1:00 PM To: Apache Torque Users List Subject: AW: Creating XML Database schema file from existing Database schema. Hi, try setting up your Torque project as described in the user guide. (especially edit torque.properties to reflect your db-setting) then run the build-torque.xml with ant using the task "jdbc" , that connects to your db and generates and xxx-schema.xml On my machine it took a while for the task to complete (~10-15 min), but it was running stable... HTH, TIno -----Ursprüngliche Nachricht----- Von: Edwin Yearwood [mailto:[EMAIL PROTECTED] Gesendet: Donnerstag, 29. Januar 2004 12:55 An: [EMAIL PROTECTED] Betreff: Creating XML Database schema file from existing Database schema. Hi, Does anyone know whether torque can create the XML database schema file "myproject-schema.xml" from an existing Database schema. If this question has been asked before can you direct me to the answer in torque's mail archive. Thanks. Edwin Yearwood Developer BTG Reuters Telephone +44 (0)208 542 5818 Email [EMAIL PROTECTED] Reuters Messaging [EMAIL PROTECTED] -------------------------------------------------------------- -- Visit our Internet site at http://www.reuters.com Get closer to the financial markets with Reuters Messaging - for more information and to register, visit http://www.reuters.com/messaging Any views expressed in this message are those of the individual sender, except where the sender specifically states them to be the views of Reuters Ltd. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
