| 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 | 100 | The fetch size used when querying from this table. Used to avoid heap memory exhaustion when query is large. |
| batch-size | int | 100 | Deprecated, use the max-batch-size store property instead. The statement batch size used when modifying this table. |
| create-on-start | boolean | true | Determines whether database tables should be created by the store on startup. |
| drop-on-exit | boolean | false | 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. |
| Name | Type | Default | Description | ||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| dialect |
| Defines the JDBC dialect. | |||||||||||||||||||||||||||||||||
| db-major-version | nonNegativeInteger | Defines the major version of the database. | |||||||||||||||||||||||||||||||||
| db-minor-version | nonNegativeInteger | Defines the minor version of the database. |
connection-pool
| Name | Type | Default | Description |
|---|---|---|---|
| properties-file | string | The path of a properties file that provides additional configuration for the connection pool. | |
| connection-url | string | A JDBC driver-specific connection URL | |
| driver | string | The class name of the driver used for connecting to the database. | |
| password | string | The password to use when connecting via connectionUrl | |
| username | string | The username to use when connecting via connectionUrl |
data-source
| Name | Type | Default | Description |
|---|---|---|---|
| jndi-url | string | The address of a datasource to use when connecting |
simple-connection
| Name | Type | Default | Description |
|---|---|---|---|
| connection-url | string | A JDBC driver-specific connection URL | |
| driver | string | The class name of the driver used for connecting to the database. | |
| password | string | The password to use when connecting via connectionUrl | |
| username | string | The username to use when connecting via connectionUrl |
| Name | Type | Default | Description |
|---|---|---|---|
| shared | boolean | false | This setting should be set to true when multiple cache instances share the same cache store (e.g., multiple nodes in a cluster using a JDBC-based CacheStore pointing to the same, shared database.) Setting this to true avoids multiple cache instances writing the same modification multiple times. If enabled, only the node where the modification originated will write to the cache store. If disabled, each individual cache reacts to a potential remote update by storing the data to the cache store. |
| transactional | boolean | false | This setting should be set to true when the underlying cache store supports transactions and it is desirable for the underlying store and the cache to remain synchronized. With this enabled any Exceptions thrown whilst writing to the underlying store will result in both the store's and cache's transactions rollingback. |
| preload | boolean | false | If true, when the cache starts, data stored in the cache store will be pre-loaded into memory. This is particularly useful when data in the cache store will be needed immediately after startup and you want to avoid cache operations being delayed as a result of loading this data lazily. Can be used to provide a 'warm-cache' on startup, however there is a performance penalty as startup time is affected by this process. |
| fetch-state | boolean | false | If true, fetch persistent state when joining a cluster. If multiple cache stores are chained, only one of them can have this property enabled. |
| purge | boolean | false | If true, purges this cache store when it starts up. |
| singleton | boolean | false | If true, the singleton store cache store is enabled. SingletonStore is a delegating cache store used for situations when only one instance in a cluster should interact with the underlying store. Deprecated: A shared store should be used instead, as this limits store writes to the primary owner of a key |
| read-only | boolean | false | If true, the cache store will only be used to load entries. Any modifications made to the caches will not be applied to the store. |
| max-batch-size | int | 100 | The maximum size of a batch to be inserted/deleted from the store. If the value is less than one, then no upper limit is placed on the number of operations in a batch. |
write-behind?
Configures a cache store as write-behind instead of write-through.
| Name | Type | Default | Description |
|---|---|---|---|
| modification-queue-size | int | 1024 | Maximum number of entries in the asynchronous queue. When the queue is full, the store becomes write-through. until it can accept new entries |
| thread-pool-size | int | 1 | Size of the thread pool whose threads are responsible for applying the modifications to the cache store. |
| fail-silently | boolean | false | If true, the async store attempts to perform write operations only as many times as configured with `connection-attempts` in the PersistenceConfiguration. If all attempts fail, the errors are ignored and the write operations are not executed on the store. If false, write operations that fail are attempted again when the underlying store becomes available. If the modification queue becomes full before the underlying store becomes available, an error is thrown on all future write operations to the store until the modification queue is flushed. The modification queue is not persisted. If the underlying store does not become available before the Async store is stopped, queued modifications are lost. |
property*
A cache store property with name and value.