0 Replies Latest reply on Aug 12, 2004 11:11 PM by Nandakumar Mounasamy

    unable to fill pool

    Nandakumar Mounasamy Newbie

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

      < datasources>
      < local-tx-datasource>

      --------
      < connection-url>jdbc:oracle:oci8:@DBINSTANCE_NAME</connection-url>

      --------
      < /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? I would appreciate any suggestions to resolve this.

      Env. Details:
      Oracle 8.1.7.4/OCI Driver/Solaris 8/JDK_1.4.2._05

      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