Kbase 21281: SQL92-Possible cause for error in compiling stored procedure
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
8/27/2001 |
|
SUMMARY:
The KBase demonstrate if you don't have JDK directory installed under %dlc%, you might get the error
=== SQL Exception 1 ===
SQLState=HY000
ErrorCode=-20141
[JDBC Progress Driver]:error in compiling the stored procedure
when compiling stored procedures.
EXPLANATION:
You will need development capability to get Java stored procedures compiled.
SOLUTION:
Following are symptoms that this solution will apply:
1. When compiling stored procedures in SQL explorer, you are getting error
[JDBC Progress Driver]:error in compiling the stored procedure
2. You are missing jdk directory under %dlc%
3. The temporary .java file is created in your wrk directory and you are able to use standalone java compiler to compile it without errors
Then you need to move the jdk directory directly under %dlc%, or install a Progress development type license. After that, you will have to restart the server.
References to Written Documentation: