Silly derby/archiva question

[EJ Ciramella-2]

So if I have the following in my context file:

 

            driverClassName="org.apache.derby.jdbc.EmbeddedDriver"

            url="jdbc:derby:database/users;create=true" />

 

Where physically are these files written out to?  I can't seem to find
them.

[Wendy Smoak-3]

On Fri, Jul 18, 2008 at 1:35 PM, EJ Ciramella <ejciramella@...> wrote:
> So if I have the following in my context file:
>            driverClassName="org.apache.derby.jdbc.EmbeddedDriver"
>            url="jdbc:derby:database/users;create=true" />
> Where physically are these files written out to?  I can't seem to find
> them.

Assuming Archiva 1.0.2, if you haven't changed anything, the user
database files will be in:
   /path/to/archiva/data/users/database

... and Archiva's database is in /path/to/archiva/data/archiva/database .

HTH,
--
Wendy

[EJ Ciramella-2]

Hmm - everything seems to have appeared in the bin directory.

Could I have done this:

url="jdbc:derby:../database/users;create=true"/>

?

Additionally, how do I configure the derby logs to go to say, the tomcat
logs directory?

-----Original Message-----
From: EJ Ciramella [mailto:ejciramella@...]
Sent: Friday, July 18, 2008 4:35 PM
To: users@...
Subject: Silly derby/archiva question

So if I have the following in my context file:

 

            driverClassName="org.apache.derby.jdbc.EmbeddedDriver"

            url="jdbc:derby:database/users;create=true" />

 

Where physically are these files written out to?  I can't seem to find
them.

[EJ Ciramella-2]

Hmm, I haven't changed anything - see my incoming mail as far as where
things wound up...

-----Original Message-----
From: Wendy Smoak [mailto:wsmoak@...]
Sent: Friday, July 18, 2008 4:39 PM
To: users@...
Subject: Re: Silly derby/archiva question

On Fri, Jul 18, 2008 at 1:35 PM, EJ Ciramella <ejciramella@...>
wrote:
> So if I have the following in my context file:
>            driverClassName="org.apache.derby.jdbc.EmbeddedDriver"
>            url="jdbc:derby:database/users;create=true" />
> Where physically are these files written out to?  I can't seem to find
> them.

Assuming Archiva 1.0.2, if you haven't changed anything, the user
database files will be in:
   /path/to/archiva/data/users/database

... and Archiva's database is in /path/to/archiva/data/archiva/database
.

HTH,
--
Wendy

[Wendy Smoak-3]

On Fri, Jul 18, 2008 at 1:42 PM, EJ Ciramella <ejciramella@...> wrote:
> Hmm - everything seems to have appeared in the bin directory.
> Could I have done this:
> url="jdbc:derby:../database/users;create=true"/>
 ?
> Additionally, how do I configure the derby logs to go to say, the tomcat
> logs directory?

Sorry, I missed the fact that you're running it in Tomcat.

You can give the full path to where you want the database files to go,
or you can set derby.system.home and give a path relative to that.

See the Derby docs for more info:
http://db.apache.org/derby/docs/dev/devguide/cdevdvlp27610.html
http://db.apache.org/derby/docs/10.2/devguide/rdevdvlp22102.html

I believe if you set derby.system.home, that's where its log file will go.

--
Wendy

[EJ Ciramella-2]

Excellent - thank you Wendy!

-----Original Message-----
From: Wendy Smoak [mailto:wsmoak@...]
Sent: Friday, July 18, 2008 4:58 PM
To: users@...
Subject: Re: Silly derby/archiva question

On Fri, Jul 18, 2008 at 1:42 PM, EJ Ciramella <ejciramella@...>
wrote:
> Hmm - everything seems to have appeared in the bin directory.
> Could I have done this:
> url="jdbc:derby:../database/users;create=true"/>
 ?
> Additionally, how do I configure the derby logs to go to say, the
tomcat
> logs directory?

Sorry, I missed the fact that you're running it in Tomcat.

You can give the full path to where you want the database files to go,
or you can set derby.system.home and give a path relative to that.

See the Derby docs for more info:
http://db.apache.org/derby/docs/dev/devguide/cdevdvlp27610.html
http://db.apache.org/derby/docs/10.2/devguide/rdevdvlp22102.html

I believe if you set derby.system.home, that's where its log file will
go.

--
Wendy