[OFBIZ-13163] SQL Exception in GenericEntity.checkFks for fields with not-null="true"

• Type: Bug
• Status: In Progress
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 18.12.16
• Component/s: framework/entity

Language

Java

• Assignee: Jacques Le Roux
• Reporter: Dimitri
• Created: 28/Oct/24 19:29
• Updated: 02/Nov/24 08:02

Description

Entities with field attribute not-null="true", for fields that are not "prim-key" or "relation"
Cause GenericEntity.checkFks to throw "SQL Exception while executing the following:INSERT" for the valid data.

How to reproduce:
create Entity with field attribute not-null="true", for field that is not "prim-key" or "relation"
(sample "entitymodel_sample.xml" attached)
invoke "parseEntityXmlFile" from "org.apache.ofbiz.webtools.WebToolsServices" with "createDummyFks" set to "Y"
(sample code "sample.java", service settings "service.xml" and restore data "BACKUP_SAMPLE.xml" attached)