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
Expand all | Collapse all

Problem in creating Adapter Notification with MySql

  • 1.  Problem in creating Adapter Notification with MySql

    Posted Wed April 18, 2012 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 Wed April 18, 2012 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 Fri April 20, 2012 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 Fri April 20, 2012 05:49 PM

    I believe that both support this feature.


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