test/jdbc/network/Gateway/GwTest4.java

   1 //No CSQL server is running .Connect with connectstring "jdbc:gateway://localhost:5678" and give incorrect "user" and "password" in properties object. It should fail.
   2 import java.sql.*;
   3 /**
   4  *
   5  * @Author : Nihar
   6  */
   7 public class GwTest4 {
   8
   9      public static void main(String[] args)
  10     {
  11        try
  12        {
  13            Class.forName("csql.jdbc.JdbcSqlDriver");
  14            Connection con = DriverManager.getConnection("jdbc:gateway://localhost:5678", "wrongusertest", "manager");
  15            if (con == null)
  16            {
  17                System.out.println("Test Case1 Passed");
  18            }
  19            System.out.println("Test Case1 Failed");
  20            System.exit(1);
  21            Connection con1 = DriverManager.getConnection("jdbc:gateway://localhost:5678", "root", "wrongpasswdtestxieliang");
  22            if (con == null)
  23            {
  24                System.out.println("Test Case2 Passed");
  25                System.exit(0);
  26            }
  27            System.out.println("Test Case2 Failed");
  28            con.close();
  29            System.exit(1);
  30         }catch(Exception e) {
  31             System.out.println("Exception in Test: "+e.getMessage());
  32             e.getStackTrace();
  33             System.exit(0);
  34        }
  35     }
  36
  37 }