archiva-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Leitch, Oblio" <Oblio.Lei...@state.vt.us>
Subject RE: assistance getting Archiva standalone to use Postgres
Date Fri, 28 Dec 2012 18:57:37 GMT
Ok, I've been trying to get this to work, and I don't know where I'm going wrong.

* I put postgresql-9.2-1002.jdbc4.jar in apache-archiva-js-1.4-M3/apps/archiva/WEB-INF/lib
* <Set name="driverClassName">org.postgresql.Driver</Set>
* <Set name="url">jdbc:postgres://localhost:1521/Archiva</Set> (yes, my instance
is accessible through 1521)

However, something's still failing.  My root error is:

INFO   | jvm 1    | 2012/12/28 11:46:03 | Caused by: 
INFO   | jvm 1    | 2012/12/28 11:46:03 | java.lang.ClassNotFoundException: org.postgresql.Driver
INFO   | jvm 1    | 2012/12/28 11:46:03 | 	at java.net.URLClassLoader$1.run(Unknown Source)
INFO   | jvm 1    | 2012/12/28 11:46:03 | 	at java.net.URLClassLoader$1.run(Unknown Source)
INFO   | jvm 1    | 2012/12/28 11:46:03 | 	at java.security.AccessController.doPrivileged(Native
Method)
INFO   | jvm 1    | 2012/12/28 11:46:03 | 	at java.net.URLClassLoader.findClass(Unknown Source)
INFO   | jvm 1    | 2012/12/28 11:46:03 | 	at java.lang.ClassLoader.loadClass(Unknown Source)
INFO   | jvm 1    | 2012/12/28 11:46:03 | 	at sun.misc.Launcher$AppClassLoader.loadClass(Unknown
Source)
INFO   | jvm 1    | 2012/12/28 11:46:03 | 	at java.lang.ClassLoader.loadClass(Unknown Source)
INFO   | jvm 1    | 2012/12/28 11:46:03 | 	at java.lang.Class.forName0(Native Method)
INFO   | jvm 1    | 2012/12/28 11:46:03 | 	at java.lang.Class.forName(Unknown Source)
INFO   | jvm 1    | 2012/12/28 11:46:03 | 	at org.apache.tomcat.jdbc.pool.PooledConnection.connectUsingDriver(PooledConnection.java:246)
INFO   | jvm 1    | 2012/12/28 11:46:03 | 	at org.apache.tomcat.jdbc.pool.PooledConnection.connect(PooledConnection.java:182)
(...)

But, I don't think this is right; the .jar is locked while the system's running, which suggests
to me that it's been loaded.  I verified that the username/password are correct using the
PG admin console; and I verified that the account can create tables in the public schema.


-----Original Message-----
From: Olivier Lamy [mailto:olamy@apache.org] 
Sent: Wednesday, December 19, 2012 6:58 PM
To: users@archiva.apache.org
Subject: Re: assistance getting Archiva standalone to use Postgres

Hi,
Depends if you are using standalone or in a servlet container

1)Standalone have a look here
http://archiva.apache.org/docs/1.4-M4-SNAPSHOT/adminguide/standalone.html
replace <Set name="driverClassName">com.mysql.jdbc.Driver</Set> with your jdbc
driver and replace url <Set name="url">jdbc:mysql://localhost/archiva</Set>

put your jdbc driver jar to lib directory
2) servlet container (it depends :-) )
for Apache Tomcat see
http://archiva.apache.org/docs/1.4-M4-SNAPSHOT/adminguide/webapp.html
put your jdbc driver jar to lib directory change values

driverClassName="org.apache.derby.jdbc.EmbeddedDriver"
           url="jdbc:derby:/path/to/database/users;create=true"

Let us know if it works.

2012/12/19 Leitch, Oblio <Oblio.Leitch@state.vt.us>:
> So, I'm trying to get a standalone instance of Archiva to use an existing Postgres db.
 What changes do I need to make and where?



--
Olivier Lamy
Talend: http://coders.talend.com
http://twitter.com/olamy | http://linkedin.com/in/olamy

Mime
View raw message