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

[Gustavo Lira e Silva (Jira)]

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

Gustavo Lira e Silva updated ISPN-12098:
----------------------------------------
    Summary: JDBC String Base Cache Store (sybase160) is trying to create an index when already exist  (was: JDBC String Base Cache Store (sybase160) trying to create an index when already exist)


> JDBC String Base Cache Store (sybase160) is 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
>            Priority: Major
>
> 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)