| Name | Type | Default | Description |
|---|---|---|---|
| key-to-string-mapper | string | 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.
| Name | Type | Default | Description |
|---|---|---|---|
| prefix | string | ispn_entry | Defines the prefix prepended to the cache name used when composing the name of the cache entry table. |
| Name | Type | Default | Description |
|---|---|---|---|
| fetch-size | int | ${TableManipulation.fetchSize} | The fetch size used when querying from this table. Used to avoid heap memory exhaustion when query is large. |
| batch-size | int | ${TableManipulation.batchSize} | Deprecated, use the max-batch-size store property instead. The statement batch size used when modifying this table. |
| create-on-start | boolean | ${TableManipulation.createOnStart} | Determines whether database tables should be created by the store on startup. |
| drop-on-exit | boolean | ${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.
| Name | Type | Default | Description |
|---|---|---|---|
| name | string | id | The name of the column used to store the cache key or bucket id. |
| type | string | VARCHAR | The 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.
| Name | Type | Default | Description |
|---|---|---|---|
| name | string | datum | The name of the column used to store the cache entry or bucket. |
| type | string | BINARY | The 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.
| Name | Type | Default | Description |
|---|---|---|---|
| name | string | version | The name of the column used to store the cache entry or bucket timestamp. |
| type | string | BIGINT | The 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.
| Name | Type | Default | Description |
|---|---|---|---|
| name | string | version | The name of the column used to store the segment number. |
| type | string | BIGINT | The type of the column used to store the segment number. |
| Name | Type | Default | Description | ||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| dialect |
| Specifies the JDBC dialect of the database. | |||||||||||||||||||||||||||||||||
| db-major-version | nonNegativeInteger | Specifies the major version of the database. | |||||||||||||||||||||||||||||||||
| db-minor-version | nonNegativeInteger | Specifies the minor version of the database. | |||||||||||||||||||||||||||||||||
| read-query-timeout | nonNegativeInteger | Defines the timeout, in seconds, for read queries. The default is 0 which indicates no timeout. | |||||||||||||||||||||||||||||||||
| write-query-timeout | nonNegativeInteger | Defines the timeout, in seconds, for write queries. The default is 0 which indicates no timeout. |
connection-pool
| Name | Type | Default | Description |
|---|---|---|---|
| properties-file | string | Sets the path of a properties file that provides additional configuration for the connection pool. | |
| connection-url | string | Sets a connection url specific to a JDBC driver. | |
| driver | string | Specifies the class name of the driver that connects to the database. | |
| password | string | Specifies the password for the database connection. | |
| username | string | Specifies the username for the database connection. |
data-source
| Name | Type | Default | Description |
|---|---|---|---|
| jndi-url | string | Specifies the address of a datasource for the JDBC connection. |
simple-connection
| Name | Type | Default | Description |
|---|---|---|---|
| connection-url | string | Sets a connection url specific to a JDBC driver. | |
| driver | string | Specifies the class name of the driver that connects to the database. | |
| password | string | Specifies the password for the database connection. | |
| username | string | Specifies the username for the database connection. |