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
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 |