dbcp mysql tomcat_在tomcat 6 下如何配置DBCP+MYSQL 5.1的连接池呢，急

最新推荐文章于 2021-12-14 21:59:13 发布

罗必成

最新推荐文章于 2021-12-14 21:59:13 发布

阅读量179

点赞数

文章标签： dbcp mysql tomcat

本文链接：https://blog.csdn.net/weixin_28717807/article/details/113464671

版权

在tomcat 6 下如何配置DBCP+MYSQL 5.1的连接池呢，JDBC也放在了tomcat/lib下，可总是部署时报异常，按照网上的各种做法都试了，结果还是不行

我是在tomcat下的conf/context.xml中的中配置的如下文件

name="jdbc/mysql"

auth="Container"

type="javax.sql.DataSource"

driverClassName="com.mysql.jdbc.Driver"

url="jdbc:mysql://localhost:3306/db?autoReconnect=true&useUnicode=true;characterEncoding=UTF-8"

username="root"

password="root"

maxActive="100"

maxIdel="30"

maxWait="10000";

factory="org.apache.tomcat.dbcp.dbcp.BasicDataSourceFactory"

removeAbandoned="true"

removeAbandonedTimeout="300"

logAbandoned="true"

并且也在WEB-INF/web.xml中配置了

DB Connection

jdbc/mysql

javax.sql.DataSource

Container

可是部署在tomcat时发生如下异常

2009-8-31 10:54:10 org.apache.catalina.core.AprLifecycleListener init

信息: The APR based Apache Tomcat Native library which allows optimal performance in production environments was not found on the java.library.path: C:\Program Files\Java\jre6\bin;D:\Computer Files\Tomcat\bin

2009-8-31 10:54:11 org.apache.coyote.http11.Http11Protocol init

信息: Initializing Coyote HTTP/1.1 on http-8080

2009-8-31 10:54:11 org.apache.catalina.startup.Catalina load

信息: Initialization processed in 930 ms

2009-8-31 10:54:11 org.apache.catalina.core.StandardService start

信息: Starting service Catalina

2009-8-31 10:54:11 org.apache.catalina.core.StandardEngine start

信息: Starting Servlet Engine: Apache Tomcat/6.0.20

2009-8-31 10:54:11 org.apache.tomcat.util.digester.Digester endElement

严重: End event threw exception

java.lang.reflect.InvocationTargetException

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

at java.lang.reflect.Method.invoke(Unknown Source)

at org.apache.tomcat.util.IntrospectionUtils.callMethod1(IntrospectionUtils.java:925)

at org.apache.catalina.startup.SetNextNamingRule.end(SetNextNamingRule.java:98)

at org.apache.tomcat.util.digester.Rule.end(Rule.java:229)

at org.apache.tomcat.util.digester.Digester.endElement(Digester.java:1140)

at com.sun.org.apache.xerces.internal.parsers.AbstractSAXParser.endElement(Unknown Source)

at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl.scanEndElement(Unknown Source)

at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl$FragmentContentDriver.next(Unknown Source)

at com.sun.org.apache.xerces.internal.impl.XMLDocumentScannerImpl.next(Unknown Source)

at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl.scanDocument(Unknown Source)

at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(Unknown Source)

at com.sun.org.apache.xerces.internal.parsers.XMLParser.parse(Unknown Source)

at com.sun.org.apache.xerces.internal.parsers.AbstractSAXParser.parse(Unknown Source)

at com.sun.org.apache.xerces.internal.jaxp.SAXParserImpl$JAXPSAXParser.parse(Unknown Source)

at org.apache.tomcat.util.digester.Digester.parse(Digester.java:1644)

at org.apache.catalina.startup.ContextConfig.processContextConfig(ContextConfig.java:789)

at org.apache.catalina.startup.ContextConfig.contextConfig(ContextConfig.java:728)

at org.apache.catalina.startup.ContextConfig.init(ContextConfig.java:1009)

at org.apache.catalina.startup.ContextConfig.lifecycleEvent(ContextConfig.java:279)

at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119)

at org.apache.catalina.core.StandardContext.init(StandardContext.java:5398)

at org.apache.catalina.core.StandardContext.start(StandardContext.java:4177)

at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:791)

at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:771)

at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:526)

at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:630)

at org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:556)

at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:491)

at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1206)

at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:314)

at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119)

at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053)

at org.apache.catalina.core.StandardHost.start(StandardHost.java:722)

at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)

at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)

at org.apache.catalina.core.StandardService.start(StandardService.java:516)

at org.apache.catalina.core.StandardServer.start(StandardServer.java:710)

at org.apache.catalina.startup.Catalina.start(Catalina.java:583)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

at java.lang.reflect.Method.invoke(Unknown Source)

at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:288)

at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:413)

Caused by: java.lang.NullPointerException

at java.util.Hashtable.containsKey(Unknown Source)

at org.apache.catalina.deploy.NamingResources.addResource(NamingResources.java:295)

... 48 more

2009-8-31 10:54:11 org.apache.catalina.startup.ContextConfig processContextConfig

严重: Parse error in context.xml for /host-manager

java.lang.NullPointerException

at org.apache.tomcat.util.digester.Digester.createSAXException(Digester.java:2808)

at org.apache.tomcat.util.digester.Digester.createSAXException(Digester.java:2834)

at org.apache.tomcat.util.digester.Digester.endElement(Digester.java:1143)