Problem in creating Adapter Notification with MySql

, ,
1

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

2

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"

3

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

4

I believe that both support this feature.