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:[email protected]] Sent: Wednesday, December 19, 2012 6:58 PM To: [email protected] 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 <[email protected]>: > 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
