Configure a datasource for JDBC Cachestore in RHDG

Solution Verified - Updated -

Issue

  • 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(T4CTTIoer.java:440)
    ...
ERROR [org.jboss.msc.service.fail] (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 org.jboss.as.clustering.msc.AsynchronousService$1.run(AsynchronousService.java:68) [jboss-as-clustering-common-7.1.2.Final-redhat-1.jar:7.1.2.Final-redhat-1]
    at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:895) [rt.jar:1.6.0_43]
   ...
Caused by: java.sql.SQLSyntaxErrorException: ORA-00906: missing left parenthesis
    ... 27 more

Environment

  • 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 of over 48,000 articles and solutions.

Current Customers and Partners

Log in for full access

Log In