Juddi DB connection problem

[Mat Anthony]

Hi All,
trying my hardest to get juddi working
Every time I access the happyjuddi.jsp it displays the following error message:-

-DB connection was not aquired. (Cannot create JDBC driver of class '' for connect URL 'null')
-SELECT COUNT(*) FROM PUBLISHER failed (null)

I have followed serveral links on the web and nothing seems to work.

software used:-
1) apache-tomcat-6.0.24
2) MySQL 5.1
3) JUDDI 0.9rc4 UDDI Version: 2.0
4) java version 1.6.0_05

configuration files used:-

Tomcat Server specific files
-----------------------------
directory: TOMCAT_HOME\WEB-INF
file name: web.xml

    
<resource-ref>
    <description>juddi DB Connection</description>
    <res-ref-name>jdbc/juddiDB</res-ref-name>
    <res-type>javax.sql.DataSource</res-type>
    <res-auth>Container</res-auth>
  </resource-ref>

directory: TOMCAT_HOME\conf
file name: context.xml

    
 <Context>
     <resource name="jdbc/juddiDB" auth="Container" 
           factory="org.apache.commons.dbcp.BasicDataSourceFactory"
           driverclassname="com.mysql.jdbc.Driver" 
           url="jdbc:mysql://localhost:3306/juddi" 
           maxActive="30"
           maxIdle="20000"
           username="juddi" 
           password="123456" 
           type="javax.sql.DataSource" 
           validationquery="select count(*) from publisher">
     </resource>
  </Context>

directory: TOMCAT_HOME\conf
file name: web.xml

    
 <resource-ref>
    <description>jUDDI DataSource</description>
    <res-ref-name>jdbc/juddiDB</res-ref-name>
    <res-type>javax.sql.DataSource</res-type>
    <res-auth>Container</res-auth>
 </resource-ref>

Juddi specific files
--------------------
directory: TOMCAT_HOME\webapps\juddi\WEB-INF
file name: juddi-users.xml

    
<?xml version="1.0" encoding="UTF-8"?>
  <juddi-users>
    <user userid="juddi" password="123456" />
  </juddi-users>

directory: TOMCAT_HOME\webapps\juddi\WEB-INF
file name: web.xml

   
<resource-ref>
    <description>jUDDI DataSource</description>
    <res-ref-name>jdbc/juddiDB</res-ref-name>
    <res-type>javax.sql.DataSource</res-type>
    <res-auth>Container</res-auth>
 </resource-ref>

I have placed the following file: mysql-connector-java-5.1.13-bin.jar
within the following locations:-

directory: TOMCAT_HOME\webapps\juddi\WEB-INF\lib
directory: TOMCAT_HOME\lib

I have used following files that came with juddi to build my juddi database and tables
create_database.sql
insert_publishers.sql

I have set a juddi user using MySQL Workbench. This user has to RWED etc.

Can anybody help, I'm just about to throw my self out of the window with this one.


Mat

[Ivan Krizsan]

Hi!
There is a distribution of jUDDI that comes complete, installed in a Tomcat - have you tried that one?
It is still not the most simple piece of software I have dealt with, but at least it saved me some trouble.
Best wishes!

[Mat Anthony]

Hi Ivan,
thanks for the response . I did as you said and downloaded the juddi-portal-bundle-3.0.3.zip .
I have mangaed to get juddi up and running and have access to the juddi Portal.
I have attempted to follow the 'Simple Publishing Example' instructions within the juddi User Guide.
On attempting to run the code I get the following error :-

org.apache.juddi.v3.error.UserMismatchException: An account must have administrative privileges to save publishers
at org.apache.juddi.validation.ValidatePublish.validateSavePublisher(ValidatePublish.java:1094)
at org.apache.juddi.api.impl.JUDDIApiImpl.savePublisher(JUDDIApiImpl.java:98)
at org.gmp.client.SimplePublish.main(SimplePublish.java:78)

Yet I get an authentication token succesfully

The code that I used is as follows:-
File: SimplePublish.java

package my.client;
import org.apache.juddi.v3.client.config.UDDIClientContainer;
import org.apache.juddi.v3.client.transport.Transport;
import org.apache.juddi.ClassUtil;
import org.uddi.v3_service.*;
import org.apache.juddi.v3_service.*;
import org.uddi.api_v3.GetAuthToken;
import org.uddi.api_v3.AuthToken;
import org.apache.juddi.api_v3.Publisher;
import org.apache.juddi.api_v3.SavePublisher;
import org.uddi.api_v3.BusinessEntity;
import org.uddi.api_v3.Name;
import org.uddi.api_v3.SaveBusiness;
import org.uddi.api_v3.BusinessDetail;
import org.uddi.api_v3.BusinessService;
import org.uddi.api_v3.SaveService;
import org.uddi.api_v3.ServiceDetail;

public class SimplePublish
{
  
  public static void main(String[] args)
  {
    UDDISecurityPortType   security=null;
    JUDDIApiPortType       juddiApi=null;
    UDDIPublicationPortType publish=null;
  try
  {
     String clazz = UDDIClientContainer.getUDDIClerkManager(null).
                    getClientConfig().getUDDINode("default").getProxyTransport();
     Class<?> transportClass = ClassUtil.forName(clazz, Transport.class);

     
     if (transportClass!=null) {
                //Retrieve the default client transport class which is designed to make
                //UDDI calls out using JAX-WS web services

                 System.out.println("Start-Setting up authentication token");
                Transport transport = (Transport) transportClass.
                    getConstructor(String.class).newInstance("default");

                security = transport.getUDDISecurityService(); //so we can get authorization tokens
                juddiApi = transport.getJUDDIApiService();     //so we can save a publisher
                publish = transport.getUDDIPublishService();   //so publish entities to the registry

                //Setup authentication code
                //=========================
                // Setting up the values to get an authentication
                // token for the 'root' user ('root' user
                //  has admin privileges and can save other publishers).
                GetAuthToken getAuthTokenRoot = new GetAuthToken();
                getAuthTokenRoot.setUserID("root");
                getAuthTokenRoot.setCred("123456");
                // Making API call that retrieves the authentication token for the 'root' user.
                AuthToken rootAuthToken = security.getAuthToken(getAuthTokenRoot);
                System.out.println ("root AUTHTOKEN = " + rootAuthToken.getAuthInfo());
                System.out.println("End-Setting up authentication token");
                //Note 'root' user (or publisher) acts as administrator for jUDDI API calls

//Now add a Publisher (i.e. using root publisher)
//=======================================================================
                // Creating a new publisher that we will use to publish our entities to.
                System.out.println("Start-Setting up publisher");
                Publisher p = new Publisher();
                p.setAuthorizedName("my-publisher");
                p.setPublisherName("My Publisher");

                // Adding the publisher to the "save" structure, using the 'root' user authentication info and
                // saving away.
                SavePublisher sp = new SavePublisher();
                sp.getPublisher().add(p);
                sp.setAuthInfo(rootAuthToken.getAuthInfo());
                juddiApi.savePublisher(sp);

                System.out.println("End-Setting up publisher");


                //Since have setup a publisher within the register, we now need to obtain it's authentication token
                //Note that we have no credentials, since we are using the default authenticator
                // Our publisher is now saved, so now we want to retrieve its authentication token
                GetAuthToken getAuthTokenMyPub = new GetAuthToken();
                getAuthTokenMyPub.setUserID("my-publisher");
                getAuthTokenMyPub.setCred("");
                AuthToken myPubAuthToken = security.getAuthToken(getAuthTokenMyPub);
                System.out.println ("myPub AUTHTOKEN = " + myPubAuthToken.getAuthInfo());

//Now add a Business Entity (i.e. associated for My Publisher)
//=======================================================================
//Note a BusinessEntity contains the business description and contact information [ Note large companies have serveral of these per/dept ]
//=============================================================================================================================
                // Creating the parent business entity that will contain our service.
                System.out.println("Start-Setting up Business entity");

                BusinessEntity myBusEntity = new BusinessEntity();
                Name myBusName = new Name();
                myBusName.setValue("My Business");
                myBusEntity.getName().add(myBusName);

                // Adding the business entity to the "save" structure, using our publisher's authentication info
                // and saving away.
//Save Business
                SaveBusiness sb = new SaveBusiness();
                sb.getBusinessEntity().add(myBusEntity);
                sb.setAuthInfo(myPubAuthToken.getAuthInfo()); //Note ***used publisher token authoInfo here****
                BusinessDetail bd = publish.saveBusiness(sb);
                String myBusKey = bd.getBusinessEntity().get(0).getBusinessKey();
                System.out.println("myBusiness key:  " + myBusKey);

                System.out.println("End-Setting up Business entity");


//Now add a Business Service to the Business Entity   (i.e.  My Business)
//=======================================================================
//Note a Business Service describes units of functionality that are consumed by the clients
//=======================================================================
                // Creating a service to save.  Only adding the minimum data: the parent business key retrieved
                //from saving the business above and a single name.
 //Save Service
                System.out.println("Start-Setting up Service");

                BusinessService myService = new BusinessService();
                myService.setBusinessKey(myBusKey);  //Note *****used the business key here******
                Name myServName = new Name();
                myServName.setValue("My Service");
                myService.getName().add(myServName);
                


               // Adding the service to the "save" structure, using our publisher's authentication info and
               // saving away.
               SaveService ss = new SaveService();
               ss.getBusinessService().add(myService);
               ss.setAuthInfo(myPubAuthToken.getAuthInfo());  //Note ***used publisher token authoInfo here****
               ServiceDetail sd = publish.saveService(ss);
               String myServKey = sd.getBusinessService().get(0).getServiceKey();
               System.out.println("myService key:  " + myServKey);
               System.out.println("End-Setting up Service");
     }

  }
  catch (Exception e)
  {
       e.printStackTrace();
  }
  }

}

File: uddi.xml

   
<?xml version="1.0" encoding="ISO-8859-1" ?>
<uddi>
<reloadDelay>5000</reloadDelay>
<manager name="example-manager">
<nodes>
<node>
<name>default</name>
<description>Main jUDDI node</description>
<properties>
<property name="serverName" value="localhost"/>
<property name="serverPort" value="8080"/>
<property name="keyDomain" value="juddi.apache.org"/>
<property name="department" value="businesses" />
</properties>
<proxyTransport>
org.apache.juddi.v3.client.transport.InVMTransport
</proxyTransport>
<custodyTransferUrl>
org.apache.juddi.api.impl.UDDICustodyTransferImpl
</custodyTransferUrl>
<inquiryUrl>org.apache.juddi.api.impl.UDDIInquiryImpl</inquiryUrl>
<publishUrl>org.apache.juddi.api.impl.UDDIPublicationImpl</publishUrl>
<securityUrl>org.apache.juddi.api.impl.UDDISecurityImpl</securityUrl>
<subscriptionUrl>org.apache.juddi.api.impl.UDDISubscriptionImpl
</subscriptionUrl>
<subscriptionListenerUrl>
org.apache.juddi.api.impl.UDDISubscriptionListenerImpl
</subscriptionListenerUrl>
<juddiApiUrl>org.apache.juddi.api.impl.JUDDIApiImpl</juddiApiUrl>
</node>
</nodes>
</manager>
</uddi>

File:juddiv3.properties

    
################################################################
#                 jUDDI-v3.0 configuration.                    #
################################################################
# Note that the property settings in this                      #
# file can be overriden by system parameters                   #
#                                                              #
################################################################
#
juddi.root.publisher=root
juddi.load.install.data=false
#
# Name of the persistence unit to use (the default, "juddiDatabase" refers to the unit compiled into the juddi library)
juddi.persistenceunit.name=juddiDatabase
#
# Check-the-time-stamp-on-this-file Interval in milli seconds  
juddi.configuration.reload.delay=2000
#
# Default locale
juddi.locale=en_US
#
#The UDDI Operator Contact Email Address
juddi.operatorEmailAddress=[e-mail]
#
# The maximum name size and maximum number
# of name elements allows in several of the
# FindXxxx and SaveXxxx UDDI functions.
juddi.maxNameLength=255
juddi.maxNameElementsAllowed=5
#
#
# The maximum number of rows returned in a find_* operation.  Each call can set
# this independently, but this property defines a global maximum.
juddi.maxRows=1000
# The maximum number of "IN" clause parameters.  Some RDMBS limit the number of 
# parameters allowed in a SQL "IN" clause.
juddi.maxInClause=1000
#
# The maximum number of UDDI artifacts allowed
# per publisher. A value of '-1' indicates any 
# number of artifacts is valid (These values can be
# overridden at the individual publisher level).
juddi.maxBusinessesPerPublisher=25
juddi.maxServicesPerBusiness=20
juddi.maxBindingsPerService=10
juddi.maxTModelsPerPublisher=100
#
# Days before a transfer request expires
juddi.transfer.expiration.days=3
#
# Days before a subscription expires
juddi.subscription.expiration.days=365
#
# Minutes before a "chunked" subscription call expires
juddi.subscription.chunkexpiration.minutes=5
#
# jUDDI Authentication module to use
juddi.authenticator = org.apache.juddi.v3.auth.JUDDIAuthenticator
#
# jUDDI UUIDGen implementation to use
juddi.uuidgen = org.apache.juddi.uuidgen.DefaultUUIDGen
#
# jUDDI Cryptor implementation to use
juddi.cryptor = org.apache.juddi.cryptor.DefaultCryptor
#
# jUDDI Key Generator to use
juddi.keygenerator=org.apache.juddi.keygen.DefaultKeyGenerator
#
# Specifies whether the inquiry API requires authentication
juddi.authenticate.Inquiry=false
#
# Specifies the interval at which the notification timer triggers
juddi.notification.interval=5000
#
# Specifies the amount of time to wait before the notification timer initially f
ires
juddi.notification.start.buffer=20000

#
# These two tokens are referenced in the install data. Note that you
# can use any tokens, and that their values can be set here or as
# System parameters.
juddi.server.name=localhost
juddi.server.port=8080

#only used by RMITransport
#juddi.proxy.factory.initial     =org.jnp.interfaces.NamingContextFactory
#juddi.proxy.provider.url        =jnp://localhost:1099
#juddi.proxy.factory.url.pkg     =org.jboss.naming

Also have you got any examples of how to setup BindingTemplates to the service.

Mat

[Ivan Krizsan]

Hi!
Sorry, I haven't done anything with jUDDI in a long time and never with v3.
I did a little with v2 when writing my SCDJWS 5 study notes (http://www.slideshare.net/krizsan/scdjws-5-study-notes-3085287), but nothing since.
Best wishes!