|
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
|
