Re: Java External Procedure

    See:

http://www.dbtalk.net/ibm-software-db2-os400/error-java-stored-procedure-105903.html


                                                         Joe Sam

Joe Sam Shirah -        http://www.conceptgo.com
conceptGO       -        Consulting/Development/Outsourcing
Java Filter Forum:       http://www.ibm.com/developerworks/java/
Just the JDBC FAQs: http://www.jguru.com/faq/JDBC
Going International?    http://www.jguru.com/faq/I18N
Que Java400?            http://www.jguru.com/faq/Java400


----- Original Message ----- 
From: "Justin Taylor" <JUSTIN@xxxxxxxxxxxxx>
To: <java400-l@xxxxxxxxxxxx>
Sent: Tuesday, March 21, 2006 9:03 AM
Subject: Java External Procedure


> > I have an iSeries Java app that accesses a non-iSeries database via
> > JDBC.  The app runs fine through QSH.  I am trying to create an
> > External Stored Procedure so that I can call this app with SQL.
> >
> > I created a symbolic link to my Class file in
> > "/qibm/UserData/OS400/SQLLib/Function".  I created the procedure using
> > iSeries Navigator.  When I call the procedure from interactive SQL, I
> > receive the following error:
> >
> > SQL4306
> > Java stored procedure or user-defined function [procedure], specific
> > name  could not call Java method [method], signature
> > (Ljava/lang/String;[Ljava/sql/ResultSet;)V.
> >
> >
> > I have been unable to find any reference to this error.  Does anyone
> > know what this is trying to tell me?
> --