问题描述
spring中配置<beanid="dataSource"class="org.springframework.jdbc.datasource.DriverManagerDataSource"><propertyname="driverClassName"><value>com.microsoft.sqlserver.jdbc.SQLServerDriver</value></property><propertyname="url"><value>jdbc:sqlserver://localhost:1433;DatabaseName=shop</value></property><propertyname="username"><value>sa</value></property><propertyname="password"><value>123456</value></property></bean>-------------------------------------------------------错误信息严重:Servlet.service()forservletdefaultthrewexceptionorg.springframework.beans.PropertyBatchUpdateException;nestedPropertyAccessExceptiondetails(1)are:PropertyAccessException1:org.springframework.beans.MethodInvocationException:Property'driverClassName'threwexception;nestedexceptionisjava.lang.IllegalStateException:CouldnotloadJDBCdriverclass[com.microsoft.sqlserver.jdbc.SQLServerDriver]atorg.springframework.beans.BeanWrapperImpl.setPropertyValue(BeanWrapperImpl.java:849)atorg.springframework.beans.BeanWrapperImpl.setPropertyValue(BeanWrapperImpl.java:651)atorg.springframework.beans.AbstractPropertyAccessor.setPropertyValues(AbstractPropertyAccessor.java:78)atorg.springframework.beans.AbstractPropertyAccessor.setPropertyValues(AbstractPropertyAccessor.java:59)atorg.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1274)atorg.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1008)atorg.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:470)atorg.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory$1.run(AbstractAutowireCapableBeanFactory.java:409)atjava.security.AccessController.doPrivileged(NativeMethod)atorg.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:380)atorg.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:264)atorg.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:220)atorg.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:261)atorg.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:185)atorg.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:164)atorg.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:429)atorg.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:729)atorg.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:381)atorg.springframework.context.support.ClassPathXmlApplicationContext.<init>(ClassPathXmlApplicationContext.java:139)atorg.springframework.context.support.ClassPathXmlApplicationContext.<init>(ClassPathXmlApplicationContext.java:83)aty2ssh.java.shop.manager.util.SpringUtil.<clinit>(SpringUtil.java:8)aty2ssh.java.shop.manager.action.LoginAction.<init>(LoginAction.java:35)atsun.reflect.NativeConstructorAccessorImpl.newInstance0(NativeMethod)atsun.reflect.NativeConstructorAccessorImpl.newInstance(UnknownSource)atsun.reflect.DelegatingConstructorAccessorImpl.newInstance(UnknownSource)atjava.lang.reflect.Constructor.newInstance(UnknownSource)atjava.lang.Class.newInstance0(UnknownSource)atjava.lang.Class.newInstance(UnknownSource)atcom.opensymphony.xwork2.ObjectFactory.buildBean(ObjectFactory.java:123)atcom.opensymphony.xwork2.ObjectFactory.buildBean(ObjectFactory.java:154)atcom.opensymphony.xwork2.ObjectFactory.buildBean(ObjectFactory.java:143)atcom.opensymphony.xwork2.ObjectFactory.buildAction(ObjectFactory.java:113)atcom.opensymphony.xwork2.DefaultActionInvocation.createAction(DefaultActionInvocation.java:275)atcom.opensymphony.xwork2.DefaultActionInvocation.init(DefaultActionInvocation.java:365)atcom.opensymphony.xwork2.DefaultActionInvocation.access$000(DefaultActionInvocation.java:38)atcom.opensymphony.xwork2.DefaultActionInvocation$1.doProfiling(DefaultActionInvocation.java:83)atcom.opensymphony.xwork2.util.profiling.UtilTimerStack.profile(UtilTimerStack.java:455)atcom.opensymphony.xwork2.DefaultActionInvocation.<init>(DefaultActionInvocation.java:74)atcom.opensymphony.xwork2.DefaultActionProxy.prepare(DefaultActionProxy.java:189)atorg.apache.struts2.impl.StrutsActionProxyFactory.createActionProxy(StrutsActionProxyFactory.java:41)atorg.apache.struts2.dispatcher.Dispatcher.serviceAction(Dispatcher.java:494)atorg.apache.struts2.dispatcher.FilterDispatcher.doFilter(FilterDispatcher.java:419)atorg.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)atorg.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)atorg.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)atorg.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)atorg.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)atorg.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)atorg.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)atorg.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286)atorg.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcessor.java:856)atorg.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.process(Http11AprProtocol.java:565)atorg.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1509)atjava.lang.Thread.run(UnknownSource)Causedby:java.lang.IllegalStateException:CouldnotloadJDBCdriverclass[com.microsoft.sqlserver.jdbc.SQLServerDriver]atorg.springframework.jdbc.datasource.DriverManagerDataSource.setDriverClassName(DriverManagerDataSource.java:145)atsun.reflect.NativeMethodAccessorImpl.invoke0(NativeMethod)atsun.reflect.NativeMethodAccessorImpl.invoke(UnknownSource)atsun.reflect.DelegatingMethodAccessorImpl.invoke(UnknownSource)atjava.lang.reflect.Method.invoke(UnknownSource)atorg.springframework.beans.BeanWrapperImpl.setPropertyValue(BeanWrapperImpl.java:840)...53moreCausedby:java.lang.ClassNotFoundException:com.microsoft.sqlserver.jdbc.SQLServerDriveratorg.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1360)atorg.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1206)atjava.lang.ClassLoader.loadClassInternal(UnknownSource)atjava.lang.Class.forName0(NativeMethod)atjava.lang.Class.forName(UnknownSource)atorg.springframework.jdbc.datasource.DriverManagerDataSource.setDriverClassName(DriverManagerDataSource.java:142)...58more
解决方案
解决方案二：
你要把数据库驱动的Jar包放在ClassPath里面
解决方案三：
哈哈，果然...太感谢了哥们....thank你...
解决方案四：
既然解决了就结贴吧
解决方案五：
结贴啊
解决方案六：
………………
解决方案七：
Causedby:java.lang.ClassNotFoundException:com.microsoft.sqlserver.jdbc.SQLServerDriver这么明显的错误，楼主要细心
解决方案八：
soory，各位，我会细心的
解决方案九：
顶结贴过来混点分
解决方案十：
算了解决了结贴啥
解决方案十一：
我也遇到了但是我的jar包是导入的了啊
解决方案十二：
该回复于2011-05-07 09:25:46被版主删除
解决方案十三：
引用10楼liujunjie2009的回复:
我也遇到了但是我的jar包是导入的了啊
如果你是web程序的话，你应该将jar包放到webRoot下的Lib里，否则，就放你导入了jar包，还是会说找不到驱动类……
解决方案十四：
Property'driverClassName'threwexception;nestedexceptionisjava.lang.IllegalStateException:CouldnotloadJDBCdriverclass[com.microsoft.sqlserver.jdbc.SQLServerDriver]一看就数据库驱动的问题啊自己换个驱动包写个测试类测试下
解决方案十五：
晕死，怎么都不看看错误代码呢，不是很明显嘛，jar没有导入