We accompliished this using socket's. Oracle trigger fires off a
socket message using the Oracle utl_smtp package.
Then the message can be handled how you wish by your socket
server (i.e., JDBC, JMS etc..).
I heard Oracle is desupporting J2EE support inside the DB
and going w/ there OC4J crap.
Bruce
Do you know that there is a flushCache method on all the Entity beans thats exposed
through JMX? That means you could have a adaptor(RMI, HTTP, whatever) to get to the
jmx object that wraps ur ejb and call flush cache on that.
View the original post :
http://www.jboss.org/index.html?mo
"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 success
I have been chasing down exactly this problem for the last week.
My two previous posts are on this and related issues.
I wanted to invalidate entity beans in JBoss using asynchronous events generated by
database triggers.
I started off trying to send JMS messages directly to the JBoss cache inv
Hi
We have the exact problem. Did you find a solution to this?
View the original post :
http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3828266#3828266
Reply to the post :
http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3828266
-
It's a little round about, but if you have Oracle Advanced Queue you can publish your
messages to the an Oracle Advanced Queue and then use the Oracle Advanced Queue Patch
to connect the JBoss Server to the queue.
View the original post :
http://www.jboss.org/index.html?module=bb&op=viewtopic&p
This is more of an Oracle question than JMS one.
You can run any Java code you want using Java stored procedures in Oracle. Then it
becomes a matter of including the JBoss jars and running the example client code in
Oracle.
View the original post :
http://www.jboss.org/index.html?module=bb&o