urn:infinispan:config:store:jdbc:13.0

string-keyed-jdbc-store

NameTypeDefaultDescription
key-to-string-mapperstring The class name of a org.infinispan.persistence.keymappers.Key2StringMapper to use for mapping keys to strings suitable for storage in a database table. Defaults to org.infinispan.persistence.keymappers.DefaultTwoWayKey2StringMapper

string-keyed-table?

Defines the table used to store cache entries.

NameTypeDefaultDescription
prefixstringispn_entryDefines the prefix prepended to the cache name used when composing the name of the cache entry table.
NameTypeDefaultDescription
fetch-sizeint${TableManipulation.fetchSize}The fetch size used when querying from this table. Used to avoid heap memory exhaustion when query is large.
batch-sizeint${TableManipulation.batchSize}Deprecated, use the max-batch-size store property instead. The statement batch size used when modifying this table.
create-on-startboolean${TableManipulation.createOnStart}Determines whether database tables should be created by the store on startup.
drop-on-exitboolean${TableManipulation.dropOnExit}Determines whether database tables should be dropped by the store on shutdown.

id-column?

Defines the column in which to store the cache key or bucket id.

NameTypeDefaultDescription
namestringidThe name of the column used to store the cache key or bucket id.
typestringVARCHARThe type of the column used to store the cache key or bucket id.

data-column?

Defines the column in which to store the cache entry or bucket.

NameTypeDefaultDescription
namestringdatumThe name of the column used to store the cache entry or bucket.
typestringBINARYThe type of the column used to store the cache entry or bucket.

timestamp-column?

Defines the column in which to store the timestamp of the cache entry or bucket.

NameTypeDefaultDescription
namestringversionThe name of the column used to store the cache entry or bucket timestamp.
typestringBIGINTThe type of the column used to store the cache entry or bucket timestamp.

segment-column?

Defines the column in which to store the segment number.

NameTypeDefaultDescription
namestringversionThe name of the column used to store the segment number.
typestringBIGINTThe type of the column used to store the segment number.
NameTypeDefaultDescription
dialect
ACCESS
DB2
DB2_390
DERBY
FIREBIRD
H2
HSQL
INFORMIX
INTERBASE
MARIA_DB
MYSQL
ORACLE
POSTGRES
SQL_SERVER
SQLITE
SYBASE
Specifies the JDBC dialect of the database.
db-major-versionnonNegativeIntegerSpecifies the major version of the database.
db-minor-versionnonNegativeIntegerSpecifies the minor version of the database.
read-query-timeoutnonNegativeIntegerDefines the timeout, in seconds, for read queries. The default is 0 which indicates no timeout.
write-query-timeoutnonNegativeIntegerDefines the timeout, in seconds, for write queries. The default is 0 which indicates no timeout.

connection-pool

NameTypeDefaultDescription
properties-filestring Sets the path of a properties file that provides additional configuration for the connection pool.
connection-urlstring Sets a connection url specific to a JDBC driver.
driverstring Specifies the class name of the driver that connects to the database.
passwordstring Specifies the password for the database connection.
usernamestring Specifies the username for the database connection.

data-source

NameTypeDefaultDescription
jndi-urlstring Specifies the address of a datasource for the JDBC connection.

simple-connection

NameTypeDefaultDescription
connection-urlstring Sets a connection url specific to a JDBC driver.
driverstring Specifies the class name of the driver that connects to the database.
passwordstring Specifies the password for the database connection.
usernamestring Specifies the username for the database connection.
Expand/Collapse All