2.7. DB Schema Creator service

Warning

You are looking at documentation for an older release. Not what you want? See the current release documentation.

DB Schema Creator is responsible for creating database schema, using a DDL script inside service configuration or in an external file, calling:

org.exoplatform.services.database.jdbc.DBSchemaCreator.createTables(String dsName, String script)

via

org.exoplatform.services.database.jdbc.CreateDBSchemaPlugin component plugin

Example of configuration:


<component>

   <key>org.exoplatform.services.database.jdbc.DBSchemaCreator</key>

   <type>org.exoplatform.services.database.jdbc.DBSchemaCreator</type>

   <component-plugins>    

      <component-plugin> 

         <name>jcr.dbschema</name>

         <set-method>addPlugin</set-method>

         <type>org.exoplatform.services.database.jdbc.CreateDBSchemaPlugin</type>

         <init-params>

            <value-param>

               <name>data-source</name>

               <value>jdbcjcr</value>

            </value-param>

            <value-param>

               <name>script-file</name>

               <value>conf/storage/jcr-mjdbc.sql</value>

            </value-param>  

         </init-params>    

      </component-plugin>

........

Example of a DDL script:

CREATE TABLE JCR_MITEM(
        ID VARCHAR(255) NOT NULL PRIMARY KEY, 
        VERSION INTEGER NOT NULL, 
        PATH VARCHAR(1024) NOT NULL
        );
CREATE INDEX JCR_IDX_MITEM_PATH ON JCR_MITEM(PATH);