Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: Automated setting of timezone with connection pooling
- From: Kris Jurka <books(at)ejurka(dot)com>
- To: George Woodring <george(dot)woodring(at)iglass(dot)net>
- Cc: pgsql-jdbc(at)postgresql(dot)org
- Subject: Re: Automated setting of timezone with connection pooling
- Date: Mon, 24 Apr 2006 15:55:08 -0500 (EST)
On Mon, 24 Apr 2006, George Woodring wrote:
We have multiple databases in a cluster ( one for each of our customers ) which the default time zone needs to be different. We are currently using dbcp to do our connection pooling. Can anyone recommend a good way of automatically setting the timezone when the connection is made?
I'm uncertain of what your requirements are. Do you just need a different default timezone per database? If so, ALTER DATABASE mydb SET timezone = 'America/Los_Angeles'; You can also set the timezone in the same fashion per database user. If you have other requirements, you'll need to make them clear, but you're probably out of luck.
Kris Jurka
- References:
- Automated setting of timezone with connection pooling
- From: George Woodring
- Automated setting of timezone with connection pooling
- Prev by Date: Money deprecation and cast problem
- Next by Date: JDBC driver does not support getGeneratedKeys method
- Previous by thread: Automated setting of timezone with connection pooling
- Next by thread: Re: Automated setting of timezone with connection pooling
- Indexes: