Re: JDBC with Timestamp with local time zone column

From: <thtsang_yh_at_yahoo.com.hk>
Date: 27 Feb 2005 18:43:14 -0800
Message-ID: <1109558594.682605.55030@g14g2000cwa.googlegroups.com>

Thanks for the reply.

It is found that when using the 8i and 9i jdbc drivers, sessiontimezone is '+00:00', ignoring the machine time zone setting. TimeZone.getDefault() gives the correct time zone.

What is the standard / recommanded way of setting the session timezone correctly? A JDBC API or simply call 'alter session set time_zone...'?

Haximus wrote:
>
> Just a coupel of thoughts:
>
> [1] check that your session is usingcorrect timezone, verify through
your
> driver that 'select dbtimezone from dual' and and 'select
sessiontimezone
> from dual' return the correct settings.
> [2] if the above are correct, trace the session/turn on jdbc logging
and
> make sure something isn't setting them
> [3] don't use the 8i driver
Received on Sun Feb 27 2005 - 20:43:14 CST