Re: Timestamps without time zone

On Thu, 10 Jan 2008, Achilleas Mantzios wrote:

> I tried other apps with the new postgresql-8.2-507.jdbc3.jar and some of
> them break. So i will need to live with the 7.4.19 driver for a while.

Without an actual failure it's tough to advise you here.  You might try
the URL option protocolVersion=2 or stringtype=unspecified to solve some
of the more common problems people have come across with the upgrade as a
workaround.

> One question, is there a way to get a hold of the Default TimeZone
> instance of the JVM (lets call it default_TZ) and put all code that
> alter it in some sort of
>     synchronized (default_TZ) {
>         TimeZone.setDefault(TimeZone.getTimeZone("UTC"));
>         // jdbc calls here that deal with timestamps without time zone
>         java.util.TimeZone.setDefault(null);
>     }
> block?

This seems unlikely to work.  Everyone would have to get the default_TZ
object before doing any TZ manipulation so they'd synchronzie on the same
object.  And there's no way you can control other code that just wants
to print out a date.  It's not going to synchronize itself on anything.

Kris Jurka