ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jeff Butler" <jeffgbut...@gmail.com>
Subject Re: Ibatis 2.0.8/Oracle 9 question: rollback on select
Date Tue, 15 May 2007 20:42:47 GMT
I'll speak to WebSphere (which has a similar issue).  This generally
improves performance because the app server doesn't need to do anything to
clean up abandoned transactions.  But all performance statements are best
prefixed with "your milage may vary".

Jeff Butler



On 5/15/07, Herbert Wu <herbertwu@gmail.com> wrote:
>
> Is this going to cause database server performance issue if the SELECT
> traffic is heavy?
> -Herbert
>
> On 5/15/07, Jeff Butler <jeffgbutler@gmail.com> wrote:
> > This could be related to the underlying app server - iBATIS will always
> > start a transaction, but will not always commit the transaction.  In
> some
> > case this will cause the app server to rollback the transaction.  To
> alter
> > this behavior, specify this:
> >
> > <transactionManager type="JDBC" commitRequired="true">
> >    ....
> > </transactionManager>
> >
> > Jeff Butler
> >
> >
> >
> > On 5/15/07, Herbert Wu <herbertwu@gmail.com> wrote:
> > > I am using Java iBatis 2.0.8 and Oracle DBA reported that a single
> > > SELECT can trigger rollback. I did not use any transaction:
> > > <transactionManager type="JDBC" >
> > >    <dataSource type="JNDI">
> > >    <property name="DataSource" value="java:/oracleDBSource"/>
> > > </dataSource>
> > > </transactionManager>
> > >
> > > So I copied the ibatis
> > >
> > com.ibatis.sqlmap.engine.transaction.jdbc.JdbcTransaction.java
> /JdbcTransactionConfig.java
> > > to create a TestTransactionConfig.java tx manager to plug in
> > >
> > > <transactionManager type=" TestTransactionConfig.java" >
> > >    <dataSource type="JNDI">
> > >    <property name="DataSource" value="java:/oracleDBSource"/>
> > > </dataSource>
> > > </transactionManager>
> > >
> > > So when I step over this TestTransactionConfig.java and did not see
> > > rollback() method is called.
> > >
> > > i am wondering if anyone has issue with Ibatis 2.0.8 rollback on
> > > select? Or it caused by underlying Oracle JDBC driver?
> > >
> > > Your help is greatly appreciated.
> > >
> > > -Herbert
> > >
> >
> >
>

Mime
View raw message