Uploaded image for project: 'JBoss Enterprise Application Platform'
  1. JBoss Enterprise Application Platform
  2. JBEAP-14028

Database cache store section missing in Configuration Guide

    XMLWordPrintable

Details

    • Enhancement
    • Resolution: Won't Do
    • Minor
    • None
    • None
    • Documentation

    Description

      EAP documentation, book Configuration Guide, chapter Infinispan should contain under section "23.3.7. Externalize HTTP Sessions to JBoss Data Grid" new section related to cache store configuration (e.g.: Store HTTP session into database). This section should cover how to configure Infinispan subsystem to use database as a store for http sessions. It should describe how to add new replicated cache with jdbc-store and table including columns definition (similar to Change to Replicated Cache Mode paragraph). Because jdbc-store uses data-source as one of the mandatory parameters, there should be mentioned how to add such a data-source or link into a section of the book where are those steps described.

      There should be also emphasised that the generated table name is based on the deployment and sub-deployment names. In case of Oracle database this table name can exceed maximum identifier length allowed causing errors when creating the table. This problem does not occur in Oracle 12.2 or higher where the identifier size limit is configurable. This issue was earlier covered by JBEAP-11349, more details can be found here JBEAP-11269.

      Example of the replication cache with string-keyed-jdbc-store configured:

      <replicated-cache name="offload" mode="SYNC">
         <locking isolation="REPEATABLE_READ"/>
         <transaction mode="BATCH"/>
         <string-keyed-jdbc-store data-source="testDS" preload="true" passivation="false" purge="false" shared="true" dialect="ORACLE">
            <string-keyed-table prefix="s">
               <id-column name="id" type="VARCHAR(255)"/>
               <data-column name="datum" type="BLOB"/>
               <timestamp-column name="ver" type="NUMBER"/>
            </string-keyed-table>
         </string-keyed-jdbc-store>
      </replicated-cache>
      

      Attachments

        Issue Links

          Activity

            People

              jsese@redhat.com Jocelyn Sese
              dcihak@redhat.com Daniel Cihak
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: