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

Problems inserting data using insert service adapter

  • 1.  Problems inserting data using insert service adapter

    Posted Fri April 18, 2008 05:32 AM

    Hi,

    I’ve a created a table in Oracle and a sequence so that the ID is generated automatically each time I insert a new record. Then in developper, I’ve created an insert service adapter but when I run it, I get errors saying that It is impossible to insert NULL values to the ID. I can’t understand why my sequence is not taken into consideration. When through SQL+ I insert some data using the INSERT INTO command, everything works out fine. Could someone please help me find out what is wrong?

    Thanks,
    Sweety.


    #webMethods
    #Integration-Server-and-ESB


  • 2.  RE: Problems inserting data using insert service adapter

    Posted Tue April 22, 2008 11:02 AM

    Hi Sweety,

    In the insert adapter service under Insert tab give the value for the Expression as ..nextvalue instead of ?


    #webMethods
    #Integration-Server-and-ESB


Related Content