Starting the Schema Editor for JDBC Connections

System Requirements

The Schema Editor requires Java Runtime Environment version 8, Update 452(JRE 8u452) or later. The Schema Editor can be used with a Java 8 Runtime Environment that contains the JavaFX libraries.

The JDBC version of the Schema Editor, which is packaged with JDBC connectors, supports JDBC connections only. However, the schema definitions themselves are compatible with both the ODBC and JDBC versions of the Schema Editor, and can be used by both ODBC and JDBC connectors regardless of the Schema Editor that was used to create the definition.

Windows

The Schema Editor supports the following versions of Windows (32- and 64-bit editions are supported):

  • Windows 10 or 11
  • Windows Server 2016 or later

Linux

The Schema Editor supports the following Linux distributions (32- and 64-bit editions are supported):

  • Red Hat® Enterprise Linux® (RHEL) 8 or 9
  • SUSE Linux Enterprise Server (SLES) 15
  • Debian 11 or 12
  • Ubuntu 22.04 or 24.04

To use the Schema Editor on Linux, you must have GTK+ 2.18, 2.20, or 2.24 installed.

macOS

The Schema Editor supports macOS version 13, 14, or 15.

Starting the Schema Editor

Use the SchemaEditor.jar file included in your JDBC connector package to start the Schema Editor. The application must be run using JRE 8u452 or later.

To verify the JRE version:

  • Open a Command Prompt or Terminal window and then run the following command:

    • java -version

This command returns information about the JRE version that your machine runs by default. For example, the following message indicates that your machine runs JRE 8u452:

java version "1.8.0_66"

Java(TM) SE Runtime Environment (build 1.8.0_66-b18)

If the command fails to run or an earlier version of Java is returned, then you must specify the full path to the JRE. For example:

"C:\Program Files\Java\jre1.8.0_66\bin\java.exe"
-version

To start the Schema Editor:

  1. Open a Command Prompt or Terminal window and then navigate to the root directory of the connector.
  2. Run one of the following commands, where [JRE_Path] is the full path to the bin subfolder in the JRE directory:
    • On Windows:

      • [JRE_Path]\java -jar SchemaEditor.jar

    • Or, on Linux or macOS:

      • [JRE_Path]/java -jar SchemaEditor.jar

    Note:

    If your machine uses JRE 8u452 or later by default, then it is not necessary to include [JRE_Path] in the command.

The Schema Editor opens on the start page. From there, you can choose to create a new schema definition by sampling data, or modify an existing schema definition stored in a JSON file or a NoSQL data store.