[infinispan-issues] [JBoss JIRA] (ISPN-2548) JDBCCacheStore doesn't work propertly with MSSql

JDBCCacheStore doesn't work propertly with MSSql ------------------------------------------------- Key: ISPN-2548 URL: https://issues.jboss.org/browse/ISPN-2548 Project: Infinispan Issue Type: Feature Request Components: Loaders and Stores Affects Versions: 5.2.0.Beta4 Reporter: Anna Manukyan Assignee: Mircea Markus 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: {code} 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 {code} 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.