Unable to fill pool

[nkmounasamy]

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

[ssaikumar]

Nanda,

Did you ever got a chance to solve this problem. We were facing with similar kind of problem. appreciate the help!.

Thanks,
Sai