Kbase 21114: SQL Exception 1 occurs when compiling stored procedures on LINUX 9.1B
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/16/2008 |
|
Status: Verified
FACT(s) (Environment):
Progress 9.1B
RedHat Linux 6.2
SYMPTOM(s):
=== SQL Exception 1 ===
SQLState=HY000
ErrorCode=-20141
[JDBC Progress Driver]:error in compiling the stored procedure
Issue occurs when using Standard Edition of Linux RedHat
SQL errors are generated when the following stored procedure is run:
SQLexplorer> create procedure test()
BEGIN
END;
The .java file created will successfully compile into a .class file (javac test.java) on the Standard Edition.
CAUSE:
Progress Bug # 20010606-004. This issue is related to a defect and a known problem involving IBM's 1.1.8 JDK. IBM has no plans to fix this bug in the 1.1.8 JDK version.
FIX:
Fixed in Progress 9.1C . In Progress 9.1C, the JDK has been switched from IBM JDK for Linux to the SUN [Sun's JDK1.3.0_02] for Linux. This change, flavor and version of JDK, cannot be made at a patch level. These types of changes can be done in a commercial release