RE: AS400 and Java CallableStatement woes

Pete

*       I would generally set property naming=system, this will make the
connection use the library list to search for the program. That way you
don't need to specify the library for the program eg call y00405
*       How have you registered your program in the database. I believe
there are two steps to this searching for the program. The first is that the
stored procedure definition has to be found in QSYSPROCS, the second is that
the underlying program has to be found on the system. Read the error message
very carefully to determine where you are getting the error.
*       In development I always set property trace=true. This will give you
a lot more information about the JDBC connection, and will also list the
as400 server job that is handling the connection. That way you can look at
the job log and see if there are any more detailed messages that may be
useful in finding out where the problem is. You can also STRSRVJOB on this
server job so that you can debug the RPG program when it is called by the
database.

cheers
Colin.W

http://as400blog.blogspot.com <http://as400blog.blogspot.com> 

Extension   5800
Direct dial   0870 429 5800


-----Original Message-----
From: StokesP@xxxxxxxxxxxxxxxx [mailto:StokesP@xxxxxxxxxxxxxxxx
<mailto:StokesP@xxxxxxxxxxxxxxxx> ]
Sent: 25 January 2005 09:30
To: Java Programming on and around the iSeries / AS400
Subject: AS400 and Java CallableStatement woes







Hi,
I am having problems calling a RPG ILE program on AS400 from a Java class
using Java's CallableStatement (JTOpen). I have two versions of the RPG
program, one takes an input param and gives output in the second param, or
one that takes the input param and gives output in the same param space. The
only way I can seem to prove it actually calls the program is when I hard
code my policy number into the prepareCall statement and make sure there are
no "?"'s. Though this is useless to me because I need to get the returned
string from the program. If I do anything other than hard code my policy
into prepareCall then I always get a SQLException on the prepareCall, it
generally complains about not finding the program. This is just a quick test
class, once proven, it's going into a struts webapp so I want to use commons
dbcp and not the AS400 classes directly like AS400 as400 = new
AS400("10.2.0.3");. Any comments would be appreciated ! Thanks, Pete.

public static void main(String[] args){
     CallableStatement csmt = null;
     ResultSet rs = null;
     Connection con = null;

     try{
       Class.forName("com.ibm.as400.access.AS400JDBCDriver");
     }catch(Exception e){
       System.out.println(e.toString());
     }
     try{
        con = DriverManager.getConnection("jdbc:as400://10.2.0.3; translate
         binary=true;date format=iso; errors=full;
         libraries=LIBA,LIBB,LIBC,LIBD");
         csmt = con.prepareCall("call LIBB.Y00405(?,?)");
         smt.setString(1, "'ABC/REF/POLICY'");
         csmt.registerOutParameter(2, Types.VARCHAR);
          csmt.execute();
System.out.println("++++RESULT: " + csmt.getString(2));



****************************************************************************
*******
This email and any files transmitted with it are confidential and intended
solely for the use of the individual or entity to whom they are addressed.
If you have received this email in error please notify the system manager.
This footnote also confirms that this email message has been swept by
MIMEsweeper for the presence of computer viruses.
****************************************************************************
*******
For any information on the Quinn Group of Companies please visit :-

http://www.quinn-group.com <http://www.quinn-group.com> 

--
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
<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
<http://archive.midrange.com/java400-l> .
This e-mail has been sent by a company of Bertram Group Ltd, whose registered 
office is 1 Broadland Business Park, Norwich, NR7 0WF. 
This message, and any attachments, are intended solely for the addressee and 
may contain privileged or confidential information.  If you are not the 
intended recipient, any disclosure, copying, distribution or any action taken 
or omitted to be taken in reliance on it, is prohibited and may be unlawful.  
If you believe that you have received this email in error, please contact the 
sender immediately. Opinions, conclusions and statements of intent in this 
e-mail are those of the sender and will not bind a Bertram Group Ltd company 
unless confirmed in writing by a director independently of this message. 
Although we have taken steps to ensure that this email and any attachments are 
free from any virus, we advise that in keeping with good computing practice the 
recipient should ensure they are actually virus free.