#57 timstamp display problem with DatabaseManagerSwing

open-fixed
None
7
2007-08-10
2006-10-18
Anonymous
No

The swing database manager crops timestamps so that
only the date is shown, not the time. The console-
based database manager shows the complete timestamp
so I think this is a display issue with the swing
code.

This occurs with Revision 1.68 of the
DatabaseManagerSwing. Perhaps it is fixed in a new
version as I saw a posting about the bug but not a
bug report itself.
Raj
rsudra@hotmail.com

Discussion

  • Fred Toussi
    Fred Toussi
    2007-05-30

    • labels: 325100 -->
    • priority: 5 --> 7
     
  • Blaine Simpson
    Blaine Simpson
    2007-06-12

    • assigned_to: nobody --> unsaved
    • status: open --> open-accepted
     
  • Blaine Simpson
    Blaine Simpson
    2007-08-10

    Logged In: YES
    user_id=551431
    Originator: NO

    Problem is due to poor JTable design. JTable prints all java.util.Date subclasses as dates without times, even though JDK-supplied classes like Timestamp are java.util.Date subclasses which have times.

    I've implemented the following work-around. DatabaseManagerSwing now does a .toString() for all java.util.Date subclasses.

    This results in undesirable behavior for Oracle. This is because Oracle has not implemented basic toString() methods for their time classes (why???). I've tested several other databases, and this work-around works great for them all.

    Fix committed to CVS hsqldb-dev module (to be HSQLDB 1.8.0.8).

     
  • Blaine Simpson
    Blaine Simpson
    2007-08-10

    • status: open-accepted --> open-fixed