test/adapter/Connect/conntest4.c

   1 //Close the connection and call execute,it should be failed.
   2
   3 #include"common.h"
   4 int main()
   5 {
   6   DbRetVal rv = OK;
   7   AbsSqlConnection *con = createConnection();
   8   rv = con->connect("root","manager");
   9   if(rv !=OK)return 1;
  10   printf("Connection opened\n");
  11
  12   AbsSqlStatement *stmt = createStatement();
  13   stmt->setConnection(con);
  14   char statement[200];
  15   strcpy(statement,"CREATE TABLE t1(f1 INT,f2 CHAR(20)); ");
  16   if(strcmp(getenv("DSN"),"db2")==0){
  17       strcpy(statement,"CREATE TABLE t1(f1 INT,f2 CHAR(20))");
  18   }
  19   int rows=0;
  20   rv = stmt->prepare(statement);
  21   if(rv!=OK)
  22   {
  23     delete stmt;
  24     delete con;
  25     return 2;
  26   }
  27   printf("prepared successfully\n");
  28
  29   rv = con->disconnect();
  30
  31   if(rv!=OK)return 3;
  32   printf("Disconnect successfully\n");
  33
  34   rv = stmt->execute(rows);
  35   if(rv == OK)
  36   {
  37     printf("Test script failed \n");
  38     delete stmt;
  39     return 4;
  40   }
  41   stmt->free();
  42   printf("Test script passed\n");
  43   delete stmt;
  44   delete con;
  45   return 0;
  46 }