Re: SQL Error - how to track

If you have v5r1 Toolbox or JTOpen 2.0 or later, the job ID of the server
job for a connection is available.  If you turn on JDBC tracing the ID is
logged with the other information.  There is also a public method,
AS400JDBCConnection.getServerJobIdentifier() that returns the info.

David Wall
AS/400 Toolbox for Java




                    "Eyers, Daniel"
                    <daniel.eyers@hone       To:     "'java400-l@midrange.com'" 
<java400-l@midrange.com>
                    ywell.com>               cc:
                    Sent by:                 Subject:     SQL Error - how to 
track
                    java400-l-admin@mi
                    drange.com


                    09/06/2001 03:47
                    PM
                    Please respond to
                    java400-l






I'm getting an SQL error [SQL0802] Data conversion or data mapping error.
on
a JDBC SQL call to the AS/400...

I'm having trouble tracking it down; I'd like to see the full error
generated by the AS/400 (in the job log) but I'm not sure how the
connection
works.  I know that the JDBC is served by a QUSER job.

Is there a way to track the error to the job and check it's error log?
We're still on WAS 2.0.3.1 ....

any and all help would be greatly appeciated...

thanks

dan
_______________________________________________
This is the Java Programming on and around the iSeries / AS400 (JAVA400-L)
mailing list
To post a message email: JAVA400-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/java400-l
or email: JAVA400-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/java400-l.