test/jdbc/Statement/test020.ksh

   1 #!/bin/ksh
   2 # execute with select ,close  statement and call getResultSet(). it should not give result set
   3 # TestScript11.java
   4
   5 TESTFILE=${PWD}/jdbc/Statement/StmtTest1.java
   6 REL_PATH=.
   7 if [ -s "$TESTFILE" ]
   8 then
   9     REL_PATH=`pwd`/jdbc/Statement
  10 fi
  11 export CLASSPATH=$CLASSPATH:${REL_PATH}
  12 java TestScript11
  13 if [ $? -ne 0 ]
  14 then
  15    echo "Drop table T1;"| $CSQL_INSTALL_ROOT/bin/csql
  16    exit 1;
  17 fi
  18 echo "Drop table T1;"| $CSQL_INSTALL_ROOT/bin/csql
  19 exit 0;