Tuesday, May 20, 2008

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

Στις Tuesday 20 May 2008 16:07:14 ο/η Achilleas Mantzios έγραψε:
> Στις 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"?
Just browsing the source of

http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/jdbc/pgjdbc/org/postgresql/ds/common/BaseDataSource.java?rev=1.13&content-type=text/x-cvsweb-markup
and i cant find anything close to supporting the "compatible" parameter.
Any thoughts?
>
> > --
> > Achilleas Mantzios
> >
>
>
>
> --
> 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: