unable to fill pool
nkmounasamy Aug 12, 2004 11:11 PMWe 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