× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



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 thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

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.