Hi, When I database is idle for too long or I manually restart database, broker is shutting down. Does it not automatically try to reconnect? Am I missing anything?
I am setting validationQuery and testOnBorrow to true in broker-config.xml datasource bean. Do I need to do anything else to tell broker for keep trying for database connection? error ========================= Failed to checkpoint a message store: java.util.concurrent.ExecutionException: java.io.IOException: The TCP/IP connection to the host has failed. java.net.ConnectException: Connection refused: connect java.util.concurrent.ExecutionException: java.io.IOException: The TCP/IP connection to the host has failed. java.net.ConnectException: Connection refused: connect at java.util.concurrent.FutureTask$Sync.innerGet(FutureTask.java:222) at java.util.concurrent.FutureTask.get(FutureTask.java:83) at org.apache.activemq.store.journal.JournalPersistenceAdapter.doCheckpoint(JournalPersistenceAdapter.java:421) at org.apache.activemq.store.journal.JournalPersistenceAdapter$1.iterate(JournalPersistenceAdapter.java:124) at org.apache.activemq.thread.PooledTaskRunner.runTask(PooledTaskRunner.java:122) at org.apache.activemq.thread.PooledTaskRunner$1.run(PooledTaskRunner.java:43) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) at java.lang.Thread.run(Thread.java:619) Caused by: java.io.IOException: The TCP/IP connection to the host has failed. java.net.ConnectException: Connection refused: connect at org.apache.activemq.util.IOExceptionSupport.create(IOExceptionSupport.java:45) at org.apache.activemq.store.jdbc.TransactionContext.getConnection(TransactionContext.java:61) at org.apache.activemq.store.jdbc.TransactionContext.begin(TransactionContext.java:151) at org.apache.activemq.store.jdbc.JDBCPersistenceAdapter.beginTransaction(JDBCPersistenceAdapter.java:406) at org.apache.activemq.store.journal.JournalPersistenceAdapter.beginTransaction(JournalPersistenceAdapter.java:216) at org.apache.activemq.util.TransactionTemplate.run(TransactionTemplate.java:41) at org.apache.activemq.store.journal.JournalMessageStore.checkpoint(JournalMessageStore.java:258) at org.apache.activemq.store.journal.JournalTopicMessageStore.checkpoint(JournalTopicMessageStore.java:171) at org.apache.activemq.store.journal.JournalPersistenceAdapter$5.call(JournalPersistenceAdapter.java:408) at org.apache.activemq.store.journal.JournalPersistenceAdapter$5.call(JournalPersistenceAdapter.java:407) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303) at java.util.concurrent.FutureTask.run(FutureTask.java:138) ... 3 more Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: The TCP/IP connection to the host has failed. java.net.ConnectException: Connection refused: connect at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(Unknown Source) at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(Unknown Source) at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(Unknown Source) at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38) at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:294) at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:974) at org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:96) at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:880) at org.apache.activemq.store.jdbc.TransactionContext.getConnection(TransactionContext.java:54) ... 13 more 2009-11-12 14:30:12,705 INFO [STDOUT] 2009-11-12 14:30:12,705 [Q Cleanup Timer] INFO BrokerService - ActiveMQ JMS Message Broker (ess.broker1, ID:VR1Server-8183-1258064801205-0:0) stopped ============ Thanks, PG -- View this message in context: http://old.nabble.com/Broker-goes-down-when-database-is-restarted-tp26327953p26327953.html Sent from the ActiveMQ - User mailing list archive at Nabble.com.
