lay
asked on
Connection Error
Hi,
I am writing an application using the following :
Tools : WSAD 5.0
App Server : WAS 5.0 (base)
Database : DB2 7.2
I have this message display in my WSAD console eventhough the transaction succeed.
"73e2485c SharedPool I J2CA0086W: Shareable connection MCWrapper id 1a68085c Managed connection com.ibm.ws.rsadapter.spi.W SRdbManage dConnectio nImpl@da58 85c State:STATE_TRAN_WRAPPER_I NUSE from resource jdbc/icisdw was used within a local transaction containment boundary."
In my application, I created a superclass where I set the auto commit to true. This superclass will also handles all the connection stuff. All my bean inherit from this superclass.
I have a bean which will add "row A" into database. Before it add, it will call another method in another bean to verify the info entered. This is how the above message thrown.
Can anyone tell me what is this message about or will it harm my application in the future? if possible, how to get rid of it.
Thank you.
I am writing an application using the following :
Tools : WSAD 5.0
App Server : WAS 5.0 (base)
Database : DB2 7.2
I have this message display in my WSAD console eventhough the transaction succeed.
"73e2485c SharedPool I J2CA0086W: Shareable connection MCWrapper id 1a68085c Managed connection com.ibm.ws.rsadapter.spi.W
In my application, I created a superclass where I set the auto commit to true. This superclass will also handles all the connection stuff. All my bean inherit from this superclass.
I have a bean which will add "row A" into database. Before it add, it will call another method in another bean to verify the info entered. This is how the above message thrown.
Can anyone tell me what is this message about or will it harm my application in the future? if possible, how to get rid of it.
Thank you.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Hi,
I am facing this problem in my application and its harming us a lot. Whats happening is that we keep getting these messages but a long time and my application code does not get executed. As a result of that my transaction time out occurs and the application crashes. I cant increase the transaction timeout time for my application beyond 120 seconds.
We have our propreitary Connection class through which we are getting a connection from the pool. Is there a way I can set some connection property while retrieving the connection from the pool to resolve this error.I found 'DISABLE_AUTO_CONN_CLEANUP ' to be one, but I think Websphere sets it correctly to 'false'.
Also, I even tried increasing my number of connections from 10 to 25 but it still fails.
Kindly help,
I am facing this problem in my application and its harming us a lot. Whats happening is that we keep getting these messages but a long time and my application code does not get executed. As a result of that my transaction time out occurs and the application crashes. I cant increase the transaction timeout time for my application beyond 120 seconds.
We have our propreitary Connection class through which we are getting a connection from the pool. Is there a way I can set some connection property while retrieving the connection from the pool to resolve this error.I found 'DISABLE_AUTO_CONN_CLEANUP
Also, I even tried increasing my number of connections from 10 to 25 but it still fails.
Kindly help,
Hi anyone has solution for this. My app is hanging and the below message I getting in WAS 6.1 console.
[5/15/08 9:12:32:028 EDT] 00000028 LocalTranCoor W WLTC0032W: One or more local transaction resources were rolled back during the cleanup of a LocalTransactionContainmen t.
[5/15/08 9:15:16:089 EDT] 00000026 SharedPool I J2CA0086W: Shareable connection MCWrapper id 65566556 Managed connection WSRdbManagedConnectionImpl @2d402d4 State:STATE_TRAN_WRAPPER_I NUSE
from resource jdbc/**** was used within a local transaction containment boundary.
[5/15/08 9:12:32:028 EDT] 00000028 LocalTranCoor W WLTC0032W: One or more local transaction resources were rolled back during the cleanup of a LocalTransactionContainmen
[5/15/08 9:15:16:089 EDT] 00000026 SharedPool I J2CA0086W: Shareable connection MCWrapper id 65566556 Managed connection WSRdbManagedConnectionImpl
from resource jdbc/**** was used within a local transaction containment boundary.
http://java.sun.com/j2ee/javaserverfaces/docs/Deployment_Guide.html
R.K