Avatar

Community Advisor

Hi @gowthamanrajendran,

 

if your table won't have huge number of records remove pkSequence="testSchemaSeq", update database structure and try again. You shouldn't insert manual values for id. Those may collide with the next value from the associated sequence. Provide an explicit list of target columns (which is almost always a good idea for persisted INSERT statements) and omit autoincremental columns completely from your INSERT statement.

 

Regards,

Milan