Thanks Sperlich, That did the trick, whoo hoo!
Edwin Yearwood Developer BTG Reuters Telephone +44 (0)208 542 5818 Email [EMAIL PROTECTED] Reuters Messaging [EMAIL PROTECTED] -----Original Message----- From: Sperlich, Tino [mailto:[EMAIL PROTECTED] Sent: 29 January 2004 13:51 To: Apache Torque Users List Subject: AW: Creating XML Database schema file from existing Database schema. Hi Edwin, you are right, it's build.properties One thing strikes me here, use UPPERCASE for your schema name, e.g. IDEMP here is my file for reference: torque.addGetByNameMethod = true torque.database.driver = oracle.jdbc.driver.OracleDriver torque.database.host = <host-IP> torque.project = pzp torque.database.schema = PORTAL_PZP torque.database.manualCreation = true torque.database.user = portal_pzp torque.database.url = jdbc:oracle:thin:@<host-IP>:1521:alias torque.database.password = xxxx torque.database = oracle torque.database.name = pzp torque.useManagers = false torque.sameJavaName = false torque.addTimeStamp = true torque.basePrefix = Base torque.complexObjectModel = true torque.useClasspath = false torque.targetPackage = de.xxxx torque.java.dir = ../WEB-INF/src torque.addIntakeRetrievable = false torque.addSaveMethod = true HTH, Tino -----Ursprüngliche Nachricht----- Von: Edwin Yearwood [mailto:[EMAIL PROTECTED] Gesendet: Donnerstag, 29. Januar 2004 14:47 An: Apache Torque Users List Betreff: RE: Creating XML Database schema file from existing Database schema. Hi Sperlich, Should I be using torque.properties or build.properties. I thought torque.properties was used during execution and build.properties for class generation and other such build requirements. Anyway the resulting schema file is empty, but the "ant -f build-torque.xml jdbc" completes successfully, have you any idea why this would happen. Here's an example of my build.properties. torque.targetPackage = com.reuters.torque torque.database.createUrl = jdbc:oracle:thin:@<host>:<port>:idem torque.database.buildUrl = jdbc:oracle:thin:@<host>:<port>:idem torque.database.url = jdbc:oracle:thin:@<host>:<port>:idem torque.database.driver = oracle.jdbc.driver.OracleDriver torque.database.user = idemp torque.database.password = idemp torque.database.host = <host> torque.database = oracle torque.sameJavaName = false torque.database.default=idem torque.database.schema = idemp torque.database.idem.adapter=oracle torque.project = idem Thanks. Edwin Yearwood Developer BTG Reuters Telephone +44 (0)208 542 5818 Email [EMAIL PROTECTED] Reuters Messaging [EMAIL PROTECTED] -----Original Message----- From: Sperlich, Tino [mailto:[EMAIL PROTECTED] Sent: 29 January 2004 12:00 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] --------------------------------------------------------------- - 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] --------------------------------------------------------------- - 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]
