Thanks for your reply.
I will give you more insight about my composite. The service which am creating is for CRUD operations in database table. The SCA components which I have in my composite are Webservice, Mediator and JCA DB Adapter (for each create, read, update and delete operations). I am not using BPEL in my composite.
Below are the issues I have with DB Adapters
1. When I create DB Adapter with custom SQL for Update operation with Update query, the WSDL created by JDeveloper is not having any response (i.e.., wsdl:output) defined in it. Because of this am not able to identify how many rows gets updated successfully similar to java jdbc which will return an integer of number of rows got updated.
2. Is there any way I can catch database constraint exceptions somewhere in my composite and interpret exception message to understand which constraint got violated and send reasonable error message to client. Because in terms of database constrain exceptions, DB Adapter is throwing constrain exception messages directly to client as part of response.
Thanks in advance.
Hope you are doing fine!
I would like to know if you've found a solution for your question above. We've a similar situation but could not figure out how to handle different errors from the DBAdapter. I know BPEL would solve this, but without using BPEL, with just Mediator, I would like to handle the situation.