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

     Many of these "advantages" also apply to HSQLDB if you know what 
you are doing. I refer to using Base to connect to the database rather 
than it be "embedded". In this case, tables, queries, forms, and reports 
can be copied from the embedded database to the external one. This is 
done using HSQLDB 1.8 database engine in Base. Then you should be able 
to upgrade Base to using HSQLDB 2.8 which includes features not 
available in the 1.8 version. This does require having a version of 
LibreOffice dedicated for this purpose (for example, using 3.6.5.2 for 
HSQLDB 2.8, and 4.0.0 for embedded databases).
     The draft of chapter 3 of the Base contains discussion of this in 
the last section.

--Dan

On 01/27/2013 04:36 AM, Marion & Noel Lodge 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