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

create-on-start atribute ignored for jdbc stores

    XMLWordPrintable

Details

    • Bug
    • Resolution: Done
    • Major
    • 9.2.1.Final
    • 9.2.0.Final
    • Server
    • 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>

      Attachments

        Activity

          People

            ttarrant@redhat.com Tristan Tarrant
            ttarrant@redhat.com Tristan Tarrant
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: