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

JDBCCacheStore doesn't work propertly with MSSql

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
    • 5.2.0.Final
    • 5.2.0.Final
    • Loaders and Stores
    • None

      The functional tests for JDBCCacheStore using MSSQL2008 R2 as a store, are failing.

      In case if the configuration is set with properties:

      .addProperty("dropTableOnExit", "false")
      .addProperty("createTableOnStart", "true")

      The following exception arrise:

       org.infinispan.loaders.CacheLoaderException: com.microsoft.sqlserver.jdbc.SQLServerException: There is already an object named 'edg_bin____defaultcache' in the database.
      	at org.infinispan.loaders.jdbc.TableManipulation.executeUpdateSql(TableManipulation.java:187)
      	at org.infinispan.loaders.jdbc.TableManipulation.createTable(TableManipulation.java:160)
      	at org.infinispan.loaders.jdbc.TableManipulation.start(TableManipulation.java:262)
      	at org.infinispan.loaders.jdbc.binary.JdbcBinaryCacheStore.doConnectionFactoryInitialization(JdbcBinaryCacheStore.java:514)
      	at org.infinispan.loaders.jdbc.binary.JdbcBinaryCacheStore.start(JdbcBinaryCacheStore.java:102)
      	at org.infinispan.loaders.CacheLoaderManagerImpl.start(CacheLoaderManagerImpl.java:159)
      	... 104 more
      

      Please note, that MSSql database is clean before the test run, this means that the table is not there. But the exception is in place anyway.

              mircea.markus Mircea Markus (Inactive)
              amanukya@redhat.com Anna Manukyan
              Archiver:
              rhn-support-adongare Amol Dongare

                Created:
                Updated:
                Resolved:
                Archived: