10.5.5.5. JdbcMixedCacheStore Library Mode Configuration
The following is a sample configuration for the
JdbcMixedCacheStore:
<loaders>
<loader class="org.infinispan.loaders.jdbc.mixed.JdbcMixedCacheStore"
fetchPersistentState="false"
ignoreModifications="false"
purgeOnStartup="false">
<properties>
<property name="tableNamePrefixForStrings" value="ISPN_MIXED_STR_TABLE"/>
<property name="tableNamePrefixForBinary" value="ISPN_MIXED_BINARY_TABLE"/>
<property name="idColumnNameForStrings" value="ID_COLUMN"/>
<property name="idColumnNameForBinary" value="ID_COLUMN"/>
<property name="dataColumnNameForStrings" value="DATA_COLUMN"/>
<property name="dataColumnNameForBinary" value="DATA_COLUMN"/>
<property name="timestampColumnNameForStrings" value="TIMESTAMP_COLUMN"/>
<property name="timestampColumnNameForBinary" value="TIMESTAMP_COLUMN"/>
<property name="timestampColumnTypeForStrings" value="BIGINT"/>
<property name="timestampColumnTypeForBinary" value="BIGINT"/>
<property name="connectionFactoryClass" value="org.infinispan.loaders.jdbc.connectionfactory.PooledConnectionFactory"/>
<property name="connectionUrl" value="jdbc:h2:mem:infinispan_mixed_cs;DB_CLOSE_DELAY=-1"/>
<property name="userName" value="sa"/>
<property name="driverClass" value="org.h2.Driver"/>
<property name="idColumnTypeForStrings" value="VARCHAR(255)"/>
<property name="idColumnTypeForBinary" value="VARCHAR(255)"/>
<property name="dataColumnTypeForStrings" value="BINARY"/>
<property name="dataColumnTypeForBinary" value="BINARY"/>
<property name="dropTableOnExitForStrings" value="false"/>
<property name="dropTableOnExitForBinary" value="false"/>
<property name="createTableOnStartForStrings" value="true"/>
<property name="createTableOnStartForBinary" value="true"/>
<property name="createTableOnStartForStrings" value="true"/>
<property name="createTableOnStartForBinary" value="true"/>
</properties>
</loader>
</loaders>
<loaders>
<loader class="org.infinispan.loaders.jdbc.mixed.JdbcMixedCacheStore"
fetchPersistentState="false"
ignoreModifications="false"
purgeOnStartup="false">
<properties>
<property name="tableNamePrefixForStrings" value="ISPN_MIXED_STR_TABLE"/>
<property name="tableNamePrefixForBinary" value="ISPN_MIXED_BINARY_TABLE"/>
<property name="idColumnNameForStrings" value="ID_COLUMN"/>
<property name="idColumnNameForBinary" value="ID_COLUMN"/>
<property name="dataColumnNameForStrings" value="DATA_COLUMN"/>
<property name="dataColumnNameForBinary" value="DATA_COLUMN"/>
<property name="timestampColumnNameForStrings" value="TIMESTAMP_COLUMN"/>
<property name="timestampColumnNameForBinary" value="TIMESTAMP_COLUMN"/>
<property name="timestampColumnTypeForStrings" value="BIGINT"/>
<property name="timestampColumnTypeForBinary" value="BIGINT"/>
<property name="connectionFactoryClass" value="org.infinispan.loaders.jdbc.connectionfactory.PooledConnectionFactory"/>
<property name="connectionUrl" value="jdbc:h2:mem:infinispan_mixed_cs;DB_CLOSE_DELAY=-1"/>
<property name="userName" value="sa"/>
<property name="driverClass" value="org.h2.Driver"/>
<property name="idColumnTypeForStrings" value="VARCHAR(255)"/>
<property name="idColumnTypeForBinary" value="VARCHAR(255)"/>
<property name="dataColumnTypeForStrings" value="BINARY"/>
<property name="dataColumnTypeForBinary" value="BINARY"/>
<property name="dropTableOnExitForStrings" value="false"/>
<property name="dropTableOnExitForBinary" value="false"/>
<property name="createTableOnStartForStrings" value="true"/>
<property name="createTableOnStartForBinary" value="true"/>
<property name="createTableOnStartForStrings" value="true"/>
<property name="createTableOnStartForBinary" value="true"/>
</properties>
</loader>
</loaders>