+++ This bug was initially created as a clone of Bug #94716 +++ Bug 94716 has been fixed. However, the fix for that bug caused LibreOffice to no longer be able to detect either a JRE (Apples JVM6 in combination with an Oracle JRE) or JDK on OSX versions 10.9 or lower. LibreOffice is currently built for production release against a minimum OSX version of 10.8, which means that we should support all of the available functionality in such a release including access to Java instantiation. At present, OSX users who require Java functionality, including any that created embedded databases which worked previously, no longer have access to that functionality in current builds.
Question for inital poster: While this bug is being triaged and investigated, is it known what the last know working version of Libreoffice that does see the JRE? I confirm this on OS X Ver. 10.11.6 (El Capitan)
LibreOffice builds through 5.0.6.3 will run with JRE 1.8 < 99 and an Apple Java for OS X (2015-001) JRE 1.6 post bug 94716 NeoOffice provided patch to work with JDK 1.8 will not run on OS X 10.8 or 10.9 builds. and solution for bug 101057 to use JRE/JDK > 99 was not back ported to the LibreOffice 5.0 builds. Eventually, Oracle and Apple will resolve the OS X JavaVM issues of bug 74877 and at that point the bug 94716 patch can be removed allowing resumed use of JRE. =-ref-= https://support.apple.com/kb/DL1572?locale=en_US
Something might be done as in bug 85695 to alert on installation (and in Wiki of course) as to how to resolve needed Java support on OS X builds.
(In reply to V Stuart Foote from comment #2) > LibreOffice builds through 5.0.6.3 will run with JRE 1.8 < 99 and an Apple > Java for OS X (2015-001) JRE 1.6 > > post bug 94716 NeoOffice provided patch to work with JDK 1.8 will not run on > OS X 10.8 or 10.9 builds. > > and solution for bug 101057 to use JRE/JDK > 99 was not back ported to the > LibreOffice 5.0 builds. > > Eventually, Oracle and Apple will resolve the OS X JavaVM issues of bug > 74877 and at that point the bug 94716 patch can be removed allowing resumed > use of JRE. > > =-ref-= > https://support.apple.com/kb/DL1572?locale=en_US Thanks for the update. I understand this isn't entirely a LO problem. I will await a fix from the Apple side. I won't attempt to test if Sierra fixes this (might open more issues rather than fixing "Java Not Found"). Than you for your time.
(In reply to John Toliver from comment #4) @John : installing a complete JDK works around the problem for current versions of LibreOffice on OSX 10.10, 10.11 and 10.12. I don't think you can count on Apple fixing the problem, the ball rather appears to lie in Oracle's court.
(In reply to Alex Thurgood from comment #5) > (In reply to John Toliver from comment #4) > > @John : installing a complete JDK works around the problem for current > versions of LibreOffice on OSX 10.10, 10.11 and 10.12. > > I don't think you can count on Apple fixing the problem, the ball rather > appears to lie in Oracle's court. Thanks so much for your assistance. I found a suitable full JDK and installed it and immediately, an instance of Java was located. Apple's behavior sometimes makes me scratch my head.
*** Bug 103232 has been marked as a duplicate of this bug. ***
(In reply to Alex Thurgood from comment #0) > Bug 94716 has been fixed. However, the fix for that bug caused LibreOffice > to no longer be able to detect either a JRE (Apples JVM6 in combination with > an Oracle JRE) or JDK on OSX versions 10.9 or lower. I'm a bit confused by the history of this bug and bug 94716 it got cloned from. Can anybody actually confirm that on OS X 10.8 or 10,9 an installation of an Oracle JDK is not found by LO?
(In reply to Stephan Bergmann from comment #8) > I'm a bit confused by the history of this bug and bug 94716 it got cloned > from. > > Can anybody actually confirm that on OS X 10.8 or 10,9 an installation of an > Oracle JDK is not found by LO? It is old NOTOURBUG bug 74877 -- and Oracle's Java runtime collision with Apples as patched for bug 94716 Oracle's issues: http://bugs.java.com/bugdatabase/view_bug.do?bug_id=7131356 http://bugs.java.com/bugdatabase/view_bug.do?bug_id=8024281 So, through 5.0, if Apples Java 1.6 is present, a JRE 1.8 will be detected and used. But as patched at 5.1.0 with http://cgit.freedesktop.org/libreoffice/core/commit/?id=32bc8ddbf335dd26019edcf12758643b4cff9913 https://bugs.documentfoundation.org/show_bug.cgi?id=94716#c9 No support for Apple JRE or Oracle JRE -- just the JDK.
(In reply to V Stuart Foote from comment #9) > (In reply to Stephan Bergmann from comment #8) > > I'm a bit confused by the history of this bug and bug 94716 it got cloned > > from. > > > > Can anybody actually confirm that on OS X 10.8 or 10,9 an installation of an > > Oracle JDK is not found by LO? > > It is old NOTOURBUG bug 74877 -- and Oracle's Java runtime collision with > Apples as patched for bug 94716 > > Oracle's issues: > > http://bugs.java.com/bugdatabase/view_bug.do?bug_id=7131356 > http://bugs.java.com/bugdatabase/view_bug.do?bug_id=8024281 > > So, through 5.0, if Apples Java 1.6 is present, a JRE 1.8 will be detected > and used. > > But as patched at 5.1.0 with > http://cgit.freedesktop.org/libreoffice/core/commit/ > ?id=32bc8ddbf335dd26019edcf12758643b4cff9913 > > https://bugs.documentfoundation.org/show_bug.cgi?id=94716#c9 > No support for Apple JRE or Oracle JRE -- just the JDK. I'm not sure whether that answers my question. I do understand that, since some version of LO (5.1, as you say), LO only supports (Oracle) JDKs, no longer any plain (Apple, Oracle) JREs. However, what I'm unsure about is whether that change also really caused LO to not even support (Oracle) JDKs on old versions of OS X (10,8, 10.9), or whether that's an unproven claim. Hence, my question whether anybody can actually confirm that. (I myself don't have such an old OS X available.) Can you confirm it?
(In reply to Stephan Bergmann from comment #10) Hi Stephan, > I'm not sure whether that answers my question. I do understand that, since > some version of LO (5.1, as you say), LO only supports (Oracle) JDKs, no > longer any plain (Apple, Oracle) JREs. However, what I'm unsure about is > whether that change also really caused LO to not even support (Oracle) JDKs > on old versions of OS X (10,8, 10.9), or whether that's an unproven claim. > Hence, my question whether anybody can actually confirm that. (I myself > don't have such an old OS X available.) Can you confirm it? In bug 94716, comments 14 and 20 confirmed this. However, I have just tested removing the existing (and now outdated) JDK version I had on my MBPro OSX 10.9.5 machine, and installed the latest JDK8_u111. This was automatically detected by LO 5152. From comment 26, a second confirmation that the JDK is detected on OSX 10.9.5, so maybe we should close this now as WFM (I have no idea which, if any, commit fixed this).
(In reply to Alex Thurgood from comment #11) > (In reply to Stephan Bergmann from comment #10) > > > > From comment 26, a second confirmation that the JDK is detected on OSX > 10.9.5, so maybe we should close this now as WFM (I have no idea which, if > any, commit fixed this). Or change the title to reflect the above.
(In reply to Alex Thurgood from comment #11) > (In reply to Stephan Bergmann from comment #10) > In bug 94716, comments 14 and 20 confirmed this. bug 94716 comment 14 indeed looks like confirmation :) bug 94716 comment 20 mentions "Oracle JDK 8.101", so probably ran into the problem that LO didn't support JDKs with update version number > 99, fixed with <https://cgit.freedesktop.org/libreoffice/core/commit/?id=64d3270a89fd88d4d0cf70329af2c66f722fd95e> "Related: tdf#101057 allow java update version number > 99" > However, I have just tested removing the existing (and now outdated) JDK > version I had on my MBPro OSX 10.9.5 machine, and installed the latest > JDK8_u111. This was automatically detected by LO 5152. > > From comment 26, a second confirmation that the JDK is detected on OSX > 10.9.5, so maybe we should close this now as WFM (I have no idea which, if > any, commit fixed this). Yes, I think closing as WFM would be best then.
(In reply to Alex Thurgood from comment #12) > Or change the title to reflect the above. Why change the title yet again? V Stuart Foote today changed it from "FILEOPEN: No JRE or JDK found in OSX 10.9 and lower" to "FILEOPEN: No JRE or JDK found in OSX 10.9 and lower, 10.10 and up need full JDK" for no apparent reason. Lets keep this bug focused on the claim that LO no longer detected JDKs on old OS X after <https://cgit.freedesktop.org/libreoffice/core/commit/?id=32bc8ddbf335dd26019edcf12758643b4cff9913> "tdf#94716 allow Oracle's JDK to be used on OS X 10.10 and 10.11". (If there's demand for a bug to track that LO now no longer detects JREs on any OS X, then either keep that to the original bug 94716 or create a new one.)
Changed the title because with bug 94716 closed, folks on 10.10-10.12 with issues of needing the JDK were being duped here. Though, I'm still not convinced that issue of needing the Apple 1.6 JRE in addition to an Oracle JRE/JDK is resolved for 10.8 or 10.9 users. Suspect folks reporting success actually have the Apple 1.6 JRE installed--finding pristine hardware for a testing a baremetal install of 10.9 and then LibreOffice with an Oracle JRE/JDK is needed.
*** Bug 103605 has been marked as a duplicate of this bug. ***
*** Bug 106314 has been marked as a duplicate of this bug. ***
*** Bug 112090 has been marked as a duplicate of this bug. ***
*** Bug 112551 has been marked as a duplicate of this bug. ***
Created attachment 141582 [details] Options screenshot
I don't know if this should be registered as a new bug, but given the number of duplicates here, I'll report my experience and if it needs its own space, so be it. I'm using Version: LibO 6.0.3.2 [Collabora release] Build ID: 8f48d515416608e3a835360314dac7e47fd0b821 CPU threads: 4; OS: Mac OS X 10.10.5; I have installed the JDK: $ java -version java version "1.8.0_172" Java(TM) SE Runtime Environment (build 1.8.0_172-b11) Java HotSpot(TM) 64-Bit Server VM (build 25.172-b11, mixed mode) export JAVA_HOME="/Library/Java/JavaVirtualMachines/jdk1.8.0_172.jdk/Contents/Home" The problem is that my LibO Options have the `LibreOffice > Advanced` "Use a Java runtime environment" greyed out -- it is impossible to use that tool. [See screenshot "_000-libo-adv.png" attached at Comment #20.] And it seems I have no "embedded" database of any kind: I cannot create a db from within the app. [See screenshot "_000-libo-embed-none.png" attached.] I have spent several hours (more than 4, less than 10) trying to solve this, and have failed miserably. I have read through this thread more than once, and have no more options. I use Base happily on Ubuntu, and would seriously like to be able to access Base on OSX as well. I will happily respond to prompts to diagnose, etc., but I've reached the limits of my ability at this point.
David, when you say "Collabora release", what do you you mean exactly? Do you mean "LibreOffice Vanilla" or "Collabora Office" from the Mac App Store? Those products are built without Java support, because apps distributed in the Mac App Store are not allowed to depend on optional functionality like Java. So if that is the case, then your comment is irrelevant here, the lack of Java is intentional, and your comment is not relevant to what is otherwise discussed in this bug.
I mean "LibreOffice Vanilla" -- thanks for reply! That clarifies a lot. And means I need to pursue a different line ... like how to persuade Base in LibO Vanilla to work, or whether I need to install "regular" LibO on that MacBook. Thanks again, and apologies for the noise. (In reply to Tor Lillqvist from comment #22) > David, when you say "Collabora release", what do you you mean exactly? Do > you mean "LibreOffice Vanilla" or "Collabora Office" from the Mac App Store? > Those products are built without Java support, because apps distributed in > the Mac App Store are not allowed to depend on optional functionality like > Java. So if that is the case, then your comment is irrelevant here, the lack > of Java is intentional, and your comment is not relevant to what is > otherwise discussed in this bug.
Hi David - the long term plan for de-java-isation of Base pivots around the new Firebird backend and migration of legacy HSQLDB databases there; if base doesn't work on Mac with firebird now in 6.0 it might be worth filing another bug on that.
Note that we don't currently include the Firebird database back-end in LibreOffice Vanilla, though. This is because of a problem in the Firebird source code that makes it crash when compiled with optimisation with a current Clang (from Xcode). There is a workaround for that in master, I will look into back-porting that to the libreoffice-6-0 branch.
Thanks, @Michael, @Tor -- am I right in thinking that Base is effectively non-functional in LibO Vanilla, then? Or at least not functional "out of the box"? I'll methodically attempt to create/use a db with Base on OSX in next few days (for me it's Ubuntu by day, and OSX by night in GMT), and if I fail will raise new issue. If you have any advice/pointers meanwhile, it would be gratefully received! I would be happy to be directly emailed (should anyone here wish to) about diagnosing, etc., if that helps keep noise down here. (Sorry for extending discussion here when irrelevant to the bug, but I don't know how else to carry this forward!)
David, that is correct yes, as far as I see. (I am not really a Base expert, or even user.) Connecting to an external database using one of the included back-ends should work, though, I assume. (But no idea if it works with the SQLite thing that comes with macOS.)
(In reply to Tor Lillqvist from comment #28) > back-ends should work, though, I assume. (But no idea if it works with the > SQLite thing that comes with macOS.) Yes and No : there is currently no direct access to SQLite3 dbs, so you would need a connector, which as it turns out is a JDBC connector (e.g. Xerial) and thus still a requirement for Java to be installed on the system...(dog wags tail...tail wags dog).
if you ever need a good syllable counter, then just check this tool https://howmanysyllables.github.io/
In current production release versions (6152 and 6203), the annoying problem of Java detection (or lack thereof) has come back, albeit in a slightly different form, with OpenJDK11. Currently using : macOS 10.14.3 I have downloaded and copied the untarred package (jdk-11.jdk) to /Library/Java/JavaVirtualMachines/ I then started LO6152, and under Preferences - Advanced, I added the path to the JDK, which was found by LO's detection routine and added to the list. I activated the radio button and then shut down LO. So far so good. If I now start LO6203, and load up a JDBC configured database file, e.g. a connection to mysql via a JDBC driver, I get an error message after having authenticated my user against the database : "The configuration of LibreOffice has been changed. Under LibreOffice - Preferences - LibreOffice - Advanced, select the Java execution environment that you want LibreOffice to use" (translated from the French). then the following message : "No Java installation could be found" I then have to go through the rigmarole of redefining my JDK11 as the selected environment, in order to continue working with my ODB file. If I close LO6203 and switch back to LO6152, I get asked the same question again, when I load up a database requiring any kind of Java instantiation (hsqldb, or any wizard function that relies on Java).
Note that this is not mysql dependent, that was just used as an example. I get the same issue when trying to load tables from an embedded hsqldb, or when starting the database wizards that rely on Java to function.
Play PUBG Online online and discover the true meaning of battleground! Download PUBG Online on PC and Mac for free. Same PUBG gameplay on a larger screen. http://pubgfree.io/
Changing priority to 'high' since the number of duplicates is higher than 5 or the number of people in CC higher than 20
There are way too many bugs on this page too, but you can just not find it. https://www.office-help-setup.com
Any update here? Are we stuck? Should it be discussed on ESC? Indeed, with notarization related bugs, it's the only bug which is high/critical for MacOS.
Miklos - one to look into I guess =)
This is one confusing bug. Can someone with deeper understanding update the title? Title sounds like the issue is limited to 10.9. Is that the case? Comment 43 mentions this being a problem on macOS 10.14. It would be nice to have a good title which summarizes the problem. 10.9 should be obsolete as 10.10 is the minimum for installation of LO as of today.
The following are the system requirements for installing the JDK and the JRE on macOS: Any Intel-based computer running macOS. Administrator privileges. You cannot install Java for a single user. Installing the JDK and JRE on macOS is performed on a systemwide basis for all users. Administrator privileges are required to install the JDK and JRE on macOS. When you install the JDK, it also installs the JRE. However, the system will not replace the current JRE with a lower version. To determine the current JRE version installed on your system, see Determining the JRE Version Installed on macOS. To install an earlier version of the JRE, you must first uninstall the current version. See Uninstalling the JRE on macOS. When you install the JRE, you can install only one JRE on your system at a time. The system will not install a JRE that has an earlier version than the current version. To determine the current JRE version installed on your system, see Determining the JRE Version Installed on macOS. To install an earlier version of the JRE, you must first uninstall the current version. See Uninstalling the JRE on macOS. <a href="https://www.pestcontrolwellingtonprosnz.info/">pest control services wellington</a>
Yes, it seems like the original issue was either fixed by Oracle or is moot now that 10.10 is required. Comment #11 says it was actually WFM at that point The issue in comment #31 seems to be a new issue with OpenJDK? I can select Oracle Java in 6.4.2 just fine (aside, what's the point in supporting OSes that don't receive security fixes by Apple? 10.13 is the latest supported version by Apple)
was this fixed? Java runtime sometimes buggy in mac.
I confirm this on OS X Ver. 10.11.6. Joana
In have downloaded and installed LibreOffice 7.1.5.2(x64) on my HP DESKTOP-DB8OFES computer. When I created a first database in Base, I received the message that I must 'install a JRE and restart LibreOffice'. I downloaded jre-8u301-windows-i586-iftw.exe and installed it several times, restarting, shutting down completely and then starting up my computer again. I also removing my firewall before downloading. Despite all these efforts I still get the same message. What must I do now to get LibreOffice installed?
(In reply to Jos from comment #43) > In have downloaded and installed LibreOffice 7.1.5.2(x64) on my HP > DESKTOP-DB8OFES computer. When I created a first database in Base, I > received the message that I must 'install a JRE and restart LibreOffice'. I > downloaded jre-8u301-windows-i586-iftw.exe and installed it several times, > restarting, shutting down completely and then starting up my computer again. > I also removing my firewall before downloading. Despite all these efforts I > still get the same message. > > What must I do now to get LibreOffice installed? Please do not hijack existing issues, and do not change their various fields. (I changed them back now.) Please see <https://wiki.documentfoundation.org/Documentation/HowTo/Install_the_correct_JRE_-_LibreOffice_on_Windows_10> and, in case that will still be necessary, better follow the links for help there than going straight to the bug tracker.
Awesome! Such a great help.
I'm going to close this bug report (seeing as I opened it). Currently, only 10.14, 10.15 and 11 are considered "supported" by Apple and receiving service and security updates. There are other, similar issues affecting the recognition of the currently available JDKs depending on source and version with current macOS releases. Those issues should probably be reported in a different bug report (if not already done).
I am trying to create a database with Base on a MacOS BigSur Version 11.5.2. But I get the following message: LibreOffice requires Oracle's Java Development Kit (JDK) on macOS 10.10 or greater to perform this task. Please install them and restart LibreOffice. https://hub.libreoffice.org/InstallJava/?LOlocale=en-US I read above that I need full JDK for it to work. When can I find the link to install this programme? I am confuse about what to do. Thank your help. Serge
@Serge: Install a current JDK for your processor type from either: https://jdk.java.net/19/ or https://www.oracle.com/java/technologies/downloads/#jdk19-mac