Basis Errors and Solutions

Symptom

JDBC Adapter Receiver when stored procedures are used does not interpreted empty string values as null, even though the channel is configured to do so. Instead empty strings are inserted into DB as it is.

Other terms

JDBC Receiver stored procedure, SP, Empty string as Null, Interpretation of empty string values
Reason and Prerequisites

You have configured the JDBC Receiver channel and field ‘Interpretation of empty string values’ is set to ‘Null Value’. Stored procedure is used to modify the DB through XML payload. Its observed that the empty strings are inserted as it is into the DB.
Reason for this is when stored procedure call is constructed this configuration is not taken into consideration (bug) as opposed to when a normal SQL query is constructed from the XML payload to be executed directly on DB.

Solution

A fix has been made to consider this option when stored procedures are used to modify the DB. Also this is applicable for the fields which are of type string. Applicable from 7.10 SP 06.