1 Reply Latest reply on Jul 21, 2006 3:59 PM by sai sadhu

    Unable to fill pool

    Nandakumar Mounasamy Newbie

      Hi!

      We are getting this error with jboss 3.2.3, which fails filling db connection pool. The issue stays until server is restarted. DB has enough connections to serve though.

      < datasources>
      < local-tx-datasource>

      --------
      --------
      < /local-tx-datasource>
      < /datasources>


      Currently we are not using valid-connection-checker-class-name, check-valid-connection-sql config. elements inside the oracle-ds.xml

      Is there a fix/work around to this issue with Jboss?

      ERROR
      ================
      2004-08-11 13:40:12,856 WARN [org.jboss.resource.connectionmanager.JBossManagedConnectionPool] Unable to fill pool
      org.jboss.resource.JBossResourceException: Could not create connection; - nested throwable: (java.sql.SQLException: ORA-65535: Message 65535 not found; product=RDBMS; facility=ORA

      )
      at org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.createManagedConnection(LocalManagedConnectionFactory.java:160)
      at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.createConnectionEventListener(InternalManagedConnectionPool.java:477)
      at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.fillToMin(InternalManagedConnectionPool.java:422)
      at org.jboss.resource.connectionmanager.PoolFiller$1.run(PoolFiller.java:63)
      at java.lang.Thread.run(Thread.java:534)
      Caused by: java.sql.SQLException: ORA-65535: Message 65535 not found; product=RDBMS; facility=ORA


      at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:168)
      at oracle.jdbc.oci8.OCIDBAccess.check_error(OCIDBAccess.java:1597)
      at oracle.jdbc.oci8.OCIDBAccess.logon(OCIDBAccess.java:354)
      at oracle.jdbc.driver.OracleConnection.(OracleConnection.java:246)
      at oracle.jdbc.driver.OracleDriver.getConnectionInstance(OracleDriver.java:365)
      at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:260)
      at org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.createManagedConnection(LocalManagedConnectionFactory.java:150)
      ... 4 more
      2004-08-11 13:40:12,859 INFO [STDOUT] 5459292 [Thread-19] WARN org.jboss.resource.connectionmanager.JBossManagedConnectionPool - Unable to fill pool
      org.jboss.resource.JBossResourceException: Could not create connection; - nested throwable: (java.sql.SQLException: ORA-65535: Message 65535 not found; product=RDBMS; facility=ORA

      )
      at org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.createManagedConnection(LocalManagedConnectionFactory.java:160)
      at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.createConnectionEventListener(InternalManagedConnectionPool.java:477)
      at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.fillToMin(InternalManagedConnectionPool.java:422)
      at org.jboss.resource.connectionmanager.PoolFiller$1.run(PoolFiller.java:63)
      at java.lang.Thread.run(Thread.java:534)
      Caused by: java.sql.SQLException: ORA-65535: Message 65535 not found; product=RDBMS; facility=ORA


      at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:168)
      at oracle.jdbc.oci8.OCIDBAccess.check_error(OCIDBAccess.java:1597)
      at oracle.jdbc.oci8.OCIDBAccess.logon(OCIDBAccess.java:354)
      at oracle.jdbc.driver.OracleConnection.(OracleConnection.java:246)
      at oracle.jdbc.driver.OracleDriver.getConnectionInstance(OracleDriver.java:365)
      at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:260)
      at org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.createManagedConnection(LocalManagedConnectionFactory.java:150)
      ... 4 more

      Thanks
      Nanda