• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Tim Cooke
  • paul wheaton
  • Paul Clapham
  • Ron McLeod
Sheriffs:
  • Jeanne Boyarsky
  • Liutauras Vilda
Saloon Keepers:
  • Tim Holloway
  • Carey Brown
  • Roland Mueller
  • Piet Souris
Bartenders:

How can I create a local table for SQL queries?

 
Ranch Hand
Posts: 67
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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 ]
 
Greenhorn
Posts: 3
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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 ]
 
Don't get me started about those stupid light bulbs.
reply
    Bookmark Topic Watch Topic
  • New Topic