• 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
  • Jeanne Boyarsky
  • Ron McLeod
  • Liutauras Vilda
  • Paul Clapham
Sheriffs:
  • paul wheaton
  • Tim Cooke
  • Henry Wong
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Piet Souris
Bartenders:
  • Mike London

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 ]
reply
    Bookmark Topic Watch Topic
  • New Topic