JDBC To File-Using BPM.

Hi all,

I have a scenario in which i need to poll data from two tables in same DB and then merge it and put a single file in File server.

I have implemented it using BPM with constant correletion.The scenario was working fine.

Since the JDBC adapter is polling data based on dates(client req) some days data wont be there for a particular date and file may not get generated.If both files are not getting generated then it is fine. But sometimes only one file will be generated and fork steps hangs indefenitely.So my entire design fails here.

Could someone thelp me in a better solution.

Thanks & Regards,

Lekshmi.