I seem to have read something that if you want a TIMESTAMP jdbc-type you have to use one of the conversion classes JavaDate2SqlTimestampFieldConversion in you repository.xml
Axel guerrero -----Original Message----- From: Sng Wee Jim [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 26, 2003 11:41 AM To: [EMAIL PROTECTED] Subject: date issue Hi, I am using MySQL 4. When a column of type "date" is mapped to JDBC type "TIMESTAMP" in the repository.xml ie. <field-descriptor id="2" name="dateField" column="dateField" jdbc-type="TIMESTAMP" nullable="false" primarykey="true" /> writing data to the database via OJB will result in invalid year and month being written to database. For eg. year 2003 will be persisted as 3903(2003+1900) Changing the jdbc-type to DATE will solve the problem though. - Jim --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]