We are facing some issue with null values in date fields while calling a stored procedure using JDBC Adapter in one of the interfaces.
When the value is null, XI gives errors in the communication channel.
Case 1 , When the value is mapped to blank. : The adapter gives an error related to date format. Unsparseable date .
Case 2 , When the value is not mapped at all : The adapter gives an error related to wrong number of arguments for the stored procedure.
One option for fixing this issue is to hardcode the value to all zeros in a appropriate date format. However this is not acceptable in our case.
Did anybody face this issue before. If yes what was the approach taken. Can you please let me know if anybody has any inputs on this.
Thanks in advance,