topic Re: Alfresco 3.1 on Websphere 6.1, using Oracle 10 in Alfresco Archive

Alfresco 3.1 on Websphere 6.1, using Oracle 10

dao — Tue, 07 Apr 2009 12:54:14 GMT

Hi,I'm trying to install Alfresco 3.1 on Websphere 6.1 with java 1.5 and Oracle 10.2.0. I've already deployed it and when I try to access my alfresco app I've got this following huge error rg.springframework.beans.factory.BeanCreationException: Error creating bean with name 'luceneFullTextSearchIn

Re: Alfresco 3.1 on Websphere 6.1, using Oracle 10

rliu — Tue, 07 Apr 2009 13:24:56 GMT

Hi Dao,

I had to use the following parameter in my custom-hibernate-cfg.properties file to connect to Oracle 10g XE on Labs 3. I would think the configuration would be similar if not the same on Alfresco 3.1. I also noticed that the Wiki page was written up to deploy with Alfresco 2.1, so read with caution.

hibernate.dialect=org.alfresco.repo.domain.hibernate.dialect.AlfrescoOracle10gDialect‍

When using this dialect, make sure it exists in the the following:

… alfresco-repository.jar\org\alfresco\repo\domain\hibernate\dialect\AlfrescoOracle10gDialect.class

You should be able to find the alfresco-repository.jar in your alfresco.war\WEB-INF\lib folder.

It took me awhile to finally get this right.

Re: Alfresco 3.1 on Websphere 6.1, using Oracle 10

dao — Tue, 07 Apr 2009 13:29:14 GMT

Thanks for your answer
But why should I configure custom-hibernate-cfg.properties and not custom-hibernate-dialect.properties ?

Re: Alfresco 3.1 on Websphere 6.1, using Oracle 10

dao — Tue, 07 Apr 2009 13:41:34 GMT

Anyway, AlfrescoOracle10gDialect.class doesn't exist in alfresco-repository.jar\org\alfresco\repo\domain\hibernate\dialect\ Only AlfrescoOracle9Dialect exists in this directory 😕

Re: Alfresco 3.1 on Websphere 6.1, using Oracle 10

rliu — Tue, 07 Apr 2009 16:35:16 GMT

Thanks for your answer
But why should I configure custom-hibernate-cfg.properties and not custom-hibernate-dialect.properties ?

It should not matter what you call your custom file as long as the filename is registered in the /alfresco/hibernate-context.xml file as such:

    <bean id="hibernateConfigProperties" class="org.springframework.beans.factory.config.PropertiesFactoryBean">
        <property name="locations">
            <list>
                <value>classpath:alfresco/domain/hibernate-cfg.properties</value>
                <value>classpath:alfresco/extension/custom-hibernate-cfg.properties</value>
            </list>
        </property>
    </bean>
‍‍‍‍‍‍‍‍‍

You would need to add the following:

<value>classpath:alfresco/extension/custom-hibernate-dialect.properties</value>‍

Re: Alfresco 3.1 on Websphere 6.1, using Oracle 10

dao — Wed, 08 Apr 2009 09:38:20 GMT

<value>classpath:alfresco/extension/custom-hibernate-dialect.properties</value>‍

I added this line to my hibernate-context.xml and placed this last in /lib/alfresco/. Unfortunately I still have this huge error…
Besides, I tried to use

hibernate.dialect=org.hibernate.dialect.Oracle9Dialect‍

instead of Oracle10gDialect, but still the same error 😕

Re: Alfresco 3.1 on Websphere 6.1, using Oracle 10

dao — Tue, 14 Apr 2009 07:48:00 GMT

Hi,
Obviously Websphere is not yet supported, not before Alfresco 3.2 : http://www.alfresco.com/services/support/stacks/3.x/

Anyway, thanks for your answers
dao.