Properties for a JDBC store seems not working for JDG6

Solution Verified - Updated -

Issue

  • Set a datasource property for the databaseType seems not working
<subsystem xmlns="urn:infinispan:server:core:5.2" ...>
  <cache-container name="clustered" ...>
    ...

    <replicated-cache name="MyCache" ...>
      <string-keyed-jdbc-store datasource="java:/jdbc/CacheStoreDS" ...>
        <property name="createTableOnStart">true</property>
        <property name="dropTableOnExit">false</property>
        <property name="databaseType">DB2_390</property>
  • There is an error during startup if the databaseType is set as property
16:22:22,933 ERROR [org.jboss.as.controller.management-operation] (ServerService Thread Pool -- 19) JBAS014612: Operation ("add") failed - address: ([
    ("subsystem" => "infinispan"),
    ("cache-container" => "clustered"),
    ("replicated-cache" => "QualitaetssicherungsLieferantList")
]): org.infinispan.commons.CacheConfigurationException: Couldn't find a setter named [setDatabaseType] which takes a single parameter, for parameter databaseType on class [class org.infinispan.persistence.jdbc.configuration.JdbcBinaryStoreConfigurationBuilder]
  at org.infinispan.configuration.parsing.XmlConfigHelper.setValues(XmlConfigHelper.java:450)
  ...
  • There is a SQL syntax error, nevertheless whether I set the datasourceType or not
ERROR [org.infinispan.loaders.jdbc.DataManipulationHelper] (MSC service thread 1-2) ISPN008007: SQL error while fetching all StoredEntries: com.ibm.db2.jcc.am.SqlSyntaxErrorException: DB2 SQL Error: SQLCODE=-104, SQLSTATE=42601, SQLERRMC=?;sBilder" FETCH FIRST;<space>, DRIVER=3.64.82

Environment

  • Red Hat JBoss Data Grid (JDG)
    • 6.0
    • 6.1.x
    • 6.2.0

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