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

