This week's book giveaway is in the Servlets forum.
We're giving away four copies of Murach's Java Servlets and JSP and have Joel Murach on-line!
See this thread for details.
The moose likes JDBC and the fly likes Is there a way to perform SQL queries on local data? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Is there a way to perform SQL queries on local data?" Watch "Is there a way to perform SQL queries on local data?" New topic
Author

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

Lon Allen
Ranch Hand

Joined: May 24, 2001
Posts: 67
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

Joined: Jan 29, 2003
Posts: 8791
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


A good question is never answered. It is not a bolt to be tightened into place but a seed to be planted and to bear more seed toward the hope of greening the landscape of the idea. John Ciardi
Lon Allen
Ranch Hand

Joined: May 24, 2001
Posts: 67
Thanks Stan
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Is there a way to perform SQL queries on local data?
 
Similar Threads
SQL benchmarking with maven
Insights on database programming
How can I create a local table for SQL queries?
Properties File For Oracle
entity class constructor