Hi,
I am trying to store a DATETIME field using EJB CMP in JBoss 4.0.2, XDoclet, and MySQL 4. Definition is very straightforward:
/**
* @return Returns the m_bidDate.
*
* @ejb.interface-method view-type = "both"
* @ejb.persistence column-name = "bid_date"
*/
public abstract Date getBidDate();
/**
* @ejb.interface-method view-type = "both"
*/
public abstract void setBidDate(Date date);
The issue I have is that I when I set a date and then read it out again, it moves back 1 hour:
17:06:58,343 INFO [STDOUT] Bid date out:Sat Jul 10 00:00:00 PDT 2004
...
17:07:01,468 INFO [STDOUT] Bid date in:Fri Jul 09 23:00:00 PDT 2004
I checked the query log for my MySQL DB, and it already arrives there wrong:
UPDATE project SET bid_date='2004-07-09 23:00:00' WHERE plan_key='9779'
Where is this coming from? I have the timezone of all my machines set to PST. Could this be a daylight savings setting?
Thanks,
Al.