Skip to Content
Former Member
Jul 10, 2007 at 11:45 AM

Rowcount and resultset check - Message Mapping


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 EmpId EmpName Address

Target Message Type

1. SOAP_Response


1.1.1.row EmpId EmpName 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 ?



Message was edited by:

Sara D