Hi all,

Excuse me for being a bit green in the J2EE world but I have a JBoss server 
(3.2.5) running a J2EE application which uses jdbc/Hibernate/Sql 
Server/Quartz/JBossMQ JMS.

All works fine until the database this application is talking to crashes (or is 
reset by me). 

At the time of the crash (or reset) I understand why I get big errors in my 
console.

However once I restart my sql server JBoss doesn't recover at all. It looks to 
me as if the connection pool in just keeps allocating connections from memory 
which have all been closed by the server crashing.

When I look at my activity for the DB JBoss has no connections to the DB at all 
and my scheduler (Quartz) keeps throwing these exceptions:

java.sql.SQLException: Invalid state, the Connection object is closed

Surely whatever is pooling these connections should be smart enough to handle 
an unexpected DB shutdown? 

If someone can point me in the right direction here that would be great.

cheers
Robert Hughes



View the original post : 
http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4038708#4038708

Reply to the post : 
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4038708
_______________________________________________
jboss-user mailing list
[email protected]
https://lists.jboss.org/mailman/listinfo/jboss-user

Reply via email to