How to match a Java SQL Exception to the SQL error message

[florian.boldt]

Hi,

is it possible to relate a Java SQL exception (for example: SQL Editor
- bad syntax in a user's sql statement) to the corresponding db2 error
message in a java application?
Does it depend on the JDBC driver type?

Thanks
Florian

[Knut Stolze]

fl***********@itgain.de wrote:

Hi,

is it possible to relate a Java SQL exception (for example: SQL Editor
- bad syntax in a user's sql statement) to the corresponding db2 error
message in a java application?
Does it depend on the JDBC driver type?

When you receive a SQL exception, you can extract the original error message
as was generated by DB2. If you don't get the DB2 error message, then it
may be your application doing some fancy stuff without even touching the
DBMS. I have my doubts that you will be able to relate the error messages
then.

--
Knut Stolze
DB2 Information Integration Development
IBM Germany

[florian.boldt]

danke Knut,

we do receive the db2 retun code but we don't know how or from where to
extract the message text. Any hints?

Thanks
Florian
Knut Stolze schrieb:

fl***********@itgain.de wrote:

Hi,

is it possible to relate a Java SQL exception (for example: SQL Editor
- bad syntax in a user's sql statement) to the corresponding db2 error
message in a java application?
Does it depend on the JDBC driver type?

When you receive a SQL exception, you can extract the original error message
as was generated by DB2. If you don't get the DB2 error message, then it
may be your application doing some fancy stuff without even touching the
DBMS. I have my doubts that you will be able to relate the error messages
then.

--
Knut Stolze
DB2 Information Integration Development
IBM Germany

[Knut Stolze]

fl***********@itgain.de wrote:

we do receive the db2 retun code but we don't know how or from where to
extract the message text. Any hints?

Before I repeat all the details, have a look here:
http://publib.boulder.ibm.com/infoce...d/tjvjcerr.htm

--
Knut Stolze
DB2 Information Integration Development
IBM Germany