Kbase P121342: Error in compiling the stored procedure, when creating an SQL-92 stored procedure
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
3/7/2007 |
|
Status: Unverified
FACT(s) (Environment):
Progress 9.x
OpenEdge 10.x
HP-UX
SYMPTOM(s):
Executing SQL-92 code that creates a stored procedure fails with an error on the screen
=== SQL Exception 1 ===
SQLState=HY000
ErrorCode=-20141
[JDBC Progress Driver]:error in compiling the stored procedure
Using the Java version that is supplied by Progress on HP-UX
CAUSE:
The JAVA SDK is a requirement for java stored procedures and triggers to work. Progress is not licensed to provide the SDK on HP-UX, therefore only the JRE is provided.
FIX:
Download and install the JAVA SDK of the same java version from the HP website.
Follow these steps:
1. First determine which version of the JRE you are currently using:
$DLC/jre/bin/java -version
2. Go to the HP website and download the JAVA SDK of the same version. Ensure that you download the SDK for the correct chipset, either PA-RISC or Itanium chipset. If you are unsure which chipset your machine is using, please contact HP.
At the time of this writing, the SDK can be downloaded from here:
http://www.hp.com/products1/unix/java/versions/index.html
3. Follow the instructions on the HP download page on how to install the SDK product.
4. Once the product has been downloaded and installed, you will need to update the Progress $DLC/bin/java_env file to point to the SDK installation directory. Look for the HP-UX section and change the JDKHOME path as shown below:
"HP-UX") # HP UNIX 11.00
THREADS_FLAG=native_threads
JVMARGS="-ms8m ${JVMARGS}"
#JDKHOME=
JDKHOME=/opt/java1.3
JDKCP=$JDKHOME/lib/tools.jar
JRECP=
VMTYPE=server
ARCH=PA_RISC
# set the shared library search path - snippet from the java script
SHLIB_PATH=$SHLIB_PATH:$JREHOME/lib/$ARCH/$THREADS_FLAG:$JREHOME/lib/$ARCH/$VMTYPE:$JREHOME/lib/$ARCH
export SHLIB_PATH