Skip to main content

Posts

Showing posts from December, 2009

MySql Timediff and JDBC (ConnectorJ) - Bad format for Time 'hhh:mm:ss' in column x

MySQL Types to Java Types for ResultSet.getObject(). MySQL Type Name Return value of GetColumnClassName Retur TIME TIME java.sql.Time http://dev.mysql.com/doc/refman/5.1/en/connector-j-reference-type-conversions.html ResultSet.getTime() will fail with an SQLException: "Bad format for Time 'hhh:mm:ss' in column x" http://bugs.mysql.com/bug.php?id=11154 Surprisingly (Shockingly) ResultSet.getString() was also throwing the same exception "Bad format for Time". http://forums.sun.com/thread.jspa?threadID=5149261