topic Update of postgresql driver to 9.1-901.jdbc4 in Alfresco Archive

Update of postgresql driver to 9.1-901.jdbc4

erny18031 — Mon, 27 Feb 2012 17:47:09 GMT

Hi.In the past, I (trademak) included postgresql-8.4-701, but I've not been aware of:http://forums.activiti.org/en/viewtopic.php?f=6&t=1996andhttp://docs.codehaus.org/display/ACT/Database+compatibilityBut now, it hit me! Insufficient testing. Would it be possible to update the root pom.xml to th

Re: Update of postgresql driver to 9.1-901.jdbc4

trademak — Tue, 28 Feb 2012 07:58:03 GMT

Hi Erny,

Can you explain a bit more about the need for the upgrade of the driver?
Yes, Activiti supports Java 1.5 so including a driver that only runs on Java 6 would be an issue.

Best regards,

Re: Update of postgresql driver to 9.1-901.jdbc4

wolpert — Tue, 28 Feb 2012 18:10:51 GMT

I can add some info here. PostgreSQL JDBC development made changes that are not backwards compatible, leading to problems in some cases. The biggest one is a change that makes 'UNICODE' and 'UTF-8' designations different, so database drivers before 9.1 may have incompatibilities connecting to 9.1 databases.

There is also a second issue involving bytea support which changed. (This is the use of hex encoding when entering in bytea data.

The UNICODE/UTF-8 issue is documented here: http://grokbase.com/t/postgresql/pgsql-hackers/114jz3zdpb/jdbc-connections-to-9-1 and the bytea issue is referenced here: http://www.postgresql.org/docs/9.1/static/runtime-config-client.html#GUC-BYTEA-OUTPUT

Also, you need the JDBC3 driver for Java 1.5 support: http://jdbc.postgresql.org/download/postgresql-9.1-901.jdbc3.jar

(I just ran into this as we're in the process of testing an upgrade to our database from 8.3 to 9.1)