I have installed Oracle’s JDK 8 on Mac OS X El Capitan in an attempt to allow Libre Office (LO) macro within a Spreadsheet and also for database use. I have had partial success, but any of the changes I make in the ‘Security’ setting i.e. Macro-Security-change to Medium, ‘Trusted folder’ etc are lost on exit from LO; bringing me back to square one.
Jul 23, 2015 It is worth to mention, Apple still providing JDK6for this newest release (El Capitan), Apple recommend user to use the latest Java from java.com. Oct 01, 2015 After installed the OS X El Capitan I get the message: to open 'CS5ServiceManager' you need to install the legacy Java SE 6 runtime. Java for OS X 2015-001 installs the legacy Java 6 runtime for OS X 10.11 El Capitan, OS X 10.10 Yosemite, OS X 10.9 Mavericks, OS X 10.8 Mountain Lion, and OS X 10.7 Lion. This package is exclusively intended for.
It also seems impossible to create a database within LO for clearly connected reasons relating to the (alleged) absence of JRE.

Update Java Mac El Capitan
Learn how to re-enable the Apple-provided Java SE 6 Java SE 6 web plug-in and Web Start features in OS X Lion and later. If, after installing Java for OS X 2014-001 and the latest version of Java 7 from Oracle, you want to disable Java 7 and re-enable the Apple-provided Java SE 6 web plug-in and Web Start functionality, follow these steps. Environment: Windows XP-10, Microsoft Office Suite 2010-2016 and 365, Microsoft live accounts, OSX Leopard, El Capitan, iOS, Android. Show more Show less Help Desk Associate.
Java El Capitan Download
I believe that there may be something specific about the ‘El Capitan’ O/S which seeks to prevent a smooth ride in this department, and as a newbie to the MAC environment at least any advice would be appreciated.