Update request for PostgreSQL JDBC

Openfire Openfire Support
1

Hello,

as of today Openfire is shipped with a version 8 PostgreSQL JDBC. This breaks things when using for example the Monitoring Plugin which use Database fields of the type bytea (binary data). The encoding of this type has changed in PostgreSQL 9 and only the newer JDBC driver does work with this datatype and database server version 9 and later.

Not sure if this is the right place but it would be nice if someone could renew the bundled JDBC to at least something in the version 9 range.

http://jdbc.postgresql.org/download.html

Thanks

Andreas

2

Thanks, I have filed OF-759 and am looking into this now.

3

I went with PostgreSQL 9.3 JDBC4 (build 1101) , which is java 1.6+ compat. You think that is OK?

4

Should be fine.They are compatibel down to server version 7.4 which no one is using anymore, so it should cover all PostgreSQL servers running as of today.

Thanks

Andreas