Database Trigger invokes a Java class in an application server

Hi, I' am new to this forum. Can anybody help me out to solve my issue.

The Scenario is:

When a database table is populated with some data, immediately a class in the Websphere application server should be invoked.

The solution that I found is writing a trigger so that this trigger will call a Java stored procedure written in Oracle and the java stored procedure will call the external Java class which is in the Application server.

The database am using is Oracle 9i. The issue am facing with the above solution is version of JRE's. Oracle 9i is having JRE1.3 but the Java class in Application server is compiled using JRE1.5.

If anybody have some alternative solution also, please let me know.

Thank you

Regards

Anoop

[779 byte] By [Anoop.Retnaa] at [2007-11-27 6:41:38]
# 1
Sounds like a fragile solution. Is polling for changes out of question in your scenario?
quittea at 2007-7-12 18:11:19 > top of Java-index,Java Essentials,Java Programming...
# 2
@Op. You could use Oracle advanced queueing instead. http://www.akadia.com/services/ora_advanced_queueing.html
kajbja at 2007-7-12 18:11:19 > top of Java-index,Java Essentials,Java Programming...