Why is the selected JRE defective?

I have a mac with Yosemite 10.10.5 and use LibreOffice I have installed JRE Version 8 update 101 from Oracle.

I am trying to open a client list in Base and I keep getting the following message: LibreOffice requires a Java runtime environment (JRE) to perform this task. The selected JRE is defective. Please select another version or install a new JRE and select it under LibreOffice - Preferences - LibreOffice - Advanced.

When I follow the above instruction there are no files to choose from and I have installed and reinstalled 3 times now after getting the message that the JRE is defective.

No Java installation is found is usually the next message I get. When I go into LibreOffice Preferences it keeps telling me that the appropriate folder contains no JRE.

My husband is furious I have somehow lost our client data base, but this has only happened since updating LibreOffice - PLEASE HELP, how do I fix this?

You need to install the JDK from Oracle for your system.

Thank you so much I have just done it and my file is open and running again. You have just solved ten hours of complete frustration.

My pleasure.