0 Replies Latest reply on Nov 16, 2004 9:48 AM by Mihai Ganea

    java.sql.Date problem

    Mihai Ganea Newbie

      Hi,
      I'm using jboss 3.2.6 with MySql and i have the folowing problem:
      I have a table with a field of type Date which is mapped to a java.sql.Date. If i try to compare this field against another ( source.getSentDate().equals(destination.getSentDate()) ) mostly i get the right result but after a while even if the dates are equals (the dates from the sql table) i get that they are different:
      13:58:12,922 INFO [STDOUT] source=2004-11-16 13:54:33.807 EET
      13:58:12,923 INFO [STDOUT] destination=2004-11-16 13:54:10.368 EET
      In the MySql table they are both "2004-11-16".
      If i restart Jboss everything works ok:
      16:05:10,433 INFO [STDOUT] source=2004-11-16 00:00:00.0 EET
      16:05:10,433 INFO [STDOUT] destination=2004-11-16 00:00:00.0 EET
      Anybody has a clue about this?