How to notify j2ee server from Oracle? 2003-12-17 - By Augustyn, Robert non Unisys
Back Jin, Yes I think that this will work, this is what I was thinking of doing :) Do you have any links of actual implementations of this? Thanks. robert
-- --Original Message-- -- From: Jin Chun [mailto:ByungChun@(protected)] Sent: Tuesday, December 16, 2003 2:47 PM To: J2EEPATTERNS-INTEREST@(protected) Subject: Re: How to notify j2ee server from Oracle?
JMHO, but you could always put a trigger on the table, and have the trigger send a notification event message off to oracle aq, then have your appserver code binding to aq through their jms apis, take the notification as an event message and do the rest of the processing.
Jin
Jin Chun
Vice President: Sr. Systems Architect
State Street ? Global Link | www.statestreet.com | www.globallink.com
617.664.1695 | byungchun@(protected)
SCJA SCJP OCP-DBA
Confidentiality Notice: The information contained in the email is intended for the confidential use of the above-named recipient(s). If the reader of this message is not the intended recipient or person responsible for delivering it to the intended recipient, you are hereby notified that you have received this communication in error, and that any review, dissemination, distribution, or copying of this communication is strictly prohibited. If you have received this in error, please notify the sender immediately and destroy this message.
|-- ------+-- ---- ---- ---- ---- ---- ---- ---> | | "Augustyn, Robert non | | | Unisys" | | | <robert.augustyn@(protected)| | | OM> | | | Sent by: An interest list| | | for Sun Java Center J2EE | | | Pattern Catalog | | | <J2EEPATTERNS-INTEREST@(protected)| | | VA.SUN.COM> | | | | | | | | | 12/16/2003 02:33 PM | | | Please respond to An | | | interest list for Sun | | | Java Center J2EE Pattern | | | Catalog | | | | |-- ------+-- ---- ---- ---- ---- ---- ---- ---> >-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --- -- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --| | | | To: J2EEPATTERNS-INTEREST@(protected) | | cc: | | Subject: How to notify j2ee server from Oracle? | >-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --- -- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --|
Hi, Is there a pattern standard way of accomplishing that? I am looking to notify j2ee server that insert or update happened on a perticular table in Oracle. Thanks for your input. robert
===================================================================Companion Site: http://www.corej2eepatterns.com J2EE BluePrints: http://java.sun.com/blueprints/corej2eepatterns List Archive: http://archives.java.sun.com/archives/j2eepatterns-interest.html Unsubscribing: email "signoff J2EEPATTERNS-INTEREST" to listserv@(protected)
===================================================================Companion Site: http://www.corej2eepatterns.com J2EE BluePrints: http://java.sun.com/blueprints/corej2eepatterns List Archive: http://archives.java.sun.com/archives/j2eepatterns-interest.html Unsubscribing: email "signoff J2EEPATTERNS-INTEREST" to listserv@(protected)
===================================================================Companion Site: http://www.corej2eepatterns.com J2EE BluePrints: http://java.sun.com/blueprints/corej2eepatterns List Archive: http://archives.java.sun.com/archives/j2eepatterns-interest.html Unsubscribing: email "signoff J2EEPATTERNS-INTEREST" to listserv@(protected)
|
|