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

JDBC String Base Cache Store (sybase160) is trying to create an index when already exist

This issue belongs to an archived project. You can view it, but you can't modify it. Learn more

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Done
    • Icon: Major Major
    • 12.0.0.Final
    • 11.0.1.Final
    • None
    • None

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

       

       

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

       

      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.

       

              gustavolira Gustavo Lira Silva
              gustavolira Gustavo Lira Silva
              Archiver:
              rhn-support-adongare Amol Dongare

                Created:
                Updated:
                Resolved:
                Archived: