This is my first post to the forum…
Am a new bie to WebMethods,I am working on V6.1.
Am trying a simple Publish/Subscribe appln using JDBC adapter.
The application goes like this…
- Have created an InsertNotification
- Created a trigger which is triggered when a record is inserted to a particular table in a database and triggers a flow which inserts another record to another table.
The issue is that even though all the services run individually without any error,there is a problem when i run the flow service.I dont get any errors but NULL is inserted to the the table
I use MSSQL V8 and have also installed MSSQL 2000 DataDriver for JDBC.
I did check the logs for the same(using pub.flow.tracePipeline),the values are present in the publishnotifydocument, but NULL is being inserted into the table.
Can someone help me get out of this problem.
Thanks in Advance