Hi,
i have been struggling to correctly setup a new Jboss 4.2.2 (migrating from 3.x) and postgresql 8.3.1 (migrating from 7.4.x).
I have decided to use XA support, since due to jboss changes Jboss TM -> Jboss TS, some code that used to work
didnt work any more. This is not PostgreSQL issue of course.
One option would be to run Jboss with Jboss TM, which is a deprecated way that will certainly couse future problems.
So i used Jboss TS, but inorder to do that i had to use the org.postgresql.xa.PGXADataSource instead of the classic org.postgresql.Driver
local datasource.
I did so, and it worked!!
The problem is that i dont know of a way to tell the org.postgresql.xa.PGXADataSource to use compatible=8.2, for array usage.
Is there any workaround?
I will post the same to the jboss camp as well.
--
Achilleas Mantzios