Re: [libreoffice-users] Re: Base Report Builder

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