我用spring mvc 作jdbc连接数据库的练习时发现老抛下面的异常,可是jdbc,dbcp,pool,logging,collections,这些包我都导进tomcat/common/lib去了,在工程里也导了,还是不行请问个位这是怎莫回事啊
----------------------------------------------
org.apache.commons.dbcp.SQLNestedException: Cannot create JDBC driver of class 'com.microsoft.jdbc.sqlserver.SQLServerDriver' for connect URL '
jdbc:microsoft:sqlserver://127.0.0.1:1433;dataBaseName=northwind
'
at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:780)
at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:540)
at com.dao.mds.selectLogin(mds.java:20)
at com.action.LoginAction.onSubmit(LoginAction.java:26)
at org.springframework.web.servlet.mvc.SimpleFormController.onSubmit(SimpleFormController.java:356)
at org.springframework.web.servlet.mvc.SimpleFormController.processFormSubmission(SimpleFormController.java:258)
at org.springframework.web.servlet.mvc.AbstractFormController.handleRequestInternal(AbstractFormController.java:249)
at org.springframework.web.servlet.mvc.AbstractController.handleRequest(AbstractController.java:153)
at org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:44)
at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:723)
at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:663)
at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:394)
at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:358)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
----------------------------------------------
org.apache.commons.dbcp.SQLNestedException: Cannot create JDBC driver of class 'com.microsoft.jdbc.sqlserver.SQLServerDriver' for connect URL '
jdbc:microsoft:sqlserver://127.0.0.1:1433;dataBaseName=northwind
'
at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:780)
at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:540)
at com.dao.mds.selectLogin(mds.java:20)
at com.action.LoginAction.onSubmit(LoginAction.java:26)
at org.springframework.web.servlet.mvc.SimpleFormController.onSubmit(SimpleFormController.java:356)
at org.springframework.web.servlet.mvc.SimpleFormController.processFormSubmission(SimpleFormController.java:258)
at org.springframework.web.servlet.mvc.AbstractFormController.handleRequestInternal(AbstractFormController.java:249)
at org.springframework.web.servlet.mvc.AbstractController.handleRequest(AbstractController.java:153)
at org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:44)
at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:723)
at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:663)
at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:394)
at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:358)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
解决方案 »
- jsp中验证码的问题
- 刚学jsp,想实现表格分页技术,大侠指点!
- Struts问题:如何选中下拉框的值?
- 请教与mysql连接问题,大家帮忙指点下!!
- 问一个有关套接字输出编码的问题
- 能不能在同一个bean里连接两个不同的数据库?
- 小弟准备学cocoon,想请网上的兄弟们对cocoon有兴趣的朋友留下QQ or mail or msn 方便交流(还有分拿 300分开三帖放分,呵呵)第二
- Jsp中怎样让语句结束?就像ASP中用response.end ???
- 表单用enctype="multipart/form-data"二进制流形式提交的话,除了file,其他的表单控件应该用什么方法接收呢?
- 集成Shiro 一直报错 提示org.hibernate.HibernateException: No Session found for current th
- mysql数据库备份后无法恢复的问题
- 一个网站有120个子站 怎么对这120个子站进行处理 急!~~~~~~~
应该是找不到jdbc连接sqlserver的jar包,你确定那个包已经导入到你的项目中了吗?
如果是刚刚导入的,请重启tomcat然后再试.