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