IBM webMethods Hybrid Integration

IBM webMethods Hybrid Integration

Join this online group to communicate across IBM product users and experts by sharing advice and best practices with peers and staying up to date regarding product enhancements.


#TechXchangePresenter
 View Only
Back to discussions
Expand all | Collapse all

Using MERGE Statement in custom adapter

  • 1.  Using MERGE Statement in custom adapter

    Posted Fri April 01, 2011 05:11 AM

    Hi,

    I can run the below SQL fine from TOAD, but when I run it via a wM JDBC 6.5 Custom SQL adapter, the adapter service just hangs (forever!)…

    “md5_digest” is just a custom function created in the DB.

    Any thoughts?

    SQL:

    MERGE INTO emp_md5 USING dual ON (employee_id=‘11111111’)
    WHEN MATCHED THEN UPDATE SET md5=md5_digest(‘test’),updated_date=sysdate where employee_id=‘11111111’ AND md5 !=md5_digest(‘test1’)
    WHEN NOT MATCHED THEN INSERT (employee_id,md5,created_date)
    VALUES (‘11111111’,md5_digest(‘test1’), sysdate)


    #Adapters-and-E-Standards
    #Integration-Server-and-ESB
    #webMethods


  • 2.  RE: Using MERGE Statement in custom adapter

    Posted Fri April 01, 2011 05:31 AM

    mod: please remove this thread…


    #Adapters-and-E-Standards
    #webMethods
    #Integration-Server-and-ESB


Related Content