Author: mircea.markus Date: 2007-09-28 11:07:03 -0400 (Fri, 28 Sep 2007) New Revision: 4517 Modified: core/trunk/src/main/resources/cache-jdbc.properties core/trunk/src/test/java/org/jboss/cache/loader/JDBCCacheLoaderTest.java Log: http://jira.jboss.com/jira/browse/JBCACHE-1099 Modified: core/trunk/src/main/resources/cache-jdbc.properties =================================================================== --- core/trunk/src/main/resources/cache-jdbc.properties 2007-09-27 15:56:20 UTC (rev 4516) +++ core/trunk/src/main/resources/cache-jdbc.properties 2007-09-28 15:07:03 UTC (rev 4517) @@ -1,5 +1,9 @@ ## # Standard JBC table properties +# The table name can also be prepended with schema name for the given table. +# Even though there is an Sql92 standard syntax for this: <schema_name>.<table name> +#schema has different meanings accross various DBMS: Oracle - user name; PointBase - database name +# Microsoft SQL Server & DB2 - schema name corresponds to the catalog owner cache.jdbc.table.name=jbosscache cache.jdbc.table.create=true cache.jdbc.table.drop=false Modified: core/trunk/src/test/java/org/jboss/cache/loader/JDBCCacheLoaderTest.java =================================================================== --- core/trunk/src/test/java/org/jboss/cache/loader/JDBCCacheLoaderTest.java 2007-09-27 15:56:20 UTC (rev 4516) +++ core/trunk/src/test/java/org/jboss/cache/loader/JDBCCacheLoaderTest.java 2007-09-28 15:07:03 UTC (rev 4517) @@ -10,6 +10,7 @@ import static org.testng.AssertJUnit.assertNull; import static org.testng.AssertJUnit.assertTrue; import static org.testng.AssertJUnit.fail; +import org.testng.annotations.Test; import java.util.Properties; @@ -29,6 +30,7 @@ * @author <a href="mailto:galder.zamarreno@jboss.com">Galder Zamarreno</a> * @version <tt>$Revision$</tt> */ +@Test(groups = {"functional"}) public class JDBCCacheLoaderTest extends CacheLoaderTestsBase { protected void configureCache() throws Exception @@ -40,7 +42,8 @@ "cache.jdbc.user=" + prop.getProperty("cache.jdbc.user") + "\n" + "cache.jdbc.password=" + prop.getProperty("cache.jdbc.password") + "\n" + "cache.jdbc.node.type=" + prop.getProperty("cache.jdbc.node.type") + "\n" + - "cache.jdbc.sql-concat=" + prop.getProperty("cache.jdbc.sql-concat"); + "cache.jdbc.sql-concat=" + prop.getProperty("cache.jdbc.sql-concat") + "\n" + + "cache.jdbc.table.name=" + prop.getProperty("cache.jdbc.table.name"); cache.getConfiguration().setCacheLoaderConfig(getSingleCacheLoaderConfig("", "org.jboss.cache.loader.JDBCCacheLoader", props, false, true, false));