View Revisions: Issue #1105
| Summary | 0001105: Avoid empty string on not-null database column | ||
|---|---|---|---|
| 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/ |
||
| 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. |
||
