AnsweredAssumed Answered

Alfresco with Oracle9i

Question asked by mail2hua on Jan 20, 2006
Latest reply on Mar 10, 2006 by cramlo
Step 1: Create Oracle User for alfresco
===========================================
Create a oracle user with name alfresco and password alfresco,grant connect and resource priviledges to the account.

Step 2:  Configue the database connection and account
=======================
Open %TOMCAT_HOME%\webapps\alfresco\WEB-INF\classes\alfresco\repostiory.properties
to include my Oracle database information. That section looked something like this when I was done:
db.driver=oracle.jdbc.driver.OracleDriver
db.url=jdbc:oracle:thin:@localhost:1521:ora92
db.username=alfresco
db.password=alfresco


Step 3:  Change the hibernate dialect
============
Open file %TOMCAT_HOME%/webapps/alfresco/WEB-INF/classes/alfresco/domain/hibernate-cfg.properties

#hibernate.dialect=org.hibernate.dialect.MySQLDialect
hibernate.dialect=org.hibernate.dialect.Oracle9Dialect


Step 4: Add oracle jdbc driver to lib
====================================
copy ojdbc.jar to the next directory
%TOMCAT_HOME%\webapps\alfresco\WEB-INF\lib

Hope it helps.

Huang Hua

Outcomes