JDBC Receiver Adapter with Null Value

[Former Member]

HI,

I have configured ID for JDBC Receiver. In my communication channel, I already check Integration of Empty String Values = Null Value. However, when I check the result from audit log, it still shows that SAP XI sends the null value to database. In my understanding, it should not send the field which has null value (It shouldn't be included in sql statement).

I check this with other scenario. With the same check at Integration of Empty String Values = Null Value, it doesn't send null value to database. It happens only with my first scenario.

Have anyone ever been through this before? Any suggestion please?

Thanks,

Pavin

[Former Member]

It should pavin, occurence of ERROR field shud be 0...1 wid null value option not checked .

[Former Member]

Hi Pavin,

First you need to test the mapping whether it is sending the null value. You can test it in Message Mapping Test tab.

Check the mapping once why it is sending the null value, I think your mapping logic is not working fine so that is sending the null value.

Regards

Goli Sridhar

[Former Member]

Hi Goli Sridhar,

My mapping actually return empty value which is what I want. In my understanding, I think that if i set Null value in ID it should help me to exclude this field from sql statement. That's what i want.

Thanks,

Paivn

[Former Member]

Pavin,

1. what is the occurrence of the fields which are sending null values ?

2. Run the same scenario without null value option , because my under standing of that null value check box in ID is other way .

Regards,

[Former Member]

Hi,

1. The occurrence is 0...1

2. This is the first result with null value (Please see field Error)

UPDATE EXPCRM_T_CustomerProfile SET RequestID=455, RecordNo=1, SAPCustomerCode=0001000344, Error=NULL, Status=2, UpdateDateTime=12/03/2008 13:45:03 WHERE (RequestID=455 AND RecordNo=1)

Then, I change the option from Null Value to Empty string. This is the result.

UPDATE EXPCRM_T_CustomerProfile SET RequestID=455, RecordNo=1, SAPCustomerCode=0001000344, Error=', Status=2, UpdateDateTime=12/03/2008 13:46:12 WHERE (RequestID=455 AND RecordNo=1)

Field Error Change from NULL to '

The expected result from me is that field Error should not exist at all. Please help.

Thanks,

Pavin