JDBC Connection Issue: Cache 2018.1 Access Denied

Question

Question

Hello Community,

I am facing a JDBC connection issue after migrating from Caché 2016 to Caché 2018.1. When I attempt to connect using the following connection settings:

CACHE_DATASOURCE_URL=jdbc:Cache://localhost:1972/TEST

CACHE_DB_USERNAME=test

CACHE_DB_PASSWORD=test

I consistently receive the following error:

[Cache JDBC] Communication link failure: Access Denied

This configuration worked perfectly with Caché 2016. I have verified the following:

The namespace (TEST) exists and is correctly specified in the connection URL.
The credentials (username: test, password: test) are correct.
The Caché instance is running on the correct hostname and port (localhost:1972)

Has anyone encountered a similar issue? Are there any known differences or required configurations for JDBC connections in Caché 2018 that weren’t present in Caché 2016?

I appreciate any guidance or support.

Thank you!

Product version: Caché 2018.1

Discussion (7)2

Log in or sign up to continue

score 1 · Answer 1 · 2026-01-27T08:17:45-05:00

Does the test user account have the right security resources to access the database you're trying to log into? The quick easy way to check if you have a security-related issue is to give the test user the %All role and see if the issue goes away. If it does, you need to figure out what resource/role is missing for the user account. You don't want to permanently leave the %All role on there.

score 0 · Answer 2 · 2026-01-27T08:37:30-05:00

Hour Abdellatif · Jan 27

Yeah the test user has %All role is there any way to intercept the error at Cache DB level ?

0 0

score 0 · Answer 3 · 2026-01-27T09:06:04-05:00

If you have Auditing turned on, you can check your audit log for login failures in system management portal. That will tell you why the login failed, which might point you in the right direction.

score 0 · Answer 4 · 2026-01-27T09:57:11-05:00

Hour Abdellatif · 22 hr ago

JDBC

JDBC error : [Cache JDBC] Communication link failure: Access Denied

0 0

score 0 · Answer 5 · 2026-01-27T13:45:59-05:00

Is the %Service_Bindings enabled with password authentication?

Check in Management Portal:
System Administration -> Security -> Services

score 0 · Answer 6 · 2026-01-28T03:24:10-05:00

yeah it is .

JDBC package :

version=2.0.0
groupId=com.intersys
artifactId=cache-jdbc

    com.intersys.jdbc.CacheDriver

score 0 · Answer 7 · 2026-01-28T03:55:35-05:00

Hour Abdellatif · 4 hr ago

it looks like there is any licence error !

0 0