Re: [JBoss-user] Managed Connection Pool running out of connections

[Scott M Stark]

Alright, so the issue is that a stateful session is being accessed after it has 
been thrown out due to its inactivity exceeding its max age value. Either you 
need to increase the period over which passivated sessions are kept or isolate 
the access of the stateful session from the encompassing transaction using a 
RequiresNew tx attribute to prevent the failure from affecting the encompassing tx.

--
xxxxxxxxxxxxxxxxxxxxxxxx
Scott Stark
Chief Technology Officer
JBoss Group, LLC
xxxxxxxxxxxxxxxxxxxxxxxx
Andrew May wrote:

OK here's the SQLException when trying to get a connection from the 
datasource after a NoSuchObjectException has been caught:

org.jboss.util.NestedSQLException: Could not enlist in transaction on 
entering meta-aware object!javax.transaction.SystemException: Could not 
enlist XAResource!
javax.transaction.RollbackException: Already marked for rollback; - 
nested throwable: (javax.resource.ResourceException: Could not enlist in 
transaction on entering meta-aware 
object!javax.transaction.SystemException: Could not enlist 
XAResource!javax.transaction.RollbackException: Already marked for 
rollback)
        at 
org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:106) 

I've made the changes so that it's not trying to get 20 connections, but 
it has made one connection permenantly unavailable.

-Andrew


-------------------------------------------------------
This SF.Net email sponsored by: Free pre-built ASP.NET sites including
Data Reports, E-commerce, Portals, and Forums are available now.
Download today and enter to win an XBOX or Visual Studio .NET.
http://aspnet.click-url.com/go/psa00100003ave/direct;at.aspnet_072303_01/01
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user