Connection pooling, jdbc3 and encoding

From: Andrea Aime <andrea(dot)aime(at)aliceposta(dot)it>
To: pgsql-jdbc(at)postgresql(dot)org
Cc: cholmes(at)openplans(dot)org
Subject: Connection pooling, jdbc3 and encoding
Date: 2004-05-16 16:34:34
Message-ID: 200405161834.34955.andrea.aime@aliceposta.it
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Hi jdbc hackers,
(cc'ing Chris Holmes which is the really interested person, I'm just writing
this e-mail since I'm aware of the problem and I'm already subscribed
to the pgsql-jdbc list)

At the geoserver project we are struggling with issue related to encoding.
Basically we would need to:
* use the JDBC3 driver;
* manage a connection pool;
* set the connection encoding (but it seems to be working only with jdbc2?)
* change the encoding of an opened connection.

About the latest request, we need to serve data to clients in different
encodings (geoserver is a network server that usually works on the
internet), and the encoding is part of the client request (specifically,
the client specify a charset, but it is the same as encoding in postgresql
parlance, right?).
Now, we we extract a connection from the connection pool, we would need to
change its enconding to fullfill the client request...
The other options seems to be to handle a connection pool for each
encoding (and maybe lazily create the pools) or to re-encode things
at the client side...

What do you suggest?

Best regards
Andrea Aime

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Kris Jurka 2004-05-16 20:21:28 Re: [BUG?] Extreme dates
Previous Message ow 2004-05-16 15:02:04 [BUG?] Extreme dates