Ah... I also have zeroDateTimeBehavior=convertToNull;in my Properties file, so that could very well be what did it for me._mOn Jul 17, 2006, at 4:35 PM, Randy Wigginton wrote:Didn't work for me. I'll leave the lottery ticket buying to you :-)( I did a select on the column in question; most came up
Didn't work for me. I'll leave the lottery ticket buying to you :-)
( I did a select on the column in question; 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 si
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, at 3:28 PM, Matt Hanlon
That won't work for values already inserted in the DB.
On Jul 17, 2006, at 3:28 PM, Matt Hanlon wrote:
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
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
oh yeah, happens all the time. There are more than a few
strangenesses about dates in Mysql. Make sure to assign your dates a
value, or else leave them as null. Make sure to create all timestamp
columns with default null onupdate null. (I think thats the right
syntax, you should check)
mySQL 5.0.18 with adaptor mysql-connector-java-3.1.12, WO 5.3.1 OSX
10.4.7
I'm just starting a new project using mySQL, and am running into date
issues. If I have an attribute that's external type is set to DATE,
and Java type is NSTimestamp, I'm able to insert values, but when
retrieving
