Oracle Sequence in CDT

A Score Level 2

Hi,

There is a CDT which is calling a Sequence in Oracle as a primary key. Below is the extract from CDT.

<xsd:element name="recordId" nillable="true" type="xsd:int">
<xsd:annotation>
<xsd:appinfo source="appian.jpa">@Column(name="RECORD_ID") @Id @GeneratedValue @SequenceGenerator(name="sequence", sequenceName="A_RECORD_ID", allocationSize=1)</xsd:appinfo>
</xsd:annotation>
</xsd:element>

For some reason, when we are trying to insert data in the table some other sequence is being called and we are getting "Unique key Violation". We are able to identify that sequence but not able to figure how this is happening. We could not find any trigger in the table.

Any pointers would be highly appreciated.

  Discussion posts and replies are publicly visible

Parents Reply Children
No Data