OSX 10.9 & LO 4.2.4 with JRE7 wants Java 6 and then crashes?

I need to run LO (4.2.4.2) on a Macbook Air (OSX 10.9.3) to use a database application. When I first installed LO (after installing Oracle JRE 7), I got a prompt saying that Apple wants to install Java 6, which I declined since JRE 7 is installed already. I see this prompt pops up each time I try to open die database, but it’s behind the LO window.

The database connects to MySQL so I need a MySQL connector. The native connector is not available for Mac so I need to use a JDBC connector. However, LO crashes before I can select that.

When I go the “Advanced” option in LO, I have Oracle JRE 7 listed as my Java Runtime Environment.

I had initially installed JRE 7 with Java 6, but it OSX and LO refused to “see” JRE 7, so after hacking around I eventually restored OSX and then Java 6 was not installed. JRE 7 installed without a problem and then LO too. Now I just need to cnnect to MySQL from Base… :-o something Ubuntu does without skipping a beat…

Try the native Mac connector available here for a 64bit version of the connector. For that you will need a 64bit version of LibreOffice.

Because of a bug in Oracle Java version 7.x it is also necessary to have Java 6 (the last Apple supported version) installed for LO Base to be able to access Java on your Mac system. Also see this rather technical discussion. So I would try installing Java 6 (the last Apple supported version - see Apple download link here), and then use the “Advanced” option to select that version for LO to use. (Please post again to let us all know whether or not this works). Obviously, this workaround leaves a lot to be desired (i.e. Mac users can’t take advantage the latest Java security patches).

Unfortunately this was on a client’s machine and she has since moved away, so I can’t verify this. I do believe it’s working now though, but can’t report what made it work, since I don’t have access to the machine anymore.