Exception : J2CA0086W: Shareable connection Managed connection State:STA TE_TRAN_WRAPPER_INUSE

[Bikash Paul]

Hi,

I'm working on very old application which is deployed in WAS5.1. I'm getting very weird behavior from WAS5.1.

I was getting below error so I have changed the res-sharing-scope of the connection to be 'Unshareable' in the web.xml file but after deployment I can see it becomes 'Shareable' in the web.xml file.

[6/12/12 16:52:42:336 CDT] 2c7824d9 SharedPool I J2CA0086W: Shareable connection MCWrapper id 7426e4ff Managed connection com.ibm.ws.rsadapter.spi.WSRdbManagedConnectionImpl@2e1a24ff State:STA
TE_TRAN_WRAPPER_INUSE
from resource jdbc/AIPOnlineDB was used within a local transaction containment boundary.

Here is the code snippet from web.xml file

<!-- JDBC DataSources (java:comp/env/jdbc) -->  
    <resource-ref id="ResourceRef_AIPOnlineDB">
   	  <description>AIP Online Database</description>
   	  <res-ref-name>jdbc/AIPOnlineDB</res-ref-name>
   	  <res-type>javax.sql.DataSource</res-type>	  
   	  <res-auth>Container</res-auth>
	  <res-sharing-scope>Unsharable</res-sharing-scope>
    </resource-ref>

Could you please give me any clue why WAS5.1 is behaving like this.

Thanks,
-Bikash