Skip to Content
avatar image
Former Member

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    Apr 14, 2010 at 11:40 AM

    Deepak,

    Did you find any errors in the JDBC receiver comm.channel? Also can you enable logSQLStatement true in your receiver JDBC channel to see what SQL query got created?

    raj

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Stefan Grube

      Thanks to everyone helping me to resolve this issue.I have tried with action DELETE and INSERT action in mapping to flush the database and INSERT the records.It is working fine.The problem earlier was database is not set properly and when i was running scenario using action UPDATE_INSERT.Every records are overwrite by next records and finally last records only get loaded to database.This last record i am able to fetch from JDBC sender Channel(Made only to check the entries).The Log which was generated in audit log for Sql query was fine which i was thinking their might be some wrong as alphanumeric values are not enclosed within '.

      Thanks

      Deepak

  • Apr 14, 2010 at 11:36 AM

    Check runtime workbench -> message monitor for adapter framework for errors.

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 14, 2010 at 12:19 PM

    Another idea, which sounds crazy, but have you considered, that the database entries and the file data are not different, so that the update would not have any impact?

    Add comment
    10|10000 characters needed characters exceeded