schema.infinispan-cachestore-sql-config-15.0.xsd Maven / Gradle / Ivy
Go to download
Show more of this group Show more artifacts with this name
Show all versions of infinispan-cachestore-sql Show documentation
Show all versions of infinispan-cachestore-sql Show documentation
Infinispan SQL CacheStore module
Specifies a database table that loads entries to the cache and stores data from the cache.
The SQL cache store automatically generates statements based on the database dialect to perform all operations.
Every field in the schema must be readable from the columns in the database table.
If the SQL cache store does not allow modifications to the database, is read only, then tables can have more columns than the schema defines.
Specifies the columns from the database table that correspond to key(s).
Use commas (,) to separate multiple columns.
Specifies the Protobuf message name to use for the value of the cache entry.
If the database table contains only one column for the value, you do not need to specify a message name and an appropriate data type is automatically used.
Specifies the Protobuf message name to use for the key of the cache entry.
If the database table contains only one column for the key, you do not need to specify a message name and an appropriate data type is automatically used.
Specifies the package for key and value message names.
You must specify a package if you set the 'key-message-name' or
'message-name' attributes.
Specifies if key field(s) are also part of the value schema.
Defines a SQL query that bulk loads cache entries from a database.
You can use an asterisk operator in the SELECT clause.
You can use parameters only if you explicitly define them in the statement, for example "WHERE FOO = 'BAR'"".
Columns that this query returns must match the columns that the 'select-single' query returns.
Columns must also match Protobuf schema for composite keys and values exactly.
Defines a SQL query that loads cache entries from a database.
You can use an asterisk operator in the SELECT clause.
You must include every field from the key schema as a named parameter, for example "FOO = :bar".
Columns that this query returns must match the columns that the 'select-all' query returns.
Columns must also match Protobuf schema for composite keys and values exactly.
Defines a SQL query to clear the cache.
This attribute is required if you configure the SQL cache store to allow modifications to the database.
You can use parameters only if you explicitly define them in the statement, for example "WHERE FOO = 'BAR'"".
Defines a SQL query to delete specific entries from the cache.
This attribute is required if you configure the SQL cache store to allow modifications to the database.
You must include every field from the key schema as a named parameter, for example "FOO = :bar".
Defines a SQL query to modify entries in the cache.
This attribute is required if you configure the SQL cache store to allow modifications to the database.
You must include every field from the key and value schema as a named parameter, for example "FOO = :bar".
Defines a SQL query to count the number of entries in the cache.
You can use parameters only if you explicitly define them in the statement, for example "WHERE FOO = 'BAR'"".