I' moving my code from Perl to Java/J2EE.
The goal is to integrate 2 systems, to be short
the business is mainly to transfert any
update, insert, delete from sytemA to systemB.
Those 2 sytems use Oracle database.
The requirement doesn't allow me to create any trigger on Oracle databases.
I there a way to go for an EJB solution that will act like a trigger ? The business of this EJB will be : "every x seconds (configurable) check changes from a given table (or view) et return the list
of rows that have been updated, inserted or deleted."
Do i need to re-invite the wheel or is this something that the container can handle itself ?
(i'm thinking about ejbload() method of an entity bean)
Thanks for your input.
José Nyimi Mbambi