DelphiFAQ Home Search:

JDBC error message Illegal hour value for java.sql.Time type in value

 

commentsThis 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

concat('',timediff(NOW(),from_unixtime(max(t_time))))

Then the returned value will be a string instead of a time field and JDBC will not parse it.

mysql> select timediff(NOW(),from_unixtime(max(t_time))) from [..]

+--------------------------------------------+
| timediff(NOW(),from_unixtime(max(t_time))) |
+--------------------------------------------+
| 94:41:48                                   | 
+--------------------------------------------+
1 row in set (0.09 sec)



Comments:

2012-04-05, 06:14:12
anonymous  
thank u :)
2012-06-05, 21:30:55
anonymous from China  
<strong> http://www.coachout..strong> <a href=' http://www.coachout..g>Coach Outlet Online</strong></a><br />
<strong> http://www.coachfac..strong> <a href=' http://www.coachfac..g>Coach Factory</strong></a><br />
<strong> http://www.myloveco..strong> <a href=' http://www.myloveco..g>Coach Outlet Online</strong></a><br />
<strong> http://www.buyincoa..strong> <a href=' http://www.buyincoa..g>Coach Outlet</strong></a><br />
<strong> http://www.cheapcoa..strong> <a href=' http://www.cheapcoa..g>Cheap Coach Handbags</strong></a><br />
<strong> http://www.coachfac..strong> <a href=' http://www.coachfac..g>Coach Factory Outlet</strong></a><br />
<strong> http://www.buycoach..strong> <a href=' http://www.buycoach..g>Coach Outlet Online</strong></a><br />
<strong>www.coachoutletonfactory.net</strong> <a href=' http://www.coachout..g>Coach Factory Outlet</strong></a><br />
<strong>www.coachoutletonline4you.us</strong> <a href=' http://www.coachout..g>Coach Outlet Online</strong></a><br />
<strong>coachfactoryoutletq.net</strong> <a href=' http://www.coachfac..g>Coach Factory</strong></a><br />
<strong>gotocoachoutlets.net</strong> <a href=' http://www.gotocoac..g>Coach Outlet Online</strong></a><br />
2012-11-12, 02:18:42
anonymous from United Kingdom  

 

 

NEW: Optional: Register   Login
Email address (not necessary):

Rate as
Hide my email when showing my comment.
Please notify me once a day about new comments on this topic.
Please provide a valid email address if you select this option, or post under a registered account.
 

Show city and country
Show country only
Hide my location
You can mark text as 'quoted' by putting [quote] .. [/quote] around it.
Please type in the code:

Please do not post inappropriate pictures. Inappropriate pictures include pictures of minors and nudity.
The owner of this web site reserves the right to delete such material.

photo Add a picture: