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 <[email protected]>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 > [email protected] > > > On 27 January 2013 17:24, Hank Alper <[email protected]> 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 < > > [email protected]> 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: > > [email protected] > > > 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: > [email protected] > > 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: [email protected] > 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: [email protected] 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
