test/jdbc/Gateway/GwTest9.java

   1 //Donot Start CSQL Server
   2 //connect through the jdbc:gateway URL create Statement and call execute to create a table. it should fail
   3 import java.sql.*;
   4 /**
   5  *
   6  * @author bijaya
   7  */
   8 public class GwTest9 {
   9  public static void main(String[] args)
  10     {
  11        try
  12        {
  13            Class.forName("csql.jdbc.JdbcSqlDriver");
  14            Connection con = DriverManager.getConnection("jdbc:gateway", "root", "manager");
  15            Statement cStmt = con.createStatement();
  16            boolean ret ;
  17            cStmt.execute("CREATE TABLE t2 (f1 integer, f2 char (20));");
  18            cStmt.close();
  19            con.close();
  20        }catch(Exception e)
  21        {
  22             System.out.println("Exception in Test: "+e);
  23             e.printStackTrace();
  24             System.out.println("Test Case Passed");
  25             System.exit(0);
  26
  27        }
  28  }
  29
  30 }