Hi Ben, Does the error still persist even if Archiva is re-started?
Thanks, Deng On Mon, Dec 7, 2009 at 8:30 PM, Ben Lidgey <[email protected]> wrote: > 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
