test/jdbc/Gateway/test044.ksh

   1 #!/bin/ksh
   2 #No CSQL server is running .Connect with connectstring "jdbc:gateway" and give incorrect "user" and "password" in properties object. It should fail.
   3 # GwTest4.java
   4
   5 TESTFILE=${PWD}/jdbc/Gateway/GwTest1.java
   6 REL_PATH=.
   7 if [ -s "$TESTFILE" ]
   8 then
   9     REL_PATH=`pwd`/jdbc/Gateway
  10 fi
  11 export CLASSPATH=$CLASSPATH:${REL_PATH}
  12 rm -f /tmp/csql.conf
  13 cp $CSQL_CONFIG_FILE /tmp/csql.conf
  14 export CSQL_CONFIG_FILE=/tmp/csql.conf
  15 #export CSQL_CONFIG_FILE=$REL_PATH/csql.conf
  16 echo "CACHE_TABLE=true" >>$CSQL_CONFIG_FILE
  17 echo DSN=$DSN >>$CSQL_CONFIG_FILE
  18 DS="$DSN $DBUSER $PASSWORD"
  19 rm -f /tmp/csql/csqlds.conf
  20 touch /tmp/csql/csqlds.conf
  21 $CSQL_INSTALL_ROOT/bin/csqlds -U $DBUSER -P $PASSWORD -D $DSN -N $TDB -a
  22 if [ $? -ne 0 ]
  23 then
  24    exit 1;
  25 fi
  26
  27 java GwTest4
  28 if [ $? -ne 0 ]
  29 then
  30    exit 2;
  31 fi
  32
  33
  34 exit 0;