Srinivas,
The main difference is that most JDBC notification types (insert, update, delete) automatically create the necessary database objects (buffer table, trigger and sequence) for the notification, while basic notifications do not.
Some DBAs do not like the automatic creation of database objects as it means they must grant extra database privileges to the database user used by the JDBC adapter connection. Basic notifications provide you (and the DBA) with more control, but require extra work as you need to set up an appropriate buffer table, trigger and sequence yourself.
TIP: Set up an insert/update/delete notification in your development environment, then “copy” the table, trigger and sequence to your own SQL script and set it up as a basic notification from then onwards.
Hope this helps.
Jonathan Heywood
webMethods Professional Services
#webMethods#Integration-Server-and-ESB