Multiple SQL commands for a single insert

Question

Hello there, 
 I have a parent child relationship mapped within Appian. When I call writeToDataStore on the parent object, Appian successfully saves both the parent and child objects however it requires 2 SQL commands to save the children. Specifically what it does is: 
 
 INSERT the Parent and Child objects 
 UPDATE the child objects with the foreign key of the parent

Is there any way to force Appian to insert the Parent and children without requiring the second update command? IE: Insert the parent, set the FK value on the child, insert the child objects? 
 Some Hibernate documentation I've read suggests setting up a "ManyToOne" relationship on the child towards the parent however this causes several unusual datastore validation errors (data store does not have a definition for parent or child) 
 docs.jboss.org/.../example-parentchild.html

vijayd · Answer

Write a Stored Procedure and Use 'Execute Stored Proc' smart service

Alok Patro · Answer

i would suggest to use a database trigger to perform your job. 
an AFTER INSERT trigger will do it. 
 
And also the load on Appian will be reduced and the process will be performance oriented. 
 
Regards 
Alok Patro

legodfw · Answer

Depending on the implementation there are two ways to do this: 
 
1. In your XSD CD definition, you can use the @joincolumn annotation for the child CDT. When you write the data, you have to write the child CDT first before you write the parent. 
 
2. Second option is just create an ID in the parent CDT, and manually assign the value to it after the child CDT was written.