Kbase P64056: SQLExplorer receives errors 8933 and 8841 on connecting to a database when using IBM's jdk
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
02/01/2009 |
|
Status: Verified
SYMPTOM(s):
SQL Explorer generates errors on connecting to a database.
Error: --- SQL Exception 1 ==== SQLState=HY000 ErrorCode=-20055 [JDBC Progress Driver]:Database not started. (8933)
SQL server process terminated. (8841)
Running IBM Java 1.3.1
The Progress Certified JDK is 1.3.1 from SUN.
FACT(s) (Environment):
RedHat Linux Advanced Server 2.1
Progress 9.1D
CHANGE:
Installed IBM's JDK.
CAUSE:
The directory structure for IBM Java is different than the directory structure of Sun's Java.
FIX:
Configure the java_env file to agree with the paths of IBM Java 1.3.1.
Make a backup copy of the original java_env file.
Replaced The Linux portion within the java_env file with:
"Linux")
THREADS_FLAG=native
JVMARGS="-ms8m ${JVMARGS}"
JDKHOME=/opt/IBMJava2-131
JREHOME=$JDKHOME/jre
JAVAHOME=$JDKHOME
export JAVAHOME
JDKCP=$JDKHOME/lib/tools.jar
JRECP=$JDKCP
VMTYPE=classic
LD_LIBRARY_PATH=$JREHOME/lib:$JREHOME/lib/${THREADS_FLAG}_threads:$JREHOME/bin:$JREHOME/lib/$ARCH/$VMTYPE:$JREHOME/bin/$VMTYPE:$LD_LIBRARY_PATH
export LD_LIBRARY_PATH
PROLIBPATH=$LD_LIBRARY_PATH; export PROLIBPATH
Run the following to determine if all the files needed to run _sqlsrv2 can be found.
. $DLC/bin/slib_env
. $DLC/bin/java_env
ldd $DLC/bin/_sqlsrv2
Add the path to any of the files listed from the ldd command into the LD_LIBRARY_PATH.
RESTART THE DATABASE USING PROSERVE.