Kbase 21181: Java Setting to Make Stored Procedures & Triggers Work
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
2/9/2007 |
|
Status: Verified
GOAL:
What Java environment settings are necessary to run stored procedures?
GOAL:
How to set Java environment for SQL-92 stored procedures
GOAL:
What is required to create stored procedures?
GOAL:
What is required to work with SQL triggers?
FACT(s) (Environment):
Progress 9.1C
Progress 9.1D
Progress 9.1E
OpenEdge 10.0x
FIX:
It is important to read the release notes for the Progress version being used as there may be specific requirements for a particular platform when creating and executing stored procedures. The following information outlines the basic requirements necessary for all platforms.
To create stored procedure and triggers the following is required:
1. JDK appropriate for each version must be installed.
2. JDKHOME environment variable must point to the JDK installation if JDK is not installed by Progress on UNIX.
3. Windows registry keys need to point to the installation directory of the installed JRE if not installed by Progress.
To execute JAVA Stored Procedures or Row triggers
1. Only JRE is required
2. If JRE being used is not the one shipped by Progress, the JREHOME environment variable must be set to point to the JRE location:
-- WINDOWS: at the system level (Control Panel>System>Advanced Tab>Environmental button>System Variables.
-- UNIX: edit the java_env file under the section for the platform being used (located under $DLC/bin).
3. The shared library path has to include the correct path to the Java JVM library or DLL on each platform.
For versions prior to Progress 9.1C, the shared library path is set by Progress.
The following are required settings of shared library path on major platforms.
-- SOLARIS:
LD_LIBRARY_PATH=$DLC/jre/lib/sparc/client:$DLC/jre/lib/sparc:$LD_LIBRARY_PATH
-- HP-UX 11 - 32 bits
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 (not required for OpenEdge 10.0X)
Running the sql_env script is strongly advised.