Alfresco with Oracle9i

[mail2hua]

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=jdbcracle:thin:@localhost:1521ra92
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

[kevinr]

Thanks for posting this info, i'm sure it will help others! 

Kevin

[cramlo]

I'm struggling installing Alfresco with Oracle. I've done that with many other software before and the installation looks quite standard.

However, I've tried putting the odbc14.jar, the classes12.jar, the nls_charset12.jar in the WEB-INF/lib folder, I'm still getting the message :

CompilerOracle: exclude org/apache/lucene/index/IndexReader$1 doBody
Mar 10, 2006 4:20:53 PM org.apache.catalina.core.AprLifecycleListener lifecycleEvent
INFO: The Apache Portable Runtime which allows optimal performance in production environments was not found on the java.library.path: D:\jdk150_06\bin;.;C….
Mar 10, 2006 4:20:54 PM org.apache.coyote.http11.Http11BaseProtocol init
INFO: Initializing Coyote HTTP/1.1 on http-8080
Mar 10, 2006 4:20:54 PM org.apache.catalina.startup.Catalina load
INFO: Initialization processed in 1797 ms
Mar 10, 2006 4:20:54 PM org.apache.catalina.core.StandardService start
INFO: Starting service Catalina
Mar 10, 2006 4:20:54 PM org.apache.catalina.core.StandardEngine start
INFO: Starting Servlet Engine: Apache Tomcat/5.5.12
Mar 10, 2006 4:20:54 PM org.apache.catalina.core.StandardHost start
INFO: XML validation disabled
16:21:12,944 ERROR [hibernate.util.JDBCExceptionReporter] Cannot load JDBC driver class 'oracle.jdbc.driver.OracleDriver '
16:21:14,819 ERROR [hibernate.util.JDBCExceptionReporter] Cannot load JDBC driver class 'oracle.jdbc.driver.OracleDriver '
16:21:14,819 ERROR [tool.hbm2ddl.SchemaUpdate] could not get database metadata
org.apache.commons.dbcp.SQLNestedException: Cannot load JDBC driver class 'oracle.jdbc.driver.OracleDriver '
        at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:766)
        at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:540)
        at org.springframework.orm.hibernate3.LocalDataSourceConnectionProvider.getConnection(LocalDataSourceConnectionProvider.java:80)
        at org.hibernate.tool.hbm2ddl.SchemaUpdate.execute(SchemaUpdate.java:127)
        at org.hibernate.impl.SessionFactoryImpl.<init>(SessionFactoryImpl.java:295)
        at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1176)
        at org.springframework.orm.hibernate3.LocalSessionFactoryBean.newSessionFactory(LocalSessionFactoryBean.java:800)
        at org.springframework.orm.hibernate3.LocalSessionFactoryBean.afterPropertiesSet(LocalSessionFactoryBean.java:726)
        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1059)
        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:363)
        at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:226)
        at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:147)
        at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:176)
        at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:105)
        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1013)
        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:824)
        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:345)
        at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:226)
        at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:147)
        at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:176)
        at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:105)
        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1013)
        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:824)
        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:345)
        at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:226)
        at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:147)
        at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:176)
        at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:105)
        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1013)
        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:824)
        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:345)
        at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:226)
        at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:147)
        at org.springframework.beans.factory.support.DefaultListableBeanFactory.getBeansOfType(DefaultListableBeanFactory.java:203)
        at org.springframework.context.support.AbstractApplicationContext.getBeansOfType(AbstractApplicationContext.java:614)
        at org.springframework.context.support.AbstractApplicationContext.registerListeners(AbstractApplicationContext.java:496)
        at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:317)
        at org.springframework.web.context.support.AbstractRefreshableWebApplicationContext.refresh(AbstractRefreshableWebApplicationContext.java:134)
        at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:246)
        at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:184)


I've tested the oracle connection manually. It works. I've got other java application running on tomcat that use Oracle without any problem.

Any idea?


Thanks

[kevinr]

Can you try putting those JARs in this location instead of WEB-INF/lib:
tomcat/common/lib

Thanks!

Kevin

[cramlo]

Doesn't work better. Same error.

I've downloaded the latest release of ojdbc14.zip from Oracle website, renamed it in ojdbc.jar and copy it under tomcat/common/lib with no luck.

I've of course removed it from anywhere else.

BUT IN THE MEANTIME, I FOUND THE ERROR AND FIXED IT

When I copied/pasted your lines to be added to the %TOMCAT_HOME%\webapps\alfresco\WEB-INF\classes\alfresco\repostiory.properties, it added 1 space at the end of each line. Thus, the driver name it was trying to found was 'oracle.jdbc.driver.OracleDriver ' instead of 'oracle.jdbc.driver.OracleDriver'.

Here we go !

Thanks for your support.