users@glassfish.java.net

EJB Transactions

From: <glassfish_at_javadesktop.org>
Date: Fri, 10 Apr 2009 09:03:10 PDT

Hi,

Please help me resolve the following error:

I am getting the following error when working with multiple users. I am getting this error after I added a user transaction to my Bean Managed stateless EJB.

[#|2009-01-19T18:40:58.454-0300|WARNING|sun-appserver9.1|javax.enterprise.resource.resourceadapter|_ThreadID=32;_ThreadName=httpSSLWorkerThread-8080-41;_RequestID=82b30543-b1b4-4347-886d-62d205190cb3;|
RAR7093 : Error while cleaning up ManagedConnection
javax.resource.ResourceException: This Managed Connection is not valid as the phyiscal connection is not usable
at com.sun.gjc.spi.ManagedConnection.checkIfValid(ManagedConnection.java:627)
at com.sun.gjc.spi.ManagedConnection.cleanup(ManagedConnection.java:233)

My configuration is as follows :

<jdbc-connection-pool connection-validation-method="table" datasource-classname="oracle.jdbc.pool.OracleConnectionPoolDataSource" fail-all-connections="false" idle-timeout-in-seconds="300" is-connection-validation-required="true" is-isolation-level-guaranteed="false" max-pool-size="32" max-wait-time-in-millis="60000" name="ddamd" pool-resize-quantity="2" res-type="javax.sql.ConnectionPoolDataSource" steady-pool-size="8" validation-table-name="HOST">
<property name="URL" value="jdbc:oracle:thin:@dbd01.lvs.dupont.com:1521:DDAMD" />
<property name="Password" value="Dpddevapp07$08" />
<property name="User" value="DDAMDISO" />
</jdbc-connection-pool>

Thanks and Regards,
Priya Anand
[Message sent by forum member 'priyap3' (priyap3)]

http://forums.java.net/jive/thread.jspa?messageID=341643