8:13 a.m.
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
8:19 a.m.
[
https://issues.jboss.org/browse/ISPN-2548?page=com.atlassian.jira.plugin....
]
RH Bugzilla Integration updated ISPN-2548:
------------------------------------------
Bugzilla Update: Perform
Bugzilla References: https://bugzilla.redhat.com/show_bug.cgi?id=879635
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
8:19 a.m.
[
https://issues.jboss.org/browse/ISPN-2548?page=com.atlassian.jira.plugin....
]
RH Bugzilla Integration commented on ISPN-2548:
-----------------------------------------------
Anna Manukyan <amanukya(a)redhat.com> made a comment on [bug
879635|https://bugzilla.redhat.com/show_bug.cgi?id=879635]
The functional tests for JDBCCacheStore using MSSQL2008 R2 as a store, are failing.
You can find the tests here:
https://svn.devel.redhat.com/repos/jboss-qa/jdg/jdg-functional-tests/trun...
https://svn.devel.redhat.com/repos/jboss-qa/jdg/jdg-functional-tests/trun...
https://svn.devel.redhat.com/repos/jboss-qa/jdg/jdg-functional-tests/trun...
The test failures can be found here:
http://jenkins.mw.lab.eng.bos.redhat.com/hudson/job/edg-60-jdbc-cache-sto...
https://jenkins.mw.lab.eng.bos.redhat.com/hudson/job/edg-60-jdbc-cache-st...
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
8:43 a.m.
[
https://issues.jboss.org/browse/ISPN-2548?page=com.atlassian.jira.plugin....
]
RH Bugzilla Integration commented on ISPN-2548:
-----------------------------------------------
Anna Manukyan <amanukya(a)redhat.com> made a comment on [bug
879635|https://bugzilla.redhat.com/show_bug.cgi?id=879635]
Also, please note - that the tests were working properly with JDG6.1.0.ER2
(Infinispan-5.2.0.Beta2 version).
I've noticed that on 9th of November, there were some changes done in
TableManipulation to tableExists() method, where the query for defining whether the table
exists in DB or not is generated according to the database type.
So we just tried the previous query for SQL_SERVER database, to find out whether the issue
is really in Infinispan or it is on database side, and our change worked.
The current code is (org.infinispan.loaders.jdbc.TableManipulation.tableExists(Connection
connection, String tableName) line 123:
...........
case SQL_SERVER:
query = "SELECT count(*) from (SELECT TOP (1) 1 FROM " + tableName + ")
T";
break;
...........
We changed to:
.............
case SQL_SERVER:
query = "SELECT count(*) FROM " + tableName;
break;
.............
This solution works.
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
8:47 a.m.
[
https://issues.jboss.org/browse/ISPN-2548?page=com.atlassian.jira.plugin....
]
Anna Manukyan updated ISPN-2548:
--------------------------------
Issue Type: Bug (was: Feature Request)
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
8:05 a.m.
[
https://issues.jboss.org/browse/ISPN-2548?page=com.atlassian.jira.plugin....
]
RH Bugzilla Integration commented on ISPN-2548:
-----------------------------------------------
Tristan Tarrant <ttarrant(a)redhat.com> made a comment on [bug
879635|https://bugzilla.redhat.com/show_bug.cgi?id=879635]
Anna, the intention of the complex query above was to minimize the effort the database
uses to discover if the table exists when a table is very large.
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
8:27 a.m.
[
https://issues.jboss.org/browse/ISPN-2548?page=com.atlassian.jira.plugin....
]
Anna Manukyan commented on ISPN-2548:
-------------------------------------
Yup, I understand Tristan. But the fact is this doesn't work for MsSQl.
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
8:43 a.m.
[
https://issues.jboss.org/browse/ISPN-2548?page=com.atlassian.jira.plugin....
]
Tristan Tarrant commented on ISPN-2548:
---------------------------------------
Anna, I don't have an instance of SQL Server here, can you try the following query
please ?
query = "SELECT count(*) from (SELECT TOP (1) FROM " + tableName + ")
T";
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
10:14 a.m.
[
https://issues.jboss.org/browse/ISPN-2548?page=com.atlassian.jira.plugin....
]
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
10:32 a.m.
[
https://issues.jboss.org/browse/ISPN-2548?page=com.atlassian.jira.plugin....
]
Tristan Tarrant commented on ISPN-2548:
---------------------------------------
Anna can you run the test with trace logs enabled please ?
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
1:51 a.m.
[
https://issues.jboss.org/browse/ISPN-2548?page=com.atlassian.jira.plugin....
]
RH Bugzilla Integration commented on ISPN-2548:
-----------------------------------------------
Martin Gencur <mgencur(a)redhat.com> made a comment on [bug
879635|https://bugzilla.redhat.com/show_bug.cgi?id=879635]
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
9:33 a.m.
[
https://issues.jboss.org/browse/ISPN-2548?page=com.atlassian.jira.plugin....
]
Tristan Tarrant updated ISPN-2548:
----------------------------------
Status: Pull Request Sent (was: Open)
Git Pull Request: https://github.com/infinispan/infinispan/pull/1486
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
4:05 a.m.
[
https://issues.jboss.org/browse/ISPN-2548?page=com.atlassian.jira.plugin....
]
RH Bugzilla Integration commented on ISPN-2548:
-----------------------------------------------
Tristan Tarrant <ttarrant(a)redhat.com> changed the Status of [bug
879635|https://bugzilla.redhat.com/show_bug.cgi?id=879635] from NEW to ASSIGNED
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
5:33 a.m.
[
https://issues.jboss.org/browse/ISPN-2548?page=com.atlassian.jira.plugin....
]
Adrian Nistor updated ISPN-2548:
--------------------------------
Fix Version/s: 5.2.0.CR1
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
Fix For: 5.2.0.CR1
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
5:35 a.m.
[
https://issues.jboss.org/browse/ISPN-2548?page=com.atlassian.jira.plugin....
]
Adrian Nistor updated ISPN-2548:
--------------------------------
Status: Resolved (was: Pull Request Sent)
Resolution: Done
Integrated. Thanks!
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
Fix For: 5.2.0.CR1
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
9:09 a.m.
[
https://issues.jboss.org/browse/ISPN-2548?page=com.atlassian.jira.plugin....
]
RH Bugzilla Integration commented on ISPN-2548:
-----------------------------------------------
Tristan Tarrant <ttarrant(a)redhat.com> changed the Status of [bug
879635|https://bugzilla.redhat.com/show_bug.cgi?id=879635] from ASSIGNED to MODIFIED
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
Fix For: 5.2.0.CR1
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
3:35 a.m.
[
https://issues.jboss.org/browse/ISPN-2548?page=com.atlassian.jira.plugin....
]
Tristan Tarrant updated ISPN-2548:
----------------------------------
Fix Version/s: 5.2.0.Beta5
(was: 5.2.0.CR1)
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
Fix For: 5.2.0.Beta5
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
3:19 p.m.
[
https://issues.jboss.org/browse/ISPN-2548?page=com.atlassian.jira.plugin....
]
RH Bugzilla Integration commented on ISPN-2548:
-----------------------------------------------
Tristan Tarrant <ttarrant(a)redhat.com> changed the Status of [bug
879635|https://bugzilla.redhat.com/show_bug.cgi?id=879635] from MODIFIED to ON_QA
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
Fix For: 5.2.0.Beta5, 5.2.0.Final
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
4399
days inactive
4411
days old
infinispan-issues@lists.jboss.org
17 comments
4 participants
participants (4)
-
Adrian Nistor (JIRA) -
Anna Manukyan (JIRA)
-
RH Bugzilla Integration (JIRA)
-
Tristan Tarrant (JIRA)