From do-not-reply at jboss.org Wed Jun 15 10:51:52 2011 Content-Type: multipart/mixed; boundary="===============0274992619334439988==" MIME-Version: 1.0 From: do-not-reply at jboss.org To: exo-jcr-commits at lists.jboss.org Subject: [exo-jcr-commits] exo-jcr SVN: r4545 - jcr/trunk/exo.jcr.docs/exo.jcr.docs.developer/en/src/main/docbook/en-US/modules/jcr/configuration. Date: Wed, 15 Jun 2011 10:51:52 -0400 Message-ID: <201106151451.p5FEpqhj024711@svn01.web.mwc.hst.phx2.redhat.com> --===============0274992619334439988== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: quoted-printable Author: dkuleshov Date: 2011-06-15 10:51:52 -0400 (Wed, 15 Jun 2011) New Revision: 4545 Modified: jcr/trunk/exo.jcr.docs/exo.jcr.docs.developer/en/src/main/docbook/en-US/= modules/jcr/configuration/jdbc-data-container-config.xml Log: EXOJCR-1332: added table with sql-scripts = Modified: jcr/trunk/exo.jcr.docs/exo.jcr.docs.developer/en/src/main/docbook= /en-US/modules/jcr/configuration/jdbc-data-container-config.xml =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D --- jcr/trunk/exo.jcr.docs/exo.jcr.docs.developer/en/src/main/docbook/en-US= /modules/jcr/configuration/jdbc-data-container-config.xml 2011-06-15 08:58:= 38 UTC (rev 4544) +++ jcr/trunk/exo.jcr.docs/exo.jcr.docs.developer/en/src/main/docbook/en-US= /modules/jcr/configuration/jdbc-data-container-config.xml 2011-06-15 14:51:= 52 UTC (rev 4545) @@ -52,7 +52,7 @@ = - HSQLDB (1.8.0.7) + HSQLDB (2.0.0) = @@ -67,6 +67,166 @@ of the database, it's possible to do that by editing the metadata SQL-script files. = + SQL-scripts are located under + 'jcr/trunk/exo.jcr.component.core/src/main/resources/conf/storage' pat= h. + Or can be found at SVN here. + + In the next two tables correspondence between the scripts and + databases is shown. + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
Single-database
MySQL DBjcr-sjdbc.mysql.sql
MySQL DB with utf-8jcr-sjdbc.mysql-utf8.sql
MS SQL Serverjcr-sjdbc.mssql.sql
PostgresSQLjcr-sjdbc.pqsql.sql
DB2 9.xjcr-sjdbc.db2.sql
DB2 8.xjcr-sjdbc.db2v8.sql
HSQLDBjcr-sjdbc.h2.sql
Sybasejcr-sjdbc.sybase.sql
Oracle DBjcr-sjdbc.ora.sql
Oracle DB analyzejcr-sjdbc.ora-analyze.sql
Ingres DBjcr-sjdbc.ingres.sql
Derby DBjcr-sjdbc.derby.sql
+ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
Multi-database
MySQL DBjcr-mjdbc.mysql.sql
MySQL DB with utf-8jcr-mjdbc.mysql-utf8.sql
MS SQL Serverjcr-mjdbc.mssql.sql
PostgresSQLjcr-mjdbc.pqsql.sql
DB2 9.xjcr-mjdbc.db2.sql
DB2 8.xjcr-mjdbc.db2v8.sql
HSQLDBjcr-mjdbc.h2.sql
Sybasejcr-mjdbc.sybase.sql
Oracle DBjcr-mjdbc.ora.sql
Oracle DB analyzejcr-mjdbc.ora-analyze.sql
Ingres DBjcr-mjdbc.ingres.sql
Derby DBjcr-mjdbc.derby.sql
+ In case the non-ANSI node name is used, it's necessary to use a database with MultiLanguage support[TODO link to MultiLanguage]. Some = JDBC drivers need additional parameters for establishing a Unicode friendly @@ -106,7 +266,7 @@ For example (standalone mode, two data containers jdbcjcr - local HSQLDB, jdbcjcr1 - remote MySQL): - = + <component> <key>org.exoplatform.services.naming.InitialContextInitializer&l= t;/key> <type>org.exoplatform.services.naming.InitialContextInitializer&= lt;/type> @@ -225,10 +385,9 @@ repository service. Each workspace will be configured for its own data container. = - For example (two workspaces = - ws - jdbcjcr, + For example (two workspaces ws - jdbcjcr, ws1 - jdbcjcr1): - = + <workspaces> <workspace name=3D"ws" auto-init-root-nodetype=3D"nt:unstructured"> <container class=3D"org.exoplatform.services.jcr.impl.storage.jdbc.= JDBCWorkspaceDataContainer"> @@ -293,36 +452,36 @@ </workspaces> = - - - source-name: A javax.sql.DataSource - name configured in InitialContextInitializer component (was - sourceName prior JCR 1.9); - + + + source-name: A javax.sql.DataSource n= ame + configured in InitialContextInitializer component (was + sourceName prior JCR 1.9); + = - - dialect: A database dialect, one of - "hsqldb", "mysql", "mysql-utf8", "pgsql", "oracle", "oracle-oci", - "mssql", "sybase", "derby", "db2", "db2v8" or "auto" for dialect - autodetection; - + + dialect: A database dialect, one of + "hsqldb", "mysql", "mysql-utf8", "pgsql", "oracle", "oracle-oci", + "mssql", "sybase", "derby", "db2", "db2v8" or "auto" for dialect + autodetection; + = - - multi-db: Enable multi-database - container with this parameter (set value "true"); - + + multi-db: Enable multi-database conta= iner + with this parameter (set value "true"); + = - - max-buffer-size: A a threshold (in - bytes) after which a javax.jcr.Value content will be swapped to a - file in a temporary storage. I.e. swap for pending changes. - + + max-buffer-size: A a threshold (in by= tes) + after which a javax.jcr.Value content will be swapped to a file in= a + temporary storage. I.e. swap for pending changes. + = - - swap-directory: A path in the file - system used to swap the pending changes. - - + + swap-directory: A path in the file sy= stem + used to swap the pending changes. + + = In this way, we have configured two workspace which will be persisted in two different databases (ws in HSQLDB, ws1 in MySQL). @@ -343,7 +502,7 @@ = For example (embedded mode for jdbcjcr da= ta container): - = + <external-component-plugins> <target-component>org.exoplatform.services.naming.InitialContext= Initializer</target-component> <component-plugin> @@ -385,7 +544,7 @@ = For example (two workspaces ws - jdbcjcr, ws1 - jdbcjcr): - = + <workspaces> <workspace name=3D"ws" auto-init-root-nodetype=3D"nt:unstructured"> <container class=3D"org.exoplatform.services.jcr.impl.storage.jdbc.= JDBCWorkspaceDataContainer"> @@ -520,7 +679,7 @@ = Simple queries will be used if you chose org.exoplatform.services.jcr.impl.storage.jdbc.JDBCWorkspac= eDataContainer: - = + <workspaces> <workspace name=3D"ws" auto-init-root-nodetype=3D"nt:unstructured"> <container class=3D"org.exoplatform.services.jcr.impl.storage.jdbc.= JDBCWorkspaceDataContainer"> @@ -531,7 +690,7 @@ = Complex queries will be used if you chose org.exoplatform.services.jcr.impl.storage.jdbc.optimisation= .CQJDBCWorkspaceDataContainer: - = + <workspaces> <workspace name=3D"ws" auto-init-root-nodetype=3D"nt:unstructured"> <container class=3D"org.exoplatform.services.jcr.impl.storage.jdbc.= optimisation.CQJDBCWorkspaceDataContainer"> @@ -559,9 +718,8 @@ for Orcale dialect, that uses query hints to increase performance for = few important queries. = - To enable this option put next configuration - property: - = + To enable this option put next configuration property: + <workspace name=3D"ws" auto-init-r= oot-nodetype=3D"nt:unstructured"> <container class=3D"org.exoplatform.services.jcr.impl.storage.jdbc.JD= BCWorkspaceDataContainer"> <properties> @@ -606,7 +764,7 @@ = A sample registry file is below: - = + Windows Registry Editor Version 5.00 = [HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Tcpip\Parameters] --===============0274992619334439988==--