Oracle Sequence in CDT

anilkumark over 8 years ago

There is a table which is using oracle sequence as a PK. I am using below annotations in XSD, the problem here is all the EMP_IDs creating in jumbling order like (1,2,3,4,13,14,5,6).

<xsd:element name="EMP_ID" type="xsd:integer">
<xsd:annotation>
<xsd:appinfo source="appian.jpa">@Id @Column(name="EMP_ID", columnDefinition="NUMBER NOT NULL") @SequenceGenerator(name="EMP_ID_SEQ_generator", sequenceName="EMP_ID_SEQ", initialValue=1) @GeneratedValue(strategy=GenerationType.SEQUENCE, generator="EMP_ID_SEQ_generator")</xsd:appinfo>
</xsd:annotation>
</xsd:element>

Discussion posts and replies are publicly visible

Parents

0 rawich over 8 years ago

Based on your sequence of numbers, it's very likely that you're using Oracle RAC (Real Application Clusters). If you modify the sequence to have "ORDER" then you can avoid the out of order numbers.
docs.oracle.com/.../statements_6017.htm

But if the order and continuity (no skipping) of the primary keys are absolutely important, you might want to consider using Appian constant together with Increment Constant smart service instead.
forum.appian.com/.../Increment_Constant_Smart_Service.html
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 rawich over 8 years ago

Based on your sequence of numbers, it's very likely that you're using Oracle RAC (Real Application Clusters). If you modify the sequence to have "ORDER" then you can avoid the out of order numbers.
docs.oracle.com/.../statements_6017.htm

But if the order and continuity (no skipping) of the primary keys are absolutely important, you might want to consider using Appian constant together with Increment Constant smart service instead.
forum.appian.com/.../Increment_Constant_Smart_Service.html
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data