Configure a datasource for JDBC Cachestore in RHDG

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