You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@openoffice.apache.org by Kay Schenk <ka...@gmail.com> on 2012/09/01 01:41:18 UTC
Re: svn commit: r1377138 - /incubator/ooo/ooo-site/trunk/content/development/releases/3.4.1.html
On 08/31/2012 02:16 PM, Marcus (OOo) wrote:
> Am 08/31/2012 10:55 PM, schrieb Michal Hriň:
>> Dňa Fri, 31 Aug 2012 22:39:13 +0200 Marcus (OOo) <ma...@wtnet.de>
>> napísal:
>>
>>> Am 08/31/2012 11:58 AM, schrieb Andreas Säger:
>>>> Am 31.08.2012 00:01, Marcus (OOo) wrote:
>>>>> Am 08/30/2012 09:09 AM, schrieb Andrea Pescetti:
>>>>>> On 29/08/2012 Andreas Säger wrote:
>>>>>>> Then extract some old version of Java6 (<= revision 23), point the
>>>>>>> office to it and try again. It's many times faster.
>>>>>>
>>>>>> So, to recap: the best version of Java we could mention as a
>>>>>> workaround
>>>>>> (after saying that Java 7 is supported and more secure, of course) is
>>>>>> "jre-6u23-windows-i586.exe" as found on
>>>>>> http://www.oracle.com/technetwork/java/javasebusiness/downloads/java-archive-downloads-javase6-419409.html#jre-6u23-oth-JPR
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>> right?
>>>>>
>>>>> But then we should write a bit more text with another paragraph to
>>>>> point
>>>>> explicitely to this specific version when the user needs it. Then the
>>>>> users can choose themselves:
>>>>>
>>>>> a) The most recent JRE 6 if they look for security.
>>>>> b) JRE 6u23 if they need the AOO Base compatibility.
>>>>>
>>>>>> That one is older than the versions that both I (6.32) and Marcus
>>>>>> (6.x
>>>>>> current) had put on that page, but since people will go to that page
>>>>>> expecting to find a workaround I'd prefer to mention a version that
>>>>>> can
>>>>>> be a workaround for multiple issues (Java not found, Java operations
>>>>>> slow in Base and so on). Andreas in
>>>>>> http://markmail.org/message/w6x6e4dlzgwtfyd7 mentions that 6.22
>>>>>> works,
>>>>>> but if 6.23 is fine too I'd list the newer one.
>>>>>
>>>>> +1
>>>>>
>>>>> So, when this is our consensus I will update the webpage on the
>>>>> weekend.
>>>>>
>>>>> Marcus
>>>>>
>>>>
>>>> Hi,
>>>>
>>>> Please bear with me. I created some Oracle account to access their
>>>> binary attic and went throug a testing parcour on my 32 bit system
>>>> where
>>>> I found out that _something_ must have changed between OOo 3.3 and
>>>> AOO 3.4:
>>>>
>>>> JRE version Linux i586 (Ubuntu 10.4, AOO 3.4)
>>>> 6.0.22 good /which is what I used to use with OOo 3.3
>>>> 6.0.23 good /don't know about OOo 3.3
>>>> 6.0.24 good /used to be bad with OOo 3.3
>>>> 6.0.24(open-jdk) good /used to be bad with OOo 3.3
>>>> 6.0.35(latest) good /used to be bad with OOo 3.3
>>>> 7.0.4 bad
>>>>
>>>>
>>>> This is the result for my 64 bit Linux machine:
>>>> JRE version Linux x64 (Ubuntu 10.4, AOO 3.4.1)
>>>> 6.0.24(open-jdk) good
>>>> 6.0.35 good
>>>> 7.x bad
>>>>
>>>> So the issue has a clear red line between JRE6 and JRE7.
>>>
>>> Thanks a lot for you testing effort. With this information I will
>>> adjust the text like the follwing:
>>>
>>> [...]
>>> Apache OpenOffice 3.4.0 and 3.4.1 support Java 7, which is the
>>> recommended configuration; but (especially on 64-bit Windows) you
>>> might receive warnings about the Java version being defective. In that
>>> case, download and install [the most current JRE 6 version | link].
>>> Make sure you get the "Windows x86 Offline (32-bit)" file. Then
>>> configure OpenOffice to use it at "Tools - Options - OpenOffice.org -
>>> Java". See [this forum topic | link] for more information.
>>> [...]
>>>
>>> With this everybody should be happy, right?
>>>
>>> Marcus
>>
>> I'm only comment, for me AOO 3.4.1 on Windows 64bit doesn't work at all
>> with Orace Java 7 (32 or 64).
>>
>> The only option that works for me is to use to Orace/Sun Java 6 32bit on
>> Windows 64bit.
>> On Ubuntu 12.04 64bit I'm using 64bit openjdk6-jre 64 bit and everything
>> works (i didn't try jdk7).
>
> Thanks for your comment. Exactly this should be the message in the text
> I want to update.
>
> Marcus
>
Marcus, I think the changes you recommended are fine. As for me, I don't
know "tests" Andreas are running, but I'm on java 7, 1.7.0_04, and
really no issues with anything I've done.
We need more enlightenment on this, but your changes should suffice.
--
------------------------------------------------------------------------
MzK
"A human being should be able to change a diaper, plan an invasion,
butcher a hog, conn a ship, design a building, write a sonnet,
balance accounts, build a wall, set a bone, comfort the dying,
take orders, give orders, cooperate, act alone, solve equations,
analyze a new problem, pitch manure, program a computer, cook a
tasty meal, fight efficiently, die gallantly.
Specialization is for insects."
-- Robert Heinlein, "Time Enough For Love"
Re: svn commit: r1377138 - /incubator/ooo/ooo-site/trunk/content/development/releases/3.4.1.html
Posted by Andreas Säger <vi...@t-online.de>.
Am 01.09.2012 19:05, Ariel Constenla-Haile wrote:
> Hi Andres,
>
>>
>> OK, once more:
>
> Yes, please. It has been some misunderstanding. If I understood clearly,
> there are two bugs:
>
> 1) Java 7 not recognized
> 2) Java versions recognized but being suboptimal with Base + JDBC
>
>
> (1) happens only on Windows, mostly Windows 7 64 bits. I haven't seen
> any report of this happening on Linux 32/64 bits, and if I understood
> you clearly, neither could you reproduce it
>
I "tested" Java7 with AOO 3.4 on a Windows 2008 box (64 bit) and a one
Windows 7 (32) box.
My personal little testing included the following steps:
Open a Base doc connected to our HSQLDB server.
Open a Base doc accessing HSQLDB in cached mode.
Export some XHTML.
Start the wizards below File>Wizards>...
Start the Base wizards for tables, queris, forms and reports.
On that evening I did not have the time to test all the wizards in depth
(and strictly speaking, I am not entitled to install any office suite on
that server machine).
The 64 bit box required an additional 32 bit version of Java7 because
OOo Java components are part of the 32 bit application.
> (2) happens on Linux and Windows, both 32 and 64 bits. This is
> a performance issue with Base+JDBC. If a user does not need Base/JDBC at
> all, she/he can still use Java 7 for the Letter/Fax/Agenda wizards,
> extensions, etc. (I haven't seen performance reports in these areas).
>
>
I never noticed this performance problem under Windows.
Strictly speaking it is not only a JDBC issue. It affects any kind of
access to some Java database. The embedded database does not use JDBC,
same with non-embedded HSQL 2.x accessing some database in cached mode,
same with a H2 databaseof mine also used in cached mode. Linux+Java7+AOO
Base makes them crawl.
> Side comment, it should be noticed that there is no need to actually
> *install* Java 6, you can unzip a JRE anywhere and then point OpenOffice
> to use it, and things work just fine (assuming you didn't mess with
> environment variables, etc.). This works both on Linux and Windows; that
> said, I've no idea if Oracle is providing un-installable, zipped
> versions.
>
Right. Any extractable rpm, deb or tar ball may do the job. Just point
Tools>Options>Java to the extracted directory.
Oracle's current jre-6u35-linux-x64.bin can be treated as a zip archive.
>
> I have been told [1] that Stephan Bergmann solved this issue in LO,
> unfortunately he's been payed by RedHat to work there, so there are no
> many chances to see the patch contributed here (though he is committer
> for this project).
>
> [1] An Ubuntu user pointed me to
> http://markmail.org/thread/nr62ppiryxyrwd7q
> http://nabble.documentfoundation.org/Trying-to-diagnose-base-running-extremely-slowly-td3426499.html
>
>
> Regards
>
Re: svn commit: r1377138 -
/incubator/ooo/ooo-site/trunk/content/development/releases/3.4.1.html
Posted by Ariel Constenla-Haile <ar...@apache.org>.
Hi Andres,
On Sat, Sep 01, 2012 at 03:27:56PM +0200, Andreas Säger wrote:
> Am 01.09.2012 01:41, Kay Schenk wrote:
> >
> >Marcus, I think the changes you recommended are fine. As for me, I don't
> >know "tests" Andreas are running, but I'm on java 7, 1.7.0_04, and
> >really no issues with anything I've done.
> >
> >We need more enlightenment on this, but your changes should suffice.
> >
>
> OK, once more:
Yes, please. It has been some misunderstanding. If I understood clearly,
there are two bugs:
1) Java 7 not recognized
2) Java versions recognized but being suboptimal with Base + JDBC
(1) happens only on Windows, mostly Windows 7 64 bits. I haven't seen
any report of this happening on Linux 32/64 bits, and if I understood
you clearly, neither could you reproduce it
(2) happens on Linux and Windows, both 32 and 64 bits. This is
a performance issue with Base+JDBC. If a user does not need Base/JDBC at
all, she/he can still use Java 7 for the Letter/Fax/Agenda wizards,
extensions, etc. (I haven't seen performance reports in these areas).
Side comment, it should be noticed that there is no need to actually
*install* Java 6, you can unzip a JRE anywhere and then point OpenOffice
to use it, and things work just fine (assuming you didn't mess with
environment variables, etc.). This works both on Linux and Windows; that
said, I've no idea if Oracle is providing un-installable, zipped
versions.
> Get some Linux box with Java7.
> Open any Base file connected to a JDBC database with some thousands
> of records. An embedded HSQLDB will be fine.
> Just in case you need one:
> >http://user.services.openoffice.org/en/forum/download/file.php?id=14591
>
>
> Open any table, query form and scroll, sort, filter the record sets.
>
> Do the same with Java6 which is by a magnitude faster.
>
> Old issues describing the problem for another set of Java versions:
> >https://issues.apache.org/ooo/show_bug.cgi?id=117089
> >https://issues.apache.org/ooo/show_bug.cgi?id=116243
> >https://issues.apache.org/ooo/show_bug.cgi?id=117203
>
> My "tests" revealed that this performance issue with Linux+JDBC+Base
> is still relevant with Java7. It never was an issue with any other
> OS nor database connection type.
I have been told [1] that Stephan Bergmann solved this issue in LO,
unfortunately he's been payed by RedHat to work there, so there are no
many chances to see the patch contributed here (though he is committer
for this project).
[1] An Ubuntu user pointed me to
http://markmail.org/thread/nr62ppiryxyrwd7q
http://nabble.documentfoundation.org/Trying-to-diagnose-base-running-extremely-slowly-td3426499.html
Regards
--
Ariel Constenla-Haile
La Plata, Argentina
Re: svn commit: r1377138 - /incubator/ooo/ooo-site/trunk/content/development/releases/3.4.1.html
Posted by Kay Schenk <ka...@gmail.com>.
On Sat, Sep 1, 2012 at 6:27 AM, Andreas Säger <vi...@t-online.de> wrote:
> Am 01.09.2012 01:41, Kay Schenk wrote:
>
>>
>> Marcus, I think the changes you recommended are fine. As for me, I don't
>> know "tests" Andreas are running, but I'm on java 7, 1.7.0_04, and
>> really no issues with anything I've done.
>>
>> We need more enlightenment on this, but your changes should suffice.
>>
>>
> OK, once more:
> Get some Linux box with Java7.
> Open any Base file connected to a JDBC database with some thousands of
> records. An embedded HSQLDB will be fine.
> Just in case you need one:
>
>> http://user.services.**openoffice.org/en/forum/**
>> download/file.php?id=14591<http://user.services.openoffice.org/en/forum/download/file.php?id=14591>
>>
>
>
> Open any table, query form and scroll, sort, filter the record sets.
>
> Do the same with Java6 which is by a magnitude faster.
>
> Old issues describing the problem for another set of Java versions:
>
>> https://issues.apache.org/ooo/**show_bug.cgi?id=117089<https://issues.apache.org/ooo/show_bug.cgi?id=117089>
>> https://issues.apache.org/ooo/**show_bug.cgi?id=116243<https://issues.apache.org/ooo/show_bug.cgi?id=116243>
>> https://issues.apache.org/ooo/**show_bug.cgi?id=117203<https://issues.apache.org/ooo/show_bug.cgi?id=117203>
>>
>
> My "tests" revealed that this performance issue with Linux+JDBC+Base is
> still relevant with Java7. It never was an issue with any other OS nor
> database connection type.
>
>
>
Right, Andreas. You have said this in the past. I will also test with your
DB. I do know Oracle recently released another patch for Java 7. I do NOT
know if this has any impact on the situation here. And, because "jdbc"
tuning can be a bit touchy at times, it's still difficult, without knowing
specific individual setups, what is going on. I hope you provided many
details in whatever issue you filed on this. I would love to test with a
mySQL DB. I may resort to this at some point.
--
----------------------------------------------------------------------------------------
MzK
"A human being should be able to change a diaper, plan an invasion,
butcher a hog, conn a ship, design a building, write a sonnet,
balance accounts, build a wall, set a bone, comfort the dying,
take orders, give orders, cooperate, act alone, solve equations,
analyze a new problem, pitch manure, program a computer, cook a
tasty meal, fight efficiently, die gallantly.
Specialization is for insects."
-- Robert Heinlein, "Time Enough For Love"
Re: svn commit: r1377138 - /incubator/ooo/ooo-site/trunk/content/development/releases/3.4.1.html
Posted by Andreas Säger <vi...@t-online.de>.
Am 01.09.2012 01:41, Kay Schenk wrote:
>
> Marcus, I think the changes you recommended are fine. As for me, I don't
> know "tests" Andreas are running, but I'm on java 7, 1.7.0_04, and
> really no issues with anything I've done.
>
> We need more enlightenment on this, but your changes should suffice.
>
OK, once more:
Get some Linux box with Java7.
Open any Base file connected to a JDBC database with some thousands of
records. An embedded HSQLDB will be fine.
Just in case you need one:
> http://user.services.openoffice.org/en/forum/download/file.php?id=14591
Open any table, query form and scroll, sort, filter the record sets.
Do the same with Java6 which is by a magnitude faster.
Old issues describing the problem for another set of Java versions:
> https://issues.apache.org/ooo/show_bug.cgi?id=117089
> https://issues.apache.org/ooo/show_bug.cgi?id=116243
> https://issues.apache.org/ooo/show_bug.cgi?id=117203
My "tests" revealed that this performance issue with Linux+JDBC+Base is
still relevant with Java7. It never was an issue with any other OS nor
database connection type.