Re: JAVA Stored Procedure

["Ruth, Brice" <bruth@xxxxxxxxxxx>]

Glad this worked, I'll report your success to our cooperative iSeries 
engineer :)

Himes, Jay wrote:

> This fixed the stored procedure.
>
> There is still a problem with the UDF; but I just needed 1 or the other.
>
> Thanks to every one for all the help.
>
> Jay Himes
> Liberty University
>
> -----Original Message-----
> From: java400-l-bounces@xxxxxxxxxxxx [mailto:java400-l-bounces@xxxxxxxxxxxx]
> On Behalf Of Ruth, Brice
> Sent: Monday, April 05, 2004 11:24 AM
> To: Java Programming on and around the iSeries / AS400
> Subject: Re: JAVA Stored Procedure
>
> Jay,
>
> Check this out - I had the iSeries engineer forward this to me, this is what
> we did when we got the "error code 5" thingie after our V5R2 upgrade:
>
>  Document Number:   29531649
>  ____________________________________________________________
>  Functional Area:                       DB2 UDB for OS/400
>  SubFunctional Area:               Native JDBC
>  SubSubFunctional Area:       General
>  ____________________________________________________________
>  Product:  OS/400 BASE (5722SS100)
>  Release:  V5R2M0
>
>  Classification:       IBM Internal Use
>
>  Keywords:
> ____________________________________________________________
> Document Title:runtime.zip Required for Java Stored Procedures and
> User-Defined Functions  Document Description:
>  Because a Java stored procedure or user-defined function (UDF) may use
> SQLJ, the Java Virtual Machine (JVM) started to run the stored procedure or
> UDF must initialize the SQLJ environment.  This requires the SQLJ runtime
> support contained in runtime.zip.  R510 and R520 OS/400 include runtime.zip
> in the user classpath; however, newer versions of the JDK require that the
> runtime.zip file be loaded by the extensions classloader.  If runtime.zip
> cannot be loaded, the application encounters the following message: SQL4304
> - Java stored procedure or user-defined function &1, specific name &2 could
> not load Java class &3 for return code of 5 (MSGSQL4304 RC5).
>
> To add runtime.zip to the extensions classpath, create a symbolic link
> (symlink) to runtime.zip in the directory /QIBM/UserData/Java400/ext.
> To create the symlink use the following command in a QSHell (QSH) command
> prompt:
>
> ln -s /QIBM/ProdData/OS400/Java400/ext/runtime.zip
> /qibm/userdata/java400/ext/runtime.zip
>
> Alternatively the Add Link (ADDLNK) command can be used.  On the OS/400
> command line, type the following:
>
> ADDLNK OBJ('/qibm/ProdData/OS400/Java400/ext/runtime.zip')
> NEWLNK('/qibm/userdata/Java400/ext/runtime.zip')
>
> Press the Enter key.
>
> The next version of iSeries Information Center will be updated to include
> the setup information listed above.
>
> _______________________________________________
> This is the Java Programming on and around the iSeries / AS400 (JAVA400-L) 
> mailing list
> To post a message email: JAVA400-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/java400-l
> or email: JAVA400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/java400-l.
>
>