Hi all!

I am connecting my app to a legacy mysql DB for reading only, all mappings work fine but I have the following problem:
The db contains several columns with "zero day dates", e.g. 2007-06-00 and I want this to be reflected in my object as june 2007
Now it reads in as 2007-05-31 00:00:00.0 .

I tried the LifeCycle interface method onLoad, but at this point the value has already be read in wrong.

Do you have any ideas where to tweak my configs/mappings/sources ?

btw.: I cannot change the content or schema of the db, and I have to read from it continuously and it will contain these mad dates again and again as the apps producing them are still in use.

Any ideas?

TIA and kind regards

Michael

hy michael,

one solution to the given problem is, to
use noDatetimeStringSync=true in the jdbc connection url [ be carefull to use & in hibernate.cfg.xml if you're using another urlparam in the connection url ]
and to map the datetime field of mysql-database again using another name, type=string and insert=false and update=false but the same columnname in the mapping.xml.

so that you at least have

getDatefield() = 31.05.07
getDatefieldString() = 00.06.07

thanks to http://swik.net/MySQL/Mark+Matthew who posted the hint nearly exactly one year ago

wkr j