test/jdbc/Gateway/test050.ksh

   1 #!/bin/sh
   2 # Connect with connectstring "jdbc:gateway"
   3 # Then do (INSERT/UPDATE/DELETE/SELECT) with params statement using gateway statement
   4 # It should pass.when csqlserver is not runnig
   5 # GwTest10.java
   6
   7 TESTFILE=${PWD}/jdbc/Gateway/ConnTest01.java
   8 REL_PATH=.
   9 if [ -s "$TESTFILE" ]
  10 then
  11     REL_PATH=`pwd`/jdbc/Gateway
  12 fi
  13 export CLASSPATH=$CLASSPATH:${REL_PATH}
  14 export CSQL_CONFIG_FILE=$REL_PATH/csql.conf
  15 echo "create table T1 (f1 int,f2 char(10),primary key(f1));" >${REL_PATH}/t1create.sql
  16 isql $DSN < ${REL_PATH}/t1create.sql >/dev/null 2>&1
  17 if [ $? -ne 0 ]
  18 then
  19    rm -f ${REL_PATH}/t1create.sql
  20    exit 1;
  21 fi
  22 java GwTest10
  23 if [ $? -ne 0 ]
  24 then
  25    exit 2;
  26 fi
  27
  28 echo "drop table T1;">${REL_PATH}/dp.sql
  29 isql $DSN < ${REL_PATH}/dp.sql >/dev/null 2>&1
  30 rm -f ${REL_PATH}/dp.sql
  31 rm -f ${REL_PATH}/t1create.sql
  32
  33 exit 0;