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.

 View Only
  • 1.  JDBC adapter database polling example

    Posted Wed June 20, 2012 11:11 PM

    Hi,
    We have a requirement where there is a need to monitor/poll a table for any insert/update. Upon an insert/update of a record in the table, a workflow needs to get executed in webMethods.
    I’m new to wm and was trying to find any examples there may be which would demonstrate something similar.
    I’m not sure at the moment how to achieve this.
    Any help on this topic will help me to a great extent.

    Thanks,
    Himanshu


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


  • 2.  RE: JDBC adapter database polling example

    Posted Tue June 26, 2012 03:35 PM

    Hi Himanshu,

    Please read the JDBC documentation. It is clearly explained.


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


  • 3.  RE: JDBC adapter database polling example

    Posted Tue June 26, 2012 09:14 PM

    Thanks David…I did look into the documentation and got some good information based on which I was able to configure the polling notification. But I’m getting another error when I try to enable the notification from IS Admin screen:

    [ART.116.3038] Adapter Runtime (Notification): Error in Notification Callback:enableCallback notification com/wm/adapter/wmjdbc/notifications/monitors/NotificationMonitor.dbObjectStatus()[Ljava/lang/Boolean; I’m trying to understand it more…I have JDBC Adapter 6.5 with the latest Fix 34.


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


  • 4.  RE: JDBC adapter database polling example

    Posted Wed June 27, 2012 09:30 PM

    OK…here is how it fixed my problem.
    I had the JDBC Adapter Fix level 34. After speaking to their support, it was realized that the Fix 34 was pulled off by SoftwareAG for the a similar issue that I was facing (Error in Notification Callback:enableCallback notification). So they suggested to put in Fix 33. After uninstalling Fix 34 and installing Fix 33, it resolved my error.
    Everything is working as expected now…thanks for showing your interest!

    Thanks,
    Himanshu


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