Database not recognizing JRE

dBase, Calc, CSV, MS ACCESS, MySQL, PostgrSQL, OTHER

Database not recognizing JRE

Postby Doc16743 » Fri Aug 29, 2014 1:32 pm

In attempting to work on an Access database, when I invoke "Use wizard to create table", I get the error message "OpenOffice requires a Java runtime environment....." and instructs me to install one and restart OpenOffice.

When I tried to install JRE, the computer informed me that it was already installed. Since re-installation was an option, I selected that and the install went with no issues.

However, when again trying to invoke the table wizard, I was again informed that it requires a JRE.

Can someone point out what I might be missing? The JRE I installed was designed for this 64-bit Windows version.

Thanks!
Doc
OpenOffice 4.1.0 on Windows 7 64-bit
Doc16743
 
Posts: 7
Joined: Fri Aug 22, 2014 1:07 pm

Re: Database not recognizing JRE

Postby Harry Hobbes » Fri Aug 29, 2014 1:37 pm

OpenOffice (and LibreOffice) require the 32-bit version of JRE. Note that both the 64-bit and 32-bit versions of JRE can co-exist on a Windows platform.
OpenOffice 4.1.0, LibreOffice Fresh (4.2.5.2) on Windows 7, x64; also learning Linux Mint Petra, X32, MATE desktop.
Base DBs using HyperSQL 2.3.2 (Split configuration).
User avatar
Harry Hobbes
 
Posts: 8
Joined: Tue Mar 25, 2014 10:32 pm
Location: Montana, USA

Re: Database not recognizing JRE

Postby Doc16743 » Fri Aug 29, 2014 1:43 pm

Wow! Fast reply AND good information!!

That did the trick!! Many thanks!
Doc
OpenOffice 4.1.0 on Windows 7 64-bit
Doc16743
 
Posts: 7
Joined: Fri Aug 22, 2014 1:07 pm

Re: Database not recognizing JRE

Postby Villeroy » Fri Aug 29, 2014 2:03 pm

Neither LibreOffice nor OpenOffice require any Java at all. However, many parts of the Base component are implemented in Java.

WIthout a single bean of Java you can ...
-- connect your Access database to this office suite through a Microsoft driver for the MS JET database engine.
-- send SQL commands through a simple command line interface (Tools>SQL). The table wizard is a joke. You don't miss anything.
-- query the database in "parsed mode" or "direct mode" (aka Access:"Pass Through Query")
-- design forms manually (the wizzard is nonsense anyway)
-- run existing Base reports but all tools to create reports rely on Java
-- utilize your database data in office documents which is the main purpose of Base. For instance you can build serial letters, feed calculation models with data and you may use Calc as an alternative reporting tool.
-- copy data from one connected database to some other connected database using a wizard that is triggered by copy&paste or drag&drop.

All the bullshit wizards rely on Java but they are not important except for the report wizard.
Connections through drivers written in Java (JDBC connections) rely on Java. MySQL, Access, PostgreSQL and many others can be connected without Java drivers.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 16.04, OpenOffice 4.x & LibreOffice 5.x
User avatar
Villeroy
Volunteer
 
Posts: 24399
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany


Return to External Data Sources

Who is online

Users browsing this forum: No registered users and 2 guests