Author: manik.surtani(a)jboss.com Date: 2009-01-26 05:49:29 -0500 (Mon, 26 Jan 2009) New Revision: 7595 Modified: core/branches/flat/src/test/resources/cache-jdbc.properties Log: Default testing JDBC settings Modified: core/branches/flat/src/test/resources/cache-jdbc.properties =================================================================== --- core/branches/flat/src/test/resources/cache-jdbc.properties 2009-01-26 10:24:58 UTC (rev 7594) +++ core/branches/flat/src/test/resources/cache-jdbc.properties 2009-01-26 10:49:29 UTC (rev 7595) @@ -3,19 +3,15 @@ # 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 -cache.jdbc.table.primarykey=jbosscache_pk -cache.jdbc.fqn.column=fqn -cache.jdbc.fqn.type=varchar(255) -cache.jdbc.node.column=node -cache.jdbc.node.type=blob -cache.jdbc.parent.column=parent +# Microsoft SQL Server & DB2 - schema name corresponds to the catalog owner -# JBoss Cache Table properties for Hypersonic, just overrides -#cache.jdbc.node.type=OBJECT +horizon.jdbc.table.name=horizon +horizon.jdbc.table.create=true +horizon.jdbc.table.drop=false +horizon.jdbc.table.primarykey=CACHE_KEY +horizon.jdbc.key.column=CACHE_KEY +horizon.jdbc.key.type=VARCHAR(255) +horizon.jdbc.node.column=CACHE_VALUE ## # DataSource @@ -25,41 +21,46 @@ # JDBC driver specific properties # Hypersonic -#cache.jdbc.node.type=OBJECT +cache.jdbc.node.type=BINARY +cache.jdbc.driver = org.hsqldb.jdbcDriver +cache.jdbc.url=jdbc:hsqldb:mem:horizondb +cache.jdbc.user=sa +cache.jdbc.password= + ## MySql #cache.jdbc.driver=com.mysql.jdbc.Driver -#cache.jdbc.url=jdbc:mysql://localhost:3306/jbossdb +#cache.jdbc.url=jdbc:mysql://localhost:3306/horizondb #cache.jdbc.user=root #cache.jdbc.password=admin ## Oracle #cache.jdbc.driver=oracle.jdbc.OracleDriver -#cache.jdbc.url=jdbc:oracle:thin:@192.168.0.100:1521:JBOSSDB -#cache.jdbc.user=jboss -#cache.jdbc.password=sa +#cache.jdbc.url=jdbc:oracle:thin:@192.168.0.100:1521:HORIZONDB +#cache.jdbc.user=scott +#cache.jdbc.password=tiger ## MS Sql Server #cache.jdbc.driver=com.microsoft.jdbc.sqlserver.SQLServerDriver -#cache.jdbc.url=jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=jbossdb;SelectMethod=cursor +#cache.jdbc.url=jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=horizondb;SelectMethod=cursor #cache.jdbc.user=sa #cache.jdbc.password= #cache.jdbc.node.type=image ## Pointbase #cache.jdbc.driver=com.pointbase.jdbc.jdbcUniversalDriver -#cache.jdbc.url=jdbc:pointbase:server://localhost:9092/jboss,new +#cache.jdbc.url=jdbc:pointbase:server://localhost:9092/horizon,new #cache.jdbc.user=PBPUBLIC #cache.jdbc.password=PBPUBLIC ## PostgreSQL #cache.jdbc.driver = org.postgresql.Driver -#cache.jdbc.url=jdbc:postgresql://192.168.0.100:5432/jbossdb +#cache.jdbc.url=jdbc:postgresql://192.168.0.100:5432/horizondb #cache.jdbc.user=postgres #cache.jdbc.password=admin ## Derby -cache.jdbc.driver = org.apache.derby.jdbc.EmbeddedDriver -cache.jdbc.url=jdbc:derby:jbossdb;create=true -cache.jdbc.user=user1 -cache.jdbc.password=user1 \ No newline at end of file +#cache.jdbc.driver = org.apache.derby.jdbc.EmbeddedDriver +#cache.jdbc.url=jdbc:derby:horizondb;create=true +#cache.jdbc.user=user1 +#cache.jdbc.password=user1 \ No newline at end of file