Page tree
Skip to end of metadata
Go to start of metadata

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>

  • No labels