AnsweredAssumed Answered

Alfresco 3.2 Community, Ibatis and PostgreSql

Question asked by pero on Jul 7, 2009
Latest reply on Nov 6, 2009 by trialot
When I configure Alfresco 3.2 Community edition to use PostgreSql

db.driver=org.postgresql.Driver
db.url=jdbc:postgresql://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)

Outcomes