2.1 Connecting Crowd to a Database

By default, Crowd 'Standalone' is shipped preconfigured with HSQL. This is fine for evaluation purposes, but for production installations, you should connect Crowd to an enterprise database. This also lets you take advantage of existing database backup and recovery procedures.

The following instructions will allow you to configure Crowd to an external database:

• 2.1.1 HSQL DB
• 2.1.2 MS SQL Server
• 2.1.3 MySQL
• 2.1.4 Oracle
• 2.1.5 PostgreSQL

Database Overview

The Crowd distribution includes the Apache Tomcat application server and an in-memory HSQL database engine. This JNDI reference (CrowdDS) can be adjusted to use your custom database and driver by editing the crowd.xml deployment description.

You will also need to edit the file build.properties, and run the script  build.xml, as described in 4.1 Important Files. The two relevant properties in the build.properties file are:

• hibernate.dialect
• hibernate.transaction.factory_class

These are described as follows.

hibernate.dialect

Below is a list of supported databases and their Hibernate configurations. You will need to edit the  hibernate.dialect property to correspond to whichever database you are using:

hibernate.transaction.factory_class

You will need to edit the  hibernate.transaction.factory_class  property to correspond to whichever application server you are using:

関連トピック

• 1. System Requirements
  • 1.1 Setting JAVA_HOME
• 2. Installing Crowd and CrowdID
  • 2.1 Connecting Crowd to a Database
    • 2.1.1 HSQL DB
    • 2.1.2 MS SQL Server
    • 2.1.3 MySQL
    • 2.1.4 Oracle
    • 2.1.5 PostgreSQL
  • 2.2 Connecting CrowdID to a Database
    • 2.2.1 HSQL DB
    • 2.2.2 MS SQL Server
    • 2.2.3 MySQL
    • 2.2.4 Oracle
    • 2.2.5 PostgreSQL
  • 2.3 Installing Crowd on a Separate Application Server
    • 2.3.1 Installing Crowd on JBoss
• 3. Running the Setup Wizard
• 4. Configuring Crowd
  • 4.1 Important Files
    • The crowd.properties File
  • 4.2 Changing the Port that Crowd uses
• 5. Installing Crowd as a Windows Service
  • 5.1 Specifying Startup Order of Windows Services
  • 5.2 Changing the User for the Crowd Windows Service
  • 5.3 Removing the Crowd Windows Service
  • 5.4 Troubleshooting Crowd as a Windows Service