3 Replies Latest reply on Jul 21, 2006 2:57 AM by jaikiran pai

    Regarding the No ManagedConnection error in jboss-4.0.3SP1

    Ottran 75 Newbie

      We are developing a application using Oracle 9i, Linux Environment ,

      We are frequently getting the no managedconnection error.
      We have closed all the connection etc properly and not only that we are monitoring the server to see for any open connection .
      Please advise/ suggest ways by which we can rectify this error.
      Your help will be highly useful for us.


        • 1. Re: Regarding the No ManagedConnection error in jboss-4.0.3S
          Weston M. Price Master

          Getting the NoManagedConnections error is not necessarily a bad thing. It really just says that the pool needs to probably be tuned.

          Please post your *-ds.xml file.

          • 2. Re: Regarding the No ManagedConnection error in jboss-4.0.3S
            Ottran 75 Newbie

            Please find the oracle-ds.xml file



            <!-- Uses the pingDatabase method to check a connection is still valid before handing it out from the pool -->
            <!-- Checks the Oracle error codes and messages for fatal errors -->
            <!-- sql to call when connection is created
            <new-connection-sql>some arbitrary sql</new-connection-sql>

            <!-- sql to call on an existing pooled connection when it is obtained from pool - the OracleValidConnectionChecker is prefered
            <check-valid-connection-sql>some arbitrary sql</check-valid-connection-sql>

            <!-- corresponding type-mapping in the standardjbosscmp-jdbc.xml (optional) -->



            • 3. Re: Regarding the No ManagedConnection error in jboss-4.0.3S
              jaikiran pai Master



              Thats a good enough pool size. What does your application do? Does it heavily use connections. How long are these connections kept open? If i remember correctly, using the jmx-console there is a way to find out the number of connection currently in use, for your datasource. Have you checked this current connection count when this exception occurs?