POWER ON · SELF TEST · PASS
CH1
PWR

诡异的database问题,记录一下

24-MAY-2006◆↤ XUWENHAO.COM
POST · 2006 · LOG

Hibernate做O/R Mapping,一个Date类映射到一个timestamp的column,然后save一把,存进去的是一个形如21:00:23.456的timestamp字符串,通过jdbc拿出来,用getString和getTimestamp取,然后用dataformat去parse或者直接toGMTString,发现时区信息,都丢失了。于是考虑直接设置Timezone到GMT,结果发现Hibernate存进去的还是Local Timezone的时间字符串,抓狂,最后发现,用getDate取出timestamp,保留了存进去的时区信息。

真的很奇怪啊。

originally posted at medium.com/@xuwenhao/%E8%AF%A1%E5%BC%82%E7%9A...

NAVNEXT ON THE BENCHDATE
PREV links for 2006–05–24 2006 ←
NEXT 公司停电 2006 →
THIS BOARD HAS BEEN TESTED.
IT RUNS.
Engineer wouldn't write that last line.
He'd just put the board on your desk and walk away.
So - that's what this is.
XUWENHAO.COM  ◆  REV 4.7  ◆  MADE IN SHANGHAI  ◆  2026