JBoss Community

JBoss Cache 3.2.2.GA - table or view does not exist error

reply from Anitha Kothandapani in JBoss Cache - View the full discussion

Huray . After going through the source code of Jboss cache , I got to know that, it was the problem with my configuration (cache-config.xml).

 

Since we have multiple schema in our db, the table name should be prefixed with the schema name before the table name like this below


 cache.jdbc.table.name=<SCHEMA_NAME>.<TABLE_NAME>

 

Since the dummy table got created in one such schema in the db, the AdjListJDBCCacheLoader:tableExists method returned true in our case. So after appending the <SCHEMA_NAME> in the cache-config.xml, the dummy table got created in my schema.

 

So if you are multiple schema in the same db , then append the <SCHEMA_NAME>. before the table name. Since the implementation of databaseMetaData.getTables(catalog, schema, tableName, null); expects the schema name before the table name.

Reply to this message by going to Community

Start a new discussion in JBoss Cache at Community