Rowcount and resultset check - Message Mapping

45 Views

Hi Experts,

If I don't get the result for the requested value for the synch webservice -> JDBC scenario(without BPM), I have to return "No records found" as a response.

Below, I have mentioned the Source and Target message Type structure.

Source Message Type:

1. JDBC_response

1.1. STATEMENT_response

1.1.1. row

1.1.1.1. EmpId

1.1.1.2. EmpName

1.1.1.3. Address

Target Message Type

1. SOAP_Response

1.1.RESPONSE

1.1.1.row

1.1.1.1. EmpId

1.1.1.2. EmpName

1.1.1.3. Address

1.1.2 Error Description

1. What function we have to use in the userdefined function to find the rowcount or to do the resultset check?

2. If the rowcount is zero, then I have to return the Error Description as a response. Where to mention the Error Description field. It should be under <b>row</b> or ?

Regards

Sara

Message was edited by:

Sara D