Kbase P196: Error in Compiling a JAVA Stored Procedure with JAVA Proxies
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
16/09/2008 |
|
Status: Verified
SYMPTOM(s):
Attempting to generate a JAVA stored procedure via a SQL-92 server results in an exception
[JDBC Progress Driver]: error in compiling the stored procedure
SQL Exception 1
SQLState=HY000
ErrorCode=-20141
FACT(s) (Environment):
Progress 9.x
OpenEdge 10.x
All Supported Operating Systems
CAUSE:
In order to get past the above SQL exception being generated with the CREATE PROCEDURE code, The SQL server processing the JAVA code must have the correct CLASSPATH settings.
FIX:
Using the Progress SQL Explorer these settings would correspond to the PROGRESSCP environmental variable. The required is the path to the directory above the package name (testApp) and the Progress .zip files (o4glrt.zip and o4glrt2.zip).