JDBC Adapter

[martini]

Hi,

I have configured a JDBC Adapter

Receiver

into Integration
Directory on SAP XI.This execute a stored procedure with only input
parameters.
The problem is when, I'm sending a blank string in any parameter.

I have configured the option "Interpretation of Empty String Values"

with
NULL Value, but this

not work

.

Why the adapter doesn't send null values in parameters ? Is it a bug of adapter ?

Thanks in advance.

Martín.

[bhavesh_kantilal · Accepted solution]

Martin, the best way to debug this would be to add the LogSQLStatement in the Reciver JDBC adapter.

This would allow you to see the call being made to the stored procedure and you can use this to see if the call is as expected.

In the receiver JDBC adapter, select Additional Parameters and add the statement LogSQLStatement with value true.

Regards

Bhavesh

[Former Member · Accepted solution]

Bhavesh, We have added the LogSQLStatement in Additional Parameteres with values as true in the Reciver JDBC adapter but in the audit log of adapter monitoring we can just see the procedure name, not the whole statement.

Is there any other configuration also which needs to be done?

[prabhu_s2]

did u get any errors in this case?