Hi ,
I have created a service based on BPEL which essentially calls a Stored Procedure to insert/update data in few tables. This service is a common service for logging information from all the integration flows and also from external applications in some cases.
This service is exposed as a JMS service. There is a wrapper BPEL webservice and an OSB business service which publishes to this service's Queue.The different services would be calling either the wrapper or business service.
So far ,it is working fine but the load is increasing as there are some services which are transnational (1 at a time) ,so they could publish 200,000 messages to this service in about 2 -3 hours . It has worked fine handling that load. But there will be tons of other services publishing to this service in the future ,sometimes at the same time which may create problems in the future in terms of threads and datasource pool.
I just wanted to get some opinions on how to best handle this kind of scenario.
Any suggestion would be highly appreciated.
Regards,
Rahul