topic Configuring postgres with alfresco 3.1 in Alfresco Archive

Configuring postgres with alfresco 3.1

kirit — Wed, 22 Jul 2009 06:27:12 GMT

I am trying to configure postgres database with the alfresco 3.1I 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 'DatabaseInforma

Re: Configuring postgres with alfresco 3.1

dward — Wed, 22 Jul 2009 10:01:43 GMT

It looks like Alfresco is attempting to call JDBC methods that are not supported by your JDBC driver.

Which JDBC driver are you using?

Re: Configuring postgres with alfresco 3.1

kirit — Wed, 22 Jul 2009 10:40:17 GMT

We are using Postgresql as database and for that we have used postgresql-8.2-506.jdbc2ee.jar, and in class path we are using jdk1.5

Re: Configuring postgres with alfresco 3.1

dward — Wed, 22 Jul 2009 11:25:11 GMT

Please try using the JDBC 4 jar.

Re: Configuring postgres with alfresco 3.1

kirit — Wed, 22 Jul 2009 11:43:30 GMT

I have tried using the JDBC 4 jar (postgresql-8.2-510.jdbc4.jar)

Now, Exception changed to this:
Cannot load JDBC driver class 'org.postgresql.Driver'
java.lang.UnsupportedClassVersionError: Bad version number in .class file
at java.lang.ClassLoader.defineClass1(Native Method)
at java.lang.ClassLoader.defineClass(ClassLoader.java:620)

Re: Configuring postgres with alfresco 3.1

kirit — Wed, 22 Jul 2009 11:56:16 GMT

Oh finally i got the jar which is supported by Alfresco 3.1 that is JDBC 3 jar (postgresql-8.2-510.jdbc3.jar)
one can get this from link : (http://jdbc.postgresql.org/download.html)

My tomcat started now with normal processing and it has created the default tables in PostGre database

Thanks.