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

qq_42769234 2019-04-25 04:33:22
圖片和錯誤信息
...全文
1425 15 打赏 收藏 转发到动态 举报
AI 作业
写回复
用AI写文章
15 条回复
切换为时间正序
请发表友善的回复…
发表回复
qq_42769234 2019-04-25
  • 打赏
  • 举报
回复
引用 14 楼 freekaiQaQ 的回复:
jdbc.properties 配置文件里 jdbc.driver 的值是多少? 这种情况可能是驱动不对和mysql数据库不对应。网上搜一下,应该有解决方案。
com.mysql.jdbc.Driver
freekaiQaQ 2019-04-25
  • 打赏
  • 举报
回复
jdbc.properties 配置文件里 jdbc.driver 的值是多少? 这种情况可能是驱动不对和mysql数据库不对应。网上搜一下,应该有解决方案。
qq_42769234 2019-04-25
  • 打赏
  • 举报
回复
引用 10 楼 getdate 的回复:
嗯,刚才搜了下,你的版本问题; 版本为: jdk1.7.0_80 mysql-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
<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信息,麻煩幫我配配,怕配不好有衝突
qq_42769234 2019-04-25
  • 打赏
  • 举报
回复
引用 10 楼 getdate 的回复:
嗯,刚才搜了下,你的版本问题; 版本为: jdk1.7.0_80 mysql-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
我命名空間是3.0,用3.0版本的?
qq_42769234 2019-04-25
  • 打赏
  • 举报
回复
引用 10 楼 getdate 的回复:
嗯,刚才搜了下,你的版本问题; 版本为: jdk1.7.0_80 mysql-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
降級的話用多少的?
getdate 2019-04-25
  • 打赏
  • 举报
回复
嗯,刚才搜了下,你的版本问题; 版本为: jdk1.7.0_80 mysql-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
qq_42769234 2019-04-25
  • 打赏
  • 举报
回复
引用 7 楼 getdate 的回复:
[quote=引用 5 楼 qq_42769234 的回复:] [quote=引用 3 楼 getdate 的回复:] 数据源,你用的是哪个啊? 换个数据源试试,<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource"
用的就是這個[/quote] 你看你截图的,不是这个[/quote]是
qq_42769234 2019-04-25
  • 打赏
  • 举报
回复
引用 4 楼 getdate 的回复:
你最好把你的配置文件,发下,别截图,还有就是把完整的错误信息发下.
?? 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
getdate 2019-04-25
  • 打赏
  • 举报
回复
引用 5 楼 qq_42769234 的回复:
[quote=引用 3 楼 getdate 的回复:] 数据源,你用的是哪个啊? 换个数据源试试,<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource"
用的就是這個[/quote] 你看你截图的,不是这个
qq_42769234 2019-04-25
  • 打赏
  • 举报
回复
<?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>
qq_42769234 2019-04-25
  • 打赏
  • 举报
回复
引用 3 楼 getdate 的回复:
数据源,你用的是哪个啊? 换个数据源试试,<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource"
用的就是這個
getdate 2019-04-25
  • 打赏
  • 举报
回复
你最好把你的配置文件,发下,别截图,还有就是把完整的错误信息发下.
getdate 2019-04-25
  • 打赏
  • 举报
回复
数据源,你用的是哪个啊? 换个数据源试试,<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource"
qq_42769234 2019-04-25
  • 打赏
  • 举报
回复
查了百度,說是jar包沒導全或是衝突,但是未發現這類的異常。web配置好了
搬砖的梦先生 2019-04-25
  • 打赏
  • 举报
回复
web中扫描配置错了吧 还有是不是resource下的路径错了

81,122

社区成员

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

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