How can I create a local table for SQL queries?

[Lon Allen]

How can I create a local table that I can use to make SQL queries to instead of creating a temp tables on the Db to make the same calls to? I have an application that makes several SQL calls to the database and each call creates a temp table to contain the new results. I want to just create a local tables on the client that I can manipulate instead of having to make all the calls to the database to do the work. I gather my results from the various SQL calls and build a new set of data to eventually write back to a different table in the Db when I am done.
Any suggestions?
[ January 08, 2004: Message edited by: Lon Allen ]

[V.T. Eialarasu]

Originally posted by Lon Allen:
How can I create a local table that I can use to make SQL queries to instead of creating a temp tables on the Db to make the same calls to? I have an application that makes several SQL calls to the database and each call creates a temp table to contain the new results. I want to just create a local tables on the client that I can manipulate instead of having to make all the calls to the database to do the work. I gather my results from the various SQL calls and build a new set of data to eventually write back to a different table in the Db when I am done.
Any suggestions?
[ January 08, 2004: Message edited by: Lon Allen ]

You can use HSQLDB as local RDBMS which will embeded in your client application and it is only 260 kb jar file. It has many facilitiis like memory based db, single embeded connection, db maintained in comma seperated file etc. More information available here.
[ January 14, 2004: Message edited by: V.T. Eialarasu ]
[ January 14, 2004: Message edited by: V.T. Eialarasu ]