Uploaded image for project: 'Infinispan'
  1. Infinispan
  2. ISPN-8992

create-on-start atribute ignored for jdbc stores

    Details

    • Type: Bug
    • Status: Resolved (View Workflow)
    • Priority: Major
    • Resolution: Done
    • Affects Version/s: 9.2.0.Final
    • Fix Version/s: 9.2.1.Final
    • Component/s: Server
    • Labels:
      None

      Description

      Using JDBC persistence on cache causes errors "TABLE JDG_xxx ALREADY exists" on Mysql, when stopping and starting the server. The attribute create-on-start which would prevent creation of the tables is currently ignored.

      <string-keyed-jdbc-store datasource="java:jboss/MySqlDS" passivation="false" preload="true" purge="false" shared="true">
            <property name="databaseType">MYSQL</property>
             <string-keyed-table prefix="JDG" create-on-start="false">
                 <id-column name="id" type="VARCHAR(100)"/>
                 <data-column name="datum" type="BLOB"/>
                 <timestamp-column name="version" type="BIGINT"/>
             </string-keyed-table>
      </string-keyed-jdbc-store>
      

        Gliffy Diagrams

          Attachments

            Activity

              People

              • Assignee:
                NadirX Tristan Tarrant
                Reporter:
                NadirX Tristan Tarrant
              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: