ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Clinton Begin" <clinton.be...@gmail.com>
Subject Re: how can i use mutiple transction in thread?
Date Thu, 06 Jul 2006 05:16:35 GMT
Use openSession() twice...don't call .startTransaction directly on the
SqlMapClient for either of them.

Cheers,
Clinton


On 7/5/06, Hoyoung Hwang <hwangma@gmail.com> wrote:
>
> thans for your answer.
>
> but, i need not nested transaction.
> (yes, if ibatis support that, i use that model.)
>
> i want to use muliple transaction (or connection) model.
>
> i need second transaction is commit immediately.
> not dependent first transaction.
>
> in first transaction is processing,
> another transaction can commit at same thread.
>
> in example--------------
>  sqlmapclient.startTransaction();         //first transaction start
> sqlmapclient.insert("table.insert",table);
> newTrans = sqlmapclient.openSession();
> newTrans.startTransaction();              //second transaction start ,
> but it is not work.
> newTrans.insert("logtable.insert",logtable);
> newTrans.commitTransaction();
> sqlmapclient.delete("table.delete",null);
> sqlmapclient.commitTransaction();
>
>
> On 7/6/06, Clinton Begin <clinton.begin@gmail.com > wrote:
> >
> >
> > Regardless....the JDBC driver and/or database likely doesn't support
> > this.  Few databases do.  I think Sybase (and SQL Server?) support nested
> > transactions, but they're not recommended.  Oracle supports savepoints,
> > which is somewhat cleaner...but ideally you should probably just simplify
> > your transaction model so that this isn't required.
> >
> >
> > Clinton
> >
> >
> >
> > On 7/5/06, Jeff Butler <jeffgbutler@gmail.com > wrote:
> > >
> > >  iBATIS does not support nested transactions like this.
> > >
> > > Jeff Butler
> > >
> > >
> > >  On 7/3/06, Hoyoung Hwang <hwangma@gmail.com> wrote:
> > > >
> > > >  i can't use muitple transaction.
> > > > how can i use mutiple transction?
> > > >
> > > > i don't use daoManager. just using SqlMap.
> > > >
> > > > example.
> > > >
> > > > sqlmapclient.startTransaction();
> > > > sqlmapclient.insert("table.insert",table);
> > > > newTrans = sqlmapclient.openSession();
> > > > newTrans.startTransaction();
> > > > newTrans.insert("logtable.insert",logtable);
> > > > newTrans.commitTransaction();
> > > > sqlmapclient.delete("table.delete",null);
> > > > sqlmapclient.commitTransaction();
> > > >
> > > > please let me know.
> > > >
> > > >
> > > >
> > >
> > >
> >
>

Mime
View raw message