JDBC to XML ant task

["Grey.Lee" <Le...@SunTrust.com>]

When I stumbled on the Wiki, I saw a brief mention of the "jdbc" ant target, which seems to read an existing JDBC connection and reverse-engineer the torque XML to match it.  I have not been able to locate any other mention, nor any documentation on this function.  Is there any?  Has anyone used it?

One of the things that worries me is wiping out my existing database by not understanding the subtleties of using Torque.  Is this a legitimate concern?  Which actions can drop tables or databases?  Do you get the chance to approve or cancel before it happens?

Thanks,

Lee Grey

SunTrust Bank 
************************************************ 
The information transmitted is intended solely 
for the individual or entity to which it is  
addressed and may contain confidential and/or 
privileged material. Any review, retransmission, 
dissemination or other use of or taking action 
in reliance upon this information by persons or 
entities other than the intended recipient is 
prohibited. If you have received this email in 
error please contact the sender and delete the 
material from any computer. 
************************************************ 

---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org

Re: JDBC to XML ant task

[T E Schmitz <ma...@numerixtechnology.de>]

Print Torque's build.xml off and have a good read. Things became much 
clearer fo me then. The create-db target drops all tables and creates a 
new empty db.

You will also find the "jdbc" target, which generates an xml schema from 
your existing db.

Regards,

Tarlika Elisabeth Schmitz


Grey.Lee wrote:

> When I stumbled on the Wiki, I saw a brief mention of the "jdbc" ant target, which seems to read an existing JDBC connection and reverse-engineer the torque XML to match it.  I have not been able to locate any other mention, nor any documentation on this function.  Is there any?  Has anyone used it?
> 
> One of the things that worries me is wiping out my existing database by not understanding the subtleties of using Torque.  Is this a legitimate concern?  Which actions can drop tables or databases?  Do you get the chance to approve or cancel before it happens?



---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org

RE: JDBC to XML ant task

[Daniel Huang <da...@cisco.com>]

Don't worry. The jdbc target just read an existing db schema and writes to schema.xml. It won't harm your database. I use it almost everyday. But be aware if you are going to use the generated schema.xml to create a db schema (by using ant sql followed by ant insert-sql), you might need to manually tweak schema.xml a little bit. For example, it does not generates non-PK unique constrains.

Regards,
Daniel

-----Original Message-----
From: Grey.Lee [mailto:Lee.Grey@SunTrust.com]
Sent: Sunday, April 18, 2004 5:39 PM
To: Apache Torque Users List
Subject: JDBC to XML ant task

When I stumbled on the Wiki, I saw a brief mention of the "jdbc" ant target, which seems to read an existing JDBC connection and reverse-engineer the torque XML to match it.  I have not been able to locate any other mention, nor any documentation on this function.  Is there any?  Has anyone used it?

One of the things that worries me is wiping out my existing database by not understanding the subtleties of using Torque.  Is this a legitimate concern?  Which actions can drop tables or databases?  Do you get the chance to approve or cancel before it happens?

Thanks,

Lee Grey

SunTrust Bank
************************************************
The information transmitted is intended solely
for the individual or entity to which it is 
addressed and may contain confidential and/or
privileged material. Any review, retransmission,
dissemination or other use of or taking action
in reliance upon this information by persons or
entities other than the intended recipient is
prohibited. If you have received this email in
error please contact the sender and delete the
material from any computer.
************************************************

---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org