Configure a datasource for JDBC Cachestore in RHDG

Solution Verified - Updated -


  • How to set a datasource configuration for a file store in JDG6?
  • How to replace the H2 database with a database in production?
  • When do I need to set the database dialect for caches in RHDG configuration?
  • After change the datasource there is an Exception during startup (example for Oracle with stripped stacktraces)
ERROR [org.infinispan.loaders.jdbc.TableManipulation] (CacheService lifecycle - 1) ISPN008011: Error while creating table; used DDL statement: 'CREATE TABLE "JDG_error"(id VARCHAR NOT NULL, datum BINARY, version BIGINT, PRIMARY KEY (id))': java.sql.SQLSyntaxErrorException: ORA-00906: missing left parenthesis
    at oracle.jdbc.driver.T4CTTIoer.processError(
ERROR [] (CacheService lifecycle - 1) MSC000001: Failed to start service jboss.infinispan.local.error: org.jboss.msc.service.StartException in service jboss.infinispan.local.error: org.infinispan.CacheException: Unable to invoke method public void org.infinispan.loaders.CacheLoaderManagerImpl.start() on object of type CacheLoaderManagerImpl
    at$ [jboss-as-clustering-common-7.1.2.Final-redhat-1.jar:7.1.2.Final-redhat-1]
    at java.util.concurrent.ThreadPoolExecutor$Worker.runTask( [rt.jar:1.6.0_43]
Caused by: java.sql.SQLSyntaxErrorException: ORA-00906: missing left parenthesis
    ... 27 more


  • Red Hat Data Grid (RHDG)
    • 6
    • 7
  • Oracle, DB2, MySQL, MariaDB, Postgress

Subscriber exclusive content

A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.

Current Customers and Partners

Log in for full access

Log In

New to Red Hat?

Learn more about Red Hat subscriptions

Using a Red Hat product through a public cloud?

How to access this content