db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From DavidZ <weizhao6...@gmail.com>
Subject Re: how can i Insert data into multiple table at a time
Date Fri, 22 Aug 2008 18:48:53 GMT
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
<franktnguyen@sbcglobal.net>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 <nsasi_cts@yahoo.com> 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
>
>
>
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message