Re: SQL Error - how to track

You can specify "errors=full" on you connection URL.

For example, if you are using the DriverManager to get connections, this
code will provide the second level text in the SQLException message when
errors occur.

     Connection connection = DriverManager.getConnection
("jdbc:db2:system;errors=full");

There is also a DataSource property to accomplish this if you are using
DataSources.

Regards,

Richard D. Dettinger
AS/400 Java Data Access Team

"Biologists have a special word for stability -- dead"

                Larry Wall
                Open Source Developers Journal
                Issue 1, Jan  2000


"Eyers, Daniel" <daniel.eyers@honeywell.com>@midrange.com on 09/06/2001
03:47:23 PM

Please respond to java400-l@midrange.com

Sent by:  java400-l-admin@midrange.com


To:   "'java400-l@midrange.com'" <java400-l@midrange.com>
cc:
Subject:  SQL Error - how to track




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.