Alfresco & MySql Error

senthil_chinnai — Mon, 29 Jan 2007 10:12:28 GMT

Hi All:I am trying to configure Alfresco with MySQL database which is in a separate server. I have modified custom-db-and-data-context.xml, custom-hibernate-dialect.xml and custom-db-connection files to point to the database server. When I start Alfresco, I am getting the following error.Note: This

Re: Alfresco & MySql Error

senthil_chinnai — Mon, 29 Jan 2007 10:14:56 GMT

Here is my custom-db-and-data-context.xml file

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

<!–
       This shows the common minimum configuration overrides.
       By default, the content and indexes are located at a relative location, which should only
       be used when doing a quick preview of the Alfresco server.
–>
<beans>

    <!– overriding to point to custom 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>

                <!– Override data location properties
                <value>classpath:alfresco/extension/custom-data-location.properties</value>    –>
                <!– Override database connection properties –>
                <value>classpath:alfresco/extension/custom-db-connection.properties</value>
            </list>
        </property>
    </bean>

    <bean id="hibernateConfigProperties" class="org.springframework.beans.factory.config.PropertiesFactoryBean">
        <property name="locations">
            <list>

                <value>classpath:alfresco/domain/hibernate-cfg.properties</value>

                <!– Override hibernate dialect –>
                <value>classpath:alfresco/extension/custom-hibernate-dialect.properties</value>
            </list>
        </property>
    </bean>

</beans>

Re: Alfresco & MySql Error

derek — Tue, 13 Feb 2007 22:59:29 GMT

Hi,

When you use the non-HSQL database, you also have to make sure that the server points to a clean filesystem location. So, make sure that the dir.root location that you are going to use is clean if you have a clean database.

Regards

topic Re: Alfresco & MySql Error in Alfresco Archive

Alfresco & MySql Error

Re: Alfresco & MySql Error

Re: Alfresco & MySql Error