Update of postgresql driver to 9.1-901.jdbc4

[erny18031]

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

and

http://docs.codehaus.org/display/ACT/Database+compatibility

But now, it hit me! Insufficient testing. Would it be possible to update the root pom.xml to the version in the title?

Be aware thar jdbc4 is for JDK >= 1.6. (Is Activiti supposed to run ontop of Java 1.5?)

Regards.
Erny

[trademak]

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,

[wolpert]

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)