Timestamp issue

[clau25]

Something weird happens in my application. I have a timestamp field in a table that has all the time's values set to hour 0 (ex. 2004-11-09 00:00:00.0). When my application loads this field from the database (within a session bean), some of the values have the time set to hour 1 (ex. 2004-11-09 01:00:00.0). This happens just to some values, not to all of them and i could not say what values are loaded with 0 hour and what with 1 hour.

Any tip would be very much appeciated, i'm kinda lost here,
Claudia

[jobor]

Be aware of how you fill the CMP field (if you're using CMP). Look at the type mappings in the standardjbosscmp-jdbc.xml file. E.g use a Calendar object in your application to create a correct date and time object (aware of timezone etc.) and use this object to fill a date, time or timestamp field (used by CMP or plain JDBC).

Johan.