tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Bill Davidson <bill...@gmail.com>
Subject Oracle database calling the web app?
Date Tue, 06 Jan 2009 22:22:52 GMT
Is it possible to set up a callback like situation so that a trigger in an
Oracle 10g database can call a method in a currently running webapp
that's running in Tomcat 6?

My situation is that I want to cache some infrequently changed database
data in memory but when that data does change in the database, I want
the web applications, running on multiple servers, to immediately pick
up the change.

Right now, one idea I have for this is to have the database trigger
create a file in a file system that's shared by the database server and
the application servers and have the web apps check for the existence
of this file to know whether to update the cache.  It feels ugly and
means hitting a networked file system a lot but it seems like it should
work and it seems like it should not be as bad as hitting the database
constantly for something that doesn't change very often.

I'd rather have the database send a message somehow to the web app that
it needs to update its cache of the data.  Any suggestions?



---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org


Mime
View raw message