Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

File to JDBC - JDBC database not getting updated using UPDATE_INSERT

Hi ,

I have a done a file to JDBC Scenario.File is successfully picked up by sender file channel and recieved by reciever JDBC channel.There is no error in receiver communication channel.I used UPDATE_INSERT action in mapping which has to update the database with all records it recieve.But,i found there is no update in Database table.I donot have access to database,so i made a sender jdbc channel querying all data in it to see what new value is populated.

I made a dummy sender jdbc channel to check what are the values updates on the run of above interface.But , i found no update occur.Please help me out of this problem.

Thanks

Deepak Jaiswal

Former Member
replied

The reason I ask , because you will see whether the message got successfully delivered to the target system.

I want to see information like below

2010-04-14 14:31:35 Success Message successfully received by messaging system. Profile: XI URL: http://server:port/MessagingSystem/receive/AFW/XI Credential (User): PIISUSER

2010-04-14 14:31:35 Success Using connection JDBC_http://sap.com/xi/XI/System. Trying to put the message into the receive queue.

2010-04-14 14:31:35 Success Message successfully put into the queue.

2010-04-14 14:31:35 Success The message was successfully retrieved from the receive queue.

2010-04-14 14:31:35 Success The message status set to DLNG.

2010-04-14 14:31:35 Success Delivering to channel: Communuication channel

2010-04-14 14:31:35 Success MP: Entering module processor

2010-04-14 14:31:35 Success MP: Processing local module localejbs/CallSapAdapter

2010-04-14 14:31:35 Success Receiver JDBC adapter: processing started; QoS required: ExactlyOnce

2010-04-14 14:31:35 Success JDBC adapter receiver channel CC: processing started; party , service DB_BS

2010-04-14 14:31:35 Success Database request processed successfully

2010-04-14 14:31:35 Success MP: Leaving module processor

2010-04-14 14:31:35 Success The message was successfully delivered to the application using connection JDBC_http://sap.com/xi/XI/System.

2010-04-14 14:31:35 Success The message status set to DLVD.

raj.

0 View this answer in context

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question