To follow up with a bit of info about my configuration...
My juddi/WEB-INF/web.xml file has the following in it:
<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>
My conf/server.xml has the following in it:
<Context path="/juddi" docBase="juddi" debug="5" reloadable="true"
crossContext="true">
<Logger className="org.apache.catalina.logger.FileLogger"
prefix="localhost_juddiDB_log" suffix=".txt"
timestamp="true"/>
<!-- the Resource element will probably work better for
you on Tomcat 5+ if you simply use a Resource only tag
with xml attributes as opposed to the nested
ResourceParams and
parameter elements -->
<Resource name="jdbc/juddiDB"
auth="Container"
type="javax.sql.DataSource"/>
<ResourceParams name="jdbc/juddiDB">
<parameter>
<name>factory</name>
<value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
</parameter>
<!-- Maximum number of dB connections in pool. Make sure you
configure your mysqld max_connections large enough to
handle
all of your db connections. Set to 0 for no limit. -->
<!--
<parameter><name>maxActive</name><value>100</value></parameter> -->
<parameter><name>maxActive</name><value>0</value></parameter>
<!-- Maximum number of idle dB connections to retain in pool.
Set to 0 for no limit. -->
<!--
<parameter><name>maxIdle</name><value>30</value></parameter> -->
<parameter><name>maxIdle</name><value>100</value></parameter>
<parameter><name>maxWait</name><value>10000</value></parameter>
<!-- MySQL dB username and password for dB connections -->
<parameter><name>username</name><value>juddi</value></parameter>
<parameter><name>password</name><value>juddi</value></parameter>
<!-- Class name for mm.mysql JDBC driver -->
<parameter>
<name>driverClassName</name>
<value>com.mysql.jdbc.Driver</value>
<!-- <value>org.gjt.mm.mysql.Driver</value> -->
</parameter>
<!-- The JDBC connection url for connecting to your MySQL dB.
The autoReconnect=true argument to the url makes sure
that the
mm.mysql JDBC Driver will automatically reconnect if
mysqld closed the
connection. mysqld by default closes idle connections
after 8 hours.
-->
<parameter>
<name>url</name>
<value>jdbc:mysql://seurat.cbt.nist.gov:3306/juddi?autoReconnect=true</value>
</parameter>
<parameter>
<name>validationQuery</name>
<value>select count(*) from PUBLISHER</value>
</parameter>
</ResourceParams>
</Context>
My juddi.properties file has the following entries:
# jUDDI Registry Properties (used by RegistryServer)
# see http://www.juddi.org for more information
# The UDDI Operator Name
juddi.operatorName = nist.gov
# The i18n locale default codes
juddi.i18n.languageCode = en
juddi.i18n.countryCode = US
# The UDDI DiscoveryURL Prefix
#juddi.discoveryURL = http://localhost:80808juddi/uddiget.jsp?
juddi.discoveryURL = https://seurat.cbt.nist.gov:8443/juddi/uddiget.jsp?
# The UDDI Operator Contact Email Address
#juddi.operatorEmailAddress = [EMAIL PROTECTED]
juddi.operatorEmailAddress = [EMAIL PROTECTED]
# 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
juddi.maxBusinessEntitiesPerUser=25
juddi.maxBusinessServicesPerBusiness=20
juddi.maxBindingTemplatesPerService=10
juddi.maxTModelsPerUser=100
juddi.maxRowsLimit=10
# jUDDI Authentication module to use
juddi.auth = org.apache.juddi.auth.DefaultAuthenticator
# jUDDI DataStore module currently to use
juddi.dataStore = org.apache.juddi.datastore.jdbc.JDBCDataStore
# jUDDI DataSource to use
juddi.dataSource=java:comp/env/jdbc/juddiDB
#juddi.dataSource=java:comp/env/jdbc/juddi
# 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 Validator to use
juddi.validator=org.apache.juddi.validator.DefaultValidator
# jUDDI Proxy Properties (used by RegistryProxy)
#juddi.proxy.adminURL = http://localhost:8080/juddi/admin
#juddi.proxy.inquiryURL = http://localhost:8080/juddi/inquiry
#juddi.proxy.publishURL = http://localhost:8080/juddi/publish
juddi.proxy.adminURL = https://seurat.cbt.nist.gov:8443/juddi/admin
juddi.proxy.inquiryURL = https://seurat.cbt.nist.gov:8443/juddi/inquiry
juddi.proxy.publishURL = https://seurat.cbt.nist.gov:8443/juddi/publish
juddi.proxy.transportClass = org.apache.juddi.proxy.AxisTransport
juddi.proxy.securityProvider = com.sun.net.ssl.internal.ssl.Provider
juddi.proxy.protocolHandler = com.sun.net.ssl.internal.www.protocol
Alan Vinh wrote:
Hi,
I'm trying to get jUDDI running on our Tomcat application server
(Tomcat 5.5.17) with "mysql-standard-5.0.22-linux-i686" (both running
on Linux redhat 3). I've followed the README instructions that came
with the jUDDI package for creating the tables for MySql, then I
followed the instructions from the following link to deploy jUDDI on
the Tomcat server:
http://wiki.apache.org/ws/Deploy_jUDDI_on_Tomcat_and_MySQL
I can go through the command line interface and access MySql databases
and query the PUBLISHER table and it does output the entries that I
have manually put in there but I can't seem to access MySql via Tomcat.
When I access the happyjuddi link below (we're using SSL), I get the
following error/output (see below). The red text is what I'm trying to
solve:
- DB connection was not aquired. (Cannot create JDBC driver of class
'' for connect URL 'null')
- SELECT COUNT(*) FROM PUBLISHER failed (null)
https://localhost:8443/juddi/happyjuddi.jsp
I have the "mysql-connector-java-3.1.13-bin.jar" file residing under
the $TOMCAT_HOME/common/lib directory.
Thank you in advance for your help - Alan
Happy jUDDI!
jUDDI Version Information
*jUDDI Version:* 0.9rc4
*Build Date:* July 18, 2006 5:37:10 PM EDT
*UDDI Version:* 2.0
jUDDI Dependencies: Class Files & Libraries
*Looking for*: org.apache.juddi.IRegistry
+Found in: /opt/apache-tomcat-5.5.17/webapps/juddi/WEB-INF/lib/juddi.jar
*Looking for*: org.apache.axis.transport.http.AxisServlet
+Found in: /opt/apache-tomcat-5.5.17/webapps/juddi/WEB-INF/lib/axis.jar
*Looking for*: org.apache.commons.discovery.Resource
+Found in:
/opt/apache-tomcat-5.5.17/webapps/juddi/WEB-INF/lib/commons-discovery-0.2.jar
*Looking for*: org.apache.commons.logging.Log
+Found in: /opt/apache-tomcat-5.5.17/bin/commons-logging-api.jar
*Looking for*: org.apache.log4j.Layout
+Found in:
/opt/apache-tomcat-5.5.17/webapps/juddi/WEB-INF/lib/log4j-1.2.8.jar
*Looking for*: javax.xml.soap.SOAPMessage
+Found in: /opt/apache-tomcat-5.5.17/webapps/juddi/WEB-INF/lib/saaj.jar
*Looking for*: javax.xml.rpc.Service
+Found in: /opt/apache-tomcat-5.5.17/webapps/juddi/WEB-INF/lib/jaxrpc.jar
*Looking for*: com.ibm.wsdl.factory.WSDLFactoryImpl
+Found in:
/opt/apache-tomcat-5.5.17/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:
/opt/apache-tomcat-5.5.17/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
*catalina.base*: /opt/apache-tomcat-5.5.17
*catalina.home*: /opt/apache-tomcat-5.5.17
*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*: UTF-8
*file.encoding.pkg*: sun.io
*file.separator*: /
*java.awt.graphicsenv*: sun.awt.X11GraphicsEnvironment
*java.awt.printerjob*: sun.print.PSPrinterJob
*java.class.path*:
:/opt/apache-tomcat-5.5.17/bin/bootstrap.jar:/opt/apache-tomcat-5.5.17/bin/commons-logging-api.jar
*java.class.version*: 49.0
*java.endorsed.dirs*: /opt/apache-tomcat-5.5.17/common/endorsed
*java.ext.dirs*: /opt/jdk1.5.0_05/jre/lib/ext
*java.home*: /opt/jdk1.5.0_05/jre
*java.io.tmpdir*: /opt/apache-tomcat-5.5.17/temp
*java.library.path*:
/opt/jdk1.5.0_05/jre/lib/i386/client:/opt/jdk1.5.0_05/jre/lib/i386:/opt/jdk1.5.0_05/jre/../lib/i386
*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_05-b05
*java.specification.name*: Java Platform API Specification
*java.specification.vendor*: Sun Microsystems Inc.
*java.specification.version*: 1.5
*java.util.logging.config.file*:
/opt/apache-tomcat-5.5.17/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_05
*java.vm.info*: mixed mode
*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_05-b05
*line.separator*:
*os.arch*: i386
*os.name*: Linux
*os.version*: 2.4.21-37.EL
*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*:
/opt/apache-tomcat-5.5.17/common/endorsed/xercesImpl.jar:/opt/apache-tomcat-5.5.17/common/endorsed/xml-apis.jar:/opt/jdk1.5.0_05/jre/lib/rt.jar:/opt/jdk1.5.0_05/jre/lib/i18n.jar:/opt/jdk1.5.0_05/jre/lib/sunrsasign.jar:/opt/jdk1.5.0_05/jre/lib/jsse.jar:/opt/jdk1.5.0_05/jre/lib/jce.jar:/opt/jdk1.5.0_05/jre/lib/charsets.jar:/opt/jdk1.5.0_05/jre/classes
*sun.boot.library.path*: /opt/jdk1.5.0_05/jre/lib/i386
*sun.cpu.endian*: little
*sun.cpu.isalist*: *sun.io.unicode.encoding*: UnicodeLittle
*sun.jnu.encoding*: UTF-8
*sun.management.compiler*: HotSpot Client Compiler
*sun.os.patch.level*: unknown
*tomcat.util.buf.StringCache.byte.enabled*: true
*user.country*: US
*user.dir*: /opt
*user.home*: /root
*user.language*: en
*user.name*: root
*user.timezone*: America/New_York
--
Alan Vinh
Building and Fire Research Laboratory
National Institute of Standards and Technology
100 Bureau Drive, MS 8630
Building 226, Room B316
Gaithersburg, MD 20899-8630, USA
-----------------------------------------------
E-mail: [EMAIL PROTECTED]
Phone: 301-975-5260
FAX: 301-975-5433
http://www.bfrl.nist.gov/
------------------------------------------------
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
