[Juddi Wiki] Update of "Deploy_jUDDI_on_Tomcat_and_Postgres" by alexoree

[Apache Wiki <wi...@apache.org>]

Dear Wiki user,

You have subscribed to a wiki page or wiki category on "Juddi Wiki" for change notification.

The "Deploy_jUDDI_on_Tomcat_and_Postgres" page has been changed by alexoree:
http://wiki.apache.org/juddi/Deploy_jUDDI_on_Tomcat_and_Postgres

New page:
== 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>

---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@juddi.apache.org
For additional commands, e-mail: commits-help@juddi.apache.org