RE: using java for stored procedures

[Mike Cunningham <mike.cunningham@xxxxxxx>]

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