topic Re: Oracle Schema with AlfrescoV1.3 in Alfresco Archive

Oracle Schema with AlfrescoV1.3

m4mf — Tue, 30 May 2006 13:16:51 GMT

Hello,would you please help me:AlfrescoV1.3, Tomcat, W2K3 with Oracle 9.2XThere is a problem to create an Oracle Schema on alfresco first start:Tablesauth_ext_keys,authority,version_count are created in Oracle.but then errorsDo I need a special Oracle DB creation script?)thanks–>…14:30:49,109

Re: Oracle Schema with AlfrescoV1.3

derek — Tue, 30 May 2006 13:37:48 GMT

Hi,

Have you changed the Hibernate dialect?

Regards

Re: Oracle Schema with AlfrescoV1.3

m4mf — Tue, 30 May 2006 13:48:43 GMT

Yes:

custom-db-connection.properties
–>
#
# Oracle connection (requires ojdbc14_g.jar or equivalent jar in shared libraries location)
#
db.driver=oracle.jdbc.OracleDriver
db.url=jdbcracle:thin:@155.250.247.71:1521:HWRK
db.username=alfresco
db.password=alfresco

custom-hibernate-dialect.properties
–>
#
# Oracle dialect
#
hibernate.dialect=org.hibernate.dialect.Oracle9Dialect

custom-services-context.xml
–>
<?xml version='1.0' encoding='UTF-8'?>
<!DOCTYPE beans PUBLIC '-//SPRING//DTD BEAN//EN' 'http://www.springframework.org/dtd/spring-beans.dtd'>

<beans>

    <!– load common properties –>
    <bean id="repository-properties" class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">
        <property name="ignoreUnresolvablePlaceholders">
            <value>true</value>
        </property>
        <property name="locations">
            <list>
                <value>classpath:alfresco/repository.properties</value>
                <value>classpath:alfresco/version.properties</value>
                <value>classpath:alfresco/domain/transaction.properties</value>
                <value>classpath:alfresco/extension/custom-repository.properties</value>
                <value>classpath:alfresco/extension/custom-db-connection.properties</value>
                <value>classpath:alfresco/extension/custom-hibernate-dialect.properties</value>
            </list>
        </property>
    </bean>

</beans>

Re: Oracle Schema with AlfrescoV1.3

m4mf — Tue, 30 May 2006 14:23:28 GMT

thanks,

it's working fine after changing the dialect value in ./domain/hibernate-cfg.properties

So I think, there is small problem with properties from custom extention file.

Re: Oracle Schema with AlfrescoV1.3

derek — Tue, 30 May 2006 14:27:08 GMT

Hi,

The problem was that you didn't use the hibernate properties bean:


    <bean id="hibernateConfigProperties" class="org.springframework.beans.factory.config.PropertiesFactoryBean">
‍‍‍

as per the sample file.

Regards