Eclipse Community Forums: Eclipse Process Manager (Stardust) » Question on Stardust Modelling and interaction with DB

Home » Archived » Eclipse Process Manager (Stardust) » Question on Stardust Modelling and interaction with DB

Question on Stardust Modelling and interaction with DB [message #1712451]

Sun, 25 October 2015 01:48

Eclipse User

Hi,

I have a Use Case to read some data from CSV and insert data if the data is not present and update it if a record exists for the existing row.

I got the Following sample which helped me to start understanding how to read from CSV using Camel and Insert but what I noticed is it just keeps on inserting record but not update it if value already present.
https://wiki.eclipse.org/CSV_parsing_and_inserting_the_records_in_database_using_Stardust_camel_features

Can you please guide me how to modify the model to do update if the record is already present with the same key value and insert if no record is present?

Thanks,
Rakesh

Re: Question on Stardust Modelling and interaction with DB [message #1712556 is a reply to message #1712451]

Mon, 26 October 2015 07:47

Eclipse User

I did not try this but i think it is possible in following ways:

1. Your table structure should define one column as a primary key.
2. When SQL application will try to insert the records with duplicate key it will get some SQLException.
3. Add and error event(Boundary error event) to catch that exception and in exception flow try to fire update query.
Your process should look something similar to below(this is just a dummy scratch)

index.php/fa/23733/0/

You can refer below documentation how to add "Error Boundary Event"

http://help.eclipse.org/mars/index.jsp?topic=%2Forg.eclipse.stardust.docs.analyst%2Fhtml%2Fhandbooks%2Fmodelling_analyst%2Fpep-events.htm&resultof=%22boundary%22%20%22boundari%22%20%22event%22%20

See section Error Boundary Event - Implementation

Thanks
Rajkumar

Attachment: SQLErrorHandler.PNG
(Size: 18.53KB, Downloaded 428 times)

Re: Question on Stardust Modelling and interaction with DB [message #1712557 is a reply to message #1712451]

Mon, 26 October 2015 07:55

Eclipse User

No Message Body

[Updated on: Tue, 27 October 2015 01:58] by Moderator

Previous Topic:	Stardust installed, but it is not showing up?
Next Topic:	Problems to deploy the ACME Workflow Model from the Support Example tutorial

Goto Forum:

-=] Back to Top [=-

Current Time: Tue Jul 22 02:18:36 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter