Alfresco with Oracle9i

mail2hua — Fri, 20 Jan 2006 10:11:23 GMT

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

Re: Alfresco with Oracle9i

kevinr — Fri, 20 Jan 2006 11:17:53 GMT

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

Kevin

Re: Alfresco with Oracle9i

cramlo — Fri, 10 Mar 2006 15:26:14 GMT

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

Re: Alfresco with Oracle9i

kevinr — Fri, 10 Mar 2006 15:30:31 GMT

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

Thanks!

Kevin

Re: Alfresco with Oracle9i

cramlo — Fri, 10 Mar 2006 18:50:40 GMT

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.

topic Re: Alfresco with Oracle9i in Alfresco Archive

Alfresco with Oracle9i

Re: Alfresco with Oracle9i

Re: Alfresco with Oracle9i

Re: Alfresco with Oracle9i

Re: Alfresco with Oracle9i