Re: how can i Insert data into multiple table at a time

2008-08-24 Thread DavidZ
and you may want to use transaction here when inserting records to multiple tables: Connection connection = null; try { connection = Transaction.begin(YouOMPeer.DATABASE_NAME); r1.save(); r2.setRefIndexId(r1.getIndex());

Re: how can i Insert data into multiple table at a time

2008-08-22 Thread Frank Nguyen
There is no difference b/w inserting into 1 table or multiple tables from a single form transaction. Read the tutorial at: http://db.apache.org/torque/releases/torque-3.1.1/user-guide.html If the second adding/inserting needs a ref index from previous inserted row, do something like: r1.save()

RE: how can i Insert data into multiple table at a time

2008-08-20 Thread Thomas Fischer
>i am new to apache torque. How can i insert data in to > multiple table at one time hit. Hm, I do not know what you mean by that. Please make yourself familiar with the appropriate Database concepts (update/insert and transaction). These are supported by Torque. > Actually i have a fo