The following bug has been logged online:

Bug reference: 1065
Logged by: R. Lemos

Email address: rslemos (AT) nce (DOT) ufrj.br

PostgreSQL version: 7.4

Operating system: Linux

Description: JDBC DataSource Serializability

Details:

The JDBC2 pooled datasource(org.postgresql.jdbc2.optional.Connectio nPool),
although implements java.io.Serializable, cannot be correctly serialized.
Its superclass does not implement java.io.Serializable and have important
fields marked as private.

Either should the superclass be Serializable or its fields non-private
(protected, friend or public).

To reproduce the issue just create and setup a ConnectionPool, serialize and
desserialize it (ByteArray*Stream will do). The new object doesn't have the
properties correctly set.

This may apply to other DataSource implementations (JDBC3 and non-pooled).

PS: I could have corrected this and submitted the patch, but I don't know
why are those properties private nor why isn't the superclass Serializable,
so I could not preview the impact those changes would make.


---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster