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

JDBCCacheStore doesn't work propertly with MSSql

    XMLWordPrintable

Details

    Description

      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.

      Attachments

        Issue Links

          relates to

          Feature Request - Feature requests from customers and/or users ISPN-4229 The JDBC Cache store should not require the schema name configuration

          • Major - To be worked after higher priority work items are addressed. When the severity is high and the effort to change it is low to moderate, this term is chosen. Issues in this category likely have an existing workaround but implementation or execution may be non-trivial.
          • Open

          Activity

            Public project attachment banner

              context keys: [headless, issue, helper, isAsynchronousRequest, project, action, user]
              current Project key: ISPN

              People

                mircea.markus Mircea Markus (Inactive)
                amanukya@redhat.com Anna Manukyan
                Votes:
                0 Vote for this issue
                Watchers:
                5 Start watching this issue

                Dates

                  Created:
                  Updated:
                  Resolved: