ESB: check if the data exists in the database
639611Jul 22 2008 — edited Jul 23 2008This is my situation. I'm using FileAdapter as the inbound to read a file. This is my sample data
MRHFD02500P00002,R18A1,92P,white,14-SNL-QB5,CHINA,T1-08-01-0075-01,R4WE01,domestic
After it is routed to the Routing Server. I just wanted to check if this MRHFD02500P00002 exists in my database. If so, I need to update the rest of data to the existing one. If not, just insert it.
The question is how do I write those conditions. Please provide me an example or any document would be great. I'm very new to SOA.