Installing jUDDI 0.9rc4 with Tomcat 5.5.20 and Postgres 7.4.14
Install Tomcat and the Tomcat Administration Web Application. Set up an admin user - see http://www.onjava.com/pub/a/onjava/2003/06/25/tomcat_tips.html
Build and install Postgres (http://www.postgresql.org/docs/7.4/interactive/installation.html). Be sure to specify --with-java when running the postgres configuration script.
Install postgresql.jar in $CATALINA_HOME/common/lib. Start postgres. Create a juddi user and database. Run the juddi-0.9rc4/sql/postgresql/create_database.sql script to initialize the juddi database. In the same directory, use insert_publishers.sql as a template for adding your publishers.
Install juddi.war in $CATALINA_HOME/webapps. Start/restart tomcat. Click on Tomcat Administration and log in using the admin user you created earlier. Expand Service/Host(localhost)/Context(juddi)/Resources.
Click on Data Sources. Click on the JNDI name (jdbc/juddiDB). Fill in the blanks:
Data Source URL: jdbc:postgresql://127.0.0.1:5432/<juddi postgres database you created earlier>
JDBC Driver Class: org.postgresql.Driver
User Name: <same as the juddi postgres user you created earlier>
Password: <same as the juddi postgres user you created earlier>
Validation Query: select count(*) from PUBLISHER
Save and commit these changes. Restart tomcat. Check the juddi happiness page.
Here's my juddi configuration from server.xml:
<Context
crossContext="true"
path="/juddi"
reloadable="true">
<Resource
auth="Container"
name="jdbc/juddiDB"
type="javax.sql.DataSource"
password="juddi"
driverClassName="org.postgresql.Driver"
maxIdle="2"
maxWait="5000"
validationQuery="select count(*) from PUBLISHER"
username="juddi"
url="jdbc:postgresql://127.0.0.1:5432/juddi"
maxActive="4"/>
</Context>