[jboss-user] [JBoss Cache Users] - Preventing JBoss Cache from recreating dummy table?

[drcallaway]

In addition to the standard "jbosscache" table that contains all of the cache data (when using the JDBCCacheLoader), JBoss Cache also creates a dummy table named "jbosscache_D". This table seems to get recreated every time the cache is started. The AdjListJDBCCacheLoader class's start() method calls a method named createDummyTableIfNeeded() that, despite its name, always drops and recreates the dummy table. Unfortunately, our DBAs do not want to grant the JBoss Cache database user "create table" privileges in production. This isn't an issue with the "jbosscache" table since there is a setting in the config file indicating whether or not this table should be recreated if it already exists. However, I haven't found any such setting for "jbosscache_D".

So, can anyone tell me if there is a way to prevent JBoss Cache from creating the dummy table (we'd rather have a DBA pre-create that table using an admin user).

Thanks!

Dustin

View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=4259257#4259257

Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=4259257