Win a copy of Java Mock Exams (software) this week in the Programmer Certification (OCPJP) forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

How can I create a local table for SQL queries?

 
Lon Allen
Ranch Hand
Posts: 67
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Greenhorn
Posts: 3
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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 ]
 
Happiness is not a goal ... it's a by-product of a life well lived - Eleanor Roosevelt. Tiny ad:
the new thread boost feature: great for the advertiser and smooth for the coderanch user
https://coderanch.com/t/674455/Thread-Boost-feature
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!