Yes, iBATIS will rollback the connection if it deems it necessary.  The only
time you might need to call rollback explicitly is if you have a "select"
that actually updates data in the database.  Such is sometimes the case with
stored procedures.

Clinton

2010/4/5 François Schiettecatte <fschietteca...@gmail.com>

> If you start a transaction or don't have auto-commit on, then the
> transaction will be rolled back. At least that is what I am seeing which
> makes sense to me.
>
> F.
>
> On Apr 5, 2010, at 12:38 PM, cowwoc wrote:
>
> > Hi,
> >
> >    What happens if I close() a SqlSession without committing? Does iBatis
> guarantee that the transaction will roll back? I ask because I want to use
> the following pattern:
> >
> > SqlSession session = factory.openSession();
> > try
> > {
> >  // do work
> >  session.commit();
> > }
> > finally
> > {
> >  session.close();
> > }
> >
> >    If no exception is thrown, the session gets committed. Otherwise, it
> is rolled back without having to catch exceptions and explicitly roll back.
> >
> > Thanks,
> > Gili
> >
> > ---------------------------------------------------------------------
> > To unsubscribe, e-mail: user-java-unsubscr...@ibatis.apache.org
> > For additional commands, e-mail: user-java-h...@ibatis.apache.org
> >
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-java-unsubscr...@ibatis.apache.org
> For additional commands, e-mail: user-java-h...@ibatis.apache.org
>
>

Reply via email to