6 Replies Latest reply on Mar 11, 2003 12:05 PM by iury

    Could not create connection; - nested throwable: (java.sql.S

    iury

      what´s it?

      I´m use Jboss3/oracle. this not exist at BAS


      09:23:42,155 ERROR [STDERR] java.lang.reflect.UndeclaredThrowableException:
      09:23:42,185 ERROR [STDERR] org.jboss.resource.ResourceException: Could not create connection; - nested throwable: (java.sql.SQLException: ORA-00020: maximum number of processes (150) exceeded
      )
      09:23:42,245 ERROR [STDERR] at org.jboss.resource.adapter.jdbc.local.LocalMa
      nagedConnectionFactory.createManagedConnection(LocalManagedConnectionFactory.jav
      a:144)
      09:23:42,295 ERROR [STDERR] at org.jboss.resource.connectionmanager.Internal
      ManagedConnectionPool.createConnection(InternalManagedConnectionPool.java:259)
      09:23:42,325 ERROR [STDERR] at org.jboss.resource.connectionmanager.Internal
      ManagedConnectionPool.getConnection(InternalManagedConnectionPool.java:106)
      09:23:42,355 ERROR [STDERR] at org.jboss.resource.connectionmanager.JBossMan
      agedConnectionPool$BasePool.getConnection(JBossManagedConnectionPool.java:323)
      09:23:42,396 ERROR [STDERR] at org.jboss.resource.connectionmanager.BaseConn

        • 1. Re: Could not create connection; - nested throwable: (java.s
          frito

          It's an exception stacktrace...

          to be more precise: it is an SQLException showing an oracle error (ORA-00020)...

          even more precise: oracle tells you, that the number of processes exeeded...

          change the apropriate value in your init.ora

          Frito

          • 2. Dont close connection
            iury

            I´m using "jboss 3 with oracle". I am opening connections normaly.



            The problem is that the data base connection does not properly closed or it is not being reused using jboss.

            What I make so that the connections are closed automatic.

            • 3. Re: Dont close connection
              iury

              I´m using "jboss 3 with oracle" whe I am just using CMPs in my application.

              The problem is that the data base connection is not closed or returned to the pool, or reused by jboss.

              Is there any configuration in the datasource to jboss reuse the statements or close the connections?

              • 4. Re: Dont close connection
                frito

                Please explain what you are doing exactly and which version of JBoss you are using (3.?.?). Perhaps you can post some helpful code / configuration snippets...

                Frito

                • 5. Re: Dont close connection
                  iury

                  I am making some operations of insert in the data base using Entity Bean CMP.
                  As the amount of register to be inserted is greater that the number of connections configured for the Oracle (150), the Jboss
                  does not close nor reuses the connections after the commit, leaving them inactive, causing the burst of excess of allowed connections.

                  This same application functions without problems in other application servers (Ex: BAS, BES, OAS).

                  • 6. Re: Dont close connection
                    iury

                    the jboss versoin is 3.0.5