With recent versions of Oracle, ActiveMQ should work within a trigger since they use SUN's JVM at 1.4 and above. I pumped older versions of ActiveMQ and we will test to see if we can get that to run on 1.2.1. I will however use your idea immediately since we are presently building a prototype. We can establish a socket connexion easily inside the Java trigger.
If we cannot get AtiveMQ to run in the 8i JVM, we will store the messages in a table and pool it but we want to reduce the plumbing complexity and get events out of oracle asap. We still have to evaluate if getting the message out involves a significant latency in the trigger. Dropping messages in a table might be a necessary step... We do not want to loose track of the events and the triggers have to be transparent (we cannot abort the transaction or take other weird actions). Thank you for the hint, Luc James.Strachan wrote: > > On 3/28/07, lprefontaine <[EMAIL PROTECTED]> wrote: >> >> We want to send messages within java triggers running in oracle 8i. >> The oracle jvm is 1.2.1 compatible in 8i it's not the Sun JVM). >> >> Does someone have an idea if an older ActiveMQ version exists that could >> be >> uses to send messages to >> an ActiveMQ 4 queue ? >> >> We would load jar files and other dependencies in oracle (loadjava). >> >> Has anyone attempted this ? With another oracle version ? > > I'm not sure if we've a version of ActiveMQ which works on 1.2.1; I'm > thinking it might be easiest to write a little lightweight Stomp > client which has minimal dependencies (and doesn't need anything from > 1.4 or 1.5). As all that is really required is to be able to read and > write to a socket; maybe even oracle PL/SQL could be used? > > http://stomp.codehaus.org/Protocol > -- > > James > ------- > http://radio.weblogs.com/0112098/ > > -- View this message in context: http://www.nabble.com/oracle-8i-java-trigger-and-ActiveMQ-tf3482864s2354.html#a9733236 Sent from the ActiveMQ - User mailing list archive at Nabble.com.
