test/sqlapi/Csql/Connect/prepareafterclose.c

   1 /*
   2    Close the connection and call prepare ,it should fail
   3 */
   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) {
  13         delete con;
  14         return 1;
  15     }
  16     printf("Connection opened\n");
  17     AbsSqlStatement *stmt = createStatement();
  18     stmt->setConnection(con);
  19     char statement[200];
  20     strcpy(statement,"CREATE TABLE T1(F1 INT);");
  21     int rows;
  22
  23     rv = con->disconnect();
  24     if(rv!=OK) {
  25         delete con;
  26         return 2;
  27     }
  28     printf("Connection closed\n");
  29
  30     rv = stmt->prepare(statement);
  31     if(rv==OK) {
  32         delete stmt; delete con;
  33         printf("Test script failed\n");
  34         return 3;
  35     }
  36     printf("Prepare failed after closing connection\n");
  37     printf("Test script passed\n");
  38
  39     delete stmt; delete con;
  40     return 0;
  41 }