Hi Tom,
Thank you for your great ideas and suggestions.
Starting with Java 1.6.0_24, this problem arose with both OpenOffice
Base and LibreOffice Base. The problems were documented on an OpenOffice
forum that I searched when the problem first arose. Another alternative
would be for LibreOffice to have its own embedded version of Java that
works instead of using the system Java. One person a month or so ago
posted here as to the exact reason the issue has happened. He felt the
problem would be corrected when Java was again updated. I was greatly
disappointed when 1.6.0_26 came out and the issue was still here. My
data base has about 2500 entries with complete contact information, and
then a separate text area I use to keep a running record of my contacts
with each person. Before Java 1.6.0_24 going from the first record to
last last record was almost instantaneous. Now if is painful. I wait
patiently for the 20 to 25 seconds for it to happen on my fastest
computer, a quad core AMD 910 with 8 gigs of ram. It is slower on my
other ones. Then paging backwards through the database, I can click 5
records and each one appears instantly, then before the 6th record there
is a pause. This happens consistently. 5 records, pause, 5 records,
pause. I need a database. I need one that works proficiently in Linux. I
was so glad when Base was added to OpenOffice. I used it for years
without issue until about 6 months ago.
Don
On 07/28/2011 12:22 PM, Tom Cloyd wrote:
Don,
Seems like a reasonable request to me, and I'll up the ante.
Where the &^%$ is the management - The Document Foundation - in all
this, right now, today? Do they even watch this list? In short, do
they give a damn that the only theoretically viable alternative to
Access (for ordinary users) is in real trouble? Why aren't they
showing up here with some clarifying position statement?
I'm desperate for time, a fix, and vision of a long-term solution to
this mess. I have work to do today, a lot of it, and I can't do it. I
can't solve the problem, and other than by implementing the
regress-your-java solution idea (which I have yet to be successful
with). No one else is solving it, either. For some, migrating to
another backend is not a challenge. For the rest of us, it's unknown
territory. I researched this a bit, and while there certainly IS stuff
out there about how to do it, there's not a lot, and there are
multiple levels of challenge with this solution anyway.
Personally, I'm definitely up for taking this on (what option do I
really have?), but do we really have to straggle through the mountains
one by one, eventually meeting on the other side, those who make it,
to talk about the experience?
So, I propose two things:
1. Anyone who has TDF connections - please get on the phone and update
them. The question is this, I think: how important, going forward, is
Base, to them? If they are going to support it, today would be a very
good day to do it. If not, yank the code, stop telling people they
have a db component in LO, and start getting honest.
2. If LO's in trouble with the current sun-Java, so's OO. Where's
Apache in this situation? Again, where's *TDF*? Why aren't they and
Apache working together on this? Looks rather like a leadership
problem, to me.
2. On the assumption that those of use who need a working db are going
to have to find the way home ourselves (as I said, I need to get work
done TODAY, and I'm not kidding) -
a. Can someone more Linux-clever than I lay out clearly the steps
involve in implementing the solution found at the end of this thread -
http://www.oooforum.org/forum/viewtopic.phtml?t=125253&postdays=0&postorder=asc&start=0
<http://www.oooforum.org/forum/viewtopic.phtml?t=125253&postdays=0&postorder=asc&start=0>.
As I pointed on in another post last night, I tried it and simply got
in over my head. This is a decent short-term solution.
b. Can we work together to lay out the steps to set up an alternative
back end? I'm going to start on sqlite, Others may wish to work on a
different db engine. Then let's get the procedure out where it can be
seen and used by others.
c. Let's get altruistic about the poor bloke who, this morning, is
about to set up a Base db using a java-run backend: Could someone put
a notice in the documentation updating people about the current
situation? It's not right for us to keep this information only on this
list.
Now I'm off to fully regress my java (I don't see a problem with
this), while I work on getting sqlite and Base to play together.
Tom
On 07/28/2011 09:16 AM, Don C. Myers wrote:
Hi Tom,
When the first problems showed up for me about 6 months ago, it was
recommended to go back to the Java 1.6.0.22 from 1.6.0.24. I have my
database on 4 computers, and could never make things work with
getting a previous version installed, so I gave up and just tolerated
the situation. Also, I had security concerns going backwards since,
as I understand it, among other things updated Java versions have
have security issues fixed. I'm relatively good with Ubuntu, but far
from an expert. What we all know is that Java is the problem. Can
someone give us instructions on how to use the LibreOffice front end
with a database that doesn't require Java. I see that you had said
that LibreOffice may be moving to sqlite? Is that a solution that
anyone could help us with?
Don
On 07/28/2011 04:04 AM, Tom Cloyd wrote:
, On 07/28/2011 12:53 AM, Tom Cloyd wrote:
On 07/28/2011 12:44 AM, Alexander Thurgood wrote:
Le 27/07/11 18:14, Tom Cloyd a écrit :
That command appears to have cut 5 seconds off the record pointer
move
test, and also off the full db search test I ran previously.
Well better than nothing I suppose, but I do sympathise. Did the
JDK/JRE
change suggested by someone else help any further ?
Alex
Am just about to make the switch - will let you know asap! I'm very
hopeful. And I've decided to switch to sqlite when I'm not so
rushed. Have heard that that's where LO's going anyway.
Tom
Ug. This is getting ugly really fast. I'm really not on home ground
here at all.
After 15 minutes of trying to make sense of what I found at
http://archive.canonical.com/ubuntu/pool/partner/s/sun-java6/, I
downloaded
sun-java6-bin_6.22-0ubuntu1~10.04_i386.deb and
sun-java6-jre_6.22-0ubuntu1~10.04_all.deb, following the thread at
http://www.oooforum.org/forum/viewtopic.phtml?t=125253&postdays=0&postorder=asc&start=0
<http://www.oooforum.org/forum/viewtopic.phtml?t=125253&postdays=0&postorder=asc&start=0>.
Then I did this at a console, with the following result:
tomc@LDT:~/software_archive$ sudo dpkg --unpack
sun-java6-bin_6.22-0ubuntu1~10.04_i386.deb
[sudo] password for tomc:
dpkg: warning: parsing file '/var/lib/dpkg/status' near line 38010
package 'amaya':
error in Version string 'wx-11.3.1-1': version number does not start
with digit
dpkg: warning: parsing file '/var/lib/dpkg/available' near line
40706 package 'amaya':
error in Version string 'wx-11.3.1-1': version number does not start
with digit
dpkg: warning: downgrading sun-java6-bin from 6.26-1natty1 to
6.22-0ubuntu1~10.04.
(Reading database ... 190655 files and directories currently
installed.)
Preparing to replace sun-java6-bin 6.26-1natty1 (using
sun-java6-bin_6.22-0ubuntu1~10.04_i386.deb) ...
debconf: unable to initialize frontend: Dialog
debconf: (Dialog frontend requires a screen at least 13 lines tall
and 31 columns wide.)
debconf: falling back to frontend: Readline
sun-dlj-v1-1 license has already been accepted
Unpacking replacement sun-java6-bin ...
Processing triggers for desktop-file-utils ...
Processing triggers for menu ...
dpkg-query: warning: parsing file '/var/lib/dpkg/status' near line
38010 package 'amaya':
error in Version string 'wx-11.3.1-1': version number does not start
with digit
Most of this is just garble to me,
THIS is scary: "dpkg: warning: downgrading sun-java6-bin from
6.26-1natty1 to 6.22-0ubuntu1~10.04."
I said UNPACK, not INSTALL. What's this "downgrading" nonsense? Then
this: "Preparing to replace sun-java6-bin 6.26-1natty1" Huh? All
this on an "unpack". This is beyond scary. This is nuts. What's up
with this???
Then, and this is the main problem - where's the result of the
command? I expected the unpack to put files in a dir, in the same
dir as the DEB file. Isn't this usually what happens when one
unpacks a file? But there's nothing there.
I'm in freefall right now. Don't know what just happened, don't know
what to do next. Can anyone help?
Guess I'm not going to get any db work done tonight, after all. Not
a good day.
Tom
--
***
*
--
Unsubscribe instructions: E-mail to [email protected]
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
