most came up as NULL, but one row had -00-00... even after applying the setting to the base DB)On Jul 17, 2006, at 4:25 PM, Matt Hanlon wrote: It's how I worked around a similar problem, with existing data from some other app... So if it doesn't then I must just be really lucky. : )_mO
It's how I worked around a similar problem, with existing data from
some other app... So if it doesn't then I must just be really lucky. : )
_m
On Jul 17, 2006, at 4:22 PM, Randy Wigginton wrote:
That won't work for values already inserted in the DB.
On Jul 17, 2006, a
Or you can just add &zeroDateTimeBehavior=convertToNull to the end of
your jdbc URL...
That should fix your problem.
some.connectionDictionary = {
URL = "jdbc:mysql://127.0.0.1/somedb?
capitalizeTypeNames=true&autoReconnect=true&maxReconnects=3&zeroDateTime
Behavior=convertToNull
Or you can just add &zeroDateTimeBehavior=convertToNull to the end of
your jdbc URL...
That should fix your problem.
some.connectionDictionary = {
URL = "jdbc:mysql://127.0.0.1/somedb?
capitalizeTypeNames=true&autoReconnect=true&maxReconnects=3&zeroDateTime
Behavior=convertToNull
