Alfresco 3.2 Community, Ibatis and PostgreSql

[pero]

When I configure Alfresco 3.2 Community edition to use PostgreSql

db.driver=org.postgresql.Driver
db.url=jdbcostgresql://localhost:5432/${db.name}
hibernate.dialect=org.hibernate.dialect.PostgreSQLDialect
hibernate.query.substitutions=true TRUE, false FALSE

I get following exception when starting alfresco

Caused by: com.ibatis.common.xml.NodeletException: Error parsing XML.  Cause: java.lang.RuntimeException: Error parsing XPath '/sqlMapConfig/sqlMap'.  Cause: com.ibatis.sqlmap.client.SqlMapException: The <sqlMap> resource is missing: alfresco/ibatis/#resource.dialect#/content-insert-SqlMap.xml
   at com.ibatis.common.xml.NodeletParser.parse(NodeletParser.java:62)
   at org.alfresco.ibatis.HierarchicalSqlMapConfigParser.parse(HierarchicalSqlMapConfigParser.java:107)
   … 139 more
Caused by: java.lang.RuntimeException: Error parsing XPath '/sqlMapConfig/sqlMap'.  Cause: com.ibatis.sqlmap.client.SqlMapException: The <sqlMap> resource is missing: alfresco/ibatis/#resource.dialect#/content-insert-SqlMap.xml
   at com.ibatis.common.xml.NodeletParser.processNodelet(NodeletParser.java:123)
   at com.ibatis.common.xml.NodeletParser.process(NodeletParser.java:84)
   at com.ibatis.common.xml.NodeletParser.process(NodeletParser.java:102)
   at com.ibatis.common.xml.NodeletParser.parse(NodeletParser.java:72)
   at com.ibatis.common.xml.NodeletParser.parse(NodeletParser.java:60)
   … 140 more
Caused by: com.ibatis.sqlmap.client.SqlMapException: The <sqlMap> resource is missing: alfresco/ibatis/#resource.dialect#/content-insert-SqlMap.xml
   at org.alfresco.ibatis.HierarchicalSqlMapConfigParser$10.process(HierarchicalSqlMapConfigParser.java:352)
   at com.ibatis.common.xml.NodeletParser.processNodelet(NodeletParser.java:121)

[quasar]

Hi guys!
As far as I've understood that postgresql scripts for the version 3.2r are still not ready. (the error <sqlMap> resource is missing: alfresco/ibatis/#resource.dialect#/content-insert-SqlMap.xml and so on). Is there any solution for this issue?
Best regards!

[pim]

Not officially. See the topic I mentioned before.

[trialot]

Some issues occur with PostgreSQL in the new 3.2 Community Edition or the 3.2r Community Edition.

These issues are the result of the postgresql-3.2r.amp not being entirely correct.

Some SqlMaps are not correct.

You can easily modify them by adjusting a set of files. Some hints can be found in the following topic:

http://forums.alfresco.com/en/viewtopic.php?f=9&t=22927&p=75067&hilit=postgresql#p75067

Works fine for me and others.

PS If i have time, I will try to adjust the amp file.