搭建ssm項目時，碰到 Error creating bean with name 'dataSource' defined in問題

圖片和錯誤信息

解决方案 »

  1.   

    web中扫描配置错了吧还有是不是resource下的路径错了
      

  2.   

    查了百度，說是jar包沒導全或是衝突，但是未發現這類的異常。web配置好了
      

  3.   

    数据源,你用的是哪个啊?换个数据源试试,<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource"
      

  4.   

    <?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:p="http://www.springframework.org/schema/p"
    xmlns:mvc="http://www.springframework.org/schema/mvc"
    xmlns:context="http://www.springframework.org/schema/context"
    xsi:schemaLocation="http://www.springframework.org/schema/beans 
    http://www.springframework.org/schema/beans/spring-beans-3.0.xsd
    http://www.springframework.org/schema/context 
    http://www.springframework.org/schema/context/spring-context-3.0.xsd
    http://www.springframework.org/schema/mvc 
    http://www.springframework.org/schema/mvc/spring-mvc-3.0.xsd">
    <context:property-placeholder location="classpath:jdbc.properties"/>

    <!-- 配置数据源 -->
    <bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
    <property name="driverClassName" value="${jdbc.driver}"></property>
    <property name="url" value="${jdbc.url}"></property>
    <property name="username" value="${jdbc.username}"></property>
    <property name="password" value="${jdbc.password}"></property>
    </bean>

    <!-- spring管理mybatis -->
    <bean id="sqlSessionFactory" class="org.apache.commons.dbcp.BasicDataSource">
    <property name="dataSource" ref="dataSource"></property>
    <property name="configLocation" value="classpath:mybatis-config.xml"></property>
    </bean>

    <!-- 扫描dao -->
    <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
    <property name="basePackage" value="com.xtkj.dao"></property>
    <property name="sqlSessionFactoryBeanName" value="sqlSessionFactory"></property>
    </bean> </beans>
      

  5.   

    ?? 25, 2019 4:18:46 ?? org.apache.catalina.startup.VersionLoggerListener log
    ??: Server version:        Apache Tomcat/7.0.68
    ?? 25, 2019 4:18:46 ?? org.apache.catalina.startup.VersionLoggerListener log
    ??: Server built:          Feb 8 2016 20:25:54 UTC
    ?? 25, 2019 4:18:46 ?? org.apache.catalina.startup.VersionLoggerListener log
    ??: Server number:         7.0.68.0
    ?? 25, 2019 4:18:46 ?? org.apache.catalina.startup.VersionLoggerListener log
    ??: OS Name:               Windows 7
    ?? 25, 2019 4:18:46 ?? org.apache.catalina.startup.VersionLoggerListener log
    ??: OS Version:            6.1
    ?? 25, 2019 4:18:46 ?? org.apache.catalina.startup.VersionLoggerListener log
    ??: Architecture:          amd64
    ?? 25, 2019 4:18:46 ?? org.apache.catalina.startup.VersionLoggerListener log
    ??: Java Home:             D:\javatools\Java\jdk1.7.0_03\jre
    ?? 25, 2019 4:18:46 ?? org.apache.catalina.startup.VersionLoggerListener log
    ??: JVM Version:           1.7.0_03-b05
    ?? 25, 2019 4:18:46 ?? org.apache.catalina.startup.VersionLoggerListener log
    ??: JVM Vendor:            Oracle Corporation
    ?? 25, 2019 4:18:46 ?? org.apache.catalina.startup.VersionLoggerListener log
    ??: CATALINA_BASE:         D:\apache-tomcat-7.0.68
    ?? 25, 2019 4:18:46 ?? org.apache.catalina.startup.VersionLoggerListener log
    ??: CATALINA_HOME:         D:\apache-tomcat-7.0.68
    ?? 25, 2019 4:18:46 ?? org.apache.catalina.startup.VersionLoggerListener log
    ??: Command line argument: -agentlib:jdwp=transport=dt_socket,suspend=y,address=localhost:56222
    ?? 25, 2019 4:18:46 ?? org.apache.catalina.startup.VersionLoggerListener log
    ??: Command line argument: -Dcatalina.home=D:\apache-tomcat-7.0.68
    ?? 25, 2019 4:18:46 ?? org.apache.catalina.startup.VersionLoggerListener log
    ??: Command line argument: -Dcatalina.base=D:\apache-tomcat-7.0.68
    ?? 25, 2019 4:18:46 ?? org.apache.catalina.startup.VersionLoggerListener log
    ??: Command line argument: -Djava.endorsed.dirs=D:\apache-tomcat-7.0.68/common/endorsed
    ?? 25, 2019 4:18:46 ?? org.apache.catalina.startup.VersionLoggerListener log
    ??: Command line argument: -Djava.io.tmpdir=D:\apache-tomcat-7.0.68\temp
    ?? 25, 2019 4:18:46 ?? org.apache.catalina.startup.VersionLoggerListener log
    ??: Command line argument: -Djava.library.path=D:\javatools\Java\jdk1.7.0_03\bin;D:\apache-tomcat-7.0.68\bin
    ?? 25, 2019 4:18:46 ?? org.apache.catalina.startup.VersionLoggerListener log
    ??: Command line argument: -Dsun.io.useCanonCaches=false
    ?? 25, 2019 4:18:46 ?? org.apache.catalina.startup.VersionLoggerListener log
    ??: Command line argument: -Dmaven.multiModuleProjectDirectory=$MAVEN_HOME
    ?? 25, 2019 4:18:46 ?? org.apache.catalina.core.AprLifecycleListener lifecycleEvent
    ??: The APR based Apache Tomcat Native library which allows optimal performance in production environments was not found on the java.library.path: D:\javatools\Java\jdk1.7.0_03\bin;D:\apache-tomcat-7.0.68\bin
    ?? 25, 2019 4:18:47 ?? org.apache.coyote.AbstractProtocol init
    ??: Initializing ProtocolHandler ["http-bio-8088"]
    ?? 25, 2019 4:18:47 ?? org.apache.coyote.AbstractProtocol init
    ??: Initializing ProtocolHandler ["ajp-bio-8009"]
    ?? 25, 2019 4:18:47 ?? org.apache.catalina.startup.Catalina load
    ??: Initialization processed in 2499 ms
    ?? 25, 2019 4:18:47 ?? org.apache.catalina.core.StandardService startInternal
    ??: Starting service Catalina
    ?? 25, 2019 4:18:47 ?? org.apache.catalina.core.StandardEngine startInternal
    ??: Starting Servlet Engine: Apache Tomcat/7.0.68
    ?? 25, 2019 4:18:47 ?? org.apache.catalina.startup.HostConfig deployDirectory
    ??: Deploying web application directory D:\apache-tomcat-7.0.68\webapps\JSP
    ?? 25, 2019 4:18:55 ?? org.apache.catalina.startup.TldConfig execute
    ??: At least one JAR was scanned for TLDs yet contained no TLDs. Enable debug logging for this logger for a complete list of JARs that were scanned but no TLDs were found in them. Skipping unneeded JARs during scanning can improve startup time and JSP compilation time.
    ?? 25, 2019 4:18:55 ?? org.apache.catalina.core.ApplicationContext log
    ??: Initializing Spring root WebApplicationContext
    log4j:WARN No appenders could be found for logger (org.springframework.web.context.ContextLoader).
    log4j:WARN Please initialize the log4j system properly.
    log4j:WARN See http://logging.apache.org/log4j/1.2/faq.html#noconfig for more info.
    ?? 25, 2019 4:18:58 ?? org.apache.catalina.core.StandardContext listenerStart
    ??: Exception sending context initialized event to listener instance of class org.springframework.web.context.ContextLoaderListener
    org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'dataSource' defined in class path resource [springMVC-jdbc.xml]: Error setting property values; nested exception is org.springframework.beans.PropertyBatchUpdateException; nested PropertyAccessExceptions (1) are:
    PropertyAccessException 1: org.springframework.beans.MethodInvocationException: Property 'driverClassName' threw exception; nested exception is java.lang.UnsupportedClassVersionError: com/mysql/jdbc/Driver : Unsupported major.minor version 52.0 (unable to load class com.mysql.jdbc.Driver)
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1361)
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1086)
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:517)
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:456)
    at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:291)
    at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222)
    at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:288)
    at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:190)
    at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:580)
    at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:895)
    at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:425)
    at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:276)
    at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:197)
    at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:47)
    at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:5068)
    at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5584)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:147)
    at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:899)
    at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:875)
    at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:652)
    at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:1259)
    at org.apache.catalina.startup.HostConfig$DeployDirectory.run(HostConfig.java:1998)
    at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
    at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334)
    at java.util.concurrent.FutureTask.run(FutureTask.java:166)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603)
    at java.lang.Thread.run(Thread.java:722)
    Caused by: org.springframework.beans.PropertyBatchUpdateException; nested PropertyAccessExceptions (1) are:
    PropertyAccessException 1: org.springframework.beans.MethodInvocationException: Property 'driverClassName' threw exception; nested exception is java.lang.UnsupportedClassVersionError: com/mysql/jdbc/Driver : Unsupported major.minor version 52.0 (unable to load class com.mysql.jdbc.Driver)
    at org.springframework.beans.AbstractPropertyAccessor.setPropertyValues(AbstractPropertyAccessor.java:102)
    at org.springframework.beans.AbstractPropertyAccessor.setPropertyValues(AbstractPropertyAccessor.java:58)
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1358)
    ... 27 more?? 25, 2019 4:18:58 ?? org.apache.catalina.core.StandardContext startInternal
    ??: One or more listeners failed to start. Full details will be found in the appropriate container log file
    ?? 25, 2019 4:18:58 ?? org.apache.catalina.core.StandardContext startInternal
    ??: Context [/JSP] startup failed due to previous errors
    ?? 25, 2019 4:18:58 ?? org.apache.catalina.core.ApplicationContext log
    ??: Closing Spring root WebApplicationContext
    ?? 25, 2019 4:18:58 ?? org.apache.catalina.startup.HostConfig deployDirectory
    ??: Deployment of web application directory D:\apache-tomcat-7.0.68\webapps\JSP has finished in 11,104 ms
    ?? 25, 2019 4:18:58 ?? org.apache.coyote.AbstractProtocol start
    ??: Starting ProtocolHandler ["http-bio-8088"]
    ?? 25, 2019 4:18:58 ?? org.apache.coyote.AbstractProtocol start
    ??: Starting ProtocolHandler ["ajp-bio-8009"]
    ?? 25, 2019 4:18:58 ?? org.apache.catalina.startup.Catalina start
    ??: Server startup in 11297 ms
      

  6.   

    嗯,刚才搜了下,你的版本问题;版本为：jdk1.7.0_80mysql-connector-java-5.1.46-bin.jar 解决办法：升级JDK或者降级MySQL Connector/J为mysql-connector-java-5.1.46-bin.jar
    https://www.baidu.com/s?ie=UTF-8&wd=com/mysql/jdbc/Driver%20%3A%20Unsupported%20major.minor%20version%2052.0
      

  7.   

    <project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
      <modelVersion>4.0.0</modelVersion>
      <groupId>com.xtkj.httpclient</groupId>
      <artifactId>07-httpclient-provider</artifactId>
      <version>0.0.1-SNAPSHOT</version>
      
      <properties>
       <spring.version>4.3.8.RELEASE</spring.version>
       <jackson.version>2.5.4</jackson.version>
      </properties>
      
      <dependencies>
       <dependency>
       <groupId>org.springframework</groupId>
       <artifactId>spring-core</artifactId>
       <version>${spring.version}</version>
       </dependency>
       <dependency>
       <groupId>org.springframework</groupId>
       <artifactId>spring-aop</artifactId>
       <version>${spring.version}</version>
       </dependency>
       <dependency>
       <groupId>org.springframework</groupId>
       <artifactId>spring-web</artifactId>
       <version>${spring.version}</version>
       </dependency>
       <dependency>
       <groupId>org.springframework</groupId>
       <artifactId>spring-webmvc</artifactId>
       <version>${spring.version}</version>
       </dependency>
       <dependency>
       <groupId>org.springframework</groupId>
       <artifactId>spring-jdbc</artifactId>
       <version>${spring.version}</version>
       </dependency>
       <dependency>
       <groupId>org.springframework</groupId>
       <artifactId>spring-tx</artifactId>
       <version>${spring.version}</version>
       </dependency>
      
       <dependency>
       <groupId>org.aspectj</groupId>
       <artifactId>aspectjrt</artifactId>
       <version>1.8.0</version>
       </dependency>
       <dependency>
       <groupId>org.aspectj</groupId>
       <artifactId>aspectjweaver</artifactId>
       <version>1.8.0</version>
       </dependency>
      
       <dependency>
       <groupId>org.mybatis</groupId>
       <artifactId>mybatis</artifactId>
       <version>3.2.3</version>
       </dependency>
       <dependency>
       <groupId>org.mybatis</groupId>
       <artifactId>mybatis-spring</artifactId>
       <version>1.2.3</version>
       </dependency>
      
       <dependency>
       <groupId>mysql</groupId>
       <artifactId>mysql-connector-java</artifactId>
       <version>5.1.26</version>
       </dependency>
       <dependency>
       <groupId>commons-dbcp</groupId>
       <artifactId>commons-dbcp</artifactId>
       <version>1.4</version>
       </dependency>   <dependency>
       <groupId>javax.servlet</groupId>
       <artifactId>servlet-api</artifactId>
       <version>2.5</version>
       </dependency>
       <dependency>
       <groupId>javax.servlet</groupId>
       <artifactId>jstl</artifactId>
       <version>1.2</version>
       </dependency>
      
       <dependency>
          <groupId>com.fasterxml.jackson.core</groupId>
          <artifactId>jackson-core</artifactId>
          <version>${jackson.version}</version>
        </dependency>
        <dependency>
          <groupId>com.fasterxml.jackson.core</groupId>
          <artifactId>jackson-databind</artifactId>
          <version>${jackson.version}</version>
        </dependency>
      
      </dependencies>
      
      <build>
       <plugins>
       <plugin>
       <groupId>org.apache.maven.plugins</groupId>
       <artifactId>maven-compiler-plugin</artifactId>
       <version>3.8.0</version>
       <configuration>
       <source>1.8</source>
       <target>1.8</target>
       <encoding>utf-8</encoding>
       </configuration>
       </plugin>
       </plugins>
      </build>
      
    </project>這是我的pom信息，麻煩幫我配配，怕配不好有衝突
      

  8.   

    jdbc.properties 配置文件里 jdbc.driver 的值是多少？ 这种情况可能是驱动不对和mysql数据库不对应。网上搜一下，应该有解决方案。
      

  9.   

    com.mysql.jdbc.Driver