database location

[Randy Kamradt <Ra...@jda.com>]

While doing some maintenance on our archiva and continuum installation,
I noticed some odd behavior wrt the location of the derby database.  The
database seems to point to the directory in which I start tomcat, rather
than in one fixed location.  So if I'm in the webapps directory and I
start tomcat with ../bin/startup.sh the database gets created in the
webapps directory, rather than finding the existing one in the bin
directory.
 
Is there a way to configure things to look in a fixed location, rather
than in the cwd?
 
Additionally, I notice that I cannot shutdown tomcat, without leaving
lck files in the directory.  I have to delete these files in order to
have archiva startup properly.
 
I have 6.0.18, archiva 1.2.1, continuum 1.3.3, and the default derby
database.

Re: database location

[Deng Ching <oc...@apache.org>]

Hi,

On Sat, Jul 18, 2009 at 11:01 PM, Randy Kamradt <Ra...@jda.com>wrote:

> While doing some maintenance on our archiva and continuum installation,
> I noticed some odd behavior wrt the location of the derby database.  The
> database seems to point to the directory in which I start tomcat, rather
> than in one fixed location.  So if I'm in the webapps directory and I
> start tomcat with ../bin/startup.sh the database gets created in the
> webapps directory, rather than finding the existing one in the bin
> directory.
>
> Is there a way to configure things to look in a fixed location, rather
> than in the cwd?


You should be able to change this by setting the db paths configured
in  <tomcat
home>/conf/Catalina/localhost/archiva.xml if you've installed it similar to
what was recommended here:

http://archiva.apache.org/docs/1.2.1/adminguide/webapp.html


> Additionally, I notice that I cannot shutdown tomcat, without leaving
> lck files in the directory.  I have to delete these files in order to
> have archiva startup properly.


Do you mind filing this in jira? :)


Thanks,
Deng