I have a table with a datetime column(CHECK_IN_TIME), among other columns. I would like to be able to go to
it via JDBC and do some searches using the CHECK_IN_TIME column as the qualifier. My query statement(see below) seems
to work fine via the interactive mode (mysql) but throws an exception when I used it via JDBC. Any help is
select count(*) from MY_TABLE where CHECK_IN_TIME > '2004-04-14 14:04:29'