No ManagedConnections Available!

[lee_x_francis]

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.
ctx.close();
conn.close();

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?

Thanks,

Lee.

connection to the pool.
Attributes for my Connection pool (oracle-service.xml) are
0
50
5000
15

[itaimaoz]

Hi,

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.

Thanks,
Itai