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

Help

Home

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

Show: Today's Messages :: Show Polls :: Message Navigator

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

Sun, 25 October 2015 05:48

Rakesh Raveendran

Messages: 5
Registered: October 2015

Junior Member

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

Report message to a moderator

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

Mon, 26 October 2015 11:47

Rajkumar Dangi

Messages: 51
Registered: November 2014
Location: Pune, India

Member

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/