Join this online group to communicate across IBM product users and experts by sharing advice and best practices with peers and staying up to date regarding product enhancements.
Hi frnds…
Im trying a Publish/Subscribe appln using JDBC adapter The application is as follows application as follows…
Am having 2 tables in oracle DB. one is source(table name) and other is target. If there is an insertion happening into first table i.e source then that should be published to broker and the same values should be inserted to 2nd table i.e target… can anyone give me the basic steps to solve this
Please refer to adapter notification in webMethods JDBC user guide. You can easily find the solution.
One of the solution could be to implement a insert notification on your table one. UIt will publish a document after a new row is created in that table. You can then subscribe to this document and insert the data in to second table.
Problem solved Thank u guys…