Tuesday, May 20, 2008

Re: [JDBC] org.postgresql.xa.PGXADataSource and compatible=8.2 in query string

Στις Tuesday 20 May 2008 15:27:47 ο/η Achilleas Mantzios έγραψε:
> 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.

Does org.postgresql.xa.PGXADataSource support property "URL"?

> --
> Achilleas Mantzios
>

--
Achilleas Mantzios

--
Sent via pgsql-jdbc mailing list (pgsql-jdbc@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-jdbc

No comments: