Very Computer

I'm using type 4 JDBC driver (1.1.67) to access DB2 NT 8.1.

When I get an SQLException I can't retrive a meaningfull error
message, neither using the toString() method, nor using getMessage().
All I can get is something like
"DB2 SQL error: SQLCODE: -204, SQLSTATE: 42704, SQLERRMC: xyz"
Is it impossible to obtain something like
"Wrong statement: non existing table xyz"?

Thanks

Bye

Franco

V8 FP 2
FP2_WR21318\Release.Notes

Full message text is not returned when using SQLException.getMessage()

By default, the DB2BaseDataSource.retrieveMessagesFromServerOnGetMessage
property is disabled. If you enable this property, all calls to the
standard JDBC SQLException.getMessage() invoke a server-side stored
procedure, which retrieves the readable message text for the error. By
default, the full message text is not returned to the client when a
server-side error occurs.

You can use the proprietary method DB2Sqlca.getMessage() to retrieve the
fully formatted message text. A call to the SQLException.getMessage()
method will start a unit of work only if
retrieveMessagesFromServerOnGetMessage is enabled. A call to the
DB2Sqlca.getMessage() method results in a stored procedure call, which
starts a unit of work. Prior to FixPak 1, the DB2Sqlca.getMessage()
method may throw an exception.

PM

Thanks a lot: it works fine.

Bye

Franco