Skip to Main Content
Forums

Java Database Connectivity (JDBC)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Unable to fill pool

843859Sep 13 2006 — edited Sep 14 2006
Please sugget a sloution for the following exception..

15:03:26,682 INFO [STDOUT] [[web]WebDisp Errors]Mon Sep 11 15:03:26 MDT 2006 Customer not found
15:03:33,249 WARN [JBossManagedConnectionPool] Throwable while attempting to get a new connection:
org.jboss.resource.JBossResourceException: Could not create connection; - nested throwable: (java.sql.SQLException: Connection is broken: Connection refused)
at org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.createManagedConnection(LocalManagedConnectionFactory.java:153)
at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.createConnectionEventListener(InternalManagedConnectionPool.java:372)
at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.getConnection(InternalManagedConnectionPool.java:185)
at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.fillToMin(InternalManagedConnectionPool.java:333)
at org.jboss.resource.connectionmanager.PoolFiller$1.run(PoolFiller.java:63)
at java.lang.Thread.run(Thread.java:534)
Caused by: java.sql.SQLException: Connection is broken: Connection refused
at org.hsqldb.Trace.getError(Unknown Source)
at org.hsqldb.Trace.error(Unknown Source)
at org.hsqldb.jdbcConnection.reconnectHSQL(Unknown Source)
at org.hsqldb.jdbcConnection.openHSQL(Unknown Source)
at org.hsqldb.jdbcConnection.<init>(Unknown Source)
at org.hsqldb.jdbcDriver.connect(Unknown Source)
at org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.createManagedConnection(LocalManagedConnectionFactory.java:143)
... 5 more
15:03:33,250 WARN [JBossManagedConnectionPool] Unable to fill pool
org.jboss.resource.JBossResourceException: Could not create connection; - nested throwable: (java.sql.SQLException: Connection is broken: Connection refused)
at org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.createManagedConnection(LocalManagedConnectionFactory.java:153)
at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.createConnectionEventListener(InternalManagedConnectionPool.java:372)
at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.getConnection(InternalManagedConnectionPool.java:185)
at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.fillToMin(InternalManagedConnectionPool.java:333)
at org.jboss.resource.connectionmanager.PoolFiller$1.run(PoolFiller.java:63)
at java.lang.Thread.run(Thread.java:534)
Caused by: java.sql.SQLException: Connection is broken: Connection refused
at org.hsqldb.Trace.getError(Unknown Source)
at org.hsqldb.Trace.error(Unknown Source)
at org.hsqldb.jdbcConnection.reconnectHSQL(Unknown Source)
at org.hsqldb.jdbcConnection.openHSQL(Unknown Source)
at org.hsqldb.jdbcConnection.<init>(Unknown Source)
at org.hsqldb.jdbcDriver.connect(Unknown Source)
at org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.createManagedConnection(LocalManagedConnectionFactory.java:143)
... 5 more


Thanks,
Unmesh

Comments

masijade
When I saw the title I wanted to say "get a hose" but seriously,
you are getting connection refused errors. Check that the DB is running and listenening where you expect it to be, and then check that you can actually reach it from the server outside of java, then check your connection parameters.

If all these work and/or are correct and you still get the problem, then check back, probably with sample code.
843859
DB is running and listenening correctly.

this is my oracle.ds file

<local-tx-datasource>
<jndi-name>HRM</jndi-name>
<connection-url>jdbc:oracle:thin:@tp1.systems.com:1521:orcl9i</connection-url>
<driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
<user-name>user</user-name>
<password>password</password>
<min-pool-size>5</min-pool-size>
<max-pool-size>300</max-pool-size>
<blocking-timeout-millis>180000</blocking-timeout-millis>
<idle-timeout-minutes>60</idle-timeout-minutes>
</local-tx-datasource>

null

Message was edited by:
Machine
masijade
From first post:
at org.hsqldb.jdbcConnection.openHSQL(Unknown Source)
From third post:
<connection-url>jdbc:oracle:thin:@tp1.systems.com:1521:orcl9i</connection-url>
<driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
Am I missing something here? You have an Oracle datasource defined with an oracle driver, but that seems to be an error for HSQL.

Does JBoss use HSQL drivers for the pools or something? I am not versed in jBoss so I'm not sure, but I'm guessing that there is a mix up here.
843859
sorry for the mistake

connection is to hsqldb.
1 - 4
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Oct 12 2006
Added on Sep 13 2006
#java-database-connectivity-jdbc
4 comments
4,838 views