Re: Avoiding explicit addDataType calls for PostGIS

From: Kris Jurka <books(at)ejurka(dot)com>
To: Oliver Jowett <oliver(at)opencloud(dot)com>
Cc: Markus Schaber <schabios(at)logi-track(dot)com>, PostGreSQL JDBC <pgsql-jdbc(at)postgresql(dot)org>
Subject: Re: Avoiding explicit addDataType calls for PostGIS
Date: 2004-10-19 06:57:47
Message-ID: Pine.BSO.4.56.0410190144280.28027@leary.csoft.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-jdbc

On Tue, 12 Oct 2004, Oliver Jowett wrote:

> > That is a nice idea that allows to control default configuration without
> > recompiling, and without explicit code in the app.
>
> Here is a first cut at implementing this.
>

This generally looks good, but I was hoping Markus would do some of the
serious testing to see if it meets the needs of his real world app.
Particularly the question about the order the property files are found and
processed in. Additionally the claim that two applications running on the
same JVM want to use two different mappings, I'm not sure that's possible.

Some simpler questions I had are:

1) Is the name postgresql.properties with no package name a good idea? It
doesn't seem ideal for an application to have to create an org/postgresql
directory just to hold a properties file, but I don't like the idea of
invading a global namespace.

2) I notice you've set the default prepareThreshold to five as we agreed
to a while ago, but I haven't gotten around to doing. The reason I
haven't done it yet is because I was concerned about how to do this (and
keep it in sync) for the DataSource implementations. With this patch it
is impossible to set the prepareThreshold back to zero from the
DataSource. It would be a simple fix to change the DataSource code to
make this work, but since we're discussing the general ability to set
defaults I thought I'd bring it up.

Kris Jurka

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Sim Zacks 2004-10-19 06:58:39 plpython question
Previous Message Tom Lane 2004-10-19 06:33:08 Re: Numeric user names

Browse pgsql-jdbc by date

  From Date Subject
Next Message Slobodan Milosevics 2004-10-19 09:11:27 Encoding porblem in JDBC
Previous Message Tomas 2004-10-19 06:53:52 Re: NullPointerException in ResultSetMetaData getColumnCount