[MRM-1659] Cannot connect to PostgreSQL

• Type: Bug
• Status: Closed
• Priority: Blocker
• Resolution: Fixed
• Affects Version/s: 1.4-M3
• Fix Version/s: 1.4-M3
• Component/s: system
• Environment: Windows XP Professional, Archiva as a .war deployed on Tomcat 7.0.26 (base separated from installation), PostgreSQL 9.1 used for FileSystem, DataStore, and Persistence Manager.
• Assignee: Olivier Lamy
• Reporter: Chris Harris
• Created: 06/Sep/12 13:22
• Updated: 21/Sep/12 09:55
• Resolved: 21/Sep/12 02:26

Description

Archiva 1.4-M3 cannot start. I'm getting this error
"java.sql.SQLFeatureNotSupportedException: Method org.postgresql.jdbc4.Jdbc4Statement.setQueryTimeout(int) is not yet implemented."

I've tried archiva-webapp-js-1.4-M3-SNAPSHOT.war and archiva-webapp-1.4-M3-SNAPSHOT.war. Archiva will start if I use apache-archiva-1.4-M2.war. I have changed archiva.xml each time to point to the respective .war file.

I tried using postgresql-9.1-901.jdbc4.jar and postgresql-9.1-902.jdbc4.jar, but neither worked. I get the same PostgreSQL-related error message.

I've attached the Tomcat 7 log and archiva.log.