My team did something similar to this last year, but we had to write our own mechanism involving cached flags that would indicate to the session fa�ade when an entity when had last been used to update the database. But as far querying the db and recovering the number of records that were added, modified or deleted, I don't think that can be done. If it can it's not going to be trivial.
Try [EMAIL PROTECTED], which is more EJB-centric than this list. There is also an EJB-INTEREST mail list. Mark -----Original Message----- From: NYIMI Jose (BMB) [mailto:[EMAIL PROTECTED] Sent: Monday, June 16, 2003 9:59 AM To: Struts Users Mailing List Subject: [OT] EJB LIKE A TRIGGER Hello, 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) ======================= Jos� Nyimi Mbambi IT Analyst http://www.proximus.be **** DISCLAIMER **** "This e-mail and any attachment thereto may contain information which is confidential and/or protected by intellectual property rights and are intended for the sole use of the recipient(s) named above. Any use of the information contained herein (including, but not limited to, total or partial reproduction, communication or distribution in any form) by other persons than the designated recipient(s) is prohibited. If you have received this e-mail in error, please notify the sender either by telephone or by e-mail and delete the material from any computer". Thank you for your cooperation. For further information about Proximus mobile phone services please see our website at http://www.proximus.be or refer to any Proximus agent. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
