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?