jtree mysql_关于数据库连接池配置引发的各种凌乱Cannot create JDBC driver of class '' for connect URL 'null’...

3..xml文件配置基本完成，然后是编写测试代码测试数据库连接池(主要连接代码如下)：

Context cxt = new

InitialContext();

DataSource ds

=(DataSource)cxt.lookup("java:/comp/env/jdbc/TestDB");

conn = ds.getConnection();

二.配置项目tomcat虚拟路径：

1.发布项目运行可以有两种路径，一种是直接在tomcat目录下webapps下建立项目文件夹(如：myProject)，然后在myProject下创建WEB-INF文件夹和*.jsp文件，在WEB-INF下创建classes文件夹(放java编译后的class文件)、lib文件夹(放jar包文件)、web.xml文件(配置同上)，完成代码后可直接在浏览器输入http://localhost:8080/myProject/index.jsp

测试效果。

PS：此方法需手动创建相关文件夹和配置，还要把通过编译后的.class文件复制到classes文件夹中，步骤繁琐却不容易出错。

2.虚拟路径设置：不想把项目放在webapps目录下，这时需设置虚拟路径。网络上对于虚拟路径的设置有很多方法，基本上是对apache-tomcat-7.0.29\conf下的context.xml和server.xml两个文件，在

path=""

docBase="">

中设置path和docBase。但这种方法对于我的项目路径却不管用，所以我在eclipse建立在其他路径下的项目运行总是出错。本人在这问题上纠结了很久，发现是虚拟路径配置问题，根据网上的方法配置了N遍都还是出现这个Exception。具体异常如下：

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

mysql.database.DBConnect.init(DBConnect.java:21)

at

mysql.database.DBConnect.(DBConnect.java:43)

at

jsp.test.BookBean.addBook(BookBean.java:59)

at

jsp.test.AddBookServlet.service(AddBookServlet.java:41)

at

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

at

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

at

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

at

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

at

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

at

org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472)

at

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

at

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

at

org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:927)

at

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

at

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

at

org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1001)

at

org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:585)

at

org.apache.tomcat.util.net.AprEndpoint$SocketProcessor.run(AprEndpoint.java:1770)

at

java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110)

at

java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603)

at

java.lang.Thread.run(Thread.java:722)

Caused by:

java.lang.NullPointerException

at

sun.jdbc.odbc.JdbcOdbcDriver.getProtocol(JdbcOdbcDriver.java:524)

at

sun.jdbc.odbc.JdbcOdbcDriver.knownURL(JdbcOdbcDriver.java:493)

at

sun.jdbc.odbc.JdbcOdbcDriver.acceptsURL(JdbcOdbcDriver.java:307)

at

java.sql.DriverManager.getDriver(DriverManager.java:273)

at

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

... 23 more

java.lang.NullPointerException

at

mysql.database.DBConnect.prepareStatement(DBConnect.java:252)

at

mysql.database.DBConnect.(DBConnect.java:44)

at

jsp.test.BookBean.addBook(BookBean.java:59)

at

jsp.test.AddBookServlet.service(AddBookServlet.java:41)

at

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

at

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

at

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

at

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

at

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

at

org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472)

at

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

at

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

at

org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:927)

at

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

at

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

at

org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1001)

at

org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:585)

at

org.apache.tomcat.util.net.AprEndpoint$SocketProcessor.run(AprEndpoint.java:1770)

at

java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110)

at

java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603)

at

java.lang.Thread.run(Thread.java:722)

解决这个异常的方法是：在eclipse中配置项目发布路径，具体如下：在eclipse下部的Servers窗口中多击Tomcat v6.0

Server at localhost，找到图中所示，将Server Locations选为第二项Use

Tomcat……

Server path：为tomcat所在目录

Deploy path：设为webapps

上图中Server

Locations显示为灰色，不能直接设置，因此必须新建一个Tomcatv6.0(2) Server at

localhost才能设置以上参数。具体方法是在下部Server窗口中右键点击Tomcatv6.0

Server at localhost ——new——Server(设置完成如下，这时使用新建的tomcat

server就能够正常运行项目了！！)