Broker pub/sub problem

, , ,
1

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 :confused:

2

Please refer to adapter notification in webMethods JDBC user guide. You can easily find the solution.

3

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.

4

Problem solved :slight_smile: Thank u guys…