import  java.sql.DatabaseMetaData;
 import  java.sql.DriverManager;
 import  java.sql.Connection;
 import  java.util.Properties;

 public   class  Connectivity_test {
   static   final  String PFILE = "pfile";
  
   public   static   void  main(String[] args)  throws  Exception {
    Connection con =  null ;
    
     try  {
      System.getProperties().load( new  java.io.FileInputStream(System.getProperty(PFILE)));
      // Getting properties from property file
      String host_driver = System.getProperty("host_driver");
      String host_url = System.getProperty("host_url");
      String host_username = System.getProperty("host_username");
      String host_password = System.getProperty("host_password");
      // get connection 
       Class .forName(host_driver).newInstance();
      System.out.println("URL            : " + host_url);
      System.out.println("username       : " + host_username);
      System.out.println("password length: " + (host_password== null ? 0 :host_password.length()));
      System.out.println('\n'+"trying to connect... ");
      con = DriverManager.getConnection(host_url, host_username, host_password);
      System.out.println("connected!!!");
      // database metadata
      System.out.println('\n'+"*** database info ***");
      DatabaseMetaData dm = con.getMetaData();
      System.out.println("Product name   : " + dm.getDatabaseProductName());
      System.out.println("Product version: " + dm.getDatabaseProductVersion());
      System.out.println("Major version  : " + dm.getDatabaseMajorVersion());
      System.out.println("Minor version  : " + dm.getDatabaseMinorVersion());
      System.out.println('\n'+"*** driver info ***");
      System.out.println("Name           : " + dm.getDriverName());
      System.out.println("Version        : " + dm.getDriverVersion());
      System.out.println("Major version  : " + dm.getDriverMajorVersion());
      System.out.println("Minor version  : " + dm.getDriverMinorVersion());
      System.out.println("JDBC Major version  : " + dm.getJDBCMajorVersion());
      System.out.println("JDBC Minor version  : " + dm.getJDBCMinorVersion());
      // properties
      /*
      Properties prop = System.getProperties();
      for (java.util.Enumeration e = prop.propertyNames(); e.hasMoreElements(); ) {
        String s = (String)e.nextElement();
        if (s.startsWith("java"))
          System.out.println(s+": "+prop.getProperty(s));
      }
      */
    }  catch  (Exception ex) {
      ex.printStackTrace();
    }  finally  {
       if  (con !=  null ) {
        System.out.println('\n'+"trying to disconnect...");
        con.close(); 
        System.out.println("done!");
        con= null ;
      }
    }
  }

}