Exceptions when purging repository

[Ben Lidgey]

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