Consultor Eletrônico



Kbase P99062: ErrorCode=-20211when executing a JAVA Stored Procedures or Row triggers
Autor   Progress Software Corporation - Progress
Acesso   Público
Publicação   4/20/2009
Status: Unverified

SYMPTOM(s):

Error when executing a JAVA Stored Procedures or Row triggers

[JDBC Progress Driver]:Server not reachable or possible RPC error

SQL Exception
SQLState=HY000
[JDBC Progress Driver]:Server not reachable or possible RPC error
No database connected. (8934)

No database connected. (8934)

FACT(s) (Environment):

All Supported Operating Systems
Progress 9.x
OpenEdge 10.x

CAUSE:

The shared library path does not include the correct path to the Java JVM library or DLL for the platform being used.


FIX:

Fix the shared library path for the Operating System that Java stored Procedure is being executed on:

SOLARIS: LD_LIBRARY_PATH=$DLC/jre/lib/sparc/client:$DLC/jre/lib/sparc:$LD_LIBRARY_PATH

32 bit HP-UX 11 SHLIB_PATH=$DLC/jre/lib/hpux
ative_threads:$DLC/jre/lib/hpux/classic:$DLC/jre/lib/hpux:$SHLIB_PATH

IBM AIX: LIBPATH=$DLC/jre/bin:$DLC/jre/lib:$DLC/jre/bin/classic:$LIBPATH
PROLIBPATH=$JDKHOME/jre/bin:$JDKHOME/jre/bin/classic:$PROLIBPATH

Compaq Tru64: LD_LIBRARY_PATH=$JREHOME/bin/classic:$LD_LIBRARY_PATH

Linux: LD_LIBRARY_PATH=$JREHOME/lib/i386
ative_threads:$JREHOME/lib/i386/classic:$LD_LIBRARY_PATH
PROLIBPATH=$JREHOME/lib/i386
ative_threads:$JREHOME/lib/i386/classic:$PROLIBPATH

Unixware: LD_LIBRARY_PATH=$JREHOME/lib/x86at:$JREHOME/lib/x86at/classic:$JREHOME/lib/x86at
ative_threads:$LD_LIBRARY_PATH

Windows NT / 2000 (with DLC set first): set PATH = %PATH%;%DLC%/jre/bin/hotspot