archiva-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Ben Lidgey <BLid...@movenetworks.com>
Subject Exceptions when purging repository
Date Mon, 07 Dec 2009 12:30:30 GMT
Hi

We are getting exceptions when the repository purge is taking place where it cannot delete
artifacts as it thinks the database connection is read-only:

javax.jdo.JDODataStoreException: Delete request failed: DELETE FROM SA.ARCHIVA_ARTIFACT WHERE
ARTIFACT_ID = ? AND CLASSIFIER = ? AND GROUP_ID = ? AND REPOSITORY_ID = ? AND FILE_TYPE =
? AND VERSION = ?
at org.jpox.store.rdbms.request.DeleteRequest.execute(DeleteRequest.java:288)
	at org.jpox.store.rdbms.table.ClassTable.delete(ClassTable.java:2611)

[snip]

NestedThrowablesStackTrace:
ERROR 25502: An SQL data change is not permitted for a read-only connection, user or database.
	at org.apache.derby.iapi.error.StandardException.newException(Unknown Source)


Has anyone seen this before? I can't find any docs or related issues. We are running Archiva
1.2.2 in Tomcat 5.5.17 using the Derby databases. The archiva instance is configured in Tomcat
conf/Catalina/localhost/archiva.xml as follows:

<?xml version="1.0" encoding="UTF-8"?>
 <Context path="/archiva"
          docBase="${catalina.home}/archiva/apache-archiva-CURRENT.war">

 <Resource name="jdbc/users" auth="Container" type="javax.sql.DataSource"
           username="sa"
           password=""
           driverClassName="org.apache.derby.jdbc.EmbeddedDriver"
           url="jdbc:derby:/home/devadmin/data/maven/archiva/database/users;create=true" />

 <Resource name="jdbc/archiva" auth="Container" type="javax.sql.DataSource"
           username="sa"
           password=""
           driverClassName="org.apache.derby.jdbc.EmbeddedDriver"
           url="jdbc:derby:/home/devadmin/data/maven/archiva/database/archiva;create=true"
/>

 <Resource name="mail/Session" auth="Container"
            type="javax.mail.Session"
            mail.smtp.host="localhost"/>
 </Context>


Thanks

Ben
Mime
View raw message