aspose file tools*
The moose likes Web Services and the fly likes Juddi DB connection problem Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Java » Web Services
Bookmark "Juddi DB connection problem" Watch "Juddi DB connection problem" New topic
Author

Juddi DB connection problem

Mat Anthony
Ranch Hand

Joined: May 21, 2008
Posts: 237
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


directory: TOMCAT_HOME\conf
file name: context.xml


directory: TOMCAT_HOME\conf
file name: web.xml


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


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


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
Ranch Hand

Joined: Oct 04, 2006
Posts: 2198
    
    1
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!


My free books and tutorials: http://www.slideshare.net/krizsan
Mat Anthony
Ranch Hand

Joined: May 21, 2008
Posts: 237
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


File: uddi.xml


File:juddiv3.properties


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

Mat
Ivan Krizsan
Ranch Hand

Joined: Oct 04, 2006
Posts: 2198
    
    1
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!
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Juddi DB connection problem