db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Kathey Marsden <kmars...@Sourcery.Org>
Subject Error Messages with Network server and the IBM DB2 Universal JDBC Driver
Date Fri, 03 Sep 2004 18:11:13 GMT
-----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-----

Mime
View raw message