[Bug 676] New: milliseconds bug in java.sql.Timestamp

[bugzilla-daemon at icedtea.classpath.org]

http://icedtea.classpath.org/bugzilla/show_bug.cgi?id=676

           Summary: milliseconds bug in java.sql.Timestamp
           Product: IcedTea
           Version: unspecified
          Platform: all
               URL: http://kurtstam.blogspot.com/2011/03/as-if-time-isnt-
                    difficult-enough-i-say.html
        OS/Version: Mac OS
            Status: NEW
          Severity: normal
          Priority: P5
         Component: IcedTea6
        AssignedTo: unassigned at icedtea.classpath.org
        ReportedBy: kurt.stam at gmail.com


BACKGROUND
I found a bug in java.sql.Timestamp that was making my unit tests fail once it
a while when the planets aligned just the right way. I was storing
java.util.Date values to a Db using Hibernate and when they come back out, they
are represented as java.sql.Timestamp, which is a small wrapper around
java.util.Date.

ISSUE
In TimeStamp, they are storing the time in whole seconds and the remaining
nanos seperately. In the Timestamp.compareTo, they call the super class first
(but pass the time part only). So methods like before() and after() are all in
error when milliseconds count. See the attached unit test if you care to
reproduce (simply run 'mvn package').

I reproduced it on both OSX's JDK
Java version: 1.6.0_24
Java home: /System/Library/Java/JavaVirtualMachines/1.6.0.jdk/Contents/Home
Default locale: en_US, platform encoding: MacRoman
OS name: "mac os x" version: "10.6.6" arch: "x86_64" Family: "mac"

as well as on Linux using OpenJDK.

Java version: 1.6.0_17
Java home: /usr/lib/jvm/java-1.6.0-openjdk-1.6.0.0.x86_64/jre
Default locale: en_US, platform encoding: UTF-8
OS name: "linux" version: "2.6.18-194.26.1.el5xen" arch: "amd64" Family: "unix" 

I know the javadoc is full of disclaimers but to *not* pass the milliseconds to
the java.util.Date super class is simply wrong.

This makes for really hard to find bugs, since even the simple act of adding
logging statements, or hooking up a debugger makes the code just slow enough
that all start working ok. This is very frustrating issue!

--Kurt


-- 
Configure bugmail: http://icedtea.classpath.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.