Oracle for CrowdID

Follow the steps below to connect CrowdID to Oracle.

1. Configure Oracle

1. Create a database user which CrowdID will connect as (e.g. crowduser).
2. Create a database for CrowdID to store data in (e.g. crowdiddb). This must be a different database to the one used by Crowd.
3. Ensure that the user has permission to connect to the database, and create and populate tables.

2. Copy the Oracle Driver to your Application Server

1. Download the Oracle JDBC driver from http://www.oracle.com/technology/software/tech/java/sqlj_jdbc/index.html.
2. Add the Oracle JDBC driver jar to the following directory:
   
   • Crowd 2.0.2 or later: {CROWD_INSTALL}/apache-tomcat/lib/.
   • Crowd 2.0.1 or earlier: {CROWD_INSTALL}/apache-tomcat/common/lib/.

3. Configure your Application Server to Connect to Oracle

1. Edit the file apache-tomcat-X.X.XX/conf/Catalina/localhost/openidserver.xml and customize the username, password, driverClassName and urlparameters for the Datasource.

   <Context path="/openidserver" docBase="../../crowd-openidserver-webapp" debug="0">
   
   <Resource name="jdbc/CrowdIDDS" auth="Container" type="javax.sql.DataSource"
   username="[enter db username here]"
   password="[enter db password here]"
   driverClassName="oracle.jdbc.driver.OracleDriver"
   url="jdbc:oracle:thin:@localhost:1521:crowdiddb"
   [ delete the minEvictableIdleTimeMillis, timeBetweenEvictionRunsMillis and maxActive params here ]
   />
   
   <Manager className="org.apache.catalina.session.PersistentManager" saveOnRestart="false"/>
   
   </Context>
   

2. Delete the minEvictableIdleTimeMillis, timeBetweenEvictionRunsMillis and maxActive attributes (which are only needed for HSQL, and degrade performance otherwise).

4. Configure CrowdID to use Oracle

1. Edit the build.properties file (located in the root of the Crowd distribution) and modify the hibernate.dialect to the following

   hibernate.dialect=org.hibernate.dialect.Oracle10gDialect
   

2. Then run ./build.sh or build.bat. This will configure CrowdID to use the Oracle dialect. There is a problem with build.bat in Crowd version 1.2.0. To fix the problem, please apply the patch described in CWD-638.

If you do not wish to edit this file and run the build script, you can edit the jdbc.properties (which the above script modifies) directly. The jdbc.properties file is located here: crowd-openidserver-webapp\WEB-INF\classes\jdbc.properties. Modify the file to the following:

# - Crowd Configuration Options

hibernate.connection.datasource=java\:comp/env/jdbc/CrowdIDDS
hibernate.dialect=org.hibernate.dialect.OracleDialect
hibernate.transaction.factory_class=org.hibernate.transaction.JDBCTransactionFactory

...

Next Steps

You should now have an application server configured to connect to a database, and CrowdID configured to use the correct database. Now start up CrowdID and watch the logs for any errors.

RELATED TOPICS

• Supported Platforms
  • Setting JAVA_HOME
  • End of support announcements for Crowd
• Installing Crowd and CrowdID
  • Connecting Crowd to a Database
    • HSQLDB
    • MS SQL Server
    • MySQL
    • Oracle
    • PostgreSQL
  • Connecting CrowdID to a Database
    • HSQLDB for CrowdID
    • MS SQL Server for CrowdID
    • MySQL for CrowdID
    • Oracle for CrowdID
    • PostgreSQL for CrowdID
  • Specifying your Crowd Home Directory
• Running the Setup Wizard
  • Troubleshooting your Configuration on Setup
• Configuring Crowd
  • Important directories and files
    • The crowd.properties file
  • Changing the Port that Crowd uses
  • Configuring Crowd to Work with SSL
  • Installing Crowd as a Windows Service
    • Specifying Startup Order of Windows Services
    • Changing the User for the Crowd Windows Service
    • Removing the Crowd Windows Service
    • Troubleshooting Crowd as a Windows Service
  • Setting Crowd to Start Automatically on Mac OS X
  • Setting Crowd to Run Automatically and Use an Unprivileged System User on UNIX