Re: using java for stored procedures

Hi Mike,

I'm not sure if your message below was a question, but if so:

The issue is pretty clear: "Connection to relational database AS400ADM already exists."

This is actually SQL0842; apparently you aren't chaining exceptions as described in my JDBC 2.0 tutorial, so you're only getting the first diagnostic error, SQL4302.

Some of the ways to connect only allow a single comnnection to THE relational database, which is effectively the AS/400 (AS400ADM in your case), and I'd say you're using that way. The answer should be either make sure you disconnect, or connect only once for the life of the SP, as you decide. Just an educated guess without the code, of course. HTH,


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: "Mike Cunningham" <mike.cunningham@xxxxxxx>
To: "'JAVA400-L@xxxxxxxxxxxx'" <java400-l@xxxxxxxxxxxx>
Sent: Wednesday, March 25, 2009 12:21 PM
Subject: RE: using java for stored procedures

We are getting

Additional Message Information

Message ID . . . . . . : SQL4302 Severity . . . . . . . : 30
Message type . . . . . : Diagnostic
Date sent . . . . . . : 03/25/09 Time sent . . . . . . : 11:55:43

Message . . . . : Java stored procedure or user-defined function
KEVIN.WAKEONLAN, specific name WAKEONLAN aborted with an exception
"Connection to relational database AS400ADM already exists.".
Cause . . . . . : The Java stored procedure or user-defined function aborted
with a Java exception. If SQJAVA component trace is on, then the component
trace for the job contains a Java stack traceback for the aborted method.
Recovery . . . : Debug the Java method to eliminate the exception.




-----Original Message-----
From: java400-l-bounces@xxxxxxxxxxxx [mailto:java400-l-bounces@xxxxxxxxxxxx] On Behalf Of Jason Abreu
Sent: Wednesday, March 25, 2009 11:33 AM
To: JAVA400-L@xxxxxxxxxxxx
Subject: Re: using java for stored procedures

I am attempting to do the exact same thing right now.
My procedure appears to be executing without errors, but I cannot tell
that the procedure actually did anything. I am testing by moving data
from one test table to another. My "to" file remains empty after execution.
:-/

Mike Cunningham wrote:

Does anyone have a simple working stored procedure using java instead of RPG? We have been trying to set our first one up following the Redbook but it is not working and a simple example might get us on the right path.

Thanks