test/sqlapi/Connect/conntest4.c

   1 //  close the connection and call execute,it should fail.
   2
   3 //  Author : Jitendra Lenka
   4
   5 #include"common.h"
   6
   7 int main()
   8 {
   9     DbRetVal rv = OK;
  10     AbsSqlConnection *con = createConnection();
  11     rv = con->connect("root","manager");
  12     if(rv !=OK)return 1;
  13     printf("Connection opened\n");
  14     AbsSqlStatement *stmt = createStatement();
  15     stmt->setConnection(con);
  16     char statement[200];
  17     strcpy(statement,"CREATE TABLE T1(F1 INT,F2 CHAR(20)); ");
  18     int rows=0;
  19     rv = stmt->prepare(statement);
  20     if(rv!=OK) { delete stmt; delete con; return 2; }
  21     printf("prepared successfully\n");
  22     rv = con->disconnect();
  23     if(rv!=OK)return 3;
  24     printf("Disconnect successfully\n");
  25     rv = stmt->execute(rows);
  26     if(rv == OK) {
  27         printf("Test script failed \n");
  28         delete stmt; return 4;
  29     }
  30     stmt->free();
  31     printf("Test script passed\n");
  32     delete stmt; delete con;
  33     return 0;
  34 }