Differences between revisions 2 and 3
Revision 2 as of 2009-09-20 22:48:35
Size: 2078
Editor: localhost
Comment: converted to 1.6 markup
Revision 3 as of 2013-04-09 20:29:19
Size: 0
Editor: KurtStam
Comment: moved to juddi's wiki
Deletions are marked like this. Additions are marked like this.
Line 1: Line 1:
== 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>