[jboss-user] [Persistence, JBoss/CMP, Hibernate, Database] - OracleValidConnectionCheck revision?

Mr_Anonymous do-not-reply at jboss.com
Wed Dec 5 21:37:23 EST 2007

In an previous discussion with Oracle, they recommended using the following

  |         try {
  |             conn1.setAutoCommit(conn1.getAutoCommit());
  |         } catch (SQLException se ) {
  |             System.out.println("the connection is no good");
  |         }
to test whether an XA connection is good, rather than using SQL.

Would there be any problem in revising OracleValidConnectionCheck to use this method rather than the pingDatabase? I'm thinking it would probably be more performant, plus these method are part of Connection and so don't require reflection.

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

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4110717

More information about the jboss-user mailing list