import java.sql.*;

public class test
{
   public static void main(String[] args) throws Exception
   {
      String URL = "jdbc:mysql://localhost/test";
      String USER = "root";
      String PASS = "";
      String DRIVER = "com.mysql.jdbc.Driver";
      String sql;
      ResultSet rs;
      String class_;
      Statement stmt;
      
      
      DriverManager.registerDriver((Driver) Class.forName(DRIVER).newInstance());
      
      Connection con = DriverManager.getConnection(URL, USER, PASS);      

      stmt = con.createStatement(java.sql.ResultSet.TYPE_FORWARD_ONLY,
                                 java.sql.ResultSet.CONCUR_READ_ONLY);

      sql = "SELECT dUpdateStart,dUpdateEnd,(SELECT dQueryCacheCleared FROM SfnQueryCacheDates WHERE cDataTable= 'T' AND cHostNameAndPath = 'X') AS dQueryCacheCleared FROM SfnDataTables WHERE cDataTable = 'T'";
      rs = stmt.executeQuery(sql);
      rs.next();
      class_ = rs.getObject(3).getClass().getName();
      System.out.println("Class: " + class_);
      

      con.close();
   }
}