I have created a web service that uses a pool of Managed Oracle connections.
I get my connection by :
odsconn = (DataSource) PortableRemoteObject.narrow ctx.lookup("java:/OracleDS"), DataSource.class);
conn = (OracleConnection) (((LocalConnection) odsconn.getConnection()).getUnderlyingConnection());
Use it and then close it.
This works fine for a while but then it starts throwing a
- org.jboss.util.NestedSQLException : No ManagedConnections Available!
It is almost as though I am not returning the connection to the pool.
Any ideas? What am I doing wrong?
connection to the pool.
Attributes for my Connection pool (oracle-service.xml) are
I'm too getting this exception.
I get it both with org.jboss.util.NestedSQLException and with javax.resource.ResourceException.
Have you found a solution?
I'm using jboss 3.0.6 with jsql.