诡异的database问题,记录一下
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...
| NAV | NEXT ON THE BENCH | DATE | |
|---|---|---|---|
| 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.
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