This week's book giveaway is in the OCPJP forum. We're giving away four copies of OCA/OCP Java SE 7 Programmer I & II Study Guide and have Kathy Sierra & Bert Bates on-line! See this thread for details.
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