把mysql更换成sql server后，项目不启动

AngelWings 2015-03-11 09:50:43
最近改版了一个项目，只换了数据库，修改了数据库连接池配置文件和jar包后，项目不启动，报错如下：


2015-03-11 09:36:12.385 [main] ERROR org.springframework.web.context.ContextLoader - Context initialization failed

org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'caseService': Injection of autowired dependencies failed; nested exception is org.springframework.beans.factory.BeanCreationException: Could not autowire field: private com.kkmy.business.service.KkmyOrderService com.kkmy.business.service.CaseService.kkmyOrderService; nested exception is org.springframework.beans.factory.CannotLoadBeanClassException: Cannot find class [com.jzt.business.datasource.DynamicDataSource] for bean with name 'dataSource' defined in URL [file:/C:/software/apache-tomcat-6.0.36/webapps/kkmyInterfaceClint/WEB-INF/classes/spring/applicationContext-dataSource.xml]; nested exception is java.lang.ClassNotFoundException: com.jzt.business.datasource.DynamicDataSource

	at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor.postProcessPropertyValues(AutowiredAnnotationBeanPostProcessor.java:288) ~[spring-beans-3.2.4.RELEASE.jar:3.2.4.RELEASE]

	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1116) ~[spring-beans-3.2.4.RELEASE.jar:3.2.4.RELEASE]

	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:519) ~[spring-beans-3.2.4.RELEASE.jar:3.2.4.RELEASE]

	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:458) ~[spring-beans-3.2.4.RELEASE.jar:3.2.4.RELEASE]

	at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:295) ~[spring-beans-3.2.4.RELEASE.jar:3.2.4.RELEASE]

	at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:223) ~[spring-beans-3.2.4.RELEASE.jar:3.2.4.RELEASE]

	at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:292) ~[spring-beans-3.2.4.RELEASE.jar:3.2.4.RELEASE]

	at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:194) ~[spring-beans-3.2.4.RELEASE.jar:3.2.4.RELEASE]

	at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:628) ~[spring-beans-3.2.4.RELEASE.jar:3.2.4.RELEASE]

	at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:932) ~[spring-context-3.2.4.RELEASE.jar:3.2.4.RELEASE]

	at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:479) ~[spring-context-3.2.4.RELEASE.jar:3.2.4.RELEASE]

	at org.springframework.web.context.ContextLoader.configureAndRefreshWebApplicationContext(ContextLoader.java:389) ~[spring-web-3.2.4.RELEASE.jar:3.2.4.RELEASE]

	at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:294) ~[spring-web-3.2.4.RELEASE.jar:3.2.4.RELEASE]

	at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:112) [spring-web-3.2.4.RELEASE.jar:3.2.4.RELEASE]

	at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4206) [catalina.jar:6.0.36]

	at org.apache.catalina.core.StandardContext.start(StandardContext.java:4705) [catalina.jar:6.0.36]

	at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:799) [catalina.jar:6.0.36]

	at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:779) [catalina.jar:6.0.36]

	at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:601) [catalina.jar:6.0.36]

	at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:1079) [catalina.jar:6.0.36]

	at org.apache.catalina.startup.HostConfig.deployDirectories(HostConfig.java:1002) [catalina.jar:6.0.36]

	at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:506) [catalina.jar:6.0.36]

	at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1317) [catalina.jar:6.0.36]

	at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:324) [catalina.jar:6.0.36]

	at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:142) [catalina.jar:6.0.36]

	at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1065) [catalina.jar:6.0.36]

	at org.apache.catalina.core.StandardHost.start(StandardHost.java:840) [catalina.jar:6.0.36]

	at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1057) [catalina.jar:6.0.36]

	at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:463) [catalina.jar:6.0.36]

	at org.apache.catalina.core.StandardService.start(StandardService.java:525) [catalina.jar:6.0.36]

	at org.apache.catalina.core.StandardServer.start(StandardServer.java:754) [catalina.jar:6.0.36]

	at org.apache.catalina.startup.Catalina.start(Catalina.java:595) [catalina.jar:6.0.36]

	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.7.0_04]

	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) ~[na:1.7.0_04]

	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.7.0_04]

	at java.lang.reflect.Method.invoke(Method.java:601) ~[na:1.7.0_04]

	at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:289) [bootstrap.jar:6.0.36]

	at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414) [bootstrap.jar:6.0.36]

Caused by: org.springframework.beans.factory.BeanCreationException: Could not autowire field: private com.kkmy.business.service.KkmyOrderService com.kkmy.business.service.CaseService.kkmyOrderService; nested exception is org.springframework.beans.factory.CannotLoadBeanClassException: Cannot find class [com.jzt.business.datasource.DynamicDataSource] for bean with name 'dataSource' defined in URL [file:/C:/software/apache-tomcat-6.0.36/webapps/kkmyInterfaceClint/WEB-INF/classes/spring/applicationContext-dataSource.xml]; nested exception is java.lang.ClassNotFoundException: com.jzt.business.datasource.DynamicDataSource

	at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor$AutowiredFieldElement.inject(AutowiredAnnotationBeanPostProcessor.java:514) ~[spring-beans-3.2.4.RELEASE.jar:3.2.4.RELEASE]

	at org.springframework.beans.factory.annotation.InjectionMetadata.inject(InjectionMetadata.java:87) ~[spring-beans-3.2.4.RELEASE.jar:3.2.4.RELEASE]

	at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor.postProcessPropertyValues(AutowiredAnnotationBeanPostProcessor.java:285) ~[spring-beans-3.2.4.RELEASE.jar:3.2.4.RELEASE]

	... 37 common frames omitted

Caused by: org.springframework.beans.factory.CannotLoadBeanClassException: Cannot find class [com.jzt.business.datasource.DynamicDataSource] for bean with name 'dataSource' defined in URL [file:/C:/software/apache-tomcat-6.0.36/webapps/kkmyInterfaceClint/WEB-INF/classes/spring/applicationContext-dataSource.xml]; nested exception is java.lang.ClassNotFoundException: com.jzt.business.datasource.DynamicDataSource

	at org.springframework.beans.factory.support.AbstractBeanFactory.resolveBeanClass(AbstractBeanFactory.java:1275) ~[spring-beans-3.2.4.RELEASE.jar:3.2.4.RELEASE]

	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.predictBeanType(AbstractAutowireCapableBeanFactory.java:575) ~[spring-beans-3.2.4.RELEASE.jar:3.2.4.RELEASE]

	at org.springframework.beans.factory.support.AbstractBeanFactory.isFactoryBean(AbstractBeanFactory.java:1344) ~[spring-beans-3.2.4.RELEASE.jar:3.2.4.RELEASE]

	at org.springframework.beans.factory.support.DefaultListableBeanFactory.doGetBeanNamesForType(DefaultListableBeanFactory.java:355) ~[spring-beans-3.2.4.RELEASE.jar:3.2.4.RELEASE]

	at org.springframework.beans.factory.support.DefaultListableBeanFactory.getBeanNamesForType(DefaultListableBeanFactory.java:334) ~[spring-beans-3.2.4.RELEASE.jar:3.2.4.RELEASE]

	at org.springframework.beans.factory.BeanFactoryUtils.beanNamesForTypeIncludingAncestors(BeanFactoryUtils.java:187) ~[spring-beans-3.2.4.RELEASE.jar:3.2.4.RELEASE]

	at org.springframework.beans.factory.support.DefaultListableBeanFactory.findAutowireCandidates(DefaultListableBeanFactory.java:897) ~[spring-beans-3.2.4.RELEASE.jar:3.2.4.RELEASE]

	at org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:855) ~[spring-beans-3.2.4.RELEASE.jar:3.2.4.RELEASE]

	at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:770) ~[spring-beans-3.2.4.RELEASE.jar:3.2.4.RELEASE]

	at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor$AutowiredFieldElement.inject(AutowiredAnnotationBeanPostProcessor.java:486) ~[spring-beans-3.2.4.RELEASE.jar:3.2.4.RELEASE]

	... 39 common frames omitted

Caused by: java.lang.ClassNotFoundException: com.jzt.business.datasource.DynamicDataSource

	at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1680) ~[catalina.jar:6.0.36]

	at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1526) ~[catalina.jar:6.0.36]

	at org.springframework.util.ClassUtils.forName(ClassUtils.java:260) ~[spring-core-3.2.4.RELEASE.jar:3.2.4.RELEASE]

	at org.springframework.beans.factory.support.AbstractBeanDefinition.resolveBeanClass(AbstractBeanDefinition.java:416) ~[spring-beans-3.2.4.RELEASE.jar:3.2.4.RELEASE]

	at org.springframework.beans.factory.support.AbstractBeanFactory.doResolveBeanClass(AbstractBeanFactory.java:1296) ~[spring-beans-3.2.4.RELEASE.jar:3.2.4.RELEASE]
...全文
208 9 打赏 收藏 转发到动态 举报
写回复
用AI写文章
9 条回复
切换为时间正序
请发表友善的回复…
发表回复
Foxir 2015-03-11
  • 打赏
  • 举报
 回复
Microsoft JDBC Driver for SQL Server 的下载地址： https://msdn.microsoft.com/en-us/sqlserver/aa937724.aspx
Defonds 2015-03-11
  • 打赏
  • 举报
 回复
sqlserver 的驱动包没有加载。检查你的运行时环境
AngelWings 2015-03-11
  • 打赏
  • 举报
 回复
引用 2 楼 rui888 的回复:
Cannot find class [com.jzt.business.datasource.DynamicDataSource] for bean with name 'dataSource' defined in URL [file:/C:/software/apache-tomcat-6.0.36/webapps/kkmyInterfaceClint/WEB-INF/classes/spring/applicationContext-dataSource.xml]
谢谢，更改后项目启动中又报错： 

2015-03-11 11:59:42.029 [main] ERROR org.apache.ibatis.executor.BaseExecutor - Could not get a databaseId from dataSource
java.sql.SQLException: ------
java.lang.ClassNotFoundException: com.microsoft.jdbc.sqlserver.SQLServerDriver
	at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1680)
	at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1526)
	at java.lang.Class.forName0(Native Method)
	at java.lang.Class.forName(Class.java:186)
	at com.jolbox.bonecp.BoneCPConfig.loadClass(BoneCPConfig.java:1757)
	at com.jolbox.bonecp.BoneCPDataSource.getConnection(BoneCPDataSource.java:116)
	at org.springframework.jdbc.datasource.lookup.AbstractRoutingDataSource.getConnection(AbstractRoutingDataSource.java:162)
	at org.apache.ibatis.mapping.VendorDatabaseIdProvider.getDatabaseProductName(VendorDatabaseIdProvider.java:76)
	at org.apache.ibatis.mapping.VendorDatabaseIdProvider.getDatabaseName(VendorDatabaseIdProvider.java:61)
	at org.apache.ibatis.mapping.VendorDatabaseIdProvider.getDatabaseId(VendorDatabaseIdProvider.java:49)
	at org.mybatis.spring.SqlSessionFactoryBean.buildSqlSessionFactory(SqlSessionFactoryBean.java:449)
	at org.mybatis.spring.SqlSessionFactoryBean.afterPropertiesSet(SqlSessionFactoryBean.java:340)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1541)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1479)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:521)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:458)
	at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:295)
	at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:223)
	at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:292)
	at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:194)
	at org.springframework.beans.factory.support.DefaultListableBeanFactory.findAutowireCandidates(DefaultListableBeanFactory.java:912)
	at org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:855)
	at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:770)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireByType(AbstractAutowireCapableBeanFactory.java:1194)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1101)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:519)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:458)
	at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:295)
	at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:223)
	at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:292)
	at org.springframework.beans.factory.support.AbstractBeanFactory.getTypeForFactoryBean(AbstractBeanFactory.java:1368)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.getTypeForFactoryBean(AbstractAutowireCapableBeanFactory.java:720)
	at org.springframework.beans.factory.support.AbstractBeanFactory.isTypeMatch(AbstractBeanFactory.java:523)
	at org.springframework.beans.factory.support.DefaultListableBeanFactory.doGetBeanNamesForType(DefaultListableBeanFactory.java:356)
	at org.springframework.beans.factory.support.DefaultListableBeanFactory.getBeanNamesForType(DefaultListableBeanFactory.java:334)
	at org.springframework.beans.factory.BeanFactoryUtils.beanNamesForTypeIncludingAncestors(BeanFactoryUtils.java:187)
	at org.springframework.beans.factory.support.DefaultListableBeanFactory.findAutowireCandidates(DefaultListableBeanFactory.java:897)
	at org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:855)
	at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:770)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireByType(AbstractAutowireCapableBeanFactory.java:1194)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1101)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:519)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:458)
	at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:295)
	at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:223)
	at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:292)
	at org.springframework.beans.factory.support.AbstractBeanFactory.getTypeForFactoryBean(AbstractBeanFactory.java:1368)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.getTypeForFactoryBean(AbstractAutowireCapableBeanFactory.java:720)
	at org.springframework.beans.factory.support.AbstractBeanFactory.isTypeMatch(AbstractBeanFactory.java:523)
	at org.springframework.beans.factory.support.DefaultListableBeanFactory.doGetBeanNamesForType(DefaultListableBeanFactory.java:356)
	at org.springframework.beans.factory.support.DefaultListableBeanFactory.getBeanNamesForType(DefaultListableBeanFactory.java:334)
	at org.springframework.beans.factory.BeanFactoryUtils.beanNamesForTypeIncludingAncestors(BeanFactoryUtils.java:187)
	at org.springframework.beans.factory.support.DefaultListableBeanFactory.findAutowireCandidates(DefaultListableBeanFactory.java:897)
	at org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:855)
	at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:770)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireByType(AbstractAutowireCapableBeanFactory.java:1194)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1101)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:519)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:458)
	at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:295)
	at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:223)
	at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:292)
	at org.springframework.beans.factory.support.AbstractBeanFactory.getTypeForFactoryBean(AbstractBeanFactory.java:1368)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.getTypeForFactoryBean(AbstractAutowireCapableBeanFactory.java:720)
	at org.springframework.beans.factory.support.AbstractBeanFactory.isTypeMatch(AbstractBeanFactory.java:523)
	at org.springframework.beans.factory.support.DefaultListableBeanFactory.doGetBeanNamesForType(DefaultListableBeanFactory.java:356)
	at org.springframework.beans.factory.support.DefaultListableBeanFactory.getBeanNamesForType(DefaultListableBeanFactory.java:334)
	at org.springframework.beans.factory.BeanFactoryUtils.beanNamesForTypeIncludingAncestors(BeanFactoryUtils.java:187)
	at org.springframework.beans.factory.support.DefaultListableBeanFactory.findAutowireCandidates(DefaultListableBeanFactory.java:897)
	at org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:855)
	at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:770)
	at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor$AutowiredFieldElement.inject(AutowiredAnnotationBeanPostProcessor.java:486)
	at org.springframework.beans.factory.annotation.InjectionMetadata.inject(InjectionMetadata.java:87)
	at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor.postProcessPropertyValues(AutowiredAnnotationBeanPostProcessor.java:285)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1116)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:519)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:458)
tony4geek 2015-03-11
  • 打赏
  • 举报
 回复
Cannot find class [com.jzt.business.datasource.DynamicDataSource] for bean with name 'dataSource' defined in URL [file:/C:/software/apache-tomcat-6.0.36/webapps/kkmyInterfaceClint/WEB-INF/classes/spring/applicationContext-dataSource.xml]
AngelWings 2015-03-11
  • 打赏
  • 举报
 回复
数据库配置文件： 

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
       xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
       xmlns:aop="http://www.springframework.org/schema/aop"
       xmlns:context="http://www.springframework.org/schema/context"
       xsi:schemaLocation="http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-3.0.xsd
     http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-3.0.xsd


     http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-3.0.xsd">

       <bean id="readdataSource" class="com.jolbox.bonecp.BoneCPDataSource">
		  <property name="driverClass"
		   value="com.microsoft.jdbc.sqlserver.SQLServerDriver" />
		  <property name="jdbcUrl" value="jdbc:microsoft:sqlserver://223.71.247.35:1433;DatabaseName=test1"/>
		  <property name="username" value="sa" />
		  <property name="password" value="boss1" />
		  
		  <property name="idleConnectionTestPeriod" value="60" />
		
		  <property name="idleMaxAge" value="240" />
		
		  <property name="maxConnectionsPerPartition" value="30" />
		
		  <property name="minConnectionsPerPartition" value="10" />
		
		  <property name="partitionCount" value="3" />
		 
		  <property name="acquireIncrement" value="5" />
		
		  <property name="poolAvailabilityThreshold" value="10"></property>
		 
		  <property name="connectionTimeout" value="3000"></property>
		 </bean> 

        <bean id="writedataSource" class="com.jolbox.bonecp.BoneCPDataSource">
		  <property name="driverClass"
		   value="com.microsoft.jdbc.sqlserver.SQLServerDriver" />
		  <property name="jdbcUrl" value="jdbc:microsoft:sqlserver://223.71.247.35:1433;DatabaseName=test1"/>
		  <property name="username" value="sa" />
		  <property name="password" value="boss1" />
		  
		  <property name="idleConnectionTestPeriod" value="60" />
		
		  <property name="idleMaxAge" value="240" />
		
		  <property name="maxConnectionsPerPartition" value="30" />
		
		  <property name="minConnectionsPerPartition" value="10" />
		
		  <property name="partitionCount" value="3" />
		 
		  <property name="acquireIncrement" value="5" />
		
		  <property name="poolAvailabilityThreshold" value="10"></property>
		 
		  <property name="connectionTimeout" value="3000"></property>
		 </bean> 
		 
        
       <bean id="dataSource" class="com.jzt.business.datasource.DynamicDataSource">      
         <property name="targetDataSources">   
          <map key-type="java.lang.String">      
                <entry key="writedataSource" value-ref="writedataSource"/>   
                 <entry key="readdataSource" value-ref="readdataSource"/>   
             </map>     
          </property>      
          <property name="defaultTargetDataSource" ref="writedataSource"/>      
     </bean>
 	
</beans>
数据库jar包吧mysql的jar包删除，加入了sqljdbc4.jar 请大神帮忙看看，谢谢！
Foxir 2015-03-11
  • 打赏
  • 举报
 回复
楼主的sqljdbc4.jar放哪里了，贴目录结构出来看看。
痘痘飞 2015-03-11
  • 打赏
  • 举报
 回复
com.jolbox.bonecp.BoneCPDataSource检查该数据源包有没有导入，极其配置
tony4geek 2015-03-11
  • 打赏
  • 举报
 回复
com.microsoft.jdbc.sqlserver.SQLServerDriver 楼上说的。 jdbc 驱动
AngelWings 2015-03-11
  • 打赏
  • 举报
 回复
引用 4 楼 defonds 的回复:
sqlserver 的驱动包没有加载。检查你的运行时环境
引用 5 楼 Foxir 的回复:
Microsoft JDBC Driver for SQL Server 的下载地址： https://msdn.microsoft.com/en-us/sqlserver/aa937724.aspx
驱动包是官网下载解压的，只用了sqljdbc4.jar这一个jar包。在环境中都是可以找到的。 请帮忙看看是不是配置文件写的有问题？
实战化课程：全面掌握SQL Server高可用技术，从菜鸟到专家
课程的实验环境介绍： 1）全部基于微软域环境和企业版SQL Server AOAG - 95%以上的企业环境都是在域环境中，不介绍非域环境和标准版的SQL Server高可用性组，这的配置在企业中较罕见，没有实践意义，不浪费学员时间...
当mysql数据库转换为sqlserver数据库时常见报错
下面是我在把mysql数据库转换为sqlserver数据库时候遇到过的一些错，踩过的坑，把它总结下来防止以后再出错。 报错 1： com.microsoft.sqlserver.jdbc.SQLServerException: 仅当使用了列列表并且 IDENTITY_INSERT...
MySQL数据库替换为SQLServer
准备工作：mysql数据库，SQLServer数据库，Microsoft SQL Server Migration Assistant 2008 for MySQL 官方转换工具，MySQL ODBC driver  1.下载MySQL驱动以后，解压双击install.bat启动，然后在控制面板里配置。...
navacit连接sqlserver_Navicat远程连接SQLServer并转换成MySQL步骤详解
前言最近项目中遇到用 SQL Server的程序，以前没用过这个数据库，于是尝试将其转换为 MySQL 的格式，可是不想在本地安装 SQL Server，于是决定在一个远程的 Windows 服务器上安装，并在本地连接它，然而在实现过程中...
保留数据重装后sqlserver数据库不能启动（sql2008,sql2012）
最近有很多用户反馈重装为预装sqlserver模板的系统，sqlserver不能正常启动，经核实大部分都是用户保留数据重装更换另外模板的windows系统的原因。由于数据库安装在D盘，有些模板是没有安装sqlserver数据库的，重装...
Web 开发

81,094

社区成员

341,717

社区内容

发帖
与我相关
我的任务
社区描述
Java Web 开发
社区管理员
  • Web 开发社区
加入社区
  • 近7日
  • 近30日
  • 至今

加载中

查看更多榜单
社区公告
暂无公告

试试用AI创作助手写篇文章吧

+ 用AI写文章