Hi All,
In My Business Case, I am generating sequence numbers from Oracle Database here I am calling sequence number next value with Data base Adapter - Execute Pure SQL Operation into BPEL Process and Concatenating this sequence number with file name like this "filename.00001.dat" , pass this name to invoke header property jca.file.filename, here BPEL Process generates files with named as filename.00001.dat,filename.00002.dat,filename.00003.dat,filename.00004.dat, filename.00005.dat,filename.00006.dat , filename.00007 in success case.
If any exception occurs during file creation in BPEL, I am not getting the missed the file name with Sequence Number (Eg:-filename.00001.dat, filename.00003.dat, filename.00005.dat, filename.00007.dat) between these I an not getting file names like filename.00002.dat, filename.00004.dat, filename.00006.dat . here I need to generate file names with sequence numbers without fail ( like this way filename.00001.dat, filename.00002.dat, filename.00003.dat, filename.00004.dat, filename.00005.dat, filename.00006.dat , filename.00007), Here how do I get the missing sequence number during BPEL Process Failure case.
Could any one please help me in this regard, its a bit urgent one for me.
Thanks in Advance to All !!!!!!!!!!!