test/jdbc/network/Adapter/ConTest01.java

   1 /* 1. Connect to Target DB using connection string  "jdbc:adapter://localhost:5678".
   2  *
   3  * 2. Used correct UserName and Password.
   4  * 3. Connect to the Target DB and Close the Connection
   5  * 4. Again Connect and Close.
   6  * 5. It should pass.
   7  */
   8
   9 import java.sql.*;
  10 public class ConTest01
  11 {
  12    public static void main(String[] args)
  13    {
  14        try
  15        {
  16            Class.forName("csql.jdbc.JdbcSqlDriver");
  17            Connection con = null;
  18            con=DriverManager.getConnection("jdbc:adapter://localhost:5678","root","manager");
  19            if(con != null)
  20            {
  21              System.out.println("Connect to Target DB");
  22            }
  23            else
  24            {
  25              System.out.println("Failed to Connect");
  26              System.exit(1);
  27            }
  28            con.close();
  29            System.out.println("Connection Closed");
  30            //-----------------------------
  31            con=DriverManager.getConnection("jdbc:adapter","root","manager");
  32            if(con != null)
  33            {
  34               System.out.println("Again Connect to Target DB");
  35            }
  36            else
  37            {
  38              System.out.println("Failed to Connect to Target DB");
  39              System.exit(1);
  40            }
  41            con.close();
  42            System.out.println("Connection Closed");
  43            System.exit(0);
  44        }catch(Exception e){
  45             System.out.println("Exception in Test: " +e);
  46             e.getStackTrace();
  47             System.exit(1);
  48        }
  49    }
  50 }