I want to send multiple requests to same running BPEL instance in hich I am using DB adapter.I want to save the data from request schemas (to BPEL) in database by using DB Adapter(same kind of multiple request schema data).After saving that data as the multiple rows in the database,I want to invoke the other WSDL to pump that data at the end of the day>

Yes, you can have a simple bpel with db adapter.
Following are the steps you need to perform.

1. You should create a BPEL process
2. Modify the incoming request according to your requirement
3. Create a database adapter and configure it to your table.
4. Then create a transformation XSLT with source as your request and target as your input message for db adapter.

Let us know how you go !!!!

*7) Give points - it is good etiquette to reward an answerer points (5 - helpful; 10 - correct) for their post if they answer your question.*

I have two applications A and B.I am using BPEL to integrate them.
Actually BPEL recieves request from A and updates the data into B.

But request comes for every half an hour from A.I need to get the data for whole 24 hrs(48 times or more than that - in which BPEL recieves data for every half an hour) and push the data into B at a time(whole 24 hrs data).

Can I do that in BPEL process?

Is it like I have to hold the data for every half an hour in a staging table and push the whole data at the end of the day(after 24 hrs means at 12 o clock midnight)?

1. Have 2 BPEL process
2. BPEL-1 will collect the message from Application-A and insert into staging table as you said. While inserting the data into the table use a column which will have data as X and once consumed by BPEL-2, make the column value as R or something, just to identify whether that paricular record is read by BPEL-2 or not.

3. BPEL-2 will run using scheduler, which will run only once a day. This bpel will be polling on staging table and consume the data from the staging table to the target table, using DBAdapter.

You can use Mediator if you are not going to have any orchestration in this BPEL-2.

Thank you very muich for giving the ultimate direction for my task. I need one more clarification on 2 nd and 3 rd point that you mentioned.

2 nd point:

" BPEL-1 will collect the message from Application-A and insert into staging table as you said. While inserting the data into the table use a column which will have data as X and once consumed by BPEL-2, make the column value as R or something, just to identify whether that paricular record is read by BPEL-2 or not. "

You mean to say that I have to include two BPEL processes in my composite application and every request comes to BPEL-1 and creates instance for every request.
We don't need to bother about how many instances created as this process is just for taking requests and inserting it into the staging table.
After that I need to put some wait activity of almost 24 hrs between BPEL-1 and BPEL-2.

3 rd point:
"BPEL-2 will run using scheduler, which will run only once a day. This bpel will be polling on staging table and consume the data from the staging table to the target table, using DBAdapter."

after reading the data from staging table ,I have to update that data into other application(B) for which I have WSDL url.That Url is response Wsdl URL and it takes the input of data from staging table.In this case I can not use DB adapter as we have to update the data through WSDL url.

How to take input data from staging table when you give input to the WSDL URL(because we will have data in the multiple rows)?

How to insert the data into WSDL input request schema so that it will be input of invoke activity of WSDL url and update the response?

a. Pull the message from Application-A and insert into database using DB Adapter insert operation.

The above will push the message into the table, as and when it receive the message from application A

BEPL-2

a. Use DB Adapter polling concept, you can configure to poll the table only once a day.
b. BPEL-2 will run only one time a day and pull out all the data from database table
c. Do the transformation according to application-B from database rows and call application - B wsdl.

There is no need to have wait or scheduler in the approach.

*7) Give points - it is good etiquette to reward an answerer points (5 - helpful; 10 - correct) for their post if they answer your question.*

I have been implementing the whole composite applications by using two BPEL processes and two DB adapters.

1) First combination of BPEL and DB Adapter:

Step-1: BPEL is being used to pull the message from Application-A and then I am using DB Adapter to insert the data into a satging table.

Result : It is working fine as it is inerting the Stagin table. DBadapter is sitting in 'External Refernces' section of Jdeveloper Composite application.

2) Then I have created another BPEL sync process to take th data from Staging table to Aplpliaction B.I am using another DB Adapter which is used to receive the data from Staging table.That DB adapter is automatically sitting in 'Exposed Services' section.I think it is sitting in that'Exposed Services' as it is receiving the data(I am not fully sure why it is sitting in 'exposed Services' section).So When I configured DB Adapter and giving it as the input for BPEL-2(which has incoke activity to invoke application-B WSDL ) to update the data into application-B.

But DB Adapter is not getting the data and I am getting below error:

'Waiting for response has timed out. The conversation id is urn:9B8055902A7711E29F4225BFA12CEE93. Please check the process instance for detail"

The second Adapter & BPEL is executing continously with the same error(I think it is the problem with DB adapter configuration).

From the staging table columns, you are using READSTATUS in DB Adapter. If any new rows goes into staging table then the DB Adapter will pick up the message and you can do whatever you want with that data.

So your Part A is working completely, without any issues..

For Part B, check on the following.

a. increase the polling interval to 10 secs or more.
b. Insert a new record into the staging table with READSTATUS column value as 'NO'

The above setting should work, if you still have issue, then share the error message from the log file.

I am getting only one record even though I have the multiple records(in Second DB Adapter) with READSTATUS column value as 'NO'.

Is it because of configuration that I set in the specified xml (like polling interval,maxTransize etc)?

Regarding Executing BPEL-2 only once in a day so that it can get the records for whole day from BPEL-1:

BPEL-1 and BPEL-2 are in the same composite.As we already know BPEL-1 inserts the record for every half an hour in a day.That means it executes multiple times(creates instances for those multiple times).

How do I execute BPEL-2 only once to get the records from table where as BPEL-1 executes multiple times?

I have to get execute BPEL-1 multiple times in a day(means for multiple intervals) which inserts the table multiple times.After that I want to execute BPEL-2 at the end of the day(for example 12 O clock midnight) to get the all the records for that day.

I hope you understand.

Thank you very much for I have come so far because of you.

Can you let me know info for above clarifications?

And one more thing is I need to pull the data exactly at 12 o clock midnight(00:00:00 am).Can I set this in BPEL-2 to make it to execute at that time.?