I am fetching data from DB using select adapater. I need throw custom custom exception if the select adapater received zero rows ($rowcount = 0). Please let me know step by step procedure for craeting custom exception in webmethods

,
1

I am fetching data from DB using select adapater. I need throw custom custom exception if the select adapater received zero rows ($rowcount = 0). Please let me know step by step procedure for creating custom exception in webMethods.

later I will handle that exception in catch block.

2

Hi Mareedu,

one option might be to wrap the select adapter service in a flow service.
Branch on $rowcount, when it is zero exit the service with Signal Failure and provide a message indicating that rowcount was zero.

Regards,
Holger

3

I want execution to come into catch block. If I use exit step execution is not coming into catch block.

4

Hi Mareedu,

can you provide some screenshots of your planned service invocation of the select adapter then, please?
Whether select adapter returns data or only $rowcount=0, it will signal always Success to the invoker, which will not trigger any catch block.

Therefore the suggestion with the intermediate wrapper service to signal Failure via Exit step, which then can be used to trigger the catch block of the invoker.

Regards,
Holger