In my latest Archiva installation, I noticed that Archiva resolves the path to the derby database relative to whatever was the current working directory at the time Tomcat was started. For example, if I'm in $CATALINA_HOME/bin and I run ./catalina.sh start, then the derby database gets created under $CATALINA_HOME/bin/archiva/derbydb. If I restart Tomcat later from a different directory, it gets created from scratch in that different directory. To work around this issue and make sure the derby db dir is always resolved to the same place, before Tomcat starts in catalina.sh, I must explicitly call: cd $CATALINA_HOME Here's part of my archiva.xml, where the path to the derby db gets set:
<Resource name="jdbc/users" auth="Container" type="javax.sql.DataSource" username="sa" password="" driverClassName="org.apache.derby.jdbc.EmbeddedDriver" url="jdbc:derby:archiva/derbydb;create=true" /> And in catalina.properties I have this: appserver.home=${catalina.home} appserver.base=${catalina.home}/archiva This is Archiva 1.0.1 on Tomcat 6.0.16 with JDK 1.6.0_04, RHEL 5 Thanks in advance, Carlton ----------------------------------------- ==================================================== This message contains PRIVILEGED and CONFIDENTIAL information that is intended only for use by the named recipient. If you are not the named recipient, any disclosure, dissemination, or action based on the contents of this message is prohibited. In such case please notify us and destroy and delete all copies of this transmission. Thank you. ====================================================