I checked the WEB-INF/juddi-users.xml file and confirmed that the userid and password in that file matches the ones in the conf/server.xml file too.
Can someone please give me a clue as to what's wrong? I've read various posts and tried/checked everything that was mentioned but Tomcat doesn't seem to want to connect to MySql - I am getting the following errors from the happyjuddi.jsp page: 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) Why is the class empty and the URL null in the "DB connection" error above? Where is it looking? Using the command line, I can get into MySql and do the query "SELECT COUNT(*) FROM PUBLISHER" and the correct count does come back as expected so I believe MySql is working. A little help please? Thanks - Alan avinh wrote: > > 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 >> >> >> >> > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > > -- View this message in context: http://www.nabble.com/jUDDI-DataSource-Validation-problem-tf1969144.html#a5423970 Sent from the jUDDI - User forum at Nabble.com. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
