Re: Error with persistence

Dave Carlson wrote:
> Hi, I am using persistent point-to-point messaging with 7 senders distributed across 3 connections and 9 receivers distributed across 3 connections, and I keep getting the following message:
> 15:56:44.703 ERROR [Scheduler-Worker-5] - Failed to destroy persistent handle
> org.exolab.jms.persistence.PersistenceException: 
> org.apache.commons.dbcp.SQLNestedException: Cannot get a connection, pool exhausted
> 	at org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:103)
> 	at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:540)
> 	at org.exolab.jms.persistence.DBCPConnectionManager.getConnection(DBCPConnectionManager.java:121)
> 	at org.exolab.jms.persistence.RDBMSAdapter.getConnection(RDBMSAdapter.java:696)
> 	at org.exolab.jms.persistence.DatabaseService.getConnection(DatabaseService.java:173)
> 	at org.exolab.jms.messagemgr.AbstractConsumerMessageHandle.destroy(AbstractConsumerMessageHandle.java:326)
> 	at org.exolab.jms.server.SentMessageCache.postSend(SentMessageCache.java:122)
> 	at org.exolab.jms.server.SessionConsumer.send(SessionConsumer.java:576)
> 	at org.exolab.jms.server.SessionConsumer.dispatch(SessionConsumer.java:498)
> 	at org.exolab.jms.server.SessionConsumer.access$000(SessionConsumer.java:78)
> 	at org.exolab.jms.server.SessionConsumer$1.run(SessionConsumer.java:155)
> 	at org.exolab.jms.scheduler.SerialTask.run(SerialTask.java:164)
> 	at org.exolab.jms.common.threads.ThreadPool$NotifyingRunnable.run(ThreadPool.java:211)
> 	at EDU.oswego.cs.dl.util.concurrent.PooledExecutor$Worker.run(Unknown Source)
> 	at java.lang.Thread.run(Thread.java:595)
> Caused by: java.util.NoSuchElementException: Timeout waiting for idle object
> 	at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:756)
> 	at org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:95)
> 	... 14 more
>
>
> Any ideas? Is the pool size configurable?
>   
See http://openjms.sourceforge.net/config/jdbc.html#Connection_pooling

-Tim

-------------------------------------------------------------------------
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/