Ok, this is a problem I solved a wee while ago via google and it is something that I have recently encountered on my shared remote server with support not aware of the fix…so I thought best broadcast.
Problem:
Error Executing Database Query.
Value ’0000-00-00′ can not be represented as java.swl.Date
The datasource is set up with a JDBC URL of:
jdbc:mysql://localhost:3306/newtriksexample
Solution:
Append this to the end of the url:
?zeroDateTimeBehavior=convertToNull
So we will have:
jdbc:mysql://localhost:3306/newtriksexample?zeroDateTimeBehavior=convertToNull
4 Comments
Can you explain a bit how JDBC URLs are used? This is a new concept to me…
Check out one of my previous posts, there is a bit more info there for you…
http://www.nutrixinteractive.com/blog/?p=36
I added this url string to my jdbc connection string and now my CF Server won’t start! Any ideas?
Started, just took a really long time. Thanks for the great tip!
One Trackback
[...] Error executing database query using ColdFusion By newtriks Ok, this is a problem I solved a wee while ago via google and it is something that I have recently encountered on my shared remote server with support not aware of the fix…so I thought best broadcast. Problem: Error Executing Database … Newtriks Web Development – http://www.nutrixinteractive.com/blog Popularity: 1% [?] Listen to this podcast [...]