Win a copy of Clojure in Action this week in the Clojure forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

How to capture the event in Java when trigger is fired in Oracle

 
G Mani
Greenhorn
Posts: 1
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,
Is there any possibility to capture an oracle trigger event in Java application that is using that d/b.either by using Observable class or by other means.
Respond with the possibility needed urgently.

Thanks in Advance
--Mani
 
Mark Spritzler
ranger
Sheriff
Posts: 17276
6
IntelliJ IDE Mac Spring
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Well, good question. Not sure I know the anzwer, but considering that you can have Java classes being used in a PL/SQL Stored Proceudre, I assume you could simulate this event capture where your Java Object sends out a JMS Asynchronous message, which "triggers" the event in Java, where your Java Objects are subscribers to that Queue, and therefore will know when that Oracle Stored Procedure is run.

But that might be the long way around, if something does already exist.

Mark
 
Bill Johnston
Ranch Hand
Posts: 201
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I wonder if Menon might have something on that in his new book?
 
R. M. Menon
Author
Ranch Hand
Posts: 50
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Originally posted by Bill Johnston:
I wonder if Menon might have something on that in his new book?


I am afraid not This is kind of specific requirement. The only way I can think of is to use JMS like Mark suggested. The trigger would result in a JMS message to the application. (I am no JMS expert, btw)

May I ask what the real business requirement is in this case?
 
I agree. Here's the link: http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic