Re: [Hsqldb-developers] HSQLdb, is it the answer to my prayers?

[Fred Toussi]

It all looks appropriate and doable. It will be extremely fast if you use simple queries on indexed columns even on very large tables (over 100000 records). For simple examples look at the TestXXX classes in 1.7.0 RC5 and read the jdbcXXXX JavaDocs for API issues. Also look at the Sourceforge forumns where there has been a lot of discussion of different issues.   Fred Toussi ----- Original Message ----- From: J. Todd Slack To: [EMAIL PROTECTED] Sent: Wednesday, May 22, 2002 1:46 AM Subject: [Hsqldb-developers] HSQLdb, is it the answer to my prayers? Hi All,   I have been looking at HSQL for a bit now and I am hoping that it is the correct item for me.   What I need to do:   I am writing a Data entry app (400+ fields) in Java. All is going well. We use oracle. We also have a package called Teams that is for Asset management.    What I would like is for each user that runs the application to have a local database on their machine. I would primarily use HSQLdb for lookup tables that don't change very often and also for adding records to the local db and then having them batched processed into Oracle later on in the day. Records need to be batched processed due to licensing restrictions on the TEAMS package where We cannot have a constant open connection. So when we need to use it, I have to create the connection and then drop it.   So here is what I would like to do:   1. have the local HSQL lookup tables (for populating combo boxes in my application) populated on startup for any changes from the oracle lookup tables. This should make the combo boxes fast and also help my in providing type-ahead on Textfields.   2. When a user adds a record, they add it to the local database and then after a set amount of time the records in the local database are batched processed into Oracle, Assets created in TEAMS, etc (a long process)   3. when a user needs to search for assets, they would search Oracle and have a result set returned to the local database for their browsing, etc (because I have to search and then disconnect) so then having the result set returned to the local database would allow them to look at the records for as long as they need, etc   4. I would set up the local database with the same exact Oracle table structure, etc so that field sizes, data types were the same (of course)   So a question or 2:   1. Does the above sound appropriate and do able in HSQL?   2. Are there examples that I can look at about connecting using the JDBC driver, setting up tables on disk, etc?   I apologize for the quick e-mail. If it doesn't make sense, I apologize, both my kids are sick and need attention, but I am still trying to get some work doe. I would be happy to clarify, etc   Does anybody have any thoughts?   -Jason