This week's book giveaway is in the Clojure forum.
We're giving away four copies of Clojure in Action and have Amit Rathore and Francis Avila on-line!
See this thread for details.
Win a copy of Clojure in Action this week in the Clojure forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

ResultSet, Statement Caching In Tomcat, Servlets

 
Vikas Aggarwal
Ranch Hand
Posts: 140
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,
Hitting the server and database for same kind of data involves the use of same Statements and use of same ResultSets over and over again.
I want to run the queries at the server start up and store tha data somewhere on application level so that it can be accessible to all of the servlets. Also this method should also avoid the concurrency issues.
Thanks for your help.
 
Ken Robinson
Ranch Hand
Posts: 52
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
If you just want to get a Collection of rows at startup and never refresh them, that is quite easy.
Create a Bean to hold a row of data. During startup of the app (via a Startup Servlet or ContextListener -2.3), run the query, build the Collection of Beans and put the Collection in the Servlet Context. Now it is available to all Servlet/Filters/JSP in the app.
 
I agree. Here's the link: http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic