Tomcat6.0.14+Db29.1 连接池问题
软件名称&软件版本：Tomcat6.0.14+Db29.1
环境平台：windows
问题描述：配置数据源不成功，
配置代码如下：
=================================================
在meta-inf文件夹下建立context.xml
type="javax.sql.DataSource" maxActive="50" maxIdle="30"
maxWait="10000" logAbandoned="true" username="db2inst1" password="password"
driverClassName="com.ibm.db2.jcc.DB2Driver"
url="jdbc:db2://10.1.120.57:50000/dcdb">
=================================================
测试代码：
<%
Context ctx=new InitialContext();
DataSource ds=(DataSource) ctx.lookup("java:/comp/env/dc");
out.println(ds.getConnection());
%>
================================================
报错：
org.apache.jasper.JasperException: javax.servlet.ServletException: org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot load JDBC driver class 'com.ibm.db2.jcc.DB2Driver' org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:541) org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:417) org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:320) org.apache.jasper.servlet.JspServlet.service(JspServlet.java:266) javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
备注：本人连本机的mysql用此方法可以实现，测试通过。但是链接远程的db2就不行
环境平台：windows
问题描述：配置数据源不成功，
配置代码如下：
=================================================
在meta-inf文件夹下建立context.xml
type="javax.sql.DataSource" maxActive="50" maxIdle="30"
maxWait="10000" logAbandoned="true" username="db2inst1" password="password"
driverClassName="com.ibm.db2.jcc.DB2Driver"
url="jdbc:db2://10.1.120.57:50000/dcdb">
=================================================
测试代码：
<%
Context ctx=new InitialContext();
DataSource ds=(DataSource) ctx.lookup("java:/comp/env/dc");
out.println(ds.getConnection());
%>
================================================
报错：
org.apache.jasper.JasperException: javax.servlet.ServletException: org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot load JDBC driver class 'com.ibm.db2.jcc.DB2Driver' org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:541) org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:417) org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:320) org.apache.jasper.servlet.JspServlet.service(JspServlet.java:266) javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
备注：本人连本机的mysql用此方法可以实现，测试通过。但是链接远程的db2就不行
12同行回答
浏览656
把driverClassName="com.ibm.db2.jcc.DB2Driver"改成driverClassName="com.p6spy.engine.spy.P6SpyDriver" ...sconglv 发表于 2010-4-23 16:27
java.lang.ClassNotFoundException: com.p6spy.engine.spy.P6SpyDriverat java.net.URLClassLoader$1.run(Unknown Source)a...把driverClassName="com.ibm.db2.jcc.DB2Driver"改成
driverClassName="com.p6spy.engine.spy.P6SpyDriver" ...
sconglv 发表于 2010-4-23 16:27
java.lang.ClassNotFoundException: com.p6spy.engine.spy.P6SpyDriver
at java.net.URLClassLoader$1.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at java.lang.ClassLoader.loadClassInternal(Unknown Source)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Unknown Source)
at org.apache.tomcat.dbcp.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1130)
at org.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection(BasicDataSource.java:880)
at org.apache.jsp.aa_jsp._jspService(aa_jsp.java:67)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:393)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:320)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:266)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
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:175)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
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:263)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:584)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
at java.lang.Thread.run(Unknown Source)
兄弟，为什么要这样呢？虽然不行，但是我还是想知道您给这个类的原因收起
浏览673
