New related comments
Number of comments in the last 48 hours
Monitoring mysql status
Location of mysql startup script
Best operating system settings for mysql throughput
JDBC error message Illegal hour value for java.sql.Time type in value
This article has not been rated yet. After reading, feel free to leave comments and rate it.
Question:I am getting a mysql exception with JDBC:
javax.servlet.ServletException: java.sql.SQLException: java.sql.SQLException: Illegal hour value '94' for java.sql.Time type in value '94:42:06.
The statement runs OK in the mysql shell (see below).
What can I do?
Answer:This is a known bug in mysql 5.0
A workaround is to convert this query to return a string. E.g. you can query
Then the returned value will be a string instead of a time field and JDBC will not parse it.