Comand Line installation

Steps of Database Deployment

Prior to successfully starting the application itself, an initial database schema has to be created. Besides the application war file ( RegistryCxn.war ) a zip package (e.g. RegistryCxn.zip ) is provided that contains a script responsible for creating the DB.

  1. Extract the zip file into a selected folder.

  2. Make sure that the location of the registry.properties file containing the DB connectivity information is referred by the environment variable REGISTRYCXN_HOME.

  3. Start ./RegistryCxn bash script or RegistryCxn.bat in the RegistryCxn/bin folder of the extracted content (depending on the OS type). The following are available:

-disableGlobalProjectAccess together with sqldeploy, disables global
project access rights
-dropSchema drops all database objects from
registration schema
-dropSchemaDS drops all database objects from downstream
schema
-help print this help summary
-migrateSchema create or upgrade database objects in
registration schema
-migrateSchemaDS create or upgrade database objects in
downstream schema
-schemaInfo prints informations about the registration
schema
-schemaInfoDS prints informations about the downstream
schema

In order to create an initial DB schema or clean an existing one completely, please use the following command line:

./RegistryCxn -migrateSchema
./RegistryCxn -dropSchema -migrateSchema

Since version 16.09.05-917:

./RegistryCxn install -migrateSchema
./RegistryCxn install -dropSchema -migrateSchema

Clearing the Database

It is possible to clear all the structures from the database while keeping the configuration, users, groups and projects in the system. After running a script, the structure-related database tables will be cleared and the sequences will be reset. This method is designed for testing purposes, it is not recommended execute it on a production database.

In order to use this functionality, please use the database deployment script with the following argument:

./RegistryCxn clear-data