[infinispan-issues] [JBoss JIRA] (ISPN-12098) JDBC String Base Cache Store (sybase160) trying to create an index when already exist

[Gustavo Lira e Silva (Jira)]

Gustavo Lira e Silva created ISPN-12098:
-------------------------------------------

             Summary: JDBC String Base Cache Store (sybase160) trying to create an index when already exist
                 Key: ISPN-12098
                 URL: https://issues.redhat.com/browse/ISPN-12098
             Project: Infinispan
          Issue Type: Bug
    Affects Versions: 11.0.1.Final
            Reporter: Gustavo Lira e Silva
            Assignee: Gustavo Lira e Silva


Using JDBC String based Cache Store + sybase 160 is throwing the following exception:

 

 
{noformat}
Caused by: com.sybase.jdbc4.jdbc.SybSQLException:
There is already an index on table 'ISPN_STRING_StringBasedCache' named '"ISPN_STRING_StringBasedCache_timestamp_index"'
{noformat}
 

Sybase is storing indexes into the database with double quotes

This line https://github.com/infinispan/infinispan/blob/master/persistence/jdbc/src/main/java/org/infinispan/persistence/jdbc/impl/table/AbstractTableManager.java#L175 will be always false with sybase according to the above explanation.

 



--
This message was sent by Atlassian Jira
(v7.13.8#713008)