Oracle JDrivers

[Adam Adams]

we are running wls6.1 on hpux11 and oracle 9i database. we were able to connect through wls using jdbc 8i thin drivers with no problems at all but we we change it to Oracle JDriver we had some problems .. thanks for your help/comments
here is my start up scripts:

# Set user-defined variables.
JAVA_HOME=/home/eservice/Dev/bea/jdk131
ORACLE_HOME=/u01/app/oracle/product/9.0.1
WL_HOME=/home/eservice/Dev/bea/wlserver6.1
#JAVA_OPTIONS="-ms512m -mx512m"
JAVA_OPTIONS="-ms64m -mx64m"

# Check that script is being run from the appropriate directory
if [ ! -f config.xml ]; then
  echo "startWeblogic.sh: must be run from the config/$ThisDomain directory." 1>
&2
# Check for classes
elif [ ! -f $WL_HOME/lib/weblogic.jar ]; then
  echo "The weblogic.jar file was not found in directory $WL_HOME/lib." 1>&2
# Check for JDK
elif [ ! -f $JAVA_HOME/bin/javac ]; then
  echo "The JDK wasn't found in directory $JAVA_HOME." 1>&2
else
cd ../..
# Grab some file descriptors.
maxfiles=`ulimit -H -n`
if [ ! $? -a "$maxfiles" != 1024 ]; then
  if [ "$maxfiles" = "unlimited" ]; then
    maxfiles=1025
  fi
  if [ "$maxfiles" -lt 1024 ]; then
    ulimit -n $maxfiles
  else
    ulimit -n 1024
  fi
fi
# Figure out how to use our shared libraries
case `uname -s` in
AIX)
  if [ -n "$LIBPATH" ]; then
    LIBPATH=$LIBPATH:$WL_HOME/lib/aix
  Else
LIBPATH=$WL_HOME/lib/aix
  fi
  PATH=$WL_HOME/lib/aix:$PATH
  export LIBPATH PATH
  echo "LIBPATH=$LIBPATH"
;;
HP-UX)
  if [ -n "$SHLIB_PATH" ]; then
    SHLIB_PATH=$SHLIB_PATH:$WL_HOME/lib/hpux11/oci901_8:$ORACLE_HOME/lib32
  else
    SHLIB_PATH=$WL_HOME/lib/hpux11/oci901_8:$ORACLE_HOME/lib32
  fi
  PATH=$WL_HOME/lib/hpux11:$PATH
  export SHLIB_PATH PATH
  echo "SHLIB_PATH=$SHLIB_PATH"
;;
IRIX)
  if [ -n "$LD_LIBRARY_PATH" ]; then
    LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$WL_HOME/lib/irix
  else
    LD_LIBRARY_PATH=$WL_HOME/lib/irix
  fi
PATH=$WL_HOME/lib/irix:$PATH
  export LD_LIBRARY_PATH PATH
  echo "LD_LIBRARY_PATH=$LD_LIBRARY_PATH"
;;
LINUX|Linux)
  if [ -n "$LD_LIBRARY_PATH" ]; then
    LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$WL_HOME/lib/linux
  else
    LD_LIBRARY_PATH=$WL_HOME/lib/linux
  fi
  PATH=$WL_HOME/lib/linux:$PATH
  export LD_LIBRARY_PATH PATH
  echo "LD_LIBRARY_PATH=$LD_LIBRARY_PATH"
;;
OSF1)
  if [ -n "$LD_LIBRARY_PATH" ]; then
    LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$WL_HOME/lib/tru64unix
  else
    LD_LIBRARY_PATH=$WL_HOME/lib/tru64unix
  fi
  PATH=$WL_HOME/lib/tru64unix:$PATH
  export LD_LIBRARY_PATH PATH
  echo "LD_LIBRARY_PATH=$LD_LIBRARY_PATH"
echo "LD_LIBRARY_PATH=$LD_LIBRARY_PATH"
;;
SunOS)
  if [ -n "$LD_LIBRARY_PATH" ]; then
    LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$WL_HOME/lib/solaris:$WL_HOME/lib/solaris/o
ci901_8
  else
    LD_LIBRARY_PATH=$WL_HOME/lib/solaris:$WL_HOME/lib/solaris/oci901_8
  fi
  PATH=$WL_HOME/lib/solaris:$PATH
  export LD_LIBRARY_PATH PATH
  echo "LD_LIBRARY_PATH=$LD_LIBRARY_PATH"
  JAVA_OPTIONS="-hotspot $JAVA_OPTIONS"
;;
*)
  echo "$0: Don't know how to set the shared library path for `uname -s`.  "
esac
#appendclasspath() {
        #CLASSPATH=$CLASSPATH:$1
#}
#prependclasspath() {
#       CLASSPATH=$1:$CLASSPATH
#}

# Reset classpath
echo
echo "Setting classpath"
CLASSPATH=
# Log4j
#chx
#echo "* Adding Log4j"
#CLASSPATH=$WL_HOME/config/$ThisDomain/lib/log4j-core.jar
#chx
# Apache Commons
# Oracle 9i thin driver
#echo "* Adding Oracle 9i Thin driver"
#CLASSPATH=$CLASSPATH:$WL_HOME/config/$ThisDomain/lib/classes111.jar
CLASSPATH=$CLASSPATH:$ORACLE_HOME/jdbc/lib/classes111.zip
# Oracle 9i debug wrapper
#echo "* Adding Oracle 9i debug wrapper"
#echo "* Adding Oracle 9i debug wrapper"
#CLASSPATH=$CLASSPATH:$WL_HOME/config/$ThisDomain/lib/oraclewrapper.jar
# e-Foundation library for e-Services
# WebLogic classpath
echo "* Adding WebLogic libraries"
CLASSPATH=$CLASSPATH:$WL_HOME:$WL_HOME/lib/weblogic_sp.jar:$WL_HOME/lib/weblogic
.jar:$ORACLE_HOME/lib32/jdbc/lib/classes111.zip
PATH=$WL_HOME/bin:$JAVA_HOME/jre/bin:$JAVA_HOME/bin:$ORACLE_HOME/bin:$PATH
echo
echo "***************************************************"
echo "*  To start WebLogic Server, use the password     *"
echo "*  assigned to the system user.  The system       *"
echo "*  username and password must also be used to     *"
echo "*  access the WebLogic Server console from a web  *"
echo "*  browser.                                       *"
echo "***************************************************"
# Set WLS_PW equal to your system password for no password prompt server startup
.
WLS_PW=egovt001
# Set Production Mode.  When set to true, the server starts up in production mod
e.  When
# set to false, the server starts up in development mode.  The default is false.
STARTMODE=false
# ensure Xerces 1.4.4 XML Parser is the first thing on the classpath
#echo "* Adding Xerces 1.4.4"
#prependclasspath $WL_HOME/config/$ThisDomain/lib/xerces.jar
echo "\n$CLASSPATH\n"
java $JAVA_OPTIONS -classpath $CLASSPATH -Dweblogic.Domain=$ThisDomain -Dweblogi
c.Name=myserver -Dbea.home=/home/eservice/Dev/bea -Dweblogic.management.password
=$WLS_PW -Dweblogic.ProductionModeEnabled=$STARTMODE -Djava.security.policy==/ho
me/eservice/Dev/bea/wlserver6.1/lib/weblogic.policy weblogic.Server
cd config/$ThisDomain
fi

[ Edited by Dave to add code tags ]
[ June 05, 2002: Message edited by: David O'Meara ]