0 Replies Latest reply on Dec 5, 2007 9:37 PM by 1 1

    OracleValidConnectionCheck revision?

    1 1 Newbie

      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.