Date: prev next · Thread: first prev next last
2013 Archives by date, by thread · List index


Hi Hank,

The URL for the HSQLDB to H2 tutorial is -

http://www.oooforum.org/forum/viewtopic.phtml?p=365296#365296

As you will see, I had asked a series of questions and dacm kindly came up
with a very comprehensive set of answers.  The steps he listed worked well
for me.

One point to watch when migrating each table. For Table name enter -
      <Database name>.PUBLIC.<Table name>
e.g. ROSTERS.PUBLIC.Availability

I think you can choose an alternative to PUBLIC, but I just went with the
default.

Regards,

Noel
--
Noel Lodge
lodgemn@gmail.com


On 28 January 2013 04:15, Hank Alper <hankalper@gmail.com> wrote:

Hi Noel,
Thank you for pointing me to H2. It appears to offer so many advantages
over the embedded HSQLDB in LO Base that I shall certainly spend some time
examining
its possibilities.  I'd definitely like to see the tutorial for replacing
HSQLDB with H2.
Hank


On Sun, Jan 27, 2013 at 4:36 AM, Marion & Noel Lodge <lodgemn@gmail.com>wrote:

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




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

Context


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.