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 = admin@juddi.org
juddi.operatorEmailAddress = alan.vinh@nist.gov
# 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/publishjuddi.proxy.adminURL =
https://seurat.cbt.nist.gov:8443/juddi/adminjuddi.proxy.inquiryURL =
https://seurat.cbt.nist.gov:8443/juddi/inquiryjuddi.proxy.publishURL =
https://seurat.cbt.nist.gov:8443/juddi/publishjuddi.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
>
>
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: juddi-user-unsubscribe@ws.apache.org
For additional commands, e-mail: juddi-user-help@ws.apache.org
Some parts of this message have been removed.
Learn more about Nabble's 