Problem in JDBC receiver Updation

[Former Member]

Hi friends,

I am updating the DB using the JDBC receiver adapter.

Tell me for the following case updation can be done or not.

key Field Field1 Field2

A X Y

B X

C X Y

Consider above is the datas cmng to receiver JDBC to update the database. But here the record B has the field2 as empty in this case i should not update the record b with the field2 only field1 updation should takes place. Bcoz if i update the field2 with empty value the existing value may get deleted, hence only the field1 should be updated. Please tell me how to handle this.

Do i need to hae 2 diff update stmt for this. Revert back for any quries.

Thanks

Prem

Edited by: Prem Kumar on Sep 24, 2008 4:27 PM

[Former Member · Accepted solution]

Prem,

We had a similar situation and got it reolved by getting a stored procedure at the database level.

Hope it helps!

[Former Member]

answered

[Former Member]

Hi,

You can write the stored procedure according to your conditions, call that stored procedure from the PI, its works fine, param also told the same thing.

If suppose field2 not came then its fails means it should not update in the database, but it is done at the stored procedure, but in the XI point of view its a successfull record.

In the MONI also it shows the record processed successfully, so you don't no how many records processed successfully and how many records fails at the receiver side.

[Former Member]

Hi,

In JDBC receiver adapter, there is a setting in Processing tab which talks abt empty string values and how it needs to be handled.

Interpretation of Empty String values:

There are two options keeping it as Null value and Empty string.

One of these option will solve ur requireement.

Am not sure which option, do check with both.

Regards,

Krish