Troubleshooting
Problem
JDBC adapter is passing null into BO when calling stored procedure which uses defaults.
Symptom
JDBC adapter outbound process is used to call a stored procedure in Oracle database. The stored procedure is an Oracle API that uses defaults if the field is not passed in. When calling the stored procedure at runtime, JDBC adapter is passing null into the fields of BO rather than the expected Oracle defaults.
Cause
This is a limitation of JDBC adapter. In current JDBC adapter design, all parameters from stored procedure are required or mandatory. If the parameter has no value, then JDBC adapter will assign null to it. So currently, JDBC adapter can not support the stored procedure with default value in parameters.
Resolving The Problem
A workaround for this issue is to assign default value to the relevant attributes of BO in BO Map within business process or mediation flow.
Was this topic helpful?
Document Information
Modified date:
15 June 2018
UID
swg21447379