db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Michael Manske <netsee...@manskes.de>
Subject Re: Generating XML from JDBC connection
Date Wed, 04 Aug 2004 19:54:51 GMT
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: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org


Mime
View raw message