Inserting NULL for foreign refereces

2003-08-16 Thread Frederico Augusto Costa
Hi folks! I have a silly question and I was not able to find a similar case on list archive. I have a table A with the following columns: A_ID INTEGER PRIMARY NOT NULL A_NAME VARCHAR(X) NOT NULL B_ID INTEGER NULL (Is a foreign reference fo

Re: SQL 2 xml

2003-08-16 Thread Sgarlata Matt
The jdbc task handles foreign keys properly for me, although this may depend on the database (I have no idea). I am using Oracle. One thing about the task is that it doesn't always generate a file that will correctly generate your torque classes on the first try using the om task. It wasn't t

Re: SQL 2 xml

2003-08-16 Thread Dave Newton
On Sat, 2003-08-16 at 15:12, Sgarlata Matt wrote: > The jdbc ant task will take care of this for you. Just type > > ant -f build-torque.xml jdbc Heck, I didn't know that. Thanks! (And thanks for keeping it on the list; dangling questions w/o known answers don't help the global knowledge pool any

Re: SQL 2 xml

2003-08-16 Thread Sgarlata Matt
The jdbc ant task will take care of this for you. Just type ant -f build-torque.xml jdbc and assuming you have Torque configured properly, this will generate the XML file for you. Here is a full list of all of the ant tasks included with Torque: http://db.apache.org/torque/generator/ Matt

SQL 2 xml

2003-08-16 Thread Brian Adams
Hello Torquers! I may have missed this but does Torque have a way to connect to a database and generate a xml schema? In the tutorial it says to type all your tables in xml. I have hundreds of tables that I would like to use Torque as the om. Please help??? Thanks, Brian Adams -