JDBC InsertNotification issue

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.

Error :

[4229]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.[4228]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.[4227]2009-10-29 15:06:01 IST [SCC.0126.0200I] SCC ConnectionManager pool Test.JDBCConnection:ConnectionTOwmDB started[4226]2009-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

[B][FONT=Arial Narrow][SIZE=3][FONT=Arial Narrow][SIZE=3]

Cause: [/b][/size][/font][/SIZE][/FONT]You did not specify any rows using the [FONT=Arial Narrow][SIZE=3][FONT=Arial Narrow][SIZE=3]SELECT [/size][/font][/SIZE][/FONT][SIZE=3][SIZE=3]tab for the configured service.

[/size][/SIZE][FONT=Arial Narrow][SIZE=3][FONT=Arial Narrow][SIZE=3]Response: [/size][/font][/SIZE][/FONT]Add rows to the SELECT tab.

Hi Nazila Bhanu,

Thanks for your response but it will not solve the issue . I’d selected all the columns available in the table in the SELECT TAB while configuring the Insert/update and Basic Notification .

I’m getting the same error .