This content has been marked as final.
Show 1 reply
-
1. Re: JBoss Cache 3.2.2.GA - table or view does not exist error
anithakothandapani Jun 28, 2010 12:37 AM (in response to anithakothandapani)Huray . After going through the source code of Jboss cache , I got to know thatthe problem is with my configuration in 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 (expected 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.