-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1
This is a common stumbling block so I just thought I would mention ...
By default, the IBM DB2 Universal JDBC Driver does not retrieve message text. This is because it has to invoke a separate stored procedure to get the message text. There are performance and unit of work considerations in turning the message retrieval on so it is left as a connection attribute.
To retrieve messages with Universal Driver set the connection attribute ~ retrieveMessagesFromServerOnGetMessage=true
The Universal Driver URL format is as follows jdbc:derby:net://server[:port]/databaseName[:propertyKey=value;...]
In ij you could connect like this:
ij>connect 'jdbc:derby:net://localhost:1527/mydb;create=true:user=me;password=secret;retrieveMessagesFromServerOnGetMessage=true;';
Note that 1) Derby embedded attributes (e.g create=true) are passed as part of the databaseName.
2) There is a ":" between the databaseName (along with embedded attributes) and the Universal driver attributes
3) Each Universal Driver attribute (including the last one) is followed by a ';'
4) The Universal Driver requires that the user and password attributes be set.
-----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.5 (MingW32) Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org
iD8DBQFBOLPBG0h36bFmkocRAlKlAJ4r+EWWRkijxhq20HhgnFmjpkfLZQCfcsTJ TlcNfsHWz7vvb3oF4GJlAaI= =0QUL -----END PGP SIGNATURE-----
