Re: [c-1.1] Anyone have Activa and CI running on the same Tomcat instance?

2007-12-15 Thread Mick Knutson
Thanks. Sorry, but I am new the the Derby DB. Are there dirctions on setting
up the external DB? I.e. do I need a users DB and an application DB? And if
I need 2, can the Users DB be shared between the 2?



On Dec 14, 2007 6:16 PM, Wendy Smoak [EMAIL PROTECTED] wrote:

 On Dec 14, 2007 8:51 AM, Mick Knutson [EMAIL PROTECTED] wrote:
  I have been trying for a few hours now. I can get Continuum.war with a
 Derby
  DB running. But then when I add Activa.war I either be *no trace at
  all*when I use the same user datasource as CI:
 
   Resource name=*jdbc/users* auth=Container type=
 javax.sql.DataSource
 username=sa
 password=
 driverClassName=org.apache.derby.jdbc.EmbeddedDriver
 url=jdbc:derby:database/users;create=true / *!-- tried
  database/archiva/users also --*

 You can only have one connection to the embedded Derby database.
 You'll need to switch to an external db in order to share it.

 --
 Wendy




-- 
Thanks,
Mick Knutson

http://www.baselogic.com
http://www.blincmagazine.com
http://www.djmick.com
http://www.myspace.com/mickknutson
http://www.myspace.com/BLiNCMagazine
http://tahoe.baselogic.com
---


Re: [c-1.1] Anyone have Activa and CI running on the same Tomcat instance?

2007-12-15 Thread ossi petz

hallo

i had the sam issue. i switched to an external mysql database: 
http://docs.codehaus.org/display/CONTINUUMUSER/Continuum+on+MySQL


archiva and continuum can share the same users database! that is also my 
configuration. actually someone told me this is recommended :)


regards
ossi


Mick Knutson schrieb:

Thanks. Sorry, but I am new the the Derby DB. Are there dirctions on setting
up the external DB? I.e. do I need a users DB and an application DB? And if
I need 2, can the Users DB be shared between the 2?



On Dec 14, 2007 6:16 PM, Wendy Smoak [EMAIL PROTECTED] wrote:


On Dec 14, 2007 8:51 AM, Mick Knutson [EMAIL PROTECTED] wrote:

I have been trying for a few hours now. I can get Continuum.war with a

Derby

DB running. But then when I add Activa.war I either be *no trace at
all*when I use the same user datasource as CI:

 Resource name=*jdbc/users* auth=Container type=

javax.sql.DataSource

   username=sa
   password=
   driverClassName=org.apache.derby.jdbc.EmbeddedDriver
   url=jdbc:derby:database/users;create=true / *!-- tried
database/archiva/users also --*

You can only have one connection to the embedded Derby database.
You'll need to switch to an external db in order to share it.

--
Wendy









Re: [c-1.1] Anyone have Activa and CI running on the same Tomcat instance?

2007-12-15 Thread Wendy Smoak
On Dec 15, 2007 3:59 PM, Mick Knutson [EMAIL PROTECTED] wrote:

 Thanks. Sorry, but I am new the the Derby DB. Are there dirctions on setting
 up the external DB? I.e. do I need a users DB and an application DB? And if
 I need 2, can the Users DB be shared between the 2?

It depends on what DBMS you choose.  If you want to stay on Derby, you
can switch from the default embedded setup to 'Derby Network Server'.
Or you can use MySQL, etc.

Here's one example:
http://docs.codehaus.org/display/MAVENUSER/Archiva+User+DB+on+Derby+Network+Server

Each application does have its own database in addition to the user
store, but it's only the user store you want to share, so that's the
only one you really need to move out to an external db.  On the other
hand, you may want to move all of them to keep things consistent, make
them more accessible, etc.

-- 
Wendy