"Last year I proposed an enhancement allowing to use the implicit db schema to ease life of end-user, unfortunately it seems that it affects the startup time of the product when the tables contain a lot of rows. Indeed the query can take several seconds to return a result. The idea of this task would be to optimize this query for all supported databases in order to avoid this drawback." "It seems that the Query for MS SQL doesn't work on MS SQL 2008 R2, it should be SELECT count(*) from (SELECT TOP (1) 1 as C FROM " + tableName + ") T "
Needed for JBoss Portal 6.2
This has been fixed since Infinispan 5.2.0 and is contained in Infinispan 5.2.9 (nothing to do here)
Closing based on comment #2.