RE: date issue

2003-11-26 Thread Guerrero, Axel 
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.


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]

date issue

2003-11-26 Thread Sng Wee Jim 
Hi,

I am using MySQL 4.

When a column of  type "date" is mapped to JDBC type "TIMESTAMP" in the 
repository.xml
ie.
   
 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]