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

[Achilleas Mantzios <achill(at)matrix(dot)gatewaynet(dot)com>]

Στις 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