persistence@glassfish.java.net

Date/time handling in OraclePlatform class (was: [Fwd: Re: Glassfish bug#1878])

From: Michael Bouschen <Michael.Bouschen_at_Sun.COM>
Date: Wed, 21 Mar 2007 17:36:52 +0100

Hi,

The fix for issue 1878 (date query test issues when running in the Seoul
timezone: https://glassfish.dev.java.net/issues/show_bug.cgi?id=1878)
introduced some special handling for java.sql.Date instance into the
OraclePlatform. I was wondering whether we need to do a similar thing
for other date/time instances such as java.sql.Timestamp etc.

Any idea? I haven't heard anything back from my previous question.

Regards Michael


attached mail follows:



Hi Kyle, hi Wonseok,

a small question: the fix adds some special handling for java.sql.Date
instances. Do we need to do the same for instances of type
java.util.Date or java.sql.Timestamp?

Regards Michael

> Hi Kyle,
> I could confirm that this work well in my environment(Korea/Seoul TZ).
> Now I don't need to change my timezone to run test against Oracle, thanks!
>
> My one concern is a typo in the comment - country is not Koreal but
> Korea.
> I will correct the comment in the code if you don't mind.
>
> Thanks,
> -Wonseok
>
> On 12/30/07, *Kyle Chen* < xiaosong.chen_at_oracle.com
> <mailto:xiaosong.chen_at_oracle.com>> wrote:
>
> Issue Number: 1878
> Submitted By: Kyle Chen
> Obtained From: TopLink
> Reviewed by: TopLink Team
> Short Description: Fix the bug that the wrong date is entered into
> the oracle database when the timezone is Koreal Seoul. The bug is
> fixed by caculating the date with the default timezone, which is
> that of the virtual machine running the application.
> Test: Tested with entity-persistence-tests.
>
>
>
>