package  ua.dn.mayton.jdbc;

 import  java.io.*;
 import  java.sql.*;

 public   class  FindODBCJDBC {
   public   static   void  Conn(String classId, String connString, String user, String pass)  throws  ClassNotFoundException {
     try  {			
      System.out.println("\n\n");
      System.out.println("Driver     :  " + classId);
      System.out.println("ConnString :  " + connString);			
       Class .forName(classId);
      Connection сonn = DriverManager.getConnection(connString, user, pass);
      System.out.println("OK!");
      сonn.close();
    }  catch (SQLException e) {
      System.out.println("\n");
      System.out.println("== SQL Exception ===========================================================");		
      System.out.println("Exception getting connection : " + e);
      System.out.println("SQLException                 : " + e.getMessage());
      System.out.println("SQLState                     : " + e.getSQLState());
      System.out.println("VendorError                  : " + e.getErrorCode()); 
      System.out.println("============================================================================");	
    }  catch (ClassNotFoundException e) {
      System.out.println("\n");
      System.out.println("= Class not found ==========================================================");		
      System.out.println(e);
      System.out.println("============================================================================");	
    }
  }


   public   static   void  main(String[] args)  throws  SQLException, ClassNotFoundException {
    String alias = "<alias>";
    String user = "scott";		
    String pass = "tiger";

    String host = "<host name>";
    String port = "1521";
    String sid = "<sid name>";

    Conn("sun.jdbc.odbc.JdbcOdbcDriver", "jdbc:oracle:" + alias, user, pass);
    Conn("oracle.jdbc.driver.OracleDriver", "jdbc:oracle:thin:@" + host + ":" + port + ":" + sid, user, pass);
    Conn("oracle.jdbc.driver.OracleDriver", "jdbc:oracle:oci8:@" + host + ":" + port + ":" + sid, user, pass);                        
    Conn("postgres95.PGDriver", "jdbc:postgres95:jdatabase", user, pass);
  }
}