Hi, I have a situation similar, where there are many applications accessing the database and upon inserts into a table events need to be triggered in the application server.
Which database server are you using? Most of the newer one allow you to write stored procedures in Java (SQLj part 1). You can make a database trigger that calls this stored procedure, which then calls an EJB. You may have problems with incompatable versions of the JVM between the DB and the app server. Alternatively you could use the stored procedure to write in to a message queue. Oracle has its Advanced Queue that you can have triggers put messages into queue which your app server could pick up with a message driven bean. Hope that this idea helps regards IV -----Original Message----- From: A mailing list for Enterprise JavaBeans development [mailto:[EMAIL PROTECTED]]On Behalf Of Sunder Sent: 10 October 2002 22:01 To: [EMAIL PROTECTED] Subject: EjbLoad on database trigger Hi, We have a situation where we create a bean that maps to a table. One of the columns is set by an external pre-trigger. I was wondering if the bean would have the triggered data set, when doing the ejb store. If not, are there alternatives for the data to be reflected back to the ejb? Thanks, Sunder =========================================================================== To unsubscribe, send email to [EMAIL PROTECTED] and include in the body of the message "signoff EJB-INTEREST". For general help, send email to [EMAIL PROTECTED] and include in the body of the message "help". =========================================================================== To unsubscribe, send email to [EMAIL PROTECTED] and include in the body of the message "signoff EJB-INTEREST". For general help, send email to [EMAIL PROTECTED] and include in the body of the message "help".
