test/jdbc/Adapter/ConTest02.java

   1 /* 1. Connect to Target DB using connection string "jdbc:adapter".
   2  *
   3  * 2. Used null properties object
   4  * 3. Coreect username and wrong password
   5  * 4. Wrong UserName and Correct password
   6  * 5. Above all three should fail
   7  *
   8  * Author : Jitendra Lenka
   9  */
  10
  11 import java.sql.*;
  12 public class ConTest02
  13 {
  14    public static void main(String[] args)
  15    {
  16        try
  17        {
  18            Class.forName("csql.jdbc.JdbcSqlDriver");
  19            Connection con = null;
  20            con=DriverManager.getConnection("jdbc:adapter",null,null);
  21            if(con != null)
  22            {
  23              System.out.println("Error-1" + con);
  24              con.close();
  25              System.exit(1);
  26            }
  27
  28           //Correct userName and Wrong Password
  29           con=DriverManager.getConnection("jdbc:adapter","root","MANAGER");
  30           if(con != null)
  31           {
  32               System.out.println("Error-2" + con);
  33               con.close();
  34               System.exit(2);
  35           }
  36
  37
  38           //wrong userName adn correct password
  39           con=DriverManager.getConnection("jdbc:adapter","ROOT","manager");
  40           if(con != null)
  41           {
  42              System.out.println("Error-2" + con);
  43              con.close();
  44              System.exit(2);
  45           }
  46
  47          }catch(Exception e){
  48             System.out.println("Exception in Test: " +e);
  49             e.getStackTrace();
  50             System.exit(0);
  51        }
  52    }
  53 }