The InterSystems Caché JDBC driver are an type 4 JDBC driver. Here are some information about the different JDBC driver versions that ships with the InterSystems Caché database.
First some basic information about the Caché JDBC URL:
Driver Class = com.intersys.jdbc.CacheDriver
The URL syntax is
jdbc:Cache://machine:port/namespace
The URL specifies the machine address, port number, and namespace to be accessed.
machine IP address or host name. For example, both localhost and 127.0.0.1 indicate the local machine.
port TCP/IP port number for the connection. For example, 56772 is the standard Caché superserver port.
namespace Namespace to connect to. For example, Samples is the namespace containing Caché sample programs.
For example
jdbc:Cache://127.0.0.1:56772/Samples
Caché driver versions
JDBC Driver Version | JDK Version | Size of CacheDB.jar file | Caché Version | Details |
5.0.5504.0 | 679kb | 5.0.12 | ||
5.0.5902.0 | 977kb | 5.0.16 | JDBC preparser: allow extrinsic functions This change corrects a regression in functionality that prevented the JDBC parser from recognizing intrinsic functions. It now allows the first character of an identifier to be ‘$’, and accepts ‘$’ and ‘^’ as possible values for subsequent characters | |
5.1.0.826 | 1.466kb | 5.1 | JDBC 3.0 Support Cache 5.1 supports JDK 1.4 and JDBC 3.0. All required features and most optional features are supported. | |
5.2.0.290 | 1.913kb | 5.2.0.290 | Driver from 5.2 field test | |
5.2.0.329 | 1.5 | 1.872kb | 5.2.0.329 | |
5.2.0.329 | 1.4 | 1.871kb | 5.2.0.329 | |
2007.1.0.254 | 1.5 | 1.940kb | 2007.1.0.254 | Driver from 2007.1 Field Test 1 |
2007.1.0.254 | 1.5 | 1.947kb | 2007.1.0.267 | Driver from 2007.1 Field Test 2If you try to connect with this driver to a Caché Database with a version smaller 5.0.13, you get a SQLExeption like this: Protocol mismatch; only protocols >= 39 supportedYou have to use a older driver for Caché < 5.0.13! |
2007.1.0.306 | 1.4 | 1.915kb | 2007.1.0.306 | Driver from 2007.1 Release Candidate (RC1) |
2007.1.0.306 | 1.5 | 1.952kb | 2007.1.0.306 | Driver from 2007.1 Release Candidate (RC1) |
2007.1.0.348 | 1.915kb | 2007.1.0.348 | Driver from 2007.1 RC2 | |
2008.1.0.171 | 1.4 | 1.842kb | [Fri 06/01/2007 0:01:54.22] | |
2008.1.0.171 | 1.5 | 1.867kb | [Fri 06/01/2007 0:01:54.22] | |
2008.1.0.171 | 1.6 | 1.937kb | [Fri 06/01/2007 0:01:54.22] | |
2012.2.0.638 | 1.6\1.7 | 2.018kb cachedb.jar298kb cachejdbc.jar | 2012.2.0.638 | |
If you have more information or found a mistake in the JDBC table, please mail to: andreas.