Re: Fwd: [libreoffice-users] Re: LibreOffice-Base CPU usage
Hi :) Ahah, thanks Jay. I was hoping that HSql only dipped into using java for a few things. So, Don needs to have that java box ticked all the time he uses Base and can only avoid it when not using Base at all. Is it possible to edit short-cuts and stuff so that opening Base will enable java but opening java wont? I think it might be possible in GnuLinux by having 2 different short-cuts on the desktop or in the taskbar/panel. regards from Tom :) --- On Sun, 18/9/11, planas jsloz...@gmail.com wrote: From: planas jsloz...@gmail.com Subject: Re: Fwd: [libreoffice-users] Re: LibreOffice-Base CPU usage To: users@global.libreoffice.org Date: Sunday, 18 September, 2011, 6:58 Hi, On Sat, 2011-09-17 at 23:30 +0100, Tom Davies wrote: Hi :) Thanks Don. I think you might be able to convert/export/migrate your back-end to a different one. I don't think you have to stick with HSql. I'm not sure if it's possible to remove java dependence when using HSql, i thought it was but i could be wrong. Regards from Tom :) --- On Sat, 17/9/11, Don Myers donmy...@myersfarm.com wrote: From: Don Myers donmy...@myersfarm.com Subject: Re: Fwd: [libreoffice-users] Re: LibreOffice-Base CPU usage To: users@global.libreoffice.org Date: Saturday, 17 September, 2011, 23:13 Hi All, I set up base shortly after it was added to Open Office. Apparently I am using the embedded database - HSQL database engine. If I turn off Java (I just tried it.), I get the following error message: The connection to the data source RE Database could not be established. No SDBC driver was found for the given URL. I cannot open my database without Java enabled. So using the database included with base will not work without Java. Don snip The HSQL engine is Java based. It may be possible to use Base as a front-end for something like MySQL or PostgreSQL, which do not use Java. On 09/17/2011 08:29 AM, Tom Davies wrote: Hi :) I think you can completely un-install all instances of java but i think that might create problems. Your web-browser might not be very happy without java. Generally i try to keep escape routes and back-up plans available = so i would just switch off java in LO so that i could switch it on again quite easily if i needed it. Tools - Options - LibreOffice/General - Java then UNtick the box at the very top Use a java runtime environment. I have only unticked this a few days ago and LO seems to start-up a lot faster. Regards from Tom :) --- On Sat, 17/9/11, Heinrich Stoellingerhc.stoellin...@aon.at wrote: From: Heinrich Stoellingerhc.stoellin...@aon.at Subject: Fwd: [libreoffice-users] Re: LibreOffice-Base CPU usage To: users@global.libreoffice.orgusers@global.libreoffice.org Date: Saturday, 17 September, 2011, 11:55 Hello again, Is there a misunderstanding somewhere? As I said, I use the ODBC-connection to MySQL on Linux (and a very well working native MySQL-connection under Windows). Like I posted in another message, ODBC also has problems (such as not showing default values for columns correctly on data entry, but - since the database is actually updated correctly - this doesn't really worry me much. So, like Tom suggests: can I get completely rid of Java if I don't conciously use it in any way that an end-user or programmer could cause? That would be more than alright for me... Regards H. Stoellinger (from a lovely early autumn sunny day here in Salzburg) P.S.: I have used the Java-connector in the past but don't do so anymore. --- Forwarded message --- From: Andreas Sägerville...@t-online.de To: users@global.libreoffice.org Subject: [libreoffice-users] Re: LibreOffice-Base CPU usage Date: Sat, 17 Sep 2011 11:35:28 +0200 Since you are not running MySQL through ODBC you can turn off all Java support for the entire office suite and simply work with the raw database connectivity and input forms. All the Java wizards are close to useless anyway. You don't need them and get much better results faster if you know what you're doing. Am 16.09.2011 20:44, Heinrich Stoellinger wrote: Hello again, On my Linux/LO 3.4.3 system, after some time of working with Base (ODBC connetcion to MySQL), LO uses 90 to 100 p.c. of one of the 4 CPUs of my PC. When I then save LO-Base, CPU-usage is normal again (for a while!). I don't really know what causes this behaviour, could it have to to with backup copy creation? I find an aweful lot of backup files in /home/rainermusik/.libreoffice/3/user/backup. All of them have a filename something like rmodbc.odb_9777.odb and are of 0 (zero) size. I wonder what's wrong. Regards H. Stoellinger --Erstellt mit Operas revolutionärem E-Mail-Modul: http://www.opera.com/mail/ --For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists
Re: Fwd: [libreoffice-users] Re: LibreOffice-Base CPU usage
Hi :) I think you can completely un-install all instances of java but i think that might create problems. Your web-browser might not be very happy without java. Generally i try to keep escape routes and back-up plans available = so i would just switch off java in LO so that i could switch it on again quite easily if i needed it. Tools - Options - LibreOffice/General - Java then UNtick the box at the very top Use a java runtime environment. I have only unticked this a few days ago and LO seems to start-up a lot faster. Regards from Tom :) --- On Sat, 17/9/11, Heinrich Stoellinger hc.stoellin...@aon.at wrote: From: Heinrich Stoellinger hc.stoellin...@aon.at Subject: Fwd: [libreoffice-users] Re: LibreOffice-Base CPU usage To: users@global.libreoffice.org users@global.libreoffice.org Date: Saturday, 17 September, 2011, 11:55 Hello again, Is there a misunderstanding somewhere? As I said, I use the ODBC-connection to MySQL on Linux (and a very well working native MySQL-connection under Windows). Like I posted in another message, ODBC also has problems (such as not showing default values for columns correctly on data entry, but - since the database is actually updated correctly - this doesn't really worry me much. So, like Tom suggests: can I get completely rid of Java if I don't conciously use it in any way that an end-user or programmer could cause? That would be more than alright for me... Regards H. Stoellinger (from a lovely early autumn sunny day here in Salzburg) P.S.: I have used the Java-connector in the past but don't do so anymore. --- Forwarded message --- From: Andreas Säger ville...@t-online.de To: users@global.libreoffice.org Subject: [libreoffice-users] Re: LibreOffice-Base CPU usage Date: Sat, 17 Sep 2011 11:35:28 +0200 Since you are not running MySQL through ODBC you can turn off all Java support for the entire office suite and simply work with the raw database connectivity and input forms. All the Java wizards are close to useless anyway. You don't need them and get much better results faster if you know what you're doing. Am 16.09.2011 20:44, Heinrich Stoellinger wrote: Hello again, On my Linux/LO 3.4.3 system, after some time of working with Base (ODBC connetcion to MySQL), LO uses 90 to 100 p.c. of one of the 4 CPUs of my PC. When I then save LO-Base, CPU-usage is normal again (for a while!). I don't really know what causes this behaviour, could it have to to with backup copy creation? I find an aweful lot of backup files in /home/rainermusik/.libreoffice/3/user/backup. All of them have a filename something like rmodbc.odb_9777.odb and are of 0 (zero) size. I wonder what's wrong. Regards H. Stoellinger --Erstellt mit Operas revolutionärem E-Mail-Modul: http://www.opera.com/mail/ --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
Fwd: Re: Fwd: [libreoffice-users] Re: LibreOffice-Base CPU usage
Hello Tom, Thanks for your suggestion. I unticked the box at the very top Use a java runtime environment and LO still works fine. It also starts up very fast. As I need Java for purposes outside of LO, I will keep it for the time being. Regards Heinrich --- Forwarded message --- From: Tom Davies tomdavie...@yahoo.co.uk To: users@global.libreoffice.org Subject: Re: Fwd: [libreoffice-users] Re: LibreOffice-Base CPU usage Date: Sat, 17 Sep 2011 14:29:10 +0200 Hi :) I think you can completely un-install all instances of java but i think that might create problems. Your web-browser might not be very happy without java. Generally i try to keep escape routes and back-up plans available = so i would just switch off java in LO so that i could switch it on again quite easily if i needed it. Tools - Options - LibreOffice/General - Java then UNtick the box at the very top Use a java runtime environment. I have only unticked this a few days ago and LO seems to start-up a lot faster. Regards from Tom :) --- On Sat, 17/9/11, Heinrich Stoellinger hc.stoellin...@aon.at wrote: From: Heinrich Stoellinger hc.stoellin...@aon.at Subject: Fwd: [libreoffice-users] Re: LibreOffice-Base CPU usage To: users@global.libreoffice.org users@global.libreoffice.org Date: Saturday, 17 September, 2011, 11:55 Hello again, Is there a misunderstanding somewhere? As I said, I use the ODBC-connection to MySQL on Linux (and a very well working native MySQL-connection under Windows). Like I posted in another message, ODBC also has problems (such as not showing default values for columns correctly on data entry, but - since the database is actually updated correctly - this doesn't really worry me much. So, like Tom suggests: can I get completely rid of Java if I don't conciously use it in any way that an end-user or programmer could cause? That would be more than alright for me... Regards H. Stoellinger (from a lovely early autumn sunny day here in Salzburg) P.S.: I have used the Java-connector in the past but don't do so anymore. --- Forwarded message --- From: Andreas Säger ville...@t-online.de To: users@global.libreoffice.org Subject: [libreoffice-users] Re: LibreOffice-Base CPU usage Date: Sat, 17 Sep 2011 11:35:28 +0200 Since you are not running MySQL through ODBC you can turn off all Java support for the entire office suite and simply work with the raw database connectivity and input forms. All the Java wizards are close to useless anyway. You don't need them and get much better results faster if you know what you're doing. Am 16.09.2011 20:44, Heinrich Stoellinger wrote: Hello again, On my Linux/LO 3.4.3 system, after some time of working with Base (ODBC connetcion to MySQL), LO uses 90 to 100 p.c. of one of the 4 CPUs of my PC. When I then save LO-Base, CPU-usage is normal again (for a while!). I don't really know what causes this behaviour, could it have to to with backup copy creation? I find an aweful lot of backup files in /home/rainermusik/.libreoffice/3/user/backup. All of them have a filename something like rmodbc.odb_9777.odb and are of 0 (zero) size. I wonder what's wrong. Regards H. Stoellinger --Erstellt mit Operas revolutionärem E-Mail-Modul: http://www.opera.com/mail/ --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 -- Erstellt mit Operas revolutionärem E-Mail-Modul: http://www.opera.com/mail/ -- 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: Fwd: [libreoffice-users] Re: LibreOffice-Base CPU usage
Hi All, I set up base shortly after it was added to Open Office. Apparently I am using the embedded database - HSQL database engine. If I turn off Java (I just tried it.), I get the following error message: The connection to the data source RE Database could not be established. No SDBC driver was found for the given URL. I cannot open my database without Java enabled. So using the database included with base will not work without Java. Don On 09/17/2011 08:29 AM, Tom Davies wrote: Hi :) I think you can completely un-install all instances of java but i think that might create problems. Your web-browser might not be very happy without java. Generally i try to keep escape routes and back-up plans available = so i would just switch off java in LO so that i could switch it on again quite easily if i needed it. Tools - Options - LibreOffice/General - Java then UNtick the box at the very top Use a java runtime environment. I have only unticked this a few days ago and LO seems to start-up a lot faster. Regards from Tom :) --- On Sat, 17/9/11, Heinrich Stoellingerhc.stoellin...@aon.at wrote: From: Heinrich Stoellingerhc.stoellin...@aon.at Subject: Fwd: [libreoffice-users] Re: LibreOffice-Base CPU usage To: users@global.libreoffice.orgusers@global.libreoffice.org Date: Saturday, 17 September, 2011, 11:55 Hello again, Is there a misunderstanding somewhere? As I said, I use the ODBC-connection to MySQL on Linux (and a very well working native MySQL-connection under Windows). Like I posted in another message, ODBC also has problems (such as not showing default values for columns correctly on data entry, but - since the database is actually updated correctly - this doesn't really worry me much. So, like Tom suggests: can I get completely rid of Java if I don't conciously use it in any way that an end-user or programmer could cause? That would be more than alright for me... Regards H. Stoellinger (from a lovely early autumn sunny day here in Salzburg) P.S.: I have used the Java-connector in the past but don't do so anymore. --- Forwarded message --- From: Andreas Sägerville...@t-online.de To: users@global.libreoffice.org Subject: [libreoffice-users] Re: LibreOffice-Base CPU usage Date: Sat, 17 Sep 2011 11:35:28 +0200 Since you are not running MySQL through ODBC you can turn off all Java support for the entire office suite and simply work with the raw database connectivity and input forms. All the Java wizards are close to useless anyway. You don't need them and get much better results faster if you know what you're doing. Am 16.09.2011 20:44, Heinrich Stoellinger wrote: Hello again, On my Linux/LO 3.4.3 system, after some time of working with Base (ODBC connetcion to MySQL), LO uses 90 to 100 p.c. of one of the 4 CPUs of my PC. When I then save LO-Base, CPU-usage is normal again (for a while!). I don't really know what causes this behaviour, could it have to to with backup copy creation? I find an aweful lot of backup files in /home/rainermusik/.libreoffice/3/user/backup. All of them have a filename something like rmodbc.odb_9777.odb and are of 0 (zero) size. I wonder what's wrong. Regards H. Stoellinger --Erstellt mit Operas revolutionärem E-Mail-Modul: http://www.opera.com/mail/ --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 -- *~~* Don C. Myers e-PRO Certified by the National Association of Realtors Manager, Farm and Rural Property Division *Coldwell Banker University Realty *126 East Foster Avenue, State College, PA 16801 Phone: 814-237-6543 Fax: 814-237-6502 Visit the Farm and Rural Property Division Website at www.cbur-ruralproperty.com http://www.cbur-ruralproperty.com/_ _View Don's farm website: www.myersfarm.com http://www.myersfarm.com/ *~~* -- 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: Fwd: [libreoffice-users] Re: LibreOffice-Base CPU usage
Hi :) Thanks Don. I think you might be able to convert/export/migrate your back-end to a different one. I don't think you have to stick with HSql. I'm not sure if it's possible to remove java dependence when using HSql, i thought it was but i could be wrong. Regards from Tom :) --- On Sat, 17/9/11, Don Myers donmy...@myersfarm.com wrote: From: Don Myers donmy...@myersfarm.com Subject: Re: Fwd: [libreoffice-users] Re: LibreOffice-Base CPU usage To: users@global.libreoffice.org Date: Saturday, 17 September, 2011, 23:13 Hi All, I set up base shortly after it was added to Open Office. Apparently I am using the embedded database - HSQL database engine. If I turn off Java (I just tried it.), I get the following error message: The connection to the data source RE Database could not be established. No SDBC driver was found for the given URL. I cannot open my database without Java enabled. So using the database included with base will not work without Java. Don On 09/17/2011 08:29 AM, Tom Davies wrote: Hi :) I think you can completely un-install all instances of java but i think that might create problems. Your web-browser might not be very happy without java. Generally i try to keep escape routes and back-up plans available = so i would just switch off java in LO so that i could switch it on again quite easily if i needed it. Tools - Options - LibreOffice/General - Java then UNtick the box at the very top Use a java runtime environment. I have only unticked this a few days ago and LO seems to start-up a lot faster. Regards from Tom :) --- On Sat, 17/9/11, Heinrich Stoellingerhc.stoellin...@aon.at wrote: From: Heinrich Stoellingerhc.stoellin...@aon.at Subject: Fwd: [libreoffice-users] Re: LibreOffice-Base CPU usage To: users@global.libreoffice.orgusers@global.libreoffice.org Date: Saturday, 17 September, 2011, 11:55 Hello again, Is there a misunderstanding somewhere? As I said, I use the ODBC-connection to MySQL on Linux (and a very well working native MySQL-connection under Windows). Like I posted in another message, ODBC also has problems (such as not showing default values for columns correctly on data entry, but - since the database is actually updated correctly - this doesn't really worry me much. So, like Tom suggests: can I get completely rid of Java if I don't conciously use it in any way that an end-user or programmer could cause? That would be more than alright for me... Regards H. Stoellinger (from a lovely early autumn sunny day here in Salzburg) P.S.: I have used the Java-connector in the past but don't do so anymore. --- Forwarded message --- From: Andreas Sägerville...@t-online.de To: users@global.libreoffice.org Subject: [libreoffice-users] Re: LibreOffice-Base CPU usage Date: Sat, 17 Sep 2011 11:35:28 +0200 Since you are not running MySQL through ODBC you can turn off all Java support for the entire office suite and simply work with the raw database connectivity and input forms. All the Java wizards are close to useless anyway. You don't need them and get much better results faster if you know what you're doing. Am 16.09.2011 20:44, Heinrich Stoellinger wrote: Hello again, On my Linux/LO 3.4.3 system, after some time of working with Base (ODBC connetcion to MySQL), LO uses 90 to 100 p.c. of one of the 4 CPUs of my PC. When I then save LO-Base, CPU-usage is normal again (for a while!). I don't really know what causes this behaviour, could it have to to with backup copy creation? I find an aweful lot of backup files in /home/rainermusik/.libreoffice/3/user/backup. All of them have a filename something like rmodbc.odb_9777.odb and are of 0 (zero) size. I wonder what's wrong. Regards H. Stoellinger --Erstellt mit Operas revolutionärem E-Mail-Modul: http://www.opera.com/mail/ --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 -- *~~* Don C. Myers e-PRO Certified by the National Association of Realtors Manager, Farm and Rural Property Division *Coldwell Banker University Realty *126 East Foster Avenue, State College, PA 16801 Phone: 814-237-6543 Fax: 814-237-6502 Visit the Farm and Rural Property Division Website at www.cbur-ruralproperty.com http://www.cbur-ruralproperty.com/_ _View Don's farm website: www.myersfarm.com http://www.myersfarm.com/ *~~* -- 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
Re: Fwd: [libreoffice-users] Re: LibreOffice-Base CPU usage
Hi Tom, There is an old saying - if it ain't broke, don't fix it. The thing I dislike most about Base is to have to open three windows to get to my form in the database. Some time ago I left a post on an Open Office forum asking if there was a way to set up a macro so I could do it in one click. There were never any replies. With Paradox or Access I was able to go to the form by just opening the program. But what I really like about Base is I just have 1 file to copy to keep my database updated on my three other computers. When I say if it ain't broken, don't fix it, I've never had one issue using Base. It has worked very well for me over a long period (7 or 8 years) of time. There are few programs I've ever used that have had that kind of dependability. Don On 09/17/2011 06:30 PM, Tom Davies wrote: Hi :) Thanks Don. I think you might be able to convert/export/migrate your back-end to a different one. I don't think you have to stick with HSql. I'm not sure if it's possible to remove java dependence when using HSql, i thought it was but i could be wrong. Regards from Tom :) --- On Sat, 17/9/11, Don Myersdonmy...@myersfarm.com wrote: From: Don Myersdonmy...@myersfarm.com Subject: Re: Fwd: [libreoffice-users] Re: LibreOffice-Base CPU usage To: users@global.libreoffice.org Date: Saturday, 17 September, 2011, 23:13 Hi All, I set up base shortly after it was added to Open Office. Apparently I am using the embedded database - HSQL database engine. If I turn off Java (I just tried it.), I get the following error message: The connection to the data source RE Database could not be established. No SDBC driver was found for the given URL. I cannot open my database without Java enabled. So using the database included with base will not work without Java. Don On 09/17/2011 08:29 AM, Tom Davies wrote: Hi :) I think you can completely un-install all instances of java but i think that might create problems. Your web-browser might not be very happy without java. Generally i try to keep escape routes and back-up plans available = so i would just switch off java in LO so that i could switch it on again quite easily if i needed it. Tools - Options - LibreOffice/General - Java then UNtick the box at the very top Use a java runtime environment. I have only unticked this a few days ago and LO seems to start-up a lot faster. Regards from Tom :) --- On Sat, 17/9/11, Heinrich Stoellingerhc.stoellin...@aon.at wrote: From: Heinrich Stoellingerhc.stoellin...@aon.at Subject: Fwd: [libreoffice-users] Re: LibreOffice-Base CPU usage To: users@global.libreoffice.orgusers@global.libreoffice.org Date: Saturday, 17 September, 2011, 11:55 Hello again, Is there a misunderstanding somewhere? As I said, I use the ODBC-connection to MySQL on Linux (and a very well working native MySQL-connection under Windows). Like I posted in another message, ODBC also has problems (such as not showing default values for columns correctly on data entry, but - since the database is actually updated correctly - this doesn't really worry me much. So, like Tom suggests: can I get completely rid of Java if I don't conciously use it in any way that an end-user or programmer could cause? That would be more than alright for me... Regards H. Stoellinger (from a lovely early autumn sunny day here in Salzburg) P.S.: I have used the Java-connector in the past but don't do so anymore. --- Forwarded message --- From: Andreas Sägerville...@t-online.de To: users@global.libreoffice.org Subject: [libreoffice-users] Re: LibreOffice-Base CPU usage Date: Sat, 17 Sep 2011 11:35:28 +0200 Since you are not running MySQL through ODBC you can turn off all Java support for the entire office suite and simply work with the raw database connectivity and input forms. All the Java wizards are close to useless anyway. You don't need them and get much better results faster if you know what you're doing. Am 16.09.2011 20:44, Heinrich Stoellinger wrote: Hello again, On my Linux/LO 3.4.3 system, after some time of working with Base (ODBC connetcion to MySQL), LO uses 90 to 100 p.c. of one of the 4 CPUs of my PC. When I then save LO-Base, CPU-usage is normal again (for a while!). I don't really know what causes this behaviour, could it have to to with backup copy creation? I find an aweful lot of backup files in /home/rainermusik/.libreoffice/3/user/backup. All of them have a filename something like rmodbc.odb_9777.odb and are of 0 (zero) size. I wonder what's wrong. Regards H. Stoellinger --Erstellt mit Operas revolutionärem E-Mail-Modul: http://www.opera.com/mail/ --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: Fwd: [libreoffice-users] Re: LibreOffice-Base CPU usage
Hi :) If the different machines are on a Lan then it might be possible to share the back-end and then any change from any of the 3 machines would be on the other machines too? Regards from Tom :) --- On Sat, 17/9/11, Don Myers donmy...@myersfarm.com wrote: From: Don Myers donmy...@myersfarm.com Subject: Re: Fwd: [libreoffice-users] Re: LibreOffice-Base CPU usage To: users@global.libreoffice.org Date: Saturday, 17 September, 2011, 23:44 Hi Tom, There is an old saying - if it ain't broke, don't fix it. The thing I dislike most about Base is to have to open three windows to get to my form in the database. Some time ago I left a post on an Open Office forum asking if there was a way to set up a macro so I could do it in one click. There were never any replies. With Paradox or Access I was able to go to the form by just opening the program. But what I really like about Base is I just have 1 file to copy to keep my database updated on my three other computers. When I say if it ain't broken, don't fix it, I've never had one issue using Base. It has worked very well for me over a long period (7 or 8 years) of time. There are few programs I've ever used that have had that kind of dependability. Don On 09/17/2011 06:30 PM, Tom Davies wrote: Hi :) Thanks Don. I think you might be able to convert/export/migrate your back-end to a different one. I don't think you have to stick with HSql. I'm not sure if it's possible to remove java dependence when using HSql, i thought it was but i could be wrong. Regards from Tom :) --- On Sat, 17/9/11, Don Myersdonmy...@myersfarm.com wrote: From: Don Myersdonmy...@myersfarm.com Subject: Re: Fwd: [libreoffice-users] Re: LibreOffice-Base CPU usage To: users@global.libreoffice.org Date: Saturday, 17 September, 2011, 23:13 Hi All, I set up base shortly after it was added to Open Office. Apparently I am using the embedded database - HSQL database engine. If I turn off Java (I just tried it.), I get the following error message: The connection to the data source RE Database could not be established. No SDBC driver was found for the given URL. I cannot open my database without Java enabled. So using the database included with base will not work without Java. Don On 09/17/2011 08:29 AM, Tom Davies wrote: Hi :) I think you can completely un-install all instances of java but i think that might create problems. Your web-browser might not be very happy without java. Generally i try to keep escape routes and back-up plans available = so i would just switch off java in LO so that i could switch it on again quite easily if i needed it. Tools - Options - LibreOffice/General - Java then UNtick the box at the very top Use a java runtime environment. I have only unticked this a few days ago and LO seems to start-up a lot faster. Regards from Tom :) --- On Sat, 17/9/11, Heinrich Stoellingerhc.stoellin...@aon.at wrote: From: Heinrich Stoellingerhc.stoellin...@aon.at Subject: Fwd: [libreoffice-users] Re: LibreOffice-Base CPU usage To: users@global.libreoffice.orgusers@global.libreoffice.org Date: Saturday, 17 September, 2011, 11:55 Hello again, Is there a misunderstanding somewhere? As I said, I use the ODBC-connection to MySQL on Linux (and a very well working native MySQL-connection under Windows). Like I posted in another message, ODBC also has problems (such as not showing default values for columns correctly on data entry, but - since the database is actually updated correctly - this doesn't really worry me much. So, like Tom suggests: can I get completely rid of Java if I don't conciously use it in any way that an end-user or programmer could cause? That would be more than alright for me... Regards H. Stoellinger (from a lovely early autumn sunny day here in Salzburg) P.S.: I have used the Java-connector in the past but don't do so anymore. --- Forwarded message --- From: Andreas Sägerville...@t-online.de To: users@global.libreoffice.org Subject: [libreoffice-users] Re: LibreOffice-Base CPU usage Date: Sat, 17 Sep 2011 11:35:28 +0200 Since you are not running MySQL through ODBC you can turn off all Java support for the entire office suite and simply work with the raw database connectivity and input forms. All the Java wizards are close to useless anyway. You don't need them and get much better results faster if you know what you're doing. Am 16.09.2011 20:44, Heinrich Stoellinger wrote: Hello again, On my Linux/LO 3.4.3 system, after some time of working with Base (ODBC connetcion to MySQL), LO uses 90 to 100 p.c. of one of the 4 CPUs of my PC. When I then save LO-Base, CPU-usage is normal again (for a while!). I don't really know what causes this behaviour, could it have to to with backup copy creation? I find an aweful lot of backup files in /home/rainermusik/.libreoffice/3/user/backup. All of them have a filename something like rmodbc.odb_9777.odb and are of 0
Re: Fwd: [libreoffice-users] Re: LibreOffice-Base CPU usage
Thank you Tom, Only one of them is on the same network. That is basically a backup computer. The other two are at a different location and are not networked with the first two. Don On 09/17/2011 06:58 PM, Tom Davies wrote: Hi :) If the different machines are on a Lan then it might be possible to share the back-end and then any change from any of the 3 machines would be on the other machines too? Regards from Tom :) --- On Sat, 17/9/11, Don Myersdonmy...@myersfarm.com wrote: From: Don Myersdonmy...@myersfarm.com Subject: Re: Fwd: [libreoffice-users] Re: LibreOffice-Base CPU usage To: users@global.libreoffice.org Date: Saturday, 17 September, 2011, 23:44 Hi Tom, There is an old saying - if it ain't broke, don't fix it. The thing I dislike most about Base is to have to open three windows to get to my form in the database. Some time ago I left a post on an Open Office forum asking if there was a way to set up a macro so I could do it in one click. There were never any replies. With Paradox or Access I was able to go to the form by just opening the program. But what I really like about Base is I just have 1 file to copy to keep my database updated on my three other computers. When I say if it ain't broken, don't fix it, I've never had one issue using Base. It has worked very well for me over a long period (7 or 8 years) of time. There are few programs I've ever used that have had that kind of dependability. Don On 09/17/2011 06:30 PM, Tom Davies wrote: Hi :) Thanks Don. I think you might be able to convert/export/migrate your back-end to a different one. I don't think you have to stick with HSql. I'm not sure if it's possible to remove java dependence when using HSql, i thought it was but i could be wrong. Regards from Tom :) --- On Sat, 17/9/11, Don Myersdonmy...@myersfarm.com wrote: From: Don Myersdonmy...@myersfarm.com Subject: Re: Fwd: [libreoffice-users] Re: LibreOffice-Base CPU usage To: users@global.libreoffice.org Date: Saturday, 17 September, 2011, 23:13 Hi All, I set up base shortly after it was added to Open Office. Apparently I am using the embedded database - HSQL database engine. If I turn off Java (I just tried it.), I get the following error message: The connection to the data source RE Database could not be established. No SDBC driver was found for the given URL. I cannot open my database without Java enabled. So using the database included with base will not work without Java. Don On 09/17/2011 08:29 AM, Tom Davies wrote: Hi :) I think you can completely un-install all instances of java but i think that might create problems. Your web-browser might not be very happy without java. Generally i try to keep escape routes and back-up plans available = so i would just switch off java in LO so that i could switch it on again quite easily if i needed it. Tools - Options - LibreOffice/General - Java then UNtick the box at the very top Use a java runtime environment. I have only unticked this a few days ago and LO seems to start-up a lot faster. Regards from Tom :) --- On Sat, 17/9/11, Heinrich Stoellingerhc.stoellin...@aon.atwrote: From: Heinrich Stoellingerhc.stoellin...@aon.at Subject: Fwd: [libreoffice-users] Re: LibreOffice-Base CPU usage To: users@global.libreoffice.orgusers@global.libreoffice.org Date: Saturday, 17 September, 2011, 11:55 Hello again, Is there a misunderstanding somewhere? As I said, I use the ODBC-connection to MySQL on Linux (and a very well working native MySQL-connection under Windows). Like I posted in another message, ODBC also has problems (such as not showing default values for columns correctly on data entry, but - since the database is actually updated correctly - this doesn't really worry me much. So, like Tom suggests: can I get completely rid of Java if I don't conciously use it in any way that an end-user or programmer could cause? That would be more than alright for me... Regards H. Stoellinger (from a lovely early autumn sunny day here in Salzburg) P.S.: I have used the Java-connector in the past but don't do so anymore. --- Forwarded message --- From: Andreas Sägerville...@t-online.de To: users@global.libreoffice.org Subject: [libreoffice-users] Re: LibreOffice-Base CPU usage Date: Sat, 17 Sep 2011 11:35:28 +0200 Since you are not running MySQL through ODBC you can turn off all Java support for the entire office suite and simply work with the raw database connectivity and input forms. All the Java wizards are close to useless anyway. You don't need them and get much better results faster if you know what you're doing. Am 16.09.2011 20:44, Heinrich Stoellinger wrote: Hello again, On my Linux/LO 3.4.3 system, after some time of working with Base (ODBC connetcion to MySQL), LO uses 90 to 100 p.c. of one of the 4 CPUs of my PC. When I then save LO-Base, CPU-usage is normal again (for a while!). I don't really know what causes this behaviour, could it have to to with backup copy creation? I find
Re: Fwd: [libreoffice-users] Re: LibreOffice-Base CPU usage
Hi, On Sat, 2011-09-17 at 23:30 +0100, Tom Davies wrote: Hi :) Thanks Don. I think you might be able to convert/export/migrate your back-end to a different one. I don't think you have to stick with HSql. I'm not sure if it's possible to remove java dependence when using HSql, i thought it was but i could be wrong. Regards from Tom :) --- On Sat, 17/9/11, Don Myers donmy...@myersfarm.com wrote: From: Don Myers donmy...@myersfarm.com Subject: Re: Fwd: [libreoffice-users] Re: LibreOffice-Base CPU usage To: users@global.libreoffice.org Date: Saturday, 17 September, 2011, 23:13 Hi All, I set up base shortly after it was added to Open Office. Apparently I am using the embedded database - HSQL database engine. If I turn off Java (I just tried it.), I get the following error message: The connection to the data source RE Database could not be established. No SDBC driver was found for the given URL. I cannot open my database without Java enabled. So using the database included with base will not work without Java. Don snip The HSQL engine is Java based. It may be possible to use Base as a front-end for something like MySQL or PostgreSQL, which do not use Java. On 09/17/2011 08:29 AM, Tom Davies wrote: Hi :) I think you can completely un-install all instances of java but i think that might create problems. Your web-browser might not be very happy without java. Generally i try to keep escape routes and back-up plans available = so i would just switch off java in LO so that i could switch it on again quite easily if i needed it. Tools - Options - LibreOffice/General - Java then UNtick the box at the very top Use a java runtime environment. I have only unticked this a few days ago and LO seems to start-up a lot faster. Regards from Tom :) --- On Sat, 17/9/11, Heinrich Stoellingerhc.stoellin...@aon.at wrote: From: Heinrich Stoellingerhc.stoellin...@aon.at Subject: Fwd: [libreoffice-users] Re: LibreOffice-Base CPU usage To: users@global.libreoffice.orgusers@global.libreoffice.org Date: Saturday, 17 September, 2011, 11:55 Hello again, Is there a misunderstanding somewhere? As I said, I use the ODBC-connection to MySQL on Linux (and a very well working native MySQL-connection under Windows). Like I posted in another message, ODBC also has problems (such as not showing default values for columns correctly on data entry, but - since the database is actually updated correctly - this doesn't really worry me much. So, like Tom suggests: can I get completely rid of Java if I don't conciously use it in any way that an end-user or programmer could cause? That would be more than alright for me... Regards H. Stoellinger (from a lovely early autumn sunny day here in Salzburg) P.S.: I have used the Java-connector in the past but don't do so anymore. --- Forwarded message --- From: Andreas Sägerville...@t-online.de To: users@global.libreoffice.org Subject: [libreoffice-users] Re: LibreOffice-Base CPU usage Date: Sat, 17 Sep 2011 11:35:28 +0200 Since you are not running MySQL through ODBC you can turn off all Java support for the entire office suite and simply work with the raw database connectivity and input forms. All the Java wizards are close to useless anyway. You don't need them and get much better results faster if you know what you're doing. Am 16.09.2011 20:44, Heinrich Stoellinger wrote: Hello again, On my Linux/LO 3.4.3 system, after some time of working with Base (ODBC connetcion to MySQL), LO uses 90 to 100 p.c. of one of the 4 CPUs of my PC. When I then save LO-Base, CPU-usage is normal again (for a while!). I don't really know what causes this behaviour, could it have to to with backup copy creation? I find an aweful lot of backup files in /home/rainermusik/.libreoffice/3/user/backup. All of them have a filename something like rmodbc.odb_9777.odb and are of 0 (zero) size. I wonder what's wrong. Regards H. Stoellinger --Erstellt mit Operas revolutionärem E-Mail-Modul: http://www.opera.com/mail/ --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 -- *~~* Don C. Myers e-PRO Certified by the National Association of Realtors Manager, Farm and Rural Property Division *Coldwell Banker University Realty *126 East Foster Avenue, State College, PA 16801 Phone: 814-237-6543 Fax: 814-237-6502 Visit the Farm and Rural Property Division Website at www.cbur-ruralproperty.com http://www.cbur-ruralproperty.com/_ _View