Re: SQJAVA?

    Hi Stu,

    "The trace level component can be used to trace the actions that
are performed by the OS/400 module responsible for the Java stored
procedures support...

The trace is enabled by adding the environment variable
QIBM_COMPONENT_TRACE_LEVEL with a value of 'SQJAVA,3'
to the job where the Java stored procedure is executed. The trace
is disabled by removing this environment variable.

Once the trace is taken, it can be dumped with the CL command
DMPUSRTRC either to STDOUT or to a file in QTEMP."

    I just happened to be able to quote that off the top of my head.    ;-P

    More seriously, take a look at

Stored Procedures, Triggers and User Defined Functions on DB2 Universal
Database for iSeries    SG24-6503-01

available at
<
http://publib-b.boulder.ibm.com/Redbooks.nsf/9445fa5b416f6e32852569ae006bb65
f/93beee575837a66185256e390055723e
>

or directly at

http://www.redbooks.ibm.com/redbooks/pdfs/sg246503.pdf

    See "7.11.2 Tracing" for the info quoted and more about trace/debug.
In addition, I would think you could output exception data to a file for
checking.  However, the example given is for a problem matching
argument types, so the trace may be the only way to get that info.


                                                         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: "Bramley, Stu" <stu.bramley@xxxxxxxxxxxxx>
To: "'Java Programming on and around the iSeries / AS400'"
<java400-l@xxxxxxxxxxxx>
Sent: Tuesday, July 27, 2004 9:37 AM
Subject: SQJAVA?


> I'm trying to get a Java Stored Procedure working on the iSeries.. when it
> is called I am receiving message SQL4302 : Java stored procedure or
> user-defined function &1, specific name &2 aborted with an exception "&3".
>
> The lower level output for this message says:
>
> 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.
>
> I cannot find any mention of 'SQJAVA' anywhere else in the manuals - and
> I've had a google and can't find anything... can anyone enlighten me as to
> where I can find some information about this? Or alternatively where I can
> find the stack trace/any output that might help tell me what is going
wrong?
>
> TIA
> Stu
>
> Stuart Bramley
> Senior Technical Developer
> Skandia Life::GroupIT
> Southampton
> t: 023 80 72 64 29 e: stu.bramley@xxxxxxxxxxxxx
> IBM Certified Specialist