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#...
Reply to the post :
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&a...