test/adapter/Select/test005na.ksh

   1 #!/bin/ksh
   2 #call execute without calling prepare. it should fail.
   3
   4 CSQL_CONF=${PWD}/adapter/Select/csql.conf
   5 REL_PATH=.
   6 if [ -s "$CSQL_CONF" ]
   7 then
   8     REL_PATH=${PWD}/adapter/Select
   9 fi
  10
  11 rm -f /tmp/csql.conf
  12 cp $REL_PATH/csql.conf /tmp/csql.conf
  13 echo CSQL_SQL_SERVER=true >>/tmp/csql.conf
  14 #echo PORT= >>/tmp/csql.conf
  15 export CSQL_CONFIG_FILE=/tmp/csql.conf
  16 if [ -z "$DBUSER" ]
  17 then
  18    echo DSN=$DSN >>$CSQL_CONFIG_FILE
  19    if [ $DSN = "psql" ]
  20    then
  21       echo TARGET_DATABASE=postgres >>$CSQL_CONFIG_FILE
  22    else
  23       echo TARGET_DATABASE=mysql >>$CSQL_CONFIG_FILE
  24    fi
  25    DS=$DSN
  26 else
  27    echo DSN=$DSN >>$CSQL_CONFIG_FILE
  28    echo DBUSER=$DBUSER >>$CSQL_CONFIG_FILE
  29    echo PASSWORD=$PASSWORD >>$CSQL_CONFIG_FILE
  30    echo TARGET_DATABASE=oracle >>$CSQL_CONFIG_FILE
  31    DS="$DSN $DBUSER $PASSWORD"
  32 fi
  33
  34 $CSQL_INSTALL_ROOT/bin/csqlsqlserver >/dev/null 2>&1 &
  35 pid=$!
  36 sleep 3
  37 ${REL_PATH}/selecttest5na
  38 if [ $? -ne 0 ]
  39 then
  40    kill -9 $pid
  41    exit 1;
  42 fi
  43 rm -f /tmp/csql.conf
  44 kill -9 $pid
  45 exit 0;