WildFly Full 19.1 Model Reference

  1. home
  2. subsystem=infinispan
  3. cache-container
  4. scattered-cache
  5. store=mixed-jdbc
  6. table=string

Defines a table used to store cache entries whose keys can be expressed as strings.

Attributes (8)

  • batch-size For DB inserts, the batch size determines how many inserts are batched together.
    • Deprecated Since 6.0.0
    Deprecated. Use max-batch-size instead.
    Attribute Value
    Default Value 100
    Type INT
    Nillable true
    Expressions Allowed true
    Storage configuration
    Access Type read-write
    Restart Required resource-services
  • create-on-start Indicates whether the store should create this database table when the cache starts.
    • Attribute Value
    Default Value true
    Type BOOLEAN
    Nillable true
    Expressions Allowed true
    Storage configuration
    Access Type read-write
    Restart Required resource-services
  • data-column A database column to hold cache entry data.
    • Attribute Value
    Type OBJECT
    Nillable true
    Expressions Allowed false
    Storage configuration
    Access Type read-write
    Restart Required no-services
  • drop-on-stop Indicates whether the store should drop this database table when the cache stops.
    • Attribute Value
    Default Value false
    Type BOOLEAN
    Nillable true
    Expressions Allowed true
    Storage configuration
    Access Type read-write
    Restart Required resource-services
  • fetch-size For DB queries, the fetch size will be used to set the fetch size on ResultSets.
    • Attribute Value
    Default Value 100
    Type INT
    Nillable true
    Expressions Allowed true
    Storage configuration
    Access Type read-write
    Restart Required resource-services
  • id-column A database column to hold cache entry ids.
    • Attribute Value
    Type OBJECT
    Nillable true
    Expressions Allowed false
    Storage configuration
    Access Type read-write
    Restart Required no-services
  • prefix The prefix for the database table name.
    • Attribute Value
    Default Value ispn_entry
    Type STRING
    Nillable true
    Expressions Allowed true
    Storage configuration
    Access Type read-write
    Restart Required resource-services
  • timestamp-column A database column to hold cache entry timestamps.
    • Attribute Value
    Type OBJECT
    Nillable true
    Expressions Allowed false
    Storage configuration
    Access Type read-write
    Restart Required no-services

Operations (2)

  • add Adds a table used to store cache entries whose keys can be expressed as strings.
    Request Parameter Type Required Expressions Allowed Default value Description
    prefix STRING false true ispn_entry The prefix for the database table name.
    fetch-size INT false true 100 For DB queries, the fetch size will be used to set the fetch size on ResultSets.
    create-on-start BOOLEAN false true true Indicates whether the store should create this database table when the cache starts.
    drop-on-stop BOOLEAN false true false Indicates whether the store should drop this database table when the cache stops.
    id-column OBJECT false false A database column to hold cache entry ids.
    data-column OBJECT false false A database column to hold cache entry data.
    timestamp-column OBJECT false false A database column to hold cache entry timestamps.
    batch-size INT false true 100 For DB inserts, the batch size determines how many inserts are batched together.
  • remove Removes a table used to store cache entries whose keys can be expressed as strings.