jdbc updates not happening

[Former Member]

hi,

i am trying ot insert records and then update them ,in message monitoring and channel i see it as success in DLVD stage but in actual database i do not see updates ,just the inserts happening.

has anyone face such a situation ?

Thanks.

[Former Member · Accepted solution]

In the mapping structure of Update_Insert, check the 'key' mapping.

Is it giving the required output in adherence to the Update query.

-Supriya.

[Former Member · Accepted solution]

Hi ,

I did not understand what do you want me to check ?

i checked in message monitoring in the query , it forms the update query. even if it is not able to update or there is anything wrong ,it should catch the error somewhere in the channel or message monitoring, but in message monitoring i see a success flag although i do not see any update in real database.

Please suggest

Thanks

[Former Member · Accepted solution]

Hi,

after u put LogSQLStatement = true in JDBC receiver, go and check the LOG file.

Clearly check the SQL statements are exactly as of ur req....

Babu

[Former Member]

Use LogSQLStatement = true in the JDBC channel and check the log. This parameter will show what query was formed and executed.

[Former Member]

Hi ,

i put that stmt and i see updates query being created and mesaage set to delivered status but real updates in Database i do not see...

Please suggest. Thnx

Edited by: sap_logic on Sep 25, 2010 12:36 AM