jUDDI integration

[Smitty McSmith]

I am using jUDDI v0.9rc.4, Tomcat v5.5.15, MySQL v5.0.18, and MySQL
Connector/J v5.0.0-beta

the steps i took:
-installed MySQL and assorted admin tools. Ran the SQL code provided
by jUDDI for MySQL and added 4 elements to the publisher table within
the juddi shema.
-installed Tomcat on my system and made sure i could get into the
tomcat manager. -Installed the Admin tool and made sure i could access
that as well.
-installed jUDDI by directly moving the provided files in the webapp
directly to the webapp directory within tomcat (C:\Program Files\Apache
Software Foundation\Tomcat 5.5\webapps\juddi\). Made sure i could go
into the tomcat manager and access juddi and tried to run happyjuddi
(ran but didn't pass obviously)
-Moved the connector/j file (mysql-connector-java-5.0.0-beta-bin) to
C:\Program Files\Apache Software Foundation\Tomcat 5.5\common\lib
-commented out the few lines in C:\Program Files\Apache Software
Foundation\Tomcat 5.5\webapps\juddi\WEB-INF\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>
-->

-went into the tomcat admin tool, to the data sources page and created
a new data source with the following properties:
JNDI Name: jdbc/juddiDB
Data Source URL:
jdbc:mysql://localhost:3306/juddi?autoReconnect=true
JDBC Driver Class: com.mysql.jdbc.Driver
User Name: juddi
Password: ****** (correct, verrified with SQL admin
tool)
Max. Active Connections: 100
Max. Idle Connections: 30
Max. Wait for Connection: 10000
Validation Query: SELECT * FROM PUBLISHER

I save and commit changes.

-Restart the tomcat server using the apache tomcat properties utility
running in my system tray. I run happyjuddi and the output is:

jUDDI Version Information
jUDDI Version: 0.9rc4
Build Date: June 14, 2005 7:20:20 AM EDT
UDDI Version: 2.0

jUDDI Dependencies: Class Files & Libraries
Looking for: org.apache.juddi.IRegistry
+Found in: C:\Program Files\Apache Software Foundation\Tomcat
5.5\webapps\juddi\WEB-INF\lib\juddi.jar
Looking for: org.apache.axis.transport.http.AxisServlet
+Found in: C:\Program Files\Apache Software Foundation\Tomcat
5.5\webapps\juddi\WEB-INF\lib\axis.jar
Looking for: org.apache.commons.discovery.Resource
+Found in: C:\Program Files\Apache Software Foundation\Tomcat
5.5\webapps\juddi\WEB-INF\lib\commons-discovery-0.2.jar
Looking for: org.apache.commons.logging.Log
+Found in:
C:\Program%20Files\Apache%20Software%20Foundation\Tomcat%205.5\bin\commons-logging-api.jar
Looking for: org.apache.log4j.Layout
+Found in: C:\Program Files\Apache Software Foundation\Tomcat
5.5\webapps\juddi\WEB-INF\lib\log4j-1.2.8.jar
Looking for: javax.xml.soap.SOAPMessage
+Found in: C:\Program Files\Apache Software Foundation\Tomcat
5.5\webapps\juddi\WEB-INF\lib\saaj.jar
Looking for: javax.xml.rpc.Service
+Found in: C:\Program Files\Apache Software Foundation\Tomcat
5.5\webapps\juddi\WEB-INF\lib\jaxrpc.jar
Looking for: com.ibm.wsdl.factory.WSDLFactoryImpl
+Found in: C:\Program Files\Apache Software Foundation\Tomcat
5.5\webapps\juddi\WEB-INF\lib\wsdl4j-1.5.1.jar
Looking for: javax.xml.parsers.SAXParserFactory
+Found in an unknown location


jUDDI Dependencies: Resource & Properties Files
Looking for: log4j.xml
+Found in:
C:\Program%20Files\Apache%20Software%20Foundation\Tomcat%205.5\webapps\juddi\WEB-INF\classes\log4j.xml


jUDDI DataSource Validation
+ Got a JNDI Context!
+ Got a JDBC DataSource (dsname=java:comp/env/jdbc/juddiDB)
- DB connection was not aquired. (Cannot create JDBC driver of class ''
for connect URL 'null')
- SELECT COUNT(*) FROM PUBLISHER failed (null)


System Properties
awt.toolkit: sun.awt.windows.WToolkit
catalina.base: C:\Program Files\Apache Software Foundation\Tomcat 5.5
catalina.home: C:\Program Files\Apache Software Foundation\Tomcat 5.5
catalina.useNaming: true
common.loader:
${catalina.home}/common/classes,${catalina.home}/common/i18n/*.jar,${catalina.home}/common/endorsed/*.jar,${catalina.home}/common/lib/*.jar
file.encoding: Cp1252
file.encoding.pkg: sun.io
file.separator: \
java.awt.graphicsenv: sun.awt.Win32GraphicsEnvironment
java.awt.printerjob: sun.awt.windows.WPrinterJob
java.class.path: C:\Program Files\Apache Software Foundation\Tomcat
5.5\bin\bootstrap.jar
java.class.version: 49.0
java.endorsed.dirs: C:\Program Files\Apache Software Foundation\Tomcat
5.5\common\endorsed
java.ext.dirs: C:\Program Files\Java\jre1.5.0_06\lib\ext
java.home: C:\Program Files\Java\jre1.5.0_06
java.io.tmpdir: C:\Program Files\Apache Software Foundation\Tomcat
5.5\temp
java.library.path: C:\Program Files\Apache Software Foundation\Tomcat
5.5\bin;.;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\Program
Files\Common Files\Adaptec Shared\System;C:\Program
Files\QuickTime\QTSystem\;C:\Program
Files\proe2001\bin;C:\ptc\objlib\bin;C:\Program
Files\graphiclib\bin;C:\Program Files\MySQL\MySQL Server 5.0\bin
java.naming.factory.initial:
org.apache.naming.java.javaURLContextFactory
java.naming.factory.url.pkgs: org.apache.naming
java.runtime.name: Java(TM) 2 Runtime Environment, Standard Edition
java.runtime.version: 1.5.0_06-b05
java.specification.name: Java Platform API Specification
java.specification.vendor: Sun Microsystems Inc.
java.specification.version: 1.5
java.util.logging.config.file: C:\Program Files\Apache Software
Foundation\Tomcat 5.5\conf\logging.properties
java.util.logging.manager: org.apache.juli.ClassLoaderLogManager
java.vendor: Sun Microsystems Inc.
java.vendor.url: http://java.sun.com/
java.vendor.url.bug: http://java.sun.com/cgi-bin/bugreport.cgi
java.version: 1.5.0_06
java.vm.info: mixed mode, sharing
java.vm.name: Java HotSpot(TM) Client VM
java.vm.specification.name: Java Virtual Machine Specification
java.vm.specification.vendor: Sun Microsystems Inc.
java.vm.specification.version: 1.0
java.vm.vendor: Sun Microsystems Inc.
java.vm.version: 1.5.0_06-b05
line.separator:

os.arch: x86
os.name: Windows XP
os.version: 5.1
package.access:
sun.,org.apache.catalina.,org.apache.coyote.,org.apache.tomcat.,org.apache.jasper.,sun.beans.
package.definition:
sun.,java.,org.apache.catalina.,org.apache.coyote.,org.apache.tomcat.,org.apache.jasper.
path.separator: ;
server.loader:
${catalina.home}/server/classes,${catalina.home}/server/lib/*.jar
shared.loader:
${catalina.base}/shared/classes,${catalina.base}/shared/lib/*.jar
sun.arch.data.model: 32
sun.boot.class.path: C:\Program
Files\Java\jre1.5.0_06\lib\rt.jar;C:\Program
Files\Java\jre1.5.0_06\lib\i18n.jar;C:\Program
Files\Java\jre1.5.0_06\lib\sunrsasign.jar;C:\Program
Files\Java\jre1.5.0_06\lib\jsse.jar;C:\Program
Files\Java\jre1.5.0_06\lib\jce.jar;C:\Program
Files\Java\jre1.5.0_06\lib\charsets.jar;C:\Program
Files\Java\jre1.5.0_06\classes
sun.boot.library.path: C:\Program Files\Java\jre1.5.0_06\bin
sun.cpu.endian: little
sun.cpu.isalist: pentium_pro+mmx pentium_pro pentium+mmx pentium i486
i386 i86
sun.desktop: windows
sun.io.unicode.encoding: UnicodeLittle
sun.jnu.encoding: Cp1252
sun.management.compiler: HotSpot Client Compiler
sun.os.patch.level: Service Pack 2
tomcat.util.buf.StringCache.byte.enabled: true
user.country: US
user.dir: C:\Program Files\Apache Software Foundation\Tomcat 5.5
user.home: C:\WINDOWS\system32\config\systemprofile
user.language: en
user.name: SYSTEM
user.timezone: America/New_York
user.variant:

there is no juddi file in C:\Program Files\Apache Software
Foundation\Tomcat 5.5\conf\Catalina\localhost\

i have not modified the juddi.properties file

if you have any incite into the problem or if i am missing files that i
was supposed to "install" because there's a good chance that i missed
one of those obvious things that everyone is supposed to know which i
don't know.

ANY help would be greatly appreciated because this is driving my up the
wall!