Deploy_jUDDI_on_Tomcat_and_Postgres

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>