You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@archiva.apache.org by "Chris Harris (JIRA)" <ji...@codehaus.org> on 2012/09/06 20:23:23 UTC
[jira] (MRM-1659) Cannot connect to PostgreSQL
Chris Harris created MRM-1659:
---------------------------------
Summary: 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
[jira] (MRM-1659) Cannot connect to PostgreSQL
Posted by "Brett Porter (JIRA)" <ji...@codehaus.org>.
[ https://jira.codehaus.org/browse/MRM-1659?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Brett Porter updated MRM-1659:
------------------------------
Comment: was deleted
(was:
ONLINE STORE :
+++ http://l2y.eu/dddqh ++++++++++
Best online store
Best quality, Best reputation , Best services
---**** NHL Jersey Woman $ 40 ---**** NFL Jersey $ 35
---**** NBA Jersey $ 34 ---**** MLB Jersey $ 35
---**** Jordan Six Ring_m $ 36 ---**** Air Yeezy_m $ 45
---**** T-Shirt_m $ 25 ---**** Jacket_m $ 36
---**** Hoody_m $ 50 ---**** Manicure Set $ 20
---**** handbag $ 37 ---**** ugg boot $ 43 ---****
---**** sunglass $ 16 ---**** bult $ 17 ---****
+++ http://l2y.eu/dddqh ++++++++++
)
> 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
[jira] (MRM-1659) Cannot connect to PostgreSQL
Posted by "Chris Harris (JIRA)" <ji...@codehaus.org>.
[ 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
[jira] (MRM-1659) Cannot connect to PostgreSQL
Posted by "Chris Harris (JIRA)" <ji...@codehaus.org>.
[ https://jira.codehaus.org/browse/MRM-1659?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=309452#comment-309452 ]
Chris Harris commented on MRM-1659:
-----------------------------------
Olivier,
I'm using a version of that last got a blue light. I think it was #1486. You can probably remove that dependency. Thanks for putting it in there though.
I think that you can close this Bug.
> 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
> Assignee: Olivier Lamy
> Priority: Blocker
> Fix For: 1.4-M3
>
> 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
[jira] (MRM-1659) Cannot connect to PostgreSQL
Posted by "Chris Harris (JIRA)" <ji...@codehaus.org>.
[ https://jira.codehaus.org/browse/MRM-1659?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=308073#comment-308073 ]
Chris Harris commented on MRM-1659:
-----------------------------------
I was able to get my Tomcat base %CATALINA_BASE_ARCHIVA% working with M3 using MySQL 5.5! I can download artifacts via the method mentioned on your "Quick Start" page. I can also browse and see that junit artifact listed!
As far as PostgreSQL, this link might help provide a clue as to how to resolve the issue: http://mybatis-user.963551.n3.nabble.com/quot-org-postgresql-jdbc4-Jdbc4PreparedStatement-setQueryTimeout-int-is-not-yet-implemented-quot-Prom-td2002356.html
It seems that their fix was to exclude some timeout setting (possibly specific to myBatis) or to include this dependency:
<dependency>
<groupId>cglib</groupId>
<artifactId>cglib</artifactId>
<version>2.1_3</version>
</dependency>
> 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
[jira] (MRM-1659) Cannot connect to PostgreSQL
Posted by "Chris Harris (JIRA)" <ji...@codehaus.org>.
[ https://jira.codehaus.org/browse/MRM-1659?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=307907#comment-307907 ]
Chris Harris commented on MRM-1659:
-----------------------------------
I wanted to mention that I did not receive this error when I ran the .war from CATALINA_HOME. My problem still isn't solved. I want to run Archiva from a Tomcat base, not the installation.
I originally had a System Environment variable %CATALINA_BASE_ARCHIVA%. To test the .war in CATALINA_HOME, I removed that Environment variable.
Next, I changed -Dappserver.home=%CATALINA_HOME% -Dappserver.base=%CATALINA_ARCHIVA_BASE% to -Dappserver.home=%CATALINA_HOME% -Dappserver.base=%CATALINA_HOME%
> 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
[jira] (MRM-1659) Cannot connect to PostgreSQL
Posted by "Chris Harris (JIRA)" <ji...@codehaus.org>.
[ https://jira.codehaus.org/browse/MRM-1659?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=309323#comment-309323 ]
Chris Harris commented on MRM-1659:
-----------------------------------
I encountered an error with the users database with Continuum using MySQL 5.5. I think that it's ridiculous to modify an exploded .war, so I tried my luck with the new PostgreSQL 9.2 and the newest PostgreSQL driver (the one for JDK 1.6/1.7). It worked with Continuum, so I tried my hand with Archiva again (I wanted to share the users database between the two apps).
It worked!
> 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
[jira] (MRM-1659) Cannot connect to PostgreSQL
Posted by "Olivier Lamy (JIRA)" <ji...@codehaus.org>.
[ https://jira.codehaus.org/browse/MRM-1659?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Olivier Lamy updated MRM-1659:
------------------------------
Fix Version/s: 1.4-M3
Assignee: Olivier Lamy
> 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
> Assignee: Olivier Lamy
> Priority: Blocker
> Fix For: 1.4-M3
>
> 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
[jira] (MRM-1659) Cannot connect to PostgreSQL
Posted by "Olivier Lamy (JIRA)" <ji...@codehaus.org>.
[ https://jira.codehaus.org/browse/MRM-1659?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Olivier Lamy closed MRM-1659.
-----------------------------
Resolution: Fixed
Apologize for delay on that.
So I have added
{code}
<dependency>
<groupId>cglib</groupId>
<artifactId>cglib</artifactId>
<version>2.2.2</version>
</dependency>
{code}
Doesn't look to have any side effect.
Let us know.
If you are using builds from https://builds.apache.org/view/A-F/view/Archiva/job/archiva-all-maven-3.x-jdk-1.6/ that will be available with #1498
> 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
> Assignee: Olivier Lamy
> Priority: Blocker
> Fix For: 1.4-M3
>
> 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
[jira] (MRM-1659) Cannot connect to PostgreSQL
Posted by "yweuijhbcf (JIRA)" <ji...@codehaus.org>.
[ https://jira.codehaus.org/browse/MRM-1659?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=308067#comment-308067 ]
yweuijhbcf commented on MRM-1659:
---------------------------------
ONLINE STORE :
+++ http://l2y.eu/dddqh ++++++++++
Best online store
Best quality, Best reputation , Best services
---**** NHL Jersey Woman $ 40 ---**** NFL Jersey $ 35
---**** NBA Jersey $ 34 ---**** MLB Jersey $ 35
---**** Jordan Six Ring_m $ 36 ---**** Air Yeezy_m $ 45
---**** T-Shirt_m $ 25 ---**** Jacket_m $ 36
---**** Hoody_m $ 50 ---**** Manicure Set $ 20
---**** handbag $ 37 ---**** ugg boot $ 43 ---****
---**** sunglass $ 16 ---**** bult $ 17 ---****
+++ http://l2y.eu/dddqh ++++++++++
> 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