|
I am having a problem running a Java Stored Procedure with JDK 1.4.2. However, the procedure will run with JDK 1.1.8. I have the class file installed in "/QIBM/UserData/OS400/SQLLib/Function". The class that is being called references other instance and static classes. I changed the entry "java.version" in the file "/QIBM/UserData/Java400/SystemDefault.properties" to run with JDK 1.4.2 or 1.1.8. I have also tried changing this in the file in the user's home directory. I am on V5R2 with the following group PTFs installed. PTF Group Level SF99519 83 SF99502 10 SF99271 12 SF99169 15 SF99098 12 The error message below appears when the procedure is run with 1.4.2. Message ID . . . . . . : SQL4304 Severity . . . . . . . : 30 Date sent . . . . . . : 01/28/04 Time sent . . . . . . : 13:27:49 Message type . . . . . : Diagnostic Message . . . . : Java stored procedure or user-defined function GET_ITEM_CLASS_EXT_DESC, specific name could not load Java class EPDM_sp for reason code 5. Cause . . . . . : The Java class given by the EXTERNAL NAME clause of a CREATE PROCEDURE or CREATE FUNCTION statement could not be loaded. The reason codes and their meanings follow: 1 -- The class was not found on the CLASSPATH. 2 -- The class did not implement the required interface ("com.ibm.db2.app.StoredProc" or "com.ibm.db2.app.UDF") or lacked the Java "public" access flag. 3 -- The default constructor failed or was unavailable. Recovery . . . : Ensure that the compiled ".class" file is installed in the CLASSPATH, for example under "/QIBM/UserData/OS400/SQLLib/Function". Ensure it implements the required Java interfaces and is "public". I would appreciate any assistance. Thank you, Allen Godwin
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact copyright@midrange.com.
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.