org.jboss.resource.adapter.jdbc: public class: CheckValidConnectionSQL

org.jboss.resource.adapter.jdbc
public class: CheckValidConnectionSQL [javadoc | source]

java.lang.Object
   org.jboss.resource.adapter.jdbc.CheckValidConnectionSQL

All Implemented Interfaces:
Serializable, ValidConnectionChecker

Implements check valid connection sql

author: < - a href="mailto:adrian@jboss.org">Adrian Brock

version: $ - Revision: 71554 $

Field Summary
String	sql

Constructor:
public CheckValidConnectionSQL() { }
public CheckValidConnectionSQL(String sql) { this.sql = sql; }

Method from org.jboss.resource.adapter.jdbc.CheckValidConnectionSQL Summary:
isValidConnection

Methods from java.lang.Object:
equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Method from org.jboss.resource.adapter.jdbc.CheckValidConnectionSQL Detail:
public SQLException isValidConnection(Connection c) { try { Statement s = c.createStatement(); try { s.execute(sql); return null; } finally { s.close(); } } catch (SQLException e) { return e; } }

Method from org.jboss.resource.adapter.jdbc.CheckValidConnectionSQL Detail:

 public SQLException isValidConnection(Connection c) {
      try    
      {
         Statement s = c.createStatement();
         try
         {
            s.execute(sql);
            return null;
         }
         finally
         {
            s.close();
         }
      }
      catch (SQLException e)
      {
         return e;
      }
}