MySQL <> EOModeler timestamp question

james o <[email protected]> Thu, 23 Jun 2005 17:03:29 -0400
Newsgroups gmane.comp.web.webobjects.eof,gmane.comp.web.webobjects.devel
Message-ID <[email protected]>
trying to utilize MySQL for the first time and i have a question with  
TimeStamps.  it looks like the current timestamp syntax for MySQL is  
0000-00-00 00:00:00.  i was getting an error in the EOModeller asking  
for a timestamp with a GMT offset *i think*.  this error disappeared  
after i changed the adaptor to include:  
zeroDateTimeBehavior=convertToNull

adaptor: jdbc:mysql://64.80.202.72/icfdis? 
zeroDateTimeBehavior=convertToNull&capitalizeTypenames=true

after changing the adaptor i could browse the data in EOModeller but  
the timestamp column was null.  i'm wondering if i adjust the EOModel  
to accept this syntax or does MySQL need to be adjusted?

WO Vers: 5.2.4
DATABASE: MySQL 4.1.7
JDBC connector: mysql-connector-java-3.1.9-bin.jar

thanks,
./james