Thanks All, its such a relief knowing that torque supports this, and Göschl thanks our environment is also Oracle 9i and Torque 3.1 so your experience was extremely helpful.
Thanks again. Edwin Yearwood Developer BTG Reuters Telephone +44 (0)208 542 5818 Email [EMAIL PROTECTED] Reuters Messaging [EMAIL PROTECTED] -----Original Message----- From: "Göschl,Siegfried" [mailto:[EMAIL PROTECTED] Sent: 29 January 2004 12:18 To: Apache Torque Users List Subject: RE: Creating XML Database schema file from existing Database schema. 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] ----------------------------------------------------------------- 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]
