[
https://jira.codehaus.org/browse/MRM-1659?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=308061#comment-308061
]
Chris Harris commented on MRM-1659:
-----------------------------------
I have an update on this situation. I was able to get Archiva running from
CATALINA_HOME using the default Jackrabbit content repository (no db involved).
Once I was able to get M3 working, I modified repository.xml to point to my
PostgreSQL 9.1 installation and deleted the entire /data/jcr directory
structure that gets automatically created. Archiva worked! But then...
I shut down my laptop for the day and rebooted the next morning. Archiva no
longer worked... On top of that, the PostgreSQL error reared its ugly head
again.
This seems to be a problem just on Windows? Please help. I would really like
to use your fine product/solution. I'm trying to get a very large organization
set up right. I don't want to go with Artifactory, simply because I'm not fond
of having a carrot dangled in front of me in terms of paying for plug-ins.
I tried downloading the Archiva source on my Win XP laptop for work, but the
Archiva project package structure is so long that it exceeds the directory path
length limit allotted for 32-bit Windows...argh. I'd put it on my personal
Ubuntu laptop, but that does me no good. I'd like to debug the project on a
Windauz box to get to the bottom of this issue. Either way, I just need some
help even getting Archiva to run with everything stored in PostgreSQL.
> Cannot connect to PostgreSQL
> ----------------------------
>
> Key: MRM-1659
> URL: https://jira.codehaus.org/browse/MRM-1659
> Project: Archiva
> Issue Type: Bug
> Components: system
> Affects Versions: 1.4-M3
> 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.
> Reporter: Chris Harris
> Priority: Blocker
> Attachments: archiva.log, localhost.2012-09-06.log
>
>
> 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.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:
https://jira.codehaus.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
