Re: Comments on adding more connection URL parameters. - Mailing list pgsql-jdbc

From Kris Jurka
Subject Re: Comments on adding more connection URL parameters.
Date
Msg-id Pine.LNX.4.33.0402040146370.21910-100000@leary.csoft.net
Whole thread Raw
In response to Re: Comments on adding more connection URL parameters.  (Oliver Jowett <oliver@opencloud.com>)
Responses Re: Comments on adding more connection URL parameters.  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: Comments on adding more connection URL parameters.  (Oliver Jowett <oliver@opencloud.com>)
List pgsql-jdbc

On Wed, 4 Feb 2004, Oliver Jowett wrote:

> One issue with the DataSource mapping is that it gets harder to support
> a whole family of parameters (e.g. the guc_ prefix suggested) in one go,
> as we need to know the exact set of parameters we support at compile
> time so we can declare the necessary accessor methods. Maybe we could
> provide a catchall accessor (setExtraParameters()?) that takes a
> Properties object or similar.

Yes, supporting all GUC options is something we certainly wouldn't want to
do by providing a method for each one.  Especially since different server
versions have different options and syntax.  I imagine setGUC(String name,
String value) would be sufficient.  I suppose also we would have to be
aware of GUC options that the driver sets itself (like datestyle and
client_encoding) to ensure that these are not overwritten.

Kris Jurka



pgsql-jdbc by date:

Previous
From: Kris Jurka
Date:
Subject: Re: Comments on adding more connection URL parameters.
Next
From: Tom Lane
Date:
Subject: Re: Comments on adding more connection URL parameters.