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.



#Automation


#Applicationintegration
#webMethods
#Integration
 View Only
  • 1.  Problem in creating Adapter Notification with MySql

    Posted 04/18/12 06:56 PM

    Hi
    When I am trying to make adapter notification with MySql I amgetting below error

    "Failed to create the adapter notification.
    com.webMethods.developer.adapter.metadata.AdapterMetadataException: com.wm.app.b2b.server.ServiceException: [ART.114.243] Adapter Runtime (Metadata): Failed to run notificationLookupValues service. Details provided in error log.
    [ADA.1.307] The adapter does not support Automatic Notification for this database “MySQL”. Please select another operation template.
    on notifyConfig.expName [Ljava.lang.String;@1f02cf8

    java.lang.Exception: Adapter values are not available."[COLOR=#000000][/color]

    [B][/b]Below is the attached image

    [ATTACH=CONFIG]849[/ATTACH]

    [TABLE=“width: 100%”]
    [TR]
    [TD=“class: heading, bgcolor: #000000, colspan: 2, align: left”]connection:fff Details[/TD]
    [/TR]
    [TR]
    [TD=“class: evenrow, bgcolor: #F0F0E0, align: right”]Connection Type[/TD]
    [TD=“class: evenrowdata-l, bgcolor: #F0F0E0, align: left”]JDBC Adapter Connection[/TD]
    [/TR]
    [TR]
    [TD=“class: oddrow, bgcolor: #E0E0C0, align: right”]Package Name[/TD]
    [TD=“class: oddrowdata-l, bgcolor: #E0E0C0, align: left”]Connection[/TD]
    [/TR]
    [TR]
    [TD=“class: heading, bgcolor: #000000, colspan: 2, align: left”]Connection Properties[/TD]
    [/TR]
    [TR]
    [TD=“class: evenrow, bgcolor: #F0F0E0, colspan: undefined, align: right”]Transaction Type[/TD]
    [TD=“class: evenrowdata-l, bgcolor: #F0F0E0, colspan: undefined, align: left”]LOCAL_TRANSACTION[/TD]
    [/TR]
    [TR]
    [TD=“class: oddrow, bgcolor: #E0E0C0, colspan: undefined, align: right”]DataSource Class[/TD]
    [TD=“class: oddrowdata-l, bgcolor: #E0E0C0, colspan: undefined, align: left”]com.mysql.jdbc.jdbc2.optional.MysqlDataSource[/TD]
    [/TR]
    [TR]
    [TD=“class: evenrow, bgcolor: #F0F0E0, colspan: undefined, align: right”]serverName[/TD]
    [TD=“class: evenrowdata-l, bgcolor: #F0F0E0, colspan: undefined, align: left”]localhost[/TD]
    [/TR]
    [TR]
    [TD=“class: oddrow, bgcolor: #E0E0C0, colspan: undefined, align: right”]user[/TD]
    [TD=“class: oddrowdata-l, bgcolor: #E0E0C0, colspan: undefined, align: left”]root[/TD]
    [/TR]
    [TR]
    [TD=“class: evenrow, bgcolor: #F0F0E0, colspan: undefined, align: right”]password[/TD]
    [TD=“class: evenrowdata-l, bgcolor: #F0F0E0, colspan: undefined, align: left”]******[/TD]
    [/TR]
    [TR]
    [TD=“class: oddrow, bgcolor: #E0E0C0, colspan: undefined, align: right”]databaseName[/TD]
    [TD=“class: oddrowdata-l, bgcolor: #E0E0C0, colspan: undefined, align: left”]webMethods[/TD]
    [/TR]
    [TR]
    [TD=“class: evenrow, bgcolor: #F0F0E0, colspan: undefined, align: right”]portNumber[/TD]
    [TD=“class: evenrowdata-l, bgcolor: #F0F0E0, colspan: undefined, align: left”]3306[/TD]
    [/TR]
    [TR]
    [TD=“class: oddrow, bgcolor: #E0E0C0, colspan: undefined, align: right”]networkProtocol[/TD]
    [TD=“class: oddrowdata-l, bgcolor: #E0E0C0, colspan: undefined, align: left”][/TD]
    [/TR]
    [TR]
    [TD=“class: evenrow, bgcolor: #F0F0E0, colspan: undefined, align: right”]Other Properties[/TD]
    [TD=“class: evenrowdata-l, bgcolor: #F0F0E0, colspan: undefined, align: left”][/TD]
    [/TR]
    [TR]
    [TD=“class: heading, bgcolor: #000000, colspan: 2, align: left”]Connection Management Properties[/TD]
    [/TR]
    [TR]
    [TD=“class: evenrow, bgcolor: #F0F0E0, colspan: undefined, align: right”]Enable Connection Pooling[/TD]
    [TD=“class: evenrowdata-l, bgcolor: #F0F0E0, colspan: undefined, align: left”]true[/TD]
    [/TR]
    [TR]
    [TD=“class: oddrow, bgcolor: #E0E0C0, colspan: undefined, align: right”]Minimum Pool Size[/TD]
    [TD=“class: oddrowdata-l, bgcolor: #E0E0C0, colspan: undefined, align: left”]1[/TD]
    [/TR]
    [TR]
    [TD=“class: evenrow, bgcolor: #F0F0E0, colspan: undefined, align: right”]Maximum Pool Size[/TD]
    [TD=“class: evenrowdata-l, bgcolor: #F0F0E0, colspan: undefined, align: left”]10[/TD]
    [/TR]
    [TR]
    [TD=“class: oddrow, bgcolor: #E0E0C0, colspan: undefined, align: right”]Pool Increment Size[/TD]
    [TD=“class: oddrowdata-l, bgcolor: #E0E0C0, colspan: undefined, align: left”]1[/TD]
    [/TR]
    [TR]
    [TD=“class: evenrow, bgcolor: #F0F0E0, colspan: undefined, align: right”]Block Timeout (msec)[/TD]
    [TD=“class: evenrowdata-l, bgcolor: #F0F0E0, colspan: undefined, align: left”]1000[/TD]
    [/TR]
    [TR]
    [TD=“class: oddrow, bgcolor: #E0E0C0, colspan: undefined, align: right”]Expire Timeout (msec)[/TD]
    [TD=“class: oddrowdata-l, bgcolor: #E0E0C0, colspan: undefined, align: left”]1000[/TD]
    [/TR]
    [TR]
    [TD=“class: evenrow, bgcolor: #F0F0E0, colspan: undefined, align: right”]Startup Retry Count[/TD]
    [TD=“class: evenrowdata-l, bgcolor: #F0F0E0, colspan: undefined, align: left”]0[/TD]
    [/TR]
    [TR]
    [TD=“class: oddrow, bgcolor: #E0E0C0, colspan: undefined, align: right”]Startup Backoff Timeout (sec)[/TD]
    [TD=“class: oddrowdata-l, bgcolor: #E0E0C0, colspan: undefined, align: left”]10[/TD]
    [/TR]
    [/TABLE]

    Please Help Me to solve this problem


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


  • 2.  RE: Problem in creating Adapter Notification with MySql

    Posted 04/18/12 11:17 PM

    Have a look through the documentation. From the message, it would appear that adapter notifications are not supported for MySQL.

    "The adapter does not support Automatic Notification for this database"


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


  • 3.  RE: Problem in creating Adapter Notification with MySql

    Posted 04/20/12 05:43 PM

    Thanks Sir… So shall i change my database to oracle or sql Server for adapter notification implemantation ?


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


  • 4.  RE: Problem in creating Adapter Notification with MySql

    Posted 04/20/12 05:49 PM

    I believe that both support this feature.


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