Issue while inserting data in third party data source

Question

Hi All

I am working on version 17.2.

I am connecting with a third party data source. I have created a CDT which has the same structure as the table in the third party data source. I am able to select as well as update data in the third party data source. However, when I try to insert data in the table, the primary key value is not generated, i.e. it goes as null thus my process breaks at Write to data store entity; which is expected behavior.

At the third part data source, the primary key is a number which is created as "GENERATED AS IDENTITY NOT NULL". In my CDT I have given the annotation @SequenceGenerator and @GeneratedValue and the CDT is getting verified with the data source.

For reference, the ID column in my XSD is given as:

<xsd:element name="ID" nillable="true" type="xsd:int">
<xsd:annotation>
<xsd:appinfo source="appian.jpa">@Id @GeneratedValue @SequenceGenerator @Column(name="ID", columnDefinition="NUMBER")</xsd:appinfo>
</xsd:annotation>
</xsd:element>

Now I want to know how to handle the primary key column i.e. what do I insert as a value in ID column.

Thanks in advance!!

aloks0189 · Answer

Hi @komalc one small clarification, which database is getting used by Third Party System like Oracle, MySQL, PostgreSQL etc... 
 The reason behind asking is, @SequenceGenerator represents the generation strategy as Sequence which is one of the type of generator, and there many databases which do not support Sequence Strategy for PK Generation, such as MYSQL 
 These are few popular databases which supports Sequence Generation Strategy, such as: 
 Oracle, SQL Server 2012, PostgreSQL, DB2, HSQLDB etc.. 
 
 So, if your DB supports Sequence Generation Strategy then try defining this as mention below: 
 @Id 
 @Column(name="ID", columnDefinition="NUMBER") 
 @GeneratedValue(generator="my_seq") 
 @SequenceGenerator(name="my_seq",sequenceName="MY_SEQ") 
 
 Hope this will help you.