BDM One to Many Relationship
We've created a simple BDM in which an Issue object can have 0, 1 or more Response objects (1-to-n). The Issue object has no reference to the Response object. OTOH, the Response object has a mandatory "issue" attribute of class Issue (Response have to point to a parent Issue object).
However, the BDM Manager creates a unique index for the Response object pointing to the Issue object. This model doesn't allow to add multiple responses for an issue:
org.h2.jdbc.JdbcSQLException: Unique index or primary key violation: "UK_HSYOB6R6TAGH8M6PGFYWCDS9P_INDEX_1 ON PUBLIC.RESPONSE(ISSUE_PID) VALUES ( /* 4 */ 1 )"; SQL statement:
insert into RESPONSE (persistenceId, ATTACHMENT, DATETIME, DIAGNOSTIC, ISSUE_PID, persistenceVersion, RESPONSE, RESPONSEACTION, USERID, USERNAME) values (null, ?, ?, ?, ?, ?, ?, ?, ?, ?)
How can we disable the creating of this unique constraint?
Can you share your process .bos file in order to reproduce the issue?