After you install the Java Runtime Environment (JRE) in Windows, you must set the Java environment variable, JAVA_HOME, to point to the JRE installation directory. The bit level (32 or 64) of the installed JRE must match the bit level of the Connect release that you are running.
Consider the following examples on setting the JAVA_HOME environment variable:
On Windows:
set JAVA_HOME=C:\Program Files (x86)\Java\jdk-11.0.22On UNIX:
export JAVA_HOME=/usr/java/jdk-11.0.22Database Connection URL
To connect to a database using the JDBC access method, you must specify the database connection URL as the database specification in the Database Connection dialog.MySQL Example
At a minimum, each database connection URL, which the JDBC driver uses to connect to the JDBC source or target, consists of jdbc, which is the required first parameter; the DBMS name, the database host name, the database name, and any additional connection property specification.
jdbc:mysql://localhost/db1where
jdbc - required first parameter to connect to a JDBC source or target.
mysql - DBMS name. This DBMS name must match the DBMS name specified
within brackets ([]) in the section header of the JDBC configuration file.
//localhost/db1 - host and database identification string that identifies
the db1 database in the local MySQL DBMS installation.
For additional information, see MySQL Driver and Data Source Class Names, URL Syntax, and Configuration Properties for Connector/J.