急急急!!org.apache.tomcat.dbcp.dbcp.SQLNestedException怎么解决?

Question

org.apache.tomcat.dbcp.dbcp.SQLNestedException:Cannot create JDBC driver of class 'com.microsoft.sqlserver.jdbc.SQLServerDataSource' for connect URL 'jdbc:sqlserver://WANGCONG-PC:1433;DatabaseName=restrant'at org.apache.tomcat.dbcp.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1150)
at org.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection(BasicDataSource.java:880)
at com.cdjj.wangcong.jj2.bean.DBConnection.getCon(DBConnection.java:25)
at com.cdjj.wangcong.jj2.dao.TextQuery.find(TextQuery.java:24)
at org.apache.jsp.ch06.textQuery_jsp._jspService(textQuery_jsp.java:60)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:374)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:342)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:267)
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: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:286)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:845)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
at java.lang.Thread.run(Thread.java:619)
Caused by: java.sql.SQLException: No suitable driver
at java.sql.DriverManager.getDriver(DriverManager.java:264)
at org.apache.tomcat.dbcp.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1143)
... 22 more
2010-4-7 22:56:58 org.apache.catalina.core.StandardWrapperValve invoke
严重: Servlet.service() for servlet jsp threw exception
java.lang.NullPointerException
at com.cdjj.wangcong.jj2.bean.SQLCommandBean.executeQuery(SQLCommandBean.java:53)
at com.cdjj.wangcong.jj2.dao.TextQuery.find(TextQuery.java:32)
at org.apache.jsp.ch06.textQuery_jsp._jspService(textQuery_jsp.java:60)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:374)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:342)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:267)
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: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:286)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:845)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
at java.lang.Thread.run(Thread.java:619)这个错误应该怎么解决.contex 配置是:<Resource name="jdbc/restrant" auth="Container" type="javax.sql.DataSource" maxActive="100"maxIdle="30" maxWait="10000" username="sa"password="wangcong" driverClassName="com.microsoft.sqlserver.jdbc.SQLServerDataSource"
  url="jdbc:sqlserver://WANGCONG-PC:1433;DatabaseName=restrant"/>数据库是sqlserver2005.tomcat6.0

Answer 1

  包导入进去了没有。。
     driverClassName="com.microsoft.sqlserver.jdbc.SQLServerDataSource"
  url="jdbc:sqlserver://WANGCONG-PC:1433;DatabaseName=restrant"/>  你确定这里写对了吗？

Answer 2

driverClassName="com.microsoft.sqlserver.jdbc.SQLServerDataSource"
  url="jdbc:sqlserver://WANGCONG-PC:1433;DatabaseName=restrant"/>
这里是写对了的,,在jsp里面第一次编译的时候报错,再刷新就有数据了...能拿到数据,现在完全懵了,不知道tomcat和sqlserver问题出在哪里了