"cheenu78" wrote : hi all, | I have a senario where in, I need to publish a message when a table in inserted or updated. That is, is it possible for an Oracle Trigger to publish a message to the JMS Topic? | thanks in advance | srinivas
A late reply I know, but... We have done this successfully, but we do a little extra work to decouple oracle and JBoss. Our trigger writes a record to a DB table for each change and we periodically poll that table (from an MBean using JDBC) and publish the message using standard JBoss JMS functionality. At the time this was quite successful and easy to maintain but the overhead is a bit high if there are a lot of changes. We are investigating using Oracle Streams (in 9.2.0.5.0) to asynchronously capture and publish the changes and then to interface to the queue either directly or via the oracle JMS interface from our J2EE application. Haven't got that working yet. brian wallis... View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3834731#3834731 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3834731 ------------------------------------------------------- This SF.Net email is sponsored by: SourceForge.net Broadband Sign-up now for SourceForge Broadband and get the fastest 6.0/768 connection for only $19.95/mo for the first 3 months! http://ads.osdn.com/?ad_id=2562&alloc_id=6184&op=click _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
