All entries for Friday 24 February 2006

February 24, 2006

hsqldb + dates suck :(, but fixed in latest version :)

Writing about web page http://www.hsqldb.org/

So I was using a fairly old version of hsqldb and was doing some unit tests of my DAO which was selecting some rows based on a date column <= someDate.

Unforunately it behaved in the exact opposite way I was expecting :( If someDate was later than the value in the database column then you would expect dateColumn <= someDate to evaluate to true. But no, it didn't. It evaluated to false. Changing the condition to dateDolumn >= someDate evaluated to true!

And yes, timezones etc. were the same :)

Oh well, at least it was consistently wrong.

Upgrading to the latest hsqldb fixed it, and it was fun while it lasted :)


February 2006

Mo Tu We Th Fr Sa Su
Jan |  Today  | Mar
      1 2 3 4 5
6 7 8 9 10 11 12
13 14 15 16 17 18 19
20 21 22 23 24 25 26
27 28               

Search this blog

Tags

Galleries

Most recent comments

  • Interesting… While I'm not completely convinced in such microbenchmarks, I'm pretty sure that 1ms … by Alexander Snaps on this entry
  • Hello. I bought the book yesterday. I was trying to find the source code for chapter 11 and chapter … by Suleman on this entry
  • http://woosight.net/account/login?username=demo by live mashup demo on this entry
  • Thanks mate ….. This blog was really helpful. by Maaz Hurzuk on this entry
  • Ty. Not directly helpful for my problem, but pointed me in the right direction. You will also get th… by Mike E. on this entry

Blog archive

Loading…
Not signed in
Sign in

Powered by BlogBuilder
© MMXX