Is Oracle Trigger able to do this ....

[ligang]

Objective:

In a Typical C/S application , When the oracle data is updated ,
the data to be updated is pushed to Websphere Message Queue.

The Solution:

Application Client ---> Oracle ---> Oracle Trigger ---> Oracle Procedure ---> JAVA ---> Webspere MQ Adapter


the oracle trigger works in the same transaction with the Oracle database operation, any trigger added will also cause a new time consumption. Will this new time consumption make a big impact?

Do we have successful case under this solution?

[shenru]

If your server application is updating the database, why not insert into message queue using the same piece of server code?