RE: using java for stored procedures -- JAVA400-L

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

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

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 [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.