| 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: | Whole Thread | Raw Message | 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 |