FirstFoundationClient and Oracle DB

[michaelr]

Hallo,

I have installed Alfresco CommunityEdition and the SDK. The Community  Edition runs under Oracle9, but I get the following error when trying the FirstFoundationClient sample:

….
Caused by: org.springframework.orm.hibernate3.HibernateJdbcException: JDBC exception on Hibernate data access: could not execute query; nested exception is java.sql.SQLException: ORA-00933: SQL command not properly ended
…

Any ideas?

Thank you in advance.

Regards,
Michael

[jdtappero]

Hi…

I had similar errors with the FirstFoundationClient until I overrode the hibernate dialect.  To do this, I added a "custom-hibernate-dialect.properties" file to the ../alfresco/extension folder of the project, and added the following block to the "custom-repository-context.xml" file:

    <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>

In the "custom-hibernate-dialect.properties" file, I un-commented the Oracle override line:

hibernate.dialect=org.hibernate.dialect.Oracle9Dialect

Joseph.

[avro]

Great! It works now!

I had already added the custom-hibernate-dialect.properties to the extension folder, but not the hibernateConfigProperties to the custom-repository-context.xml

That was all of it.

Thank you so much Joseph!

[asavasamuel]

Michael


Here is an ORM that works with Oracle
https://www.kellermansoftware.com/p-47-net-data-access-layer.aspx