Cachedb.jar ? What is it? The "cachedb.jar" is a jar file (read more about the jar format) that contain all java classes to connect to the InterSystems database Caché. This is the JDBC Driver for Caché.

The Java components required to connect to Caché are contained within the file CacheDB.jar. The Java client connects to and communicates with a Caché server via a TCP/IP socket. The Java client can be a simple JVM or an Enterprise Java Bean (EJB) Server.

System Requirements

Caché requires that the Java client use the Java SDK, version 1.4 or higher. You find the right JDBC driver file in you cache home folder:

\dev\java\lib\jdk14

\dev\java\lib\jdk15

\dev\java\lib\jdk16

On Windows systems, this file is found in your Caché installation: \Dev\java\lib\jdk14\CacheDB.jar; if you accept the defaults during a Windows installation, the file will be at C:\CacheSys\Dev\java\lib\jdk14\CacheDB.jar.

In UNIX distributions, the default location for is /usr/cachesys.

The Java environment uses the system environment variable CLASSPATH to find files that it needs to function. It must include the location of the CacheDB.jar file. Configuring a Server Connection Every Java client that wishes to connect to a Caché server needs the following information: A URL that provides the server IP address, port number, and Caché namespace. A user name and password.

The Java sample programs use the following connection information:

String url = "jdbc:Cache://127.0.0.1:1972/SAMPLES";

String user = "_SYSTEM";

String password = "SYS";

Platform Information and Release Notes 2008.1