]
Tristan Tarrant updated ISPN-8992:
----------------------------------
Status: Pull Request Sent (was: Open)
Git Pull Request:
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}