[infinispan-issues] [JBoss JIRA] (ISPN-8992) create-on-start atribute ignored for jdbc stores

[Tristan Tarrant (JIRA)]

     [ https://issues.jboss.org/browse/ISPN-8992?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Tristan Tarrant updated ISPN-8992:
----------------------------------
    Status: Open  (was: New)


> create-on-start atribute ignored for jdbc stores
> ------------------------------------------------
>
>                 Key: ISPN-8992
>                 URL: https://issues.jboss.org/browse/ISPN-8992
>             Project: Infinispan
>          Issue Type: Bug
>          Components: Server
>    Affects Versions: 9.2.0.Final
>            Reporter: Tristan Tarrant
>            Assignee: Tristan Tarrant
>             Fix For: 9.2.1.Final
>
>
> 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.
> {code:xml}
> <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>
> {code}



--
This message was sent by Atlassian JIRA
(v7.5.0#75005)