Thats the way it works. It's limited in what it converts to xml schema. You will have
to add a lot of additional properties/entities manually.
-Sarav
-----Original Message-----
From: Derek Anderson <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Date: Wed, 04 Aug 2004 08:51:06 -0500
Subject: Generating XML from JDBC connection
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,
--
-- ----------------------------------------------- --
~ ____ ___ ___ Derek C. Anderson ~
~ | _ | _ \| __| Computer Scientist / Tech Lead ~
~ | | || __/|| Computer Sciences Corporation ~
~ | |_|| \ ||_-- http://kered.org/professional ~
~ (_)___|_|_\|___/ [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]
