If a Caché instance is already reachable through an ODBC data source, you have everything you need to set up a JDBC connection — the values are the same, they just sit in a different dialogue. This post maps the fields across. It dates from the Caché Monitor era, which is why the tool is referred to by that name below.
The five fields that matter
These are the fields of the Caché ODBC settings dialogue, in the order they appear in it.
- Host / IP address — the IP address in dotted decimal notation, such as
127.0.0.1, or simply the server name. - Host port number — the port used to connect to the data source. The default for Caché is 1972.
- User name — the account used to log in. By default this is
_SYSTEM, and it is not case sensitive. - Password — the password for that account. For the
_SYSTEMuser the default isSYS, and it is case sensitive. - Caché namespace — the namespace the data source connects to.
The namespace is optional
The fifth field is where the JDBC connection differs from the ODBC data source. Caché Monitor does not need a namespace, because it reads the list of namespaces from the server and shows all of them for navigation. You pick the one you want in the tree instead of committing to one in the connection.
That requires a login with enough rights to query the namespace list from the %SYS database. If the account you are using does not have those rights, enter a namespace on the Details tab of the connection dialogue and the connection will use that one directly.
For the full field-by-field reference of the connection dialogue as it stands today, see setting up a connection to InterSystems IRIS or Caché, and for the tree that puts every server and namespace in one place, see the Server Navigator.
The current release, with the bundled InterSystems drivers, is on the download page.