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