AnsweredAssumed Answered

Configuring postgres with alfresco 3.1

Question asked by kirit on Jul 22, 2009
Latest reply on Jul 22, 2009 by kirit
I am trying to configure postgres database with the alfresco 3.1
I was using my same configuration which was working for the Alfresco 2.1 (e.g driver settings, property files settings, jar (postgres8.2))

Following is the exact Exception which i am getting.

Error creating bean with name 'DatabaseInformationResource' defined in file [D:\Work\alfresco3.1\tomcat\webapps\alfresco\WEB-INF\classes\alfresco\enterprise\repository-jmx-context.xml]: Cannot create inner bean 'org.alfresco.enterprise.repo.management.Database#1e4eb5b' of type [org.alfresco.enterprise.repo.management.Database] while setting bean property 'resource'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'org.alfresco.enterprise.repo.management.Database#1e4eb5b' defined in file [D:\Work\alfresco3.1\tomcat\webapps\alfresco\WEB-INF\classes\alfresco\enterprise\repository-jmx-context.xml]: Instantiation of bean failed; nested exception is org.springframework.beans.BeanInstantiationException: Could not instantiate bean class [org.alfresco.enterprise.repo.management.Database]: Constructor threw exception; nested exception is java.lang.AbstractMethodError: org.postgresql.jdbc2.Jdbc2DatabaseMetaData.getDatabaseMajorVersion()I
Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'org.alfresco.enterprise.repo.management.Database#1e4eb5b' defined in file [D:\Work\alfresco3.1\tomcat\webapps\alfresco\WEB-INF\classes\alfresco\enterprise\repository-jmx-context.xml]: Instantiation of bean failed; nested exception is org.springframework.beans.BeanInstantiationException: Could not instantiate bean class [org.alfresco.enterprise.repo.management.Database]: Constructor threw exception; nested exception is java.lang.AbstractMethodError: org.postgresql.jdbc2.Jdbc2DatabaseMetaData.getDatabaseMajorVersion()I
Caused by: org.springframework.beans.BeanInstantiationException: Could not instantiate bean class [org.alfresco.enterprise.repo.management.Database]: Constructor threw exception; nested exception is java.lang.AbstractMethodError: org.postgresql.jdbc2.Jdbc2DatabaseMetaData.getDatabaseMajorVersion()I
Caused by: java.lang.AbstractMethodError: org.postgresql.jdbc2.Jdbc2DatabaseMetaData.getDatabaseMajorVersion()I
        at org.alfresco.enterprise.repo.management.Database.<init>(Database.java:111)
        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
        at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
        at java.lang.reflect.Constructor.newInstance(Constructor.java:494)

Any idea? what should we do for this?

Outcomes