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

[Anna Manukyan (JIRA)]

Anna Manukyan created ISPN-2548:
-----------------------------------

             Summary: 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.

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira