Ashish, I think Larry's point is that by storing it in Java, it may not be as up to date as it is in the database. With 16,000 rows, you could have the logic in a stored procedure that is run as a database trigger whenever the data changes and retrieve the result from your application.
How soon do you need the changes in the data to be seen by your Java application? -Richard -----Original Message----- From: Ashish Kulkarni [mailto:[EMAIL PROTECTED] Sent: Monday, June 11, 2007 10:52 AM To: [email protected]; [EMAIL PROTECTED] Subject: Re: Caching data requirement. Hi I can use stored procedure to read this data, but i would like to store it in java( basically this is a web application ) so store this in a ServletContext or some where and update it when ever there is change in this data. if was wondering if ibatis can be any help in doing so On 6/10/07, Larry Meadors <[EMAIL PROTECTED]> wrote: I'd look for a way to make the database do this - any solution on the Java side will be inherently out-of-date. Can you do this in a stored procedure? Larry On 6/10/07, Ashish Kulkarni <[EMAIL PROTECTED]> wrote: > Hi > I have a situation where i have a table of about 16,000. rows, which i need > to use for mathematical calculation. > i want to cache the data and this data should update as soon as the database > is updated. > > Database is updated by external process, so Java program does not know if > there is update by some other process. > > Is it possible to do this requirement using ibatis, any suggestions > > Ashish > > > >
