1 Reply Latest reply on Mar 24, 2003 4:59 AM by Itai Maoz

    No ManagedConnections Available!

    Lee Francis Newbie

      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