
MySQL JDBC 5.0.5 bug with TIME column and midnight
Coldfusion 8 comes bundled with the mysql commercial jdbc driver 5.0.5 (or it did with my install anyway). I just ran into a bug that results in this error: java.sql.SQLException: Value '00:00:00 can not be represented as java.sql.Time
The bug is the date / time parsing interprets midnight (00:00:00) as illegal for the TIME type.
Two ways to fix.
Update to 5.0.6 (I haven't tried this yet, but assume it would be just fine)
OR add "useFastDateParsing=false" to the connection string in the datasource.
I tried the "useFastDateParsing=false" and it worked perfectly. No restarts of anything. Not sure how that will affect performance though. My quick tests show it running pretty quick still. If I get time I will try with and without and time queries to see. Ideally I would like to update the driver instead, but its Friday at 5:30 and I am not about to do that right now.
Which gets me thinking, how often would Adobe be updating these drivers? Will the next updater fix this? Or should we be doing that manually?

NAVIGATION
HomeAbout Me
RSS
Search
Subscribe
Recent Entries
Flash Camp BostonNew Blog Design
Pre-Conference Training at cf.Objective()
FireFox 3.6 KTML Editor Fix
I am now a part of the Adobe Community Professionals Group
Recent Comments
FireFox 3.6 KTML Editor Fix
Joshua said: While changing that far will load the editor, does it show the drop down class menu correctly now?
[More]
FireFox 3.6 KTML Editor Fix
Al Johnson said: HI,
I am still fighting to keep my code going as there is nothing better than KTML nad I have writt...
[More]
Google Chrome Review
web development said: ow there are all kinds of cool architectural ideas around Google Chrome, but right now, they don't m...
[More]
FireFox 3.6 KTML Editor Fix
wayne said: i have been having issues with the code editor myself, it seems i can no longer copy and paste or th...
[More]
submiting a form inside an iframe from outside the iframe
Peter said: I doubt you’re still having this problem over 2 years later, but if anyone else finds this page on t...
[More]
Calendar
| Sun | Mon | Tue | Wed | Thu | Fri | Sat |
|---|---|---|---|---|---|---|
| 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 | 29 | 30 | 31 |
Archives By Subject
blogs (31) [RSS]books (4) [RSS]
Crazy (39) [RSS]
DIY (8) [RSS]
Flex (3) [RSS]
games (10) [RSS]
GRRR (13) [RSS]
Ideas (11) [RSS]
Local (14) [RSS]
LOLpics (2) [RSS]
money (9) [RSS]
music (3) [RSS]
Personal (27) [RSS]
Photos (8) [RSS]
Politics (8) [RSS]
Projects (22) [RSS]
Review (18) [RSS]
RPM (9) [RSS]
Spam (16) [RSS]
Technology (66) [RSS]
Testing (3) [RSS]
TV (15) [RSS]
video (32) [RSS]
Web Dev (218) [RSS]
World of Warcraft (16) [RSS]
