µÚ11Â¥

Õâϸü¿Ö²ÀÁË£º jUDDI DataSource Validation + Got a JNDI Context! + Got a JDBC DataSource (dsname=java:comp/env/jdbc/juddiDB) - DB connection was not aquired. (java.sql.SQLException: Server connection failure during transaction. Due to underlying exception: 'java.sql.SQLException: Syntax error or access violation message from server: "Unknown database 'juddi'"'. ** BEGIN NESTED EXCEPTION ** java.sql.SQLException MESSAGE: Syntax error or access violation message from server: "Unknown database 'juddi'" STACKTRACE: java.sql.SQLException: Syntax error or access violation message from server: "Unknown database 'juddi'"  at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1997)  at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1906)  at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:2520)  at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:817)  at com.mysql.jdbc.Connection.createNewIO(Connection.java:1902)  at com.mysql.jdbc.Connection.(Connection.java:450)  at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:411)  at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:83)  at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:184)  at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(Unknown Source)  at org.apache.commons.dbcp.AbandonedObjectPool.borrowObject(AbandonedObjectPool.java:117)  at org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:110)  at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:312)  at org.apache.jsp.happyjuddi_jsp._jspService(happyjuddi_jsp.java:333)  at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:92)  at javax.servlet.http.HttpServlet.service(HttpServlet.java:809)  at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:162)  at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:240)  at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:187)  at javax.servlet.http.HttpServlet.service(HttpServlet.java:809)  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:200)  at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:146)  at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:209)  at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:596)  at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:433)  at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:948)  at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:144)  at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:596)  at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:433)  at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:948)  at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2358)  at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:133)  at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:596)  at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:118)  at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:594)  at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:116)  at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:594)  at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:433)  at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:948)  at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:127)  at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:596)  at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:433)  at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:948)  at org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:152)  at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:799)  at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:705)  at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:577)  at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:683)  at java.lang.Thread.run(Thread.java:534) ** END NESTED EXCEPTION ** Attempted reconnect 3 times. Giving up.) - SELECT COUNT(*) FROM PUBLISHER failed (null) ÎÒ°²×°MySQLµÄʱºòÓõÄĬÈÏusername£¬ÉèÖÃÁËÃÜÂë ÄÇô <parameter><name>username</name><value>root</value></parameter> <parameter><name>password</name><value>****</value></parameter> Ö»Òª°ÑÃÜÂë¸Ä³É×Ô¼ºµÄ¾Í¿ÉÒÔÁË°É <value>jdbc:mysql://host.domain.com:3306/juddi?autoReconnect=true</value> ÒòΪ·þÎñÆ÷¾ÍÊDZ¾µØ»úÆ÷£¬¾Í¸Ä³ÉÁË <value>jdbc:mysql://localhost:3306/juddi?autoReconnect=true</value> È»ºó¼ì²â¾ÍһƬºìÁË¡­¡­ÇëÎÊÕâÊǵ½µ×Ϊʲôѽ

	µÚ12Â¥

ÎÒÒ²Åöµ½ÀàËƵÄÎÊÌ⣬ + 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) ŪÁËÒ»ÕûÌ죬googleÁ˺ܶàÍøÕ¾£¬»¹ÊÇûÓи㶨£¡ÕæÊÇÓôÃÆ°¡£¡ ¿ÒÇëÅöµ½¹ý´ËÎÊÌâ²¢³É¹¦½â¾öµÄxdÖ¸µãһϣ¡

	µÚ13Â¥

ÎÒÓõÄÊÇsqlserver2000ÅäÖÃÁËÒ»±é£¬½á¹û»¹ÊÇÓÐÄÇÁ½Ðкì×Ö£¬µÚÒ»ÐеĴíÎóÓе㲻ͬ¡£ Çë¸÷λ´óʦָµã£¬Ó¦¸ÃÔõô¸ã¶¨Ëû¡£¡£ + Got a JNDI Context! + Got a JDBC DataSource (dsname=java:comp/env/jdbc/juddiDB) - DB connection was not aquired. (Cannot create PoolableConnectionFactory) - SELECT COUNT(*) FROM PUBLISHER failed (null)

	µÚ14Â¥

fsaf

	µÚ15Â¥

ÎÒÓõÄÊÇjdk1.5.0+tomcat5.5.9,tomcatÕý³£Ê¹ÓÃ. ÎÒ°´×°juddiµÄ²½ÖèÈçÏÂ: 1.´ÓmysqlµÄ¹Ù·½ÍøÕ¾ÉÏÏÂÔØmysql-5.0.13-rc-win32.zip½âѹºó°²×°µ½C:\Program Files\MySQL\MySQL Server 5.0. 2.´Óapache¹Ù·½ÍøÕ¾ÉÏÏÂÔØjuddi-0.9rc4.zip,½âѹºó½«juddi.war¸´ÖƵ½..\tomcat\webapps\ÏÂ. 3.´Óhttp://www.mysql.com/downloads/api-jdbc-stable.html,ÏÂÔØmysql-connector-java-3.0.17-ga.zip,½âѹºó½«mysql-connector-java-3.0.17-ga-bin.jar¸´ÖƵ½../tomcat/common/lib/ÏÂ( http://www.mysql.com/downloads/api-jdbc-stable.htmlÍøÕ¾ÉÏ˵.ga¾ÍÊÇstable°æ). 4.ÐÞ¸Ä../tomcat/conf/server.xmlÔÚ</Host>ºóÌí¼ÓÈçÏÂ: <DefaultContext 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"/>   <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>     <!-- 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>maxWait</name><value>10000</value></parameter>     <!-- MySQL dB username and password for dB connections -->     <parameter><name>username</name><value>root</value></parameter>     <parameter><name>password</name><value>147369</value></parameter>     <!-- Class name for mysql JDBC driver -->     <parameter>       <name>driverClassName</name>      <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://localhost:3306/juddi?autoReconnect=true</value>     </parameter>     <parameter>            <name>validationQuery</name>            <value>select count(*) from PUBLISHER</value>     </parameter>   </ResourceParams> </DefaultContext> 5.´ò¿ªmysql,ÒÔrootÉí·ÝµÇ½(ÃÜÂë:147369),²¢½¨Á¢Êý¾Ý¿â¼°±í¸ñÈçÏÂ: mysql> CREATE database juddi; Query OK, 1 row affected (0.02 sec) mysql> use juddi; Database changed mysql> CREATE TABLE PUBLISHER     ->  (     ->    PUBLISHER_ID VARCHAR(20) NOT NULL,     ->    PUBLISHER_NAME VARCHAR(255) NOT NULL,     ->    LAST_NAME VARCHAR(150) NULL,     ->    FIRST_NAME VARCHAR(100) NULL,     ->    MIDDLE_INIT VARCHAR(5) NULL,     ->    WORK_PHONE VARCHAR(50) NULL,     ->    MOBILE_PHONE VARCHAR(50) NULL,     ->    PAGER VARCHAR(50) NULL,     ->    EMAIL_ADDRESS VARCHAR(255) NULL,     ->    ADMIN VARCHAR(5) NULL,     ->    ENABLED VARCHAR(5) NULL,     ->    PRIMARY KEY (PUBLISHER_ID)     ->  ); Query OK, 0 rows affected (0.13 sec) mysql> INSERT INTO PUBLISHER (PUBLISHER_ID, PUBLISHER_NAME, ADMIN) valueS ('ju i', 'Juddi user', 'false'); Query OK, 1 row affected (0.05 sec) 6.ÖØÐÂÆô¶¯tomcat,µ«»¹ÊÇÏÔʾ¸Õ¸Õ°²ÉÏjuddiʱµÄÁ½¸ö´íÎó: - DB connection was not aquired. (Cannot create JDBC driver of class '' for connect URL 'null') - SELECT COUNT(*) FROM PUBLISHER failed (null) ºÃÏñserver.xmlµÄÐÞ¸ÄûÓÐÈκÎ×÷ÓÃÒ»Ñù. ÎÒºÃ׿±,ºÃÓôÃÆ,Íû°æÖ÷¸øÓëÖ¸µã,²»Ê¤¸Ð¼¤!!!!

	µÚ16Â¥

¶ÔÁË£¬ÎÒµÄϵͳÊÇwin2000

	µÚ17Â¥

´ó¼ÒºÃ

	µÚ18Â¥

ÎÒÓÖÀ´ÁË,²»¹ýÕâ´ÎÊÇÒªºÍ´ó¼Ò·ÖÏíʤÀûµÄϲÔÃ! ÎÒÓõÄÊÇjdk1.5.0+tomcat5.0.30,tomcatÕý³£Ê¹ÓÃ.(win2000ϵͳ) ÎÒ°´×°juddiµÄ²½ÖèÈçÏÂ: 1.´ÓmysqlµÄ¹Ù·½ÍøÕ¾ÉÏÏÂÔØmysql-5.0.13-rc-win32.zip½âѹºó°²×°µ½C:\Program Files\MySQL\MySQL Server 5.0. 2.´Óapache¹Ù·½ÍøÕ¾ÉÏÏÂÔØjuddi-0.9rc4.zip,½âѹºó½«juddi.war¸´ÖƵ½..\tomcat\webapps\ÏÂ. 3.´Óhttp://www.mysql.com/downloads/api-jdbc-stable.html,ÏÂÔØmysql-connector-java-3.0.17-ga.zip,½âѹºó½«mysql-connector-java-3.0.17-ga-bin.jar¸´ÖƵ½../tomcat/common/lib/ÏÂ(²¢Ìí¼Óµ½»·¾³±äÁ¿)../tomcat/webapps/juddi/WEB-INF/lib. 4.ÐÞ¸Ä../tomcat/conf/server.xmlÔÚ</Host>ºóÌí¼ÓÈçÏÂ: <DefaultContext reloadable="true" crossContext="true">   <Resource name="jdbc/juddiDB" scope="Shareable" type="javax.sql.DataSource"/>   <ResourceParams name="jdbc/juddiDB">    <parameter>       <name>username</name>       <value>myy</value>     </parameter>     <parameter>       <name>password</name>       <value>123456</value>     </parameter>     <parameter>       <name>url</name>       <value>         jdbc:mysql://localhost/javatest       </value>     </parameter>     <parameter>       <name>driverClassName</name>       <value>org.gjt.mm.mysql.Driver</value>     </parameter>   </ResourceParams> </DefaultContext> 5.´ò¿ªmysql,ÒÔrootÉí·ÝµÇ½,²¢½¨Á¢Óû§(×¢ÒâÓû§Ò»¶¨Òª½¨Á¢),Êý¾Ý¿â¼°±í¸ñÈçÏÂ: mysql> GRANT ALL PRIVILEGES ON *.* TO 'myy'@'localhost'       ->     IDENTIFIED BY '123456' WITH GRANT OPTION; //ÎÒµÄÓû§ÃûÊÇmyy,ÃÜÂë:123456 mysql> create database javatest; Query OK, 1 row affected (0.02 sec) mysql> use juddi; Database changed mysql> CREATE TABLE PUBLISHER     ->  (     ->    PUBLISHER_ID VARCHAR(20) NOT NULL,     ->    PUBLISHER_NAME VARCHAR(255) NOT NULL,     ->    LAST_NAME VARCHAR(150) NULL,     ->    FIRST_NAME VARCHAR(100) NULL,     ->    MIDDLE_INIT VARCHAR(5) NULL,     ->    WORK_PHONE VARCHAR(50) NULL,     ->    MOBILE_PHONE VARCHAR(50) NULL,     ->    PAGER VARCHAR(50) NULL,     ->    EMAIL_ADDRESS VARCHAR(255) NULL,     ->    ADMIN VARCHAR(5) NULL,     ->    ENABLED VARCHAR(5) NULL,     ->    PRIMARY KEY (PUBLISHER_ID)     ->  ); Query OK, 0 rows affected (0.13 sec) mysql> INSERT INTO PUBLISHER (PUBLISHER_ID, PUBLISHER_NAME, ADMIN) valueS ('ju i', 'Juddi user', 'false'); Query OK, 1 row affected (0.05 sec) 6.ÖØÐÂÆô¶¯tomcat. ×¢Òâ: 1.tomcatµÄ°æ±¾ºÜÖØÒª,ÎÒ¸Õ¿ªÊ¼Ê±Ê¹ÓõÄÊÇtomcat5.5.9,ÎÞÂÛÈçºÎ¶¼ÅäÖò»ºÃ,¶øÇÒ´íÎó´ÓÀ´¶¼²»±ä,ºóÀ´·¢ÏÖtomcat5.5.9ºÍconfĿ¼ÖеÄÄÚÈݺÍtomcat5.0.30²»Ò»Ñù,ָʾÆäÅäÖÃÐÅÏ¢ÎÞ·¨¼ÓÔØ.

	µÚ19Â¥

ÅäÖÃÕâ¸öÐèҪעÒâµÄÎÊÌ⣺ $tomcat_home/webapps\juddi\WEB-INF juddi_user.xmlÎĵµÖÐÌí¼ÓÓû§£¬²¢È·±£ÆäÔÚ Êý¾Ý¿âpublisher±íÖÐ ÐÞ¸Ä$tomcat_home/conf/server.xml Îĵµ ÕâÊÇÅäÖÃjuddiÊý¾ÝÔ´µÄ£¬ÒÔ¼°Êý¾ÝÇý¶¯

----------------------------------------------
²»Òª·ÅÆúºÍѧ»á·ÅÆú

	µÚ20Â¥

ÇëÎÊÉ϶δúÂëÊÇÔÚserver.xmlÖÐÐ޸ĵÄÂð£¿ÎÒÔõôÔÚserver.xmlÖÐÕÒ²»µ½±êÇ©<context>¡£¶øÇÒÔÚÔËÐÐhappyjuddi.jspʱ£¬»¹ÓÐÒ»Ïî´íÎóÊÇnot found: javax.activation.DataHandler.Âé·³¸÷λ¸øÓè½â´ð¡£