topic Re: PostgreSQL / Existing Tomcat Install Issue in Alfresco Archive

PostgreSQL / Existing Tomcat Install Issue

jazzcat — Thu, 15 Dec 2005 17:49:09 GMT

Greetings,I'm having problems installing Alfresco on an existing Tomcat 5.5.14 installation.I have followed the instructions on this thread,http://www.alfresco.org/forums/viewtopic.php?t=116with the caveat that the hibernate-context.xml file did not contain the Dialect specs, instead it was in the d

Re: PostgreSQL / Existing Tomcat Install Issue

gavinc — Mon, 19 Dec 2005 09:18:51 GMT

Although you say the database exists and can be connected to it does seem like there is an issue with the database as you are getting the following exception:

org.springframework.transaction.CannotCreateTransactionException: Could not open Hibernate session for transaction; nested exception is org.hibernate.exception.GenericJDBCException: Cannot open connection‍

Have you placed the MySQL driver in the tomcat/common/lib? If you have done that have you tried connecting to the database as alfresco/alfresco?

Re: PostgreSQL / Existing Tomcat Install Issue

jazzcat — Tue, 20 Dec 2005 19:47:07 GMT

Do I need the MySQL driver even though I'm using PG?

I downloaded the PG JDBC driver and put it under {tomcat_root}common/lib; then I restarted Tomcat.

In the catalina.out file, I get this message now:

Caused by: org.apache.commons.dbcp.SQLNestedException: Cannot load JDBC driver class 'org.postgresqlDriver'…
…Caused by: java.lang.ClassNotFoundException: org.postgresqlDriver

I also explicitly added the {tomcat_root}/common/lib directory to the normal JAVA CLASSPATH for my user account.

I'm going to go visit a PostgreSQL JDBC list, but is there anything else from an alfresco point of view that I need to do to let it know to load the driver?

Thanks,
-Josh

Re: PostgreSQL / Existing Tomcat Install Issue

steve — Wed, 21 Dec 2005 10:10:38 GMT

Hello,

I believe PostgreSQL changed it's class structure for it's JDBC driver at some point, it might be worth checking you have the most up-to-date version, or if you are running an old PostgreSQL version then check your hibernate mappings:

If You are running an older version of JDBC, the driver name may be wrong. Version 6.5 and lower use "postgresql.Driver", and later versions use "org.postgresql.Driver".

Steve

Re: PostgreSQL / Existing Tomcat Install Issue

arnab — Sat, 24 Dec 2005 18:11:50 GMT

Please note that if you are running PostgreSql Server on the default port then a slight modification is required to the settings instructions that have been posted in this url:
http://www.alfresco.org/forums/viewtopic.php?t=23

The settings in respository.properties should look like this:

# Database configuration

db.driver=org.postgresql.Driver
db.name=alfresco
db.url=jdbcostgresql://localhost:5432/${db.name}
db.username=alfresco
db.password=alfresco

Note the port number (5432 default) that has been appended to the db url

The 3 drivers that I am using are:
1. pg80b1.308.jdbc2.jar
2. pg80b1.308.jdbc2ee.jar
3. pg80b1.308.jdbc3.jar
These can be found in C:\Program Files\PostgreSQL\8.0\jdbc directory (ie. the jdbc directory in your Postgres installation).

Hope that helps.

Cheers

-Arnab