Error Messages with Network server and the IBM DB2 Universal JDBC Driver

[Kathey Marsden <km...@Sourcery.Org>]

-----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-----