[jboss-user] [Persistence, JBoss/CMP, Hibernate, Database] - Re: How to detect stale Connections ?

2009-03-11 Thread dimar1975
Hi peter, thanks for your reply. I was meaning, is there a way to trigger an Action when a connection is not reachable (f.e. oracle listener just shut down) ? from what I can understand, I can discover a broken connection only polling the DB with a running thread.maybe is there something

[jboss-user] [Persistence, JBoss/CMP, Hibernate, Database] - Re: How to detect stale Connections ?

2009-03-11 Thread PeterJ
Polling the DB with a separate thread is the only way I know of detecting this. View the original post : http://www.jboss.org/index.html?module=bbop=viewtopicp=4216995#4216995 Reply to the post : http://www.jboss.org/index.html?module=bbop=postingmode=replyp=4216995

[jboss-user] [Persistence, JBoss/CMP, Hibernate, Database] - Re: How to detect stale Connections ?

2009-03-10 Thread PeterJ
What do you mean by a stale connection? Also, check-valid-connection-sql is used each time the app asks for a connection, whether the connection was just now created or was created earlier and came from the connection pool. View the original post :