Oracle JDBC Driver load test: NewInstance : Connection « Database SQL JDBC « Java

1. Java
2. Database SQL JDBC
3. Connection

Oracle JDBC Driver load test: NewInstance

    
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class TestClassForNameNewInstanceApp {

  public static void main(String args[]) {

    try {
      Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();
    } catch (ClassNotFoundException e) {
      System.out.println("Oops! Can't find class oracle.jdbc.driver.OracleDriver");
      System.exit(1);
    } catch (IllegalAccessException e) {
      System.out
          .println("Uh Oh! You can't load oracle.jdbc.driver.OracleDriver");
      System.exit(2);
    } catch (InstantiationException e) {
      System.out
          .println("Geez! Can't instantiate oracle.jdbc.driver.OracleDriver");
      System.exit(3);
    }

    Connection conn = null;
    Statement stmt = null;
    ResultSet rset = null;
    try {
      conn = DriverManager.getConnection(
          "jdbc:oracle:thin:@dssw2k01:1521:orcl", "scott", "tiger");

      stmt = conn.createStatement();
      rset = stmt
          .executeQuery("select 'Hello '||USER||'!' result from dual");
      while (rset.next())
        System.out.println(rset.getString(1));
      rset.close();
      rset = null;
      stmt.close();
      stmt = null;
      conn.close();
      conn = null;
    } catch (SQLException e) {
      System.out.println("Darn! A SQL error: " + e.getMessage());
    } finally {
      if (rset != null)
        try {
          rset.close();
        } catch (SQLException ignore) {
        }
      if (stmt != null)
        try {
          stmt.close();
        } catch (SQLException ignore) {
        }
      if (conn != null)
        try {
          conn.close();
        } catch (SQLException ignore) {
        }
    }
  }
}

           
         
    
    
    
  

Related examples in the same category