Hi, Am trying to create an InsertNotification on a table. Have selected all the columns in the table under SELECT TAB while configuring the insert notification. I’m seeing the below error in the IS Server and error log and insert notification is not working. Has anyone come across this issue before ? Any help towards finding solution would be highly appreciated.
I’m using JDBC Adapter 6.5.
2009-10-29 15:08:41 IST [ART.0114.1408I] Adapter Runtime: No settings provided for template com.wm.adapter.wmjdbc.notifications.InsertNotification of adapter JDBCAdapter. Creating default settings.2009-10-29 15:08:41 IST [ART.0114.1007E] Adapter Runtime: Error Logged. See Error log for details. Error: [ADA.1.308] There must be at least one expression for the SELECT statement.2009-10-29 15:06:01 IST [SCC.0126.0200I] SCC ConnectionManager pool Test.JDBCConnection:ConnectionTOwmDB started2009-10-29 15:06:01 IST [ART.0114.1100I] Adapter Runtime: Facility 1 - JDBCAdapter registered with bundle com.wm.adapter.wmjdbc.JDBCAdapterResourceBundle
Thanks in Advance