concerning the actual access, that Javaworld article about sql in Java sounds a cool way to do it...
about the initializing: - create a standard servlet that fetches the data and sets up a JavaBean (aka POJO) and stores that in the servlet-context - define this servlet in the web.xml and add the "load-on-startup" parameter. Then the container will load it automatically for you and only afterwards your webapp will be enabled hope this helps Alexander -----Original Message----- From: Ashish Kulkarni [mailto:[EMAIL PROTECTED] Sent: Monday, November 29, 2004 9:54 PM To: [EMAIL PROTECTED] Subject: data caching in web application Hi I have a table in DB2 on AS400 which has about 10000 records, i want to cache this data to improve my web application performance, I dont want to cache it in session, I was thinking of loading the data in array or some class and load it in servlet context, what is the best way to do it? is there some better way so i can querry this cached data using keys as if using primary key in SQL statment Ashish __________________________________ Do you Yahoo!? Meet the all-new My Yahoo! - Try it today! http://my.yahoo.com --------------------------------------------------------------------- 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]
