View Revisions: Issue #1105

Summary 0001105: Avoid empty string on not-null database column
Revision 2020-01-08 20:47 by rijkr
Description IST: Oracle DB interprets an empty zero-length string as NULL value. When set on a JPA "nullable = false" database column, this causes "ERROR - ORA-01400: cannot insert NULL".
SOLL-1: Do not set empty string on JPA "nullable = false" database column.
SOLL-2: Beware that Oracle DB stores empty string on "nullable = true" column as NULL value.
Revision 2020-02-25 09:34 by rijkr
Description IST: Oracle DB interprets an empty zero-length string as NULL value. When set on a JPA "nullable = false" database column, this causes "ERROR - ORA-01400: cannot insert NULL".
SOLL-1: Do not set empty string on JPA "nullable = false" database column.
SOLL-2: Beware that Oracle DB stores empty string on "nullable = true" column as NULL value.

https://schneide.blog/2010/07/12/an-oracle-story-null-empty-or-what/