https://answers.axonivy.com/questions/1369/how-to-work-with-null-values-in-datetime-types-using-persistence<p>We are facing the following problem: We are using the persistence-feature to handle complex objects. During the fetch we get values where a datetime-field is not set (NULL in the database) - when we try to write the entity object instance back to the database (merge) we get the following exception:</p> <pre><code>"SQLException: Only dates between January 1, 1753 and December 31, 9999 are accepted. DataException: could not update: [de.*****.qia.persistence.QuestionnaireQuestion#130] PersistenceException: org.hibernate.exception.DataException: could not update: [de.*****.qia.persistence.QuestionnaireQuestion#130] RollbackException: Error while committing the transaction Failed to excecute operation "merge" for persistence unit "qiaPersistence". </code></pre> <p>The reason is quite obvious - the auto-initialized value is out of the allowed range for the MSSQL-Server. But shouldn't NULL be the value to be written back?</p> <p>How can we adress this? A workaround would be to enforce that a date is created during the initial persist but there could be situation where "NULL" is programmtically a valid entry.</p> <p>How can we adress this issue?</p> <p>Edit: RDBMS: MSSQL Express 2008</p>enMon, 05 Dec 2016 20:16:11 -0500https://answers.axonivy.com/questions/1369/how-to-work-with-null-values-in-datetime-types-using-persistence/2242<p>Faces similar problems here, we were able to save auto-initialized date but they were still a pain. Empty date became 0001-01-01. </p> <p>I've fixed it when saving, nice, but now and then when we display a new object we still get 0001-01-01 date in p:calendar into the UI. We will probably find them elsewhere too I guess (data export, reports and the like). </p> <p>We have to track every single one of them and fix them to make sure to display empty date. This is very annoying and not always obvious. It would be great that initialized/uninitialized state don't temper with the data itself. </p> <p>If any global fix exist for that I would be interested.</p>RemiMorinMon, 05 Dec 2016 20:16:11 -0500https://answers.axonivy.com/questions/1369/how-to-work-with-null-values-in-datetime-types-using-persistence/2242https://answers.axonivy.com/questions/1369/how-to-work-with-null-values-in-datetime-types-using-persistence/1372<p>There exists an utility which can set auto initialized data class values back to NULL. So you could use it to restore a valid state before you merge it to persistency. Its published here: <a href="http://sourceforge.net/projects/ivysupplements/files/Helper/">http://sourceforge.net/ivySupplement/dataClassNuller</a></p> <p>I did not test if this implementation still works with an up to date ivy version. So you have to verify and test it.</p>Reguel WermelingerMon, 22 Jun 2015 09:02:56 -0400https://answers.axonivy.com/questions/1369/how-to-work-with-null-values-in-datetime-types-using-persistence/1372