Re: [libreoffice-users] Re: Base Report Builder much better, but...
Heinrich, Thanks for the heads-up on 4.1.2.3 lines working. I plan to try 4.x when it gets to 4.1.5+. I will try that Report Builder at that time. I am currently using Slackware 14.0 Linux, 3.2.29 32-bit SMP kernel, MySQL 5.5.29, mysql-connector-java-5.1.18, LO 3.6.7.2 and KDE 4.8.5. I am aware of the talk on this forum regarding the time values. I am using the MySQL Connector Java for my interface to my MySQL database, so I may not run into that problem, but I will look for it, since I do use times as well as dates. There is also a migration to mariadb in the future for me. Thanks again. Girvin On 10/16/2013 12:53 AM, Heinrich Stoellinger wrote: Hi Girvin, I did also have the problem of horizontal lines not working. However, they do appear correctly now under LO 4.1.2.3. My system is Linux-Mint-15, 32 bit. But then - as I have mentioned before (and filed a bug report) - time-values don't appear correctly both in Base as such and of course in report builder as a consequence. Everything works o.k. when using JDBC (for the time being...) It's a never-ending story! Regards Heinrich On Wed, 16 Oct 2013 09:46:04 +0200, Alex Thurgood wrote Le 16/10/2013 03:18, Girvin Herr a écrit : Hi Girvin, However, I still see that lines still are not supported. It appears as if I am inserting horizontal lines in my report, but they do not print. I do not see any way to make them thicker, in case that is the problem. I don't know whether this has been fixed yet in current release versions of 4.x, if Robert is reading, he might know more about that. Second, the Report Headers do not seem to work as I expected. The Report Footer section seems to be okay, but the Report Header section is under the Page Header on each page. I expected them to be reversed - the Report Header first, followed by the Page Header, the latter which goes on each page, the former goes on the first page only. As it is, the Page Header and Report Header are the same thing, going on each page. Is there a way to move the Report Header to page one only or is this a known bug? There are many ReportBuilder bugs in successive release versions - some get fixed in one version and others appear, these then get fixed and still others appear or re-appear - it seems to be an ever-changing landscape. Your best bet to find out is Bugzilla, but I'm pretty sure that what you are experiencing is a known bug. Additionally, the problem might depend on the distributor of the LO version you are using. Ubuntu PPA versions of LO, for example, tend to have their own additional bugs, especially in extensions (like the ReportBuilder). Alex -- To unsubscribe e-mail to: users+unsubscr...@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
Re: [libreoffice-users] Re: Base Report Builder much better, but...
On 10/16/2013 12:46 AM, Alex Thurgood wrote: Second, the Report Headers do not seem to work as I expected. The Report Footer section seems to be okay, but the Report Header section is under the Page Header on each page. I expected them to be reversed - the Report Header first, followed by the Page Header, the latter which goes on each page, the former goes on the first page only. As it is, the Page Header and Report Header are the same thing, going on each page. Is there a way to move the Report Header to page one only or is this a known bug? There are many ReportBuilder bugs in successive release versions - some get fixed in one version and others appear, these then get fixed and still others appear or re-appear - it seems to be an ever-changing landscape. Your best bet to find out is Bugzilla, but I'm pretty sure that what you are experiencing is a known bug. Additionally, the problem might depend on the distributor of the LO version you are using. Ubuntu PPA versions of LO, for example, tend to have their own additional bugs, especially in extensions (like the ReportBuilder). Alex Alex, For the record, I am using the binary RPM I downloaded from the LO website. So, I doubt this would be the problem. As I said, this is not a work-stopper for me, just a query (pun?) to see if anyone had a fix or work-around. It should get fixed sooner or later. I am primarily glad this version is running at a reasonable speed, unlike previous versions I tried to use and gave up for a 3rd-party report builder which had its own set of bugs. That report builder also had problems with inserting lines - option in the menu, but did nothing. However, it did do report headers properly. Thanks. Girvin -- To unsubscribe e-mail to: users+unsubscr...@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
Re: [libreoffice-users] Re: Base Report Builder much better, but...
Hi Girvin, I did also have the problem of horizontal lines not working. However, they do appear correctly now under LO 4.1.2.3. My system is Linux-Mint-15, 32 bit. But then - as I have mentioned before (and filed a bug report) - time-values don't appear correctly both in Base as such and of course in report builder as a consequence. Everything works o.k. when using JDBC (for the time being...) It's a never-ending story! Regards Heinrich On Wed, 16 Oct 2013 09:46:04 +0200, Alex Thurgood wrote Le 16/10/2013 03:18, Girvin Herr a écrit : Hi Girvin, However, I still see that lines still are not supported. It appears as if I am inserting horizontal lines in my report, but they do not print. I do not see any way to make them thicker, in case that is the problem. I don't know whether this has been fixed yet in current release versions of 4.x, if Robert is reading, he might know more about that. Second, the Report Headers do not seem to work as I expected. The Report Footer section seems to be okay, but the Report Header section is under the Page Header on each page. I expected them to be reversed - the Report Header first, followed by the Page Header, the latter which goes on each page, the former goes on the first page only. As it is, the Page Header and Report Header are the same thing, going on each page. Is there a way to move the Report Header to page one only or is this a known bug? There are many ReportBuilder bugs in successive release versions - some get fixed in one version and others appear, these then get fixed and still others appear or re-appear - it seems to be an ever-changing landscape. Your best bet to find out is Bugzilla, but I'm pretty sure that what you are experiencing is a known bug. Additionally, the problem might depend on the distributor of the LO version you are using. Ubuntu PPA versions of LO, for example, tend to have their own additional bugs, especially in extensions (like the ReportBuilder). Alex -- Erstellt mit Operas revolutionärem E-Mail-Modul: http://www.opera.com/mail/ -- To unsubscribe e-mail to: users+unsubscr...@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
[libreoffice-users] Re: Base Report Builder much better, but...
Le 16/10/2013 03:18, Girvin Herr a écrit : Hi Girvin, However, I still see that lines still are not supported. It appears as if I am inserting horizontal lines in my report, but they do not print. I do not see any way to make them thicker, in case that is the problem. I don't know whether this has been fixed yet in current release versions of 4.x, if Robert is reading, he might know more about that. Second, the Report Headers do not seem to work as I expected. The Report Footer section seems to be okay, but the Report Header section is under the Page Header on each page. I expected them to be reversed - the Report Header first, followed by the Page Header, the latter which goes on each page, the former goes on the first page only. As it is, the Page Header and Report Header are the same thing, going on each page. Is there a way to move the Report Header to page one only or is this a known bug? There are many ReportBuilder bugs in successive release versions - some get fixed in one version and others appear, these then get fixed and still others appear or re-appear - it seems to be an ever-changing landscape. Your best bet to find out is Bugzilla, but I'm pretty sure that what you are experiencing is a known bug. Additionally, the problem might depend on the distributor of the LO version you are using. Ubuntu PPA versions of LO, for example, tend to have their own additional bugs, especially in extensions (like the ReportBuilder). Alex -- To unsubscribe e-mail to: users+unsubscr...@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
Re: [libreoffice-users] Re: Base Report Builder
> Lol! I liked that post. Very funny. The reality is much less funny for all screen-labourslaves who have to work in those pathologically dysfunctional organisations. > I thought PostgreSQL was for large databases? It's for anything. > Also i thought Firebird was supposed to be quite good? Among FOSS client-server RDMBS, Firebird probably comes in second after PostgreSQL, that's right. But if I have any choice, I choose PostgreSQL. Sincerely, Wolfgang -- For unsubscribe instructions e-mail to: users+h...@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
Re: [libreoffice-users] Re: Base Report Builder
Hi :) Lol! I liked that post. Very funny. I thought PostgreSQL was for large databases? Also i thought Firebird was supposed to be quite good? I think that really is a large one though so possibly not what i am looking for. I'm hoping it is because i think one of my bosses is buying a front-end that uses it and i was hoping to use the same back-end for other databases. Regards from Tom :) > > From: Wolfgang Keller >To: users@global.libreoffice.org >Sent: Wednesday, 30 January 2013, 17:31 >Subject: Re: [libreoffice-users] Re: Base Report Builder > >> I have heard that corporates love to have their valuable data in java >> based backends > >That's because corporations are intrinsically dysfunctional organisations >that promote opportunist egomaniacs who have no competence in any other >field than careerism into those positions where they can cause the >maximum damage to the entity. > >FOSS projects shouldn't try to mimic corporate pathologies. > >> but is there something safer that is still good for smaller amounts >> of data? > >There's no (FOSS) RDBMS that beats PostgreSQL. And LO has a native >driver for it. > >Sincerely, > >Wolfgang > >-- >For unsubscribe instructions e-mail to: users+h...@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+h...@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
Re: [libreoffice-users] Re: Base Report Builder
> I have heard that corporates love to have their valuable data in java > based backends That's because corporations are intrinsicly dysfunctional organisations that promote opportunist egomaniacs who have no competence in any other field than careerism into those positions where they can cause the maximum damage to the entity. FOSS projects shouldn't try to mimic corporate pathologies. > but is there something safer that is still good for smaller amounts > of data? There's no (FOSS) RDBMS that beats PostgreSQL. And LO has a native driver for it. Sincerely, Wolfgang -- For unsubscribe instructions e-mail to: users+h...@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
Re: [libreoffice-users] Re: Base Report Builder
Hi :) I think Dan is describing how to migrate tables out of the embedded back-end and then the next (hopefully last) stepping stone gets the tables into the latest version of HsqlDb. Yes a pain but only a temporary one for most people making such a move. I'm not sure about H2 beign such a great alternative. Better and clearer documentation is a big plus but even so it is still based on Java so presumably as Java continues to fall apart under the 'new' owners (Oracle) it's just going to keep on being a problem. Is it at all likely that either one will re-code their back-ends to C# or C++ (same thing as each other or different?) or Python or Qt (?) or anything else that Is also cross-platform but less troublesome? I have heard that corporates love to have their valuable data in java based backends but is there something safer that is still good for smaller amounts of data? Errr, i guess i should ask that as a separate question, sorry. Regards from Tom :) > > From: Alex Thurgood >To: users@global.libreoffice.org >Sent: Wednesday, 30 January 2013, 10:59 >Subject: [libreoffice-users] Re: Base Report Builder > >Le 27/01/2013 13:47, Dan Lewis a écrit : > >Hi Dan, > >> 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. > >That is a considerable PITA, i.e. having two versions of LO just so you can >run two different versions of hsqldb. From that perspective alone, H2 is a >much better choice. However, the hsqldb version mismatch problem will soon >hopefully be moot, as Fred Toussi (the hsqldb developer guy) is currently >working on resolving these problems with an upcoming version 2.30 of hsqldb. > > >Alex > > >-- For unsubscribe instructions e-mail to: users+h...@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+h...@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
[libreoffice-users] Re: Base Report Builder
Le 27/01/2013 13:47, Dan Lewis a écrit : Hi Dan, > 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. That is a considerable PITA, i.e. having two versions of LO just so you can run two different versions of hsqldb. From that perspective alone, H2 is a much better choice. However, the hsqldb version mismatch problem will soon hopefully be moot, as Fred Toussi (the hsqldb developer guy) is currently working on resolving these problems with an upcoming version 2.30 of hsqldb. Alex -- For unsubscribe instructions e-mail to: users+h...@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
Re: [libreoffice-users] Re: Base Report Builder
Hi Tom, Noel, Dan, Alex and the others were all quite helpful. I'm going to explore some of my options. Noel suggested H2 as a back end and I was impressed with its specs. I downloaded the program and was pleased with the very clear documentation. In Noel's last post he was good enough to point me to a step by step tutorial for replacing embedded HSQLDB with H2. Unfortunately, that server appears to be down the last few days. Nevertheless I was able to get a connection to the H2 backend with JDBC using the H2 documentation. I have run into some syntax and database naming differences which I shall have to clear up. I expect I shall have plenty of questions about Base's behavior as a client. Hank On Tue, Jan 29, 2013 at 7:06 AM, Tom Davies wrote: > Hi :) > Sorry about scaring you! Hopefully you have picked up some good ways of > doing this from some of the other threads. > > If the database is not small then there are tons of good back-ends any one > of which would be great to use. I think Postgresql might be the best at > the moment but you might also enjoy using MySql/MariaDb instead and there > are other good ones. > > Hopefully it should be reasonably easy to migrate the tables and doing so > should not affect tables and forms especially if they are built up from > Queries rather than directly from the tables. If they were do directly > refer to the tables then they probably do need a bit of editing but > hopefully nothing too drastic. > > Apols for not replying sooner! I've just been a bit snowed under and > anyway Dan, Alex and others know far more about specifically Base itself so > hopefully someone has been able to give you much better help! > Regards from > tom :) > > > -- > *From:* Hank Alper > *To:* Alexander Thurgood > *Cc:* users@global.libreoffice.org > *Sent:* Sunday, 27 January 2013, 6:24 > > *Subject:* Re: [libreoffice-users] Re: Base Report Builder > > 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.thurg...@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+ > h...@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+h...@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+h...@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
Re: [libreoffice-users] Re: Base Report Builder
Hi :) Sorry about scaring you! Hopefully you have picked up some good ways of doing this from some of the other threads. If the database is not small then there are tons of good back-ends any one of which would be great to use. I think Postgresql might be the best at the moment but you might also enjoy using MySql/MariaDb instead and there are other good ones. Hopefully it should be reasonably easy to migrate the tables and doing so should not affect tables and forms especially if they are built up from Queries rather than directly from the tables. If they were do directly refer to the tables then they probably do need a bit of editing but hopefully nothing too drastic. Apols for not replying sooner! I've just been a bit snowed under and anyway Dan, Alex and others know far more about specifically Base itself so hopefully someone has been able to give you much better help! Regards from tom :) > > From: Hank Alper >To: Alexander Thurgood >Cc: users@global.libreoffice.org >Sent: Sunday, 27 January 2013, 6:24 >Subject: Re: [libreoffice-users] Re: Base Report Builder > >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.thurg...@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+h...@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+h...@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+h...@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
Re: [libreoffice-users] Re: Base Report Builder
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 - .PUBLIC. 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 lodg...@gmail.com On 28 January 2013 04:15, Hank Alper 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 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 >> lodg...@gmail.com >> >> >> On 27 January 2013 17:24, Hank Alper 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.thurg...@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+h...@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+h...@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+h...@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+h...@global.libreoffice.org Problems? http://www.lib
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 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 > lodg...@gmail.com > > > On 27 January 2013 17:24, Hank Alper 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.thurg...@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+h...@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+h...@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+h...@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+h...@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
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 lodg...@gmail.com On 27 January 2013 17:24, Hank Alper 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.thurg...@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+h...@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+h...@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+h...@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
Re: [libreoffice-users] Re: Base Report Builder
Hi :) Preferably before trying the big video please go to Tools - Options - Memory and radically increase the various settings in there so that the program can cope with the video. Does the whole video really have to be embedded in the slide-show/file or could it just be linked to and then the 2 files carried around together? It might seems a little clunkier that way but it does increase flexibility for the longer-term or if the show needs to appear on lower-spec machines (such as netbooks or tablets or hand-helds). It's not always possible easily so don't worry too much about it. It's just a thought. Several assumptions there that 'need' to be demolished. 1. LibreOffice is one single program/application with several different parts to it. Those parts should really be called "modules" rather than apps but we tend to use the wrong word to minimise endless repetitions of explanations and discussions which are mostly irrelevant to whatever problems the original poster had. Obviously it back-fires sometimes as in this case. So, Writer, Draw, Impress, Calc and Math are all 'just' modules within the program and the 1 single program is LibreOffice. You dealt with that just fine in the end but sometimes it's a struggle to explain. 2. Reinstalling does not reset settings nor configurations. You fixed a much more serious issue with the reinstall. The program/package itself 'must' have been broken in some way. Perhaps a corrupted download or something. Generally if you have weird problems and want to "get back to factory defaults" just to see if it was somethign in the settings or perhaps some 3rd party Extension struggling then just rename the User Profile https://wiki.documentfoundation.org/Documentation/UserProfile Actually on Friday i was able to rapidly fix a broken Gimp session on a colleague's machine by following that familiar link rather than trying to find my way through Gimp's own documentation. Not that Gimp's is bad, just that i had under a minute to find&fix. So, welcome in and regards from Tom :) > > From: Dr. Philipp Walderdorff >To: users@global.libreoffice.org >Sent: Sunday, 27 January 2013, 11:12 >Subject: Re: [libreoffice-users] Re: Base Report Builder > >Thanks for answer >After several trys to delete and reinstall LibreOfficeImpress I looked >for any file in the computer: >sudo find / -name libreoffice* -print >and deleted all of them and installed LibreOfficeImpress new >from Ubuntu Software Center >And ... its working :-) > >In one of these files must have been the wrong configuration, which >happened through copy and paste the 2 minute long video to >LibreOfficeImpress. I have read, that the correct way to input a video I >have to use the "input"-button. Yet I did not try the big video, but I >can go on working with LibreOffice, which makes me happy :-) > >If the problem will occure with the big video, I will try H2 > >Thanks for help > > >On 2013-01-27 10:36, 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 >> lodg...@gmail.com >> >> >> On 27 January 2013 17:24, Hank Alper 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 copie
Re: [libreoffice-users] Re: Base Report Builder
Thanks for answer After several trys to delete and reinstall libreOfficeImpress I looked for any file in the computer: sudo find / -name libreoffice* -print and deleted all of them and installed libreOfficeImpress new from ubuntuSoftwareCenter And ... its working :-) In one of these files must have been the wrong configuration, which happened through copy and paste the 2 minute long video to libreOfficeImpress. I have read, that the correct way to input a video I have to use the "input"-button. Yet I did not try the big video, but I can go on working with libreOffice, which makes me happy :-) If the problem will occure with the big video, I will try H2 Thanks for help On 2013-01-27 10:36, 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 lodg...@gmail.com On 27 January 2013 17:24, Hank Alper 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.thurg...@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+h...@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+h...@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+h...@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
Re: [libreoffice-users] Re: Base Report Builder
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 lodg...@gmail.com On 27 January 2013 17:24, Hank Alper 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.thurg...@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+h...@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+h...@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+h...@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
Re: [libreoffice-users] Re: Base Report Builder
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.thurg...@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+h...@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+h...@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
[libreoffice-users] Re: Base Report Builder
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+h...@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
[libreoffice-users] Re: Base Report Builder
Le 21/01/13 16:17, Tom Davies a écrit : Hi Tom, > I thought the back-end stayed external and Base would just link to it? > > Is the connector for this a bit broken too? It has nothing to do with a connector, I was referring to your question re the possibility of substituting internal hsqldb for an external one. This is discussed in the Base user guide, I believe, but it no longer works, if you want to use a different version of hsqldb than the one that LO uses internally. Anway, this is off topic with regard to the initial question. Alex -- For unsubscribe instructions e-mail to: users+h...@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
Re: [libreoffice-users] Re: Base Report Builder
Hi :) I thought the back-end stayed external and Base would just link to it? Is the connector for this a bit broken too? Regards from Tom :) > > From: Alex Thurgood >To: users@global.libreoffice.org >Sent: Monday, 21 January 2013, 13:34 >Subject: [libreoffice-users] Re: Base Report Builder > >On 01/21/2013 11:57 AM, Tom Davies wrote: >> Hi :) >>>From what i can gather it is better to have the tables as data in an >>>external database. Apparently the internal ancient and heavily tweaked >>>version of HSqlDb is a bit problematic but moving the tables to an external >>>proper and more recent version (or to a different back-end entirely) > >You can't currently successfully load a second, more recent version of >hsqldb.jar into LO (via the Java classpath/archive declaration dialog) >without untoward consequences, i.e. you can no longer open your existing >hsqldb ODB files without getting a driver loader error... > >see here : > >https://bugs.freedesktop.org/show_bug.cgi?id=34411 > > >Alex > > > >-- >For unsubscribe instructions e-mail to: users+h...@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+h...@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
[libreoffice-users] Re: Base Report Builder
On 01/21/2013 11:57 AM, Tom Davies wrote: > Hi :) >>From what i can gather it is better to have the tables as data in an external >>database. Apparently the internal ancient and heavily tweaked version of >>HSqlDb is a bit problematic but moving the tables to an external proper and >>more recent version (or to a different back-end entirely) You can't currently successfully load a second, more recent version of hsqldb.jar into LO (via the Java classpath/archive declaration dialog) without untoward consequences, i.e. you can no longer open your existing hsqldb ODB files without getting a driver loader error... see here : https://bugs.freedesktop.org/show_bug.cgi?id=34411 Alex -- For unsubscribe instructions e-mail to: users+h...@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
[libreoffice-users] Re: Base Report Builder
On 01/20/2013 10:31 PM, Hank Alper wrote: Hi Hank, I > restarted, LO blithely announced it was recovering my database. It did, but > the new Report and the modifications to a query I made in this session were > gone. I think* most* of this behavior is due to Report Builder. Has anyone > else observed this type of behavior before ?. My own personal advice would be not to use the autorecovery feature for ODB files. What this feature does is save what is in the volatile memory of the application at a given moment. This would be all well and good, BUT, and this is the killer : an ODB file does not load all data from the tables, reports, queries, etc into LO's volatile memory, only parts of that data (crap design, I know, but it was done initially for performance reasons). This means that if you get a crash, only a part of your whole ODB file data is actually saved to a temporary file, which is then used during the autorecovery process. The fact that you have not lost more data/queries/reports is pure luck so far. Instability of Base ODB files when opened within the LO application in general is one reason (apart from dependence on Java) why there is a search on for a replacement backend that would allow for more robust binary streaming. In the end, it may turn out that the ODB file, as with other db backends, e.g. server backends like mysql and postgres, will become just a container for forms, queries and reports, and the actual data will be held in a separate file. This should actually make the data handling more robust, but performance might become an issue (not that current hsqldb/ODB performance is stellar, coz it isn't). Someone was looking at the possibility of using firebird. For the moment, however, nothing has been decided or actually undertaken as far as I know. If you really need to rely on your data keeping its coherency and consistency, my advice would be not to use the default hsqldb/ODB pair that is provided as the default. It is a shame really, as hsqldb in itself, certainly in its 2.0 version, is a capable db engine. It is just the integration with AOO/LO that is one of the root causes of many of the problems that users experience. Alex -- For unsubscribe instructions e-mail to: users+h...@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