topic Problem using postgresql with alfresco 1.4 in Alfresco Archive

Problem using postgresql with alfresco 1.4

lgr — Tue, 28 Nov 2006 19:22:30 GMT

Hi,I'm using Alfresco v1.4 and postgresql.I'm trying to implement content rules on template folders like add a category to some contents.When creating a new folder from a template folder, i've got many errors like :Caused by: org.springframework.jdbc.UncategorizedSQLException: Hibernate operation: C

Re: Problem using postgresql with alfresco 1.4

kevinr — Wed, 29 Nov 2006 10:26:58 GMT

I assume you've changed the hibernate dialect to the appropriate one for postgresql. If so, did this work before with Alfresco 1.3 or is this your first test? We haven't tried postgresql but we'd hope that it would work as it is apparently supported by Hibernate.

Anyone else out there used postgresql successfully with Alfresco?

Thanks,

Kevin

Re: Problem using postgresql with alfresco 1.4

lgr — Wed, 29 Nov 2006 10:33:10 GMT

Yes, i've changed the hibernate dialect. And the database was populated correctly at bootstrap.

And yes, this is my first test, i was using mysql before.

Laurent.

Re: Problem using postgresql with alfresco 1.4

derek — Fri, 01 Dec 2006 16:47:20 GMT

Hi,

In custom-hibernate-dialect.properties add the following:

hibernate.show_sql=true‍

Is there more stack trace associated with this error?

Regards

Re: Problem using postgresql with alfresco 1.4

lgr — Fri, 01 Dec 2006 16:55:50 GMT

Hi Derek,

You'll have to wait a few days before i reinstall Alfresco.
But i'll make the test in the next installation.

Followups will be posted there.

Laurent.