System.Exception: Java is not installed or not accessible. java.exe The system cannot find the file specified

ODBC PowerPack JDBC-ODBC Bridge
, ,
1

Problem

When using the ZappySys ODBC JDBC Bridge Driver (e.g., for connecting to sources like Infor Data Lake, Amazon Athena, MySQL, etc.), you might encounter this error if Java Runtime Environment (JRE) or Java Development Kit (JDK) is missing or incorrectly configured on your system.

System.Exception: Test Connection: FAILED
Java is not installed or not accessible.
java.exe
The system cannot find the file specified

This article walks you through how to resolve this issue step by step.

Cause

This error typically occurs when the ZappySys JDBC driver attempts to execute a Java process but fails because the system cannot locate java.exe. The driver depends on the Java Runtime Environment (JRE) or Java Development Kit (JDK) to function, and if Java is not properly installed or configured, the test connection fails with a message indicating that Java is either not installed or not accessible.

Step-by-Step Solution

Step 1: Check if Java is Installed

Open Command Prompt and run:

java -version
  • If Java is installed and configured correctly, you’ll see the version info.
  • If not, you’ll see:
     'java' is not recognized as an internal or external command

Step 2: Install Java Runtime (JRE 8 or JDK 8)

You need either JRE or JDK version 8 (others may work, but 8 is most compatible).

Option A: Amazon Corretto JRE 8 (Free & Recommended)

Option B: Oracle JRE 8 (License may be required)

Install the downloaded package.

Step 3: Restart the Machine

Restarting ensures that all environment changes are applied.

Step 4: (If Needed) Manually Set JAVA PATH

If java -version doesn’t work:

  1. Set JAVA_HOME (if not automatically done)

    • Go to: System Properties > Advanced > Environment Variables

      System Properties
      System Properties412×468 14.2 KB

    • Under System Variables, please check if a variable named JAVA_HOME exists. If it does, edit it to point to your installed Java folder path.
      If it doesn’t exist, click ‘New’ under System Variables and create it by adding the correct path to your Java installation.:

      • Variable name: JAVA_HOME
      • Value: Path to your JDK/JRE, e.g.,
      C:\Program Files\Amazon Corretto\jdk1.8.0_xx

      System variables
      System variables618×585 37.7 KB

Step 5: Re-test JDBC Connection in ZappySys

Open ZappySys Data Gateway or your SSIS component and click Test Connection again. If Java is configured correctly, the connection should succeed.

Troubleshooting Tips

  • Ensure you’re using a 64-bit version of Java if your application is 64-bit.
  • Avoid installing multiple Java versions unless needed. If multiple versions are present, make sure the correct one is set in JAVA_HOME.
  • If you’re running from Visual Studio, make sure it picks up the updated environment variables (restart it if needed).

Summary

The error message:

System.Exception: Test Connection: FAILED
Java is not installed or not accessible.

is resolved by:

  • Installing Java (JRE 8 or JDK 8)
  • Setting the correct JAVA_HOME and PATH
  • Restarting your system and retrying the connection

Conclusion

The “Java is not installed or not accessible” error in ZappySys JDBC Driver is a clear indication that the required Java environment is either missing or misconfigured. By ensuring that Java (preferably JRE 8 or JDK 8) is properly installed and that the system environment variables (JAVA_HOME and PATH) are correctly set, this issue can be resolved quickly. Once Java is accessible, the JDBC driver should function as expected, allowing successful test connections and data access.

References