Hi,
you have to provide the used Oracle schema in build.properties, eg.
torque.database.schema = TEST
see the properties reference for details: http://db.apache.org/torque/generator/properties-reference.html
Micha
Derek Anderson wrote:
Hey everyone,
I'm trying to generate a schema off our existing oracle database using the torque generator. The jdbc build target is completing successfully, yet the schema file is woefully incomplete. Does anyone have a suggestion?
Here is the ant output:
C:\home\projects\EMS.torque\torque-gen-3.1>ant -f build-torque.xml jdbc Buildfile: build-torque.xml
jdbc: [echo] +-----------------------------------------------+ [echo] | | [echo] | Generating XML from JDBC connection ! | [echo] | | [echo] +-----------------------------------------------+ [torque-jdbc-transform] Torque - JDBCToXMLSchema starting [torque-jdbc-transform] Your DB settings are: [torque-jdbc-transform] driver : oracle.jdbc.driver.OracleDriver [torque-jdbc-transform] URL : jdbc:oracle:thin:@192.server.ip.1:1601:EMS920 [torque-jdbc-transform] user : ems [torque-jdbc-transform] schema : EMS920 [torque-jdbc-transform] DB driver sucessfuly instantiated [torque-jdbc-transform] DB connection established [torque-jdbc-transform] Getting table list... [torque-jdbc-transform] Building column/table map... [torque-jdbc-transform] ./schema/schema.xml [torque-jdbc-transform] Torque - JDBCToXMLSchema finished
BUILD SUCCESSFUL Total time: 2 seconds
And the resulting schema.xml:
C:\home\projects\EMS.torque\torque-gen-3.1>cat schema\schema.xml
<?xml version="1.0"?>
<!DOCTYPE database SYSTEM "http://db.apache.org/torque/dtd/database_3_1.dtd";>
<!-- Autogenerated by JDBCToXMLSchema! -->
<database/>
Thanks,
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
