You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@openoffice.apache.org by bu...@apache.org on 2012/11/05 11:17:03 UTC
[Bug 121312] New: Slow database access with Java 7
https://issues.apache.org/ooo/show_bug.cgi?id=121312
Priority: P3
Bug ID: 121312
Assignee: ooo-issues@incubator.apache.org
Summary: Slow database access with Java 7
Severity: normal
Issue Type: DEFECT
Classification: Application
OS: Linux64
Reporter: villeroy@t-online.de
Hardware: PC
Status: UNCONFIRMED
Version: AOO 3.4.1
Component: code
Product: database access
Base becomes very slow when connected via JDBC and Java 7. There is no such
problem with Java 6.
OpenOffice.org 3.2 and 3.3 suffered from the same performance problem with any
Java version >6.23
This problem never occurred under Windows 7 nor XP.
Verified under Ubuntu Linux(32 and 64) with the following JDBC connections:
1. embedded HSQLDB 1.8
2. external HSQLDB 2.2.x
3. external H2 1.2.x
--
You are receiving this mail because:
You are the assignee for the bug.
[Issue 121312] Slow database access with Java 7
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=121312
--- Comment #16 from mroe <mr...@gmx.net> ---
Because AOO works with Java 6 and Java 8 but not with Java 7, it seems there
was a problem in Java 7, not in AOO. But if anyone know the reason, why AOO
slows down with Java 7 and find a solution in the AOO code, he should reopen
this issue. Otherwise I think that no developer will grab this issue. Isn't it?
--
You are receiving this mail because:
You are the assignee for the issue.
You are watching all issue changes.
[Issue 121312] Slow database access with Java 7
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=121312
--- Comment #12 from mroe <mr...@gmx.net> ---
There are several security updates in Java since 6.x.
Because a linux distribution integrates Java in its update mechanism, for most
users it is difficult to switch back to an earlier Java release without
removing the actual one.
--
You are receiving this mail because:
You are the assignee for the issue.
You are watching all issue changes.
[Bug 121312] Slow database access with Java 7
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=121312
--- Comment #2 from Andreas Säger <vi...@t-online.de> ---
Both, Oracle Java7 and openjdk-7.
--
You are receiving this mail because:
You are the assignee for the bug.
[Issue 121312] Slow database access with Java 7
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=121312
--- Comment #10 from mroe <mr...@gmx.net> ---
This issue should get a higher priority because HSQL is virtual unusable
because every data access needs 100 % CPU power over seconds/minutes. (Ubuntu
368)
--
You are receiving this mail because:
You are the assignee for the issue.
You are watching all issue changes.
[Issue 121312] Slow database access with Java 7
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=121312
--- Comment #11 from Andreas Säger <vi...@t-online.de> ---
> With AOO 4.0.1 the problem exists with jre 6u22 and 7u51.
No, it works well with 6u22. Call Tools>Options>Java and make sure that the old
JRE is checked. Click the option button, not just the list entry! Then restart
the office completely including any "quick starter" (which is the most obsolete
anti-feature, by the way).
--
You are receiving this mail because:
You are the assignee for the issue.
You are watching all issue changes.
[Issue 121312] Slow database access with Java 7
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=121312
--- Comment #13 from mroe <mr...@gmx.net> ---
Seems the problem is gone with Java 8.
--
You are receiving this mail because:
You are the assignee for the issue.
You are watching all issue changes.
[Issue 121312] Slow database access with Java 7
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=121312
--- Comment #17 from Kay <ks...@apache.org> ---
Re comment 16. I understand your reasoning. I will pass on the "dev" and see
what opinions are.
--
You are receiving this mail because:
You are the assignee for the issue.
You are watching all issue changes.
[Bug 121312] Slow database access with Java 7
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=121312
Andreas Säger <vi...@t-online.de> changed:
What |Removed |Added
----------------------------------------------------------------------------
Version|3.4.0 |4.0.1
--
You are receiving this mail because:
You are the assignee for the bug.
You are watching all bug changes.
[Bug 121312] Slow database access with Java 7
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=121312
andreas.grupe@newsales.de changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |andreas.grupe@newsales.de
--- Comment #5 from andreas.grupe@newsales.de ---
This issue keeps me on the very very old Java 1.6.022!
Please fix this issue - it's open since months and months. I'm working with
OpenSuse 12.3!
Thanks
--
You are receiving this mail because:
You are the assignee for the bug.
You are watching all bug changes.
[Issue 121312] Slow database access with Java 7
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=121312
Andreas Säger <vi...@t-online.de> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|CONFIRMED |RESOLVED
Resolution|--- |OBSOLETE
--- Comment #14 from Andreas Säger <vi...@t-online.de> ---
(In reply to mroe from comment #13)
> Seems the problem is gone with Java 8.
Indeed.
--
You are receiving this mail because:
You are the assignee for the issue.
You are watching all issue changes.
[Bug 121312] Slow database access with Java 7
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=121312
--- Comment #7 from Andreas Säger <vi...@t-online.de> ---
Same problem with AOO 4.0.1.
--
You are receiving this mail because:
You are the assignee for the bug.
You are watching all bug changes.
[Issue 121312] Slow database access with Java 7
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=121312
Kay <ks...@apache.org> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |kschenk@apache.org
Latest|4.1.0-dev |4.2.0-dev
Confirmation on| |
--- Comment #15 from Kay <ks...@apache.org> ---
Why was this changed to Resolved/Obsolete?
Java 8 is not part of our current system requirements.
I'm on 4.1.1 and openJDK "1.7.0_51", and yes, I definitely experience the issue
described here.
I'm assuming Java 8 is a work-around by this discussion, but is "Obsolete" the
right reason?
--
You are receiving this mail because:
You are the assignee for the issue.
You are watching all issue changes.
[Bug 121312] Slow database access with Java 7
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=121312
--- Comment #8 from Andreas Säger <vi...@t-online.de> ---
Same problem with AOO 4.1.0 beta.
--
You are receiving this mail because:
You are the assignee for the bug.
You are watching all bug changes.
[Bug 121312] Slow database access with Java 7
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=121312
Ariel Constenla-Haile <ar...@apache.org> changed:
What |Removed |Added
----------------------------------------------------------------------------
Latest|--- |4.1-dev
Confirmation on| |
Version|4.0.1 |OOo 3.3 or older
--
You are receiving this mail because:
You are the assignee for the bug.
You are watching all bug changes.
[Bug 121312] Slow database access with Java 7
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=121312
Oliver-Rainer Wittmann <or...@apache.org> changed:
What |Removed |Added
----------------------------------------------------------------------------
Version|3.4.1 |3.4.0
OS|Linux64 |Linux
--- Comment #6 from Oliver-Rainer Wittmann <or...@apache.org> ---
due to reporters description:
platform = 'Linux'
version = 'pre-3.4.0' (which is not available), thus '3.4.0'
--
You are receiving this mail because:
You are the assignee for the bug.
You are watching all bug changes.
[Bug 121312] Slow database access with Java 7
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=121312
jolatt <jo...@gmx.net> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |josef.latt@gmx.net
--- Comment #1 from jolatt <jo...@gmx.net> ---
I don't use those connections but IMHO it's not unimportant which java is
mentioned, Oracle or openjdk.
--
You are receiving this mail because:
You are the assignee for the bug.
[Issue 121312] Slow database access with Java 7
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=121312
leroy.tennison@verizon.net changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |leroy.tennison@verizon.net
--- Comment #9 from leroy.tennison@verizon.net ---
With AOO 4.0.1 the problem exists with jre 6u22 and 7u51.
--
You are receiving this mail because:
You are the assignee for the issue.
You are watching all issue changes.
[Bug 121312] Slow database access with Java 7
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=121312
jolatt <jo...@gmx.net> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC|josef.latt@gmx.net |
--
You are receiving this mail because:
You are the assignee for the bug.
You are watching all bug changes.
[Bug 121312] Slow database access with Java 7
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=121312
robbygro <ro...@familiegrosskopf.de> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |robert@familiegrosskopf.de
--- Comment #3 from robbygro <ro...@familiegrosskopf.de> ---
Have just tested AOO 4.0. There is a test-database here:
https://bugs.freedesktop.org/attachment.cgi?id=63257
When I will open the table under OpenSUSE 64bit rpm and 1.7.0_21 openjdk it
needs 10 seconds to show the rows on the screen. Now, when I will move to last
row, it lasts 2 Minutes and 40 seconds.
Same test on the same environment, only changed the jre to 1.6.0_22 SUN, the
table opens immediately, moving to last row about max. 2 seconds.
Don't know how I could change the Status, but it has to be changed to
"Confirmed".
--
You are receiving this mail because:
You are the assignee for the bug.
[Bug 121312] Slow database access with Java 7
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=121312
Ariel Constenla-Haile <ar...@apache.org> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|UNCONFIRMED |CONFIRMED
CC| |arielch@apache.org
Ever confirmed|0 |1
--- Comment #4 from Ariel Constenla-Haile <ar...@apache.org> ---
Setting CONFIRMED status
--
You are receiving this mail because:
You are the assignee for the bug.