Properties for a JDBC store seems not working for JDG6
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.