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

create-on-start atribute ignored for jdbc stores

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Done
    • Icon: Major Major
    • 9.2.1.Final
    • 9.2.0.Final
    • Server
    • None

      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>
      

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

                Created:
                Updated:
                Resolved: