Re: Automated setting of timezone with connection pooling

Hi, Woody,

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?

Chris already pointed out how to set the time zones per database and per
user.

Some connection poolings also include the possibility to specify
commands which are executed after connecting and before reusing a
connection. For JBoss foo-ds.xml, the syntax would be like:


<datasources>
  <no-tx-datasource>
    <jndi-name>...</jndi-name>
    <connection-url>...</connection-url>
    <!-- other settings ... -->
    <new-connection-sql>SET timezone TO 5</new-connection-sql>
    <check-valid-connection-sql>SET timezone TO
5</check-valid-connection-sql>
  </no-tx-datasource>
</datasources>

HTH,
Markus

--
Markus Schaber | Logical Tracking&Tracing International AG
Dipl. Inf.     | Software Development GIS

Fight against software patents in EU! www.ffii.org www.nosoftwarepatents.org