test/jdbc/Gateway/test049.ksh

   1 #!/bin/ksh
   2 # Donot Start CSQL Server
   3 # Connect through the csql:gateway URL create Statement and call execute to create a table. it should fail
   4
   5 # GwTest9.java
   6
   7 TESTFILE=${PWD}/jdbc/Gateway/GwTest1.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 rm -f /tmp/csql.conf
  15 cp $CSQL_CONFIG_FILE /tmp/csql.conf
  16 export CSQL_CONFIG_FILE=/tmp/csql.conf
  17 #export CSQL_CONFIG_FILE=$REL_PATH/csql.conf
  18 echo "CACHE_TABLE=true" >>$CSQL_CONFIG_FILE
  19 echo DSN=$DSN >>$CSQL_CONFIG_FILE
  20 DS="$DSN $DBUSER $PASSWORD"
  21 rm -f /tmp/csql/csqlds.conf
  22 touch /tmp/csql/csqlds.conf
  23 $CSQL_INSTALL_ROOT/bin/csqlds -U $DBUSER -P $PASSWORD -D $DSN -N $TDB -a
  24 if [ $? -ne 0 ]
  25 then
  26    exit 1;
  27 fi
  28
  29 java GwTest9
  30 if [ $? -ne 0 ]
  31 then
  32    exit 1;
  33 fi
  34
  35
  36 exit 0;