I am trying to update a database table through write to data store entity smart

Ketan Patel

Certified Lead Developer

over 8 years ago

I am trying to update a database table through write to data store entity smart service. The CDT has an ID column which is defined as follows:
<xsd:element form="qualified" name="routingRuleWorkflowId"
nillable="true" type="xsd:int">
<xsd:annotation>
<xsd:appinfo source="appian.jpa">
                                        @Id
                                        @GeneratedValue
                              </xsd:appinfo>
</xsd:annotation>
</xsd:element>

When the table is created with the above xsd definition (along with some additional columns) – a Primary Key constraint is also created automatically in DB for this column with name: C0079862.

When I am trying to write above CDT to table – I am getting following error:
Details: org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update: java.sql.BatchUpdateException: ORA-00001: unique constraint (BPMBUSINESS.SYS_C0079862) violated
[Appian Work Item - 30984 - ProcessExec01 : UnattendedJavaActivityRequest] ERROR com.appiancor...

Discussion posts and replies are publicly visible

Top Replies

Ketan Patel over 8 years ago +1
Certified Lead Developer

...17/2015 8:27 PM GMT+00:00,2015-09-17 20:27:16.53,2,0,1}}]] alertMsg[error.duringWrite.alertMsg=An error occurred while trying to write to the entity “RoutingRuleWorkflows” [id=e441eea9-cc6c-459a-ad31…

Parents

0 Ketan Patel
Certified Lead Developer
over 8 years ago

... : 2 (Primary Key),2,1,0,1,1,1,1,0,Ketan,<null>,ketan,2015-09-17 20:27:16.53,1,1,1

Record2: <null>(Primary Key),2,1,0,1,0,1,0,1,ketan,2015-09-17 20:27:16.53,9/17/2015 8:27 PM GMT+00:00,2015-09-17 20:27:16.53,2,0,1

Record 1 has some updated value and Record 2 is a new insert and hence Primary Key is passed as NULL since it is @GeneratedValue.

The issue what I understand is Hibernate is throwing unique constraint violation exception for a row which I am trying to Update or in other words Hibernate is trying to Insert a record which I am trying to Update.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 Ketan Patel
Certified Lead Developer
over 8 years ago

... : 2 (Primary Key),2,1,0,1,1,1,1,0,Ketan,<null>,ketan,2015-09-17 20:27:16.53,1,1,1

Record2: <null>(Primary Key),2,1,0,1,0,1,0,1,ketan,2015-09-17 20:27:16.53,9/17/2015 8:27 PM GMT+00:00,2015-09-17 20:27:16.53,2,0,1

Record 1 has some updated value and Record 2 is a new insert and hence Primary Key is passed as NULL since it is @GeneratedValue.

The issue what I understand is Hibernate is throwing unique constraint violation exception for a row which I am trying to Update or in other words Hibernate is trying to Insert a record which I am trying to Update.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data