This week's book giveaway is in the OO, Patterns, UML and Refactoring forum. We're giving away four copies of Refactoring for Software Design Smells: Managing Technical Debt and have Girish Suryanarayana, Ganesh Samarthyam & Tushar Sharma on-line! See this thread for details.
I have a NOT NULL datetime column DATEAUTHORIZATION in a MySQL table. The records have the value "0000-00-00 00:00:00" in this field. I'm using JPA in my application, but when I read this datetime field, JPA changes it to null. If I want just update any other field (and not DATEAUTHORIZATION ) it raises an error complaining that the datetime field cannot be null.
Is there a way to make JPA transforms the value "0000-00-00 00:00:00" to a non nullable value?