Win a copy of Functional Reactive Programming this week in the Other Languages forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Is there a way to perform SQL queries on local data?

 
Lon Allen
Ranch Hand
Posts: 67
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I am trying to find a way to be able to query local data objects with SQL commands to avoid constantly hitting the database. I have an app that creates temporary tables in the database from some SELECT statements and I use those temp tables as the datasource for many more queries and temp table creations. If I could load local objects with the same data from these queries and query them instead I could buy some performance back by not having to hit the database so often. I know that .NET supports "disconnected" tables to allow something like this, but I cannot find anything in Java that I can so it with.
TIA
 
Stan James
(instanceof Sidekick)
Ranch Hand
Posts: 8791
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Try a google for "Java in memory database". There are a number of open source and other products. Here's are a couple: http://hsqldb.sourceforge.net/ and http://www.mcobject.com/index.php
 
Lon Allen
Ranch Hand
Posts: 67
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thanks Stan
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic