ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From <Richard.Sto...@cexp.com>
Subject RE: JTA with Ibatis and JBoss
Date Fri, 01 Jun 2007 16:54:30 GMT
JBoss has the same issue.  (Or is it the iBatis TransactionManager that
has the issue?)

 

Rick Stokoe

Corporate Express US Inc.

________________________________

From: Jeff Butler [mailto:jeffgbutler@gmail.com] 
Sent: Friday, March 30, 2007 8:31 AM
To: user-java@ibatis.apache.org
Subject: Re: JTA with Ibatis and WebLogic Server

 

Try setting

 

<transactionManager type="JTA" commitRequired="true">

...

</transactionManager>
 

Without this setting, iBATIS will not commit transactions (either
automatic or explicit) that only have selects in them.  We see a similar
issue on WebSphere.

 

Jeff Butler


 

On 3/30/07, Mehul <dikshit_mehul@rediffmail.com> wrote: 


Hi
I was trying to work with JTA IBatis and WebLogic combination for my
persistence layer.
My configuration as below... 
   <transactionManager type="JTA">
           <property name="UserTransaction"
value="javax.transaction.UserTransaction"/>
           <dataSource type="JNDI"> 
               <property name="DataSource" value="jdbc/pscdb"/>
           </dataSource>
   </transactionManager>

THe problem we are facing is that IBatis is creating new connection
every 
time and the pool gets evantually exhausted. We are not starting any
tansaction for select query but the connection is not released back to
pool.
the connections are only released after the connection time out period
is 
elasped.

Is it necessary to start transaction and end them even for select query?
Or
is there something more to be done to release the connection back to
Pool.

Thanks,
--
View this message in context:
http://www.nabble.com/JTA-with-Ibatis-and-WebLogic-Server-tf3492356.html
#a9753607
Sent from the iBATIS - User - Java mailing list archive at Nabble.com.

 


Mime
View raw message