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

[Anna Manukyan (JIRA)]

    [ https://issues.jboss.org/browse/ISPN-2548?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12737014#comment-12737014 ] 

Anna Manukyan commented on ISPN-2548:
-------------------------------------

Hi Tristan,

we have tried out the new query sent by you, but it gives the same exception described in the jobs logs file.

E.g. 
 There is already an object named 'edg_bin____defaultcache' in the database.

Best regards,
Anna.
                
> JDBCCacheStore doesn't work propertly with MSSql 
> -------------------------------------------------
>
>                 Key: ISPN-2548
>                 URL: https://issues.jboss.org/browse/ISPN-2548
>             Project: Infinispan
>          Issue Type: Bug
>          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