tomcat6.0连接mysql_tomcat6.0下配置mysql连接池（二）

javax.naming.Context ctx = new javax.naming.InitialContext();

javax.sql.DataSource ds =

(javax.sql.DataSource)ctx.lookup("java:/comp/env/jdbc/webdb");

conn = ds.getConnection();

如果你也出现了下面的问题，很可能是你的配置文件出错，仔细检查下，可能就会发现问题。

org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create JDBC

driver of class '' for connect URL 'null'

at

org.apache.tomcat.dbcp.dbcp.BasicDataSource.createConnectionFactory(BasicDataSource.java:1452)

at

org.apache.tomcat.dbcp.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1371)

at

org.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044)

at common.DBServlet.service(DBServlet.java:43)

at logreg.Register.service(Register.java:20)

at

javax.servlet.http.HttpServlet.service(HttpServlet.java:717)

at

org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)

at

org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

at

org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)

at

org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)

at

org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)

at

org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)

at

org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)

at

org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:291)

at

org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:859)

at

org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:602)

at

org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)

at java.lang.Thread.run(Unknown Source)

Caused by: java.lang.NullPointerException

at sun.jdbc.odbc.JdbcOdbcDriver.getProtocol(Unknown Source)

at sun.jdbc.odbc.JdbcOdbcDriver.knownURL(Unknown Source)

at sun.jdbc.odbc.JdbcOdbcDriver.acceptsURL(Unknown Source)

at java.sql.DriverManager.getDriver(Unknown Source)

at

org.apache.tomcat.dbcp.dbcp.BasicDataSource.createConnectionFactory(BasicDataSource.java:1437)

... 17 more

null

如果建立了context.xml文件，放到%TOMCATHOME%\conf\Catalina\localhost目录下时就会报下面的错误。

java.lang.IllegalArgumentException: Document base

D:\Java\apache-tomcat-6.0.33\webapps\context does not exist or is

not a readable directory

at

org.apache.naming.resources.FileDirContext.setDocBase(FileDirContext.java:142)

at

org.apache.catalina.core.StandardContext.resourcesStart(StandardContext.java:4320)

at

org.apache.catalina.core.StandardContext.start(StandardContext.java:4489)

at

org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:799)

at

org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:779)

at

org.apache.catalina.core.StandardHost.addChild(StandardHost.java:601)

at

org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:675)

at

org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:601)

at

org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:502)

at

org.apache.catalina.startup.HostConfig.start(HostConfig.java:1317)

at

org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:324)

at

org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:142)

at

org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1065)

at

org.apache.catalina.core.StandardHost.start(StandardHost.java:840)

at

org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1057)

at

org.apache.catalina.core.StandardEngine.start(StandardEngine.java:463)

at

org.apache.catalina.core.StandardService.start(StandardService.java:525)

at

org.apache.catalina.core.StandardServer.start(StandardServer.java:754)

at

org.apache.catalina.startup.Catalina.start(Catalina.java:595)

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:289)

at

org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414)

2011-9-8 14:55:54 org.apache.catalina.core.StandardContext

start

以上是我在tomcat6中配置数据库连接池的经验，希望对于需要的人有所帮助。由于本人的经验、能力有限，如有理解错误的地方，希望大家发email及时通知我，

我的邮箱是srb.123@163.com。