ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Clifford Marks" <cliffordma...@hotmail.com>
Subject Re: Websphere 6 + iBatis + DB2 iSeries problem
Date Thu, 22 Jun 2006 13:37:49 GMT
Unscribe this user group


>From: "Jeff Butler" <jeffgbutler@gmail.com>
>Reply-To: user-java@ibatis.apache.org
>To: user-java@ibatis.apache.org
>Subject: Re: Websphere 6 + iBatis + DB2 iSeries problem
>Date: Thu, 22 Jun 2006 08:32:49 -0500
>
>I doubt this is an iBATIS issue.  We have a large appliation using WAS6,
>DB2, iBATIS and don't see these problems.
>
>With your transaction configuration you are relying on WebSphere to commit
>the transactions.  To me, this implies you are using EJBs - so I would 
>check
>the EJB configuration first to see if you've properly configured the
>transactional behavior of the EJBs.
>
>If you are not using EJBs, then this transaction configuration is not
>appropriate on WebSphere - unless you've configured some proprietary
>WebSphere extensions to deal with container managed transactions with
>servlets.  If you are not using EJBs, then this is a more appropriate
>transaction configuration:
>
><transactionManager type="JTA" commitRequired="true">
>  <property name="UserTransaction" value="java:comp/UserTransaction"/>
>  <dataSource type="JNDI">
>    <property name="DataSource" value="${DBSOURCE}"/>
>  </dataSource>
></transactionManager>
>
>Jeff Butler
>
>
>
>On 6/22/06, cantohi@kepler-rominfo.com <cantohi@kepler-rominfo.com> wrote:
>>
>>Hi,
>>
>>We are facing a very big problem with WAS6 + iBatis 2.1.5 + DB3 iSeries
>>(V%R3M0).
>>
>>We are performing the stressing test and after a while (usually 30-60
>>minutes) af activity, the connection pool from Websphere become full (100
>>connections allocated from 100) and everything is stucked. This happens in
>>2 minutes and before everithing is going very smoothly ...
>>
>>We have tried many configuration like:
>>- lazyLoadingEnabled="false"
>><transactionManager commitRequired="true" type="EXTERNAL" >
>>      <property name="DefaultAutoCommit" value="false" />
>>      <property name="SetAutoCommitAllowed" value="false" />
>>      <dataSource type="JNDI">
>>               <property name="DataSource" value="${DBSOURCE}"/>
>>        </dataSource>
>></transactionManager>
>>
>>There is no error message except "Timeout waiting for free connection
>>...".
>>
>>On iSeries we are seeing all 100 connections open but nothing si locked
>>(rows, tables), nothing runs in each connection ... seems like they are in
>>wait.
>>
>>On Websphere we see:
>>com.ibm.ws.LocalTransaction.LocalTranCoordImpl@2993a251;RUNNING;
>>MCWrapper id 828224d  Managed connection
>>WSRdbManagedConnectionImpl@4c58624c  State:STATE_TRAN_WRAPPER_INUSE Thread
>>Id: 5b75a268 Thread Name: WebContainer : 74 Handle count 0
>>
>>We are asking if they may be some problems between iBatis and Websphere
>>...
>>
>>Please help!
>>
>>Thank you,
>>Cornel
>>
>>



Mime
View raw message