Hi Hank,
I haven't been following this thread closely, but it seem like you are
experiencing some of the same problems I had using Base HSQLDB. I
eventually decided to move my Accounting Project to the H2 Database
Engine,
(see http://www.h2database.com/html/main.html).
Some of the many advantages of H2 are -
- Separate files for Data and Project
- Can be run in single or multi-user mode
- Users report successfully running very large databases
- An active users forum
I have found H2 to be very stable and have not regretted making the
change.
If you are interested at all, I can point you to a very good tutorial for
replacing HSQLDB with H2.
This may not be what you are looking for, but it's probably worth your
while at least having a look at what H2 has to offer.
Noel
--
Noel Lodge
lodgemn@gmail.com
On 27 January 2013 17:24, Hank Alper <hankalper@gmail.com> wrote:
Hi Alex, Mark, Tom,
You guys scare me ! I'm beginning to think I'd better start looking
for a
new back end. I've put a lot of work into this project. Tom, this is
not a
small database like an address book. After normalizing, my design has 16
tables.( with a few more coming as I've discovered as I feed more data
into it.) If I connect to an external server is there any way I can
save my
forms and reports? Or shall I have to start anew ? My tables, queries
and
views were all produced using SQL and I have text copies of all of
them to
feed any server I might select. Transfer of data becomes a problem, of
course.
Hank
On Mon, Jan 21, 2013 at 10:36 AM, Alexander Thurgood <
alex.thurgood@gmail.com> wrote:
Le 21/01/13 16:01, Mark Stanton a écrit :
Isn't hsqldb *still* a (relatively) good choice, as long as it is
installed and
used *external* to Base? That does of course mean it's still not
the
"default"
setting.
As I mentioned in my answer to Tom, if you use an external version of
hsqldb, it can only be the same version number as the internal version
provided with LO, else the old ODB files can no longer be opened. In
other words, you can not install an external hsqldb jar and expect
your
old ODB(hsqldb) files to keep working, as this will throw an error.
So yes, it still remains a possibility, but one that you may want to
avoid if you still have old ODB files that use the internal hsqldb
with
an older revision number than the externa jar you plug into LO.
Alex
--
For unsubscribe instructions e-mail to:
users+help@global.libreoffice.org
Problems?
http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more:
http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be
deleted
--
For unsubscribe instructions e-mail to:
users+help@global.libreoffice.org
Problems?
http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more:
http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be
deleted
--
For unsubscribe instructions e-mail to: users+help@global.libreoffice.org
Problems?
http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be
deleted