File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes EJB and other Java EE Technologies and the fly likes External Database Changes sending notifications to Entity Beans Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Java » EJB and other Java EE Technologies
Bookmark "External Database Changes sending notifications to Entity Beans" Watch "External Database Changes sending notifications to Entity Beans" New topic
Author

External Database Changes sending notifications to Entity Beans

Vivek Viswanathan
Ranch Hand

Joined: Mar 03, 2001
Posts: 350
Hi

I dont know if this feature is avaliable in EJB where by when an external database change triggers a call back method on an entity bean, notifying it about the change. Acually, as I am writing this I am quite sure there doesnt exist such a facility.

I have a database that is accessed from the server side java application and the Db can also be accessed directly ( manual CRUD) and I would like that client application to be notified of any changes. Incase of changes through the server side java application I could send out a JMS from entity bean, but if the database is changed manually I have no way of knowing.
I dont want to poll the database table for changes and I am also not that keen on triggers, but I am interested in knowing how I can achive this using triggers.

Sybase Database
Weblogic 8.1
Swing Client Application


Vivek Viswanathan SCJP 1.2, SCJP 1.6,SCJD,SCEA,SCWCD,IBM-484,IBM-486,IBM-141,Ms.NET C# 70-316,SCMAD, LPIC-I
Karthik Guru
Ranch Hand

Joined: Mar 06, 2001
Posts: 1209
If you are talking about entity cache invalidation then
you might want to take a look at this
Vivek Viswanathan
Ranch Hand

Joined: Mar 03, 2001
Posts: 350
Thanks I will have a look at it.
riddick plus
Greenhorn

Joined: Nov 09, 2004
Posts: 3
how to use this weblogic.ejb.CachingHome class ??
riddick plus
Greenhorn

Joined: Nov 09, 2004
Posts: 3
If i'm using entity exclusive mode how can in do that ?
Vivek Viswanathan
Ranch Hand

Joined: Mar 03, 2001
Posts: 350
I didnt have much time to go through that class, since the external changes to the database will be only during production problems and we can ask the users to explicitly refresh at that time.
But you never know these code standards and desing policies change like the weather.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: External Database Changes sending notifications to Entity Beans