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());
....
r2.save(); }
Transaction.commit(connection);
}
catch(TorqueException e) {
Transaction.safeRollback(connection);
throw e;
}
Hope this will help.
On Fri, Aug 22, 2008 at 11:26 AM, Frank Nguyen
<[EMAIL PROTECTED]>wrote:
> 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();
> r2.setRefIndexId(r1.getIndex());
> ....
> r2.save();
>
> Hope this helps,
>
>
>
>
>
> Sasikumar Natarajan <[EMAIL PROTECTED]> wrote: Hi All,
> i am new to apache torque. How can i insert data in to multiple
> table at one time hit. Actually i have a form to get the user's input and
> need to insert data in multiple table . Please help me..
> Thanks in Advance
> Sasi
>
>
>
>
