Bug 1042871

Summary: Infinispan cache store doesn't read databaseType property
Product: [JBoss] JBoss Enterprise Application Platform 6 Reporter: Tomas Remes <tremes>
Component: ClusteringAssignee: Paul Ferraro <paul.ferraro>
Status: CLOSED EOL QA Contact: Michal Vinkler <mvinkler>
Severity: medium Docs Contact:
Priority: unspecified    
Version: 6.2.0   
Target Milestone: ---   
Target Release: ---   
Hardware: Unspecified   
OS: Unspecified   
Whiteboard:
Fixed In Version: Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2019-08-19 12:48:42 UTC Type: Bug
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:

Description Tomas Remes 2013-12-13 14:49:32 UTC
There's option to specify database type in your jdbc cache store definition e.g.:

<binary-keyed-jdbc-store datasource="java:jboss/datasources/ExampleDS" preload="true" passivation="false" purge="false">
        <property name="databaseType">SYBASE</property>
        <binary-keyed-table prefix="b">
        <id-column name="id" type="VARCHAR(255)"/>
        <data-column name="datum" type="VARBINARY(10000)"/>
        <timestamp-column name="ver" type="BIGINT"/>
   </binary-keyed-table>
</binary-keyed-jdbc-store>

The problem is that this property is never read, which for example means that user cannot use jTDS jdbc drivers, where infinispan is not able to guess database type from driver specification.
Note that I've tried to add this property manually as well as using CLI.

Comment 1 Tomas Remes 2013-12-16 09:02:30 UTC
Upstream issue https://issues.jboss.org/browse/ISPN-3837