This page last changed on Jun 19, 2007 by rosie@atlassian.com.

CrowdID is a free add-on that ships with Crowd versions 1.1 and later.

By default, CrowdID 'Standalone' is shipped preconfigured with HSQL. This is fine for evaluation purposes, but for production installations, you should connect CrowdID 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 CrowdID to an external database:

Database Overview

The CrowdID distribution includes the Apache Tomcat application server and an in-memory HSQL database engine. This JNDI reference (CrowdIDDS) 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 2. Installing and Configuring Crowd and CrowdID. 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:

RDBMS Hibernate SQL Dialect
HypersonicSQL org.hibernate.dialect.HSQLDialect
Microsoft SQL Server org.hibernate.dialect.SQLServerDialect
MySQL org.hibernate.dialect.MySQLDialect
MySQL with InnoDB org.hibernate.dialect.MySQLInnoDBDialect
MySQL with MyISAM org.hibernate.dialect.MySQLMyISAMDDialect
Oracle org.hibernate.dialect.OracleDialect
PostgreSQL org.hibernate.dialect.PostgreSQLDialect

hibernate.transaction.factory_class

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

J2EE Server Dialect
Borland ES org.hibernate.transaction.BESTransactionManagerLookup
JBoss org.hibernate.transaction.JBossTransactionManagerLookup
JOnAS org.hibernate.transaction.JOnASTransactionManagerLookup
JOTM org.hibernate.transaction.JOTMTransactionManagerLookup
JRun4 org.hibernate.transaction.JRun4TransactionManagerLookup
Orion org.hibernate.transaction.OrionTransactionManagerLookup
Resin org.hibernate.transaction.ResinTransactionManagerLookup
Weblogic org.hibernate.transaction.WeblogicTransactionManagerLookup
WebSphere org.hibernate.transaction.WebSphereTransactionManagerLookup

Related Topics

Document generated by Confluence on Jun 20, 2007 20:58