I am working on a SOAP to JDBC Synchronous scenario, where i have to handle fault exceptions.
If the data present in database it will send response to SOAP. but if the record not matching with data in database/table it will give empty records. we need to handle it by sending information to SOAP like that particular(request) data is not available in database/table.
For that we have used fault message type, but our client requires a generic fault response with missing request data.
Assume i am sending data like empid=123 and unit = "abc" and the data is not available, so i need to send response as "123 empid is not available who belongs to "abc" unit".
please suggest me the possible solution.