You might need to check database permissions, the notification will need to create a temp table and a trigger.
Did you check database to see if the temp table and trigger was generated?
Also increase JDBC Adapter logging facilities and check for errors.
If nothing helps you, you can at the end (depending the database JDBC driver), generate driver traces and check for errors.
#Integration-Server-and-ESB#webMethods#Adapters-and-E-Standards