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

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
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated:
              Resolved: