https://bz.apache.org/ooo/show_bug.cgi?id=128508
Issue ID: 128508
Issue Type: DEFECT
Summary: Installing the correct 64 bit version of java runtime
onto Windows 10 64 renders Base unable to connect to a
database.
Product: Base
Version: 4.1.6
Hardware: PC
OS: Windows 10
Status: UNCONFIRMED
Severity: Blocker
Priority: P5 (lowest)
Component: code
Assignee: [email protected]
Reporter: [email protected]
Target Milestone: ---
Installing the correct 64 bit version of java runtime onto Windows 10 64
renders Base unable to connect to a database.
In my present case, that's MySQL (installed by
mysql-installer-community-8.0.29.0.msi), but because Base requires 32 bit java
runtime to connect, I expect the same problem would probably exist for ALL
databases.
Base depends on the 32 JRE, but the latest 32 bit JRE, by Oracle (installed by
jre-8u333-windows-i586.exe), deletes the latest 64 bit Java JDK runtime engine
(installed by jdk-18_windows-x64_bin.msi), which comes with the 64 bit JDK. As
a result, installing Base, and the 32 bit JRE it demands, breaks java
development tools on the host system... specifically tools such as Netbeans and
its database connectivity, which require the 64 bit JDK java runtime engine to
function.
The inverse is also true. Installing the latest 64 bit JDK onto Windows 10 64
pro AFTER installing Apache Openoffice Base also breaks Openoffice Base's
capacity to connect to a MySQL database, because the 64 bit JDK removes the 32
bit JRE required by base, to connect to a database (such as MySQL, in this
case).
The 64 bit Windows 10 64 pro JDK installer does not present the option to let
the existing JRE remain on the system. It doesn't ask, and it always clobbers
it.
The 32 bit Windows JRE installer offers the option not to delete the existing
java runtime engine, but it does delete it, regardless, even if you select the
32 bit installer's option to leave the existing runtime engine on the system...
This means Base, which DEMANDS a 32 bit JRE installation to connect to a
database, can not coexist on a Windows 64 bit development machine which uses
programs like Netbeans... because these tools require the 64 bit version of
java. Furthermore, even a standard 64 bit JRE would probably also break Base,
by the very same token. The java runtime engines simply don't leave each other
be. Bear in mind, 64 bit java is EXPECTED for 64 bit Windows operating
systems. For that reason, I hate to say it, but Base is essentially "broken"
for 64 bit Windows, unless the user simply desires base so much that they are
willing to break everything else java-related, on the whole computer, just to
make base work. I believe it is time that Open Office for Windows start
including a 64 bit installer, and that installer should accept 64 bit java
runtime, instead of depending on legacy 32 bit java runtime. I believe that
would fix these problems right up. Thanks for reading.
PS: Please understand that I am not prepared to dig into various installation
tests, to follow this up. Installation tests would destabilizes my current
development environment (Netbeans+JDK+MySQL-database), which took days to
prepare. Sorry about that, but that's how it has to be.
--
You are receiving this mail because:
You are the assignee for the issue.
