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));