请教Mybatis和Spring结合的配置问题，谢谢！

chain416 2012-06-03 10:49:57
我自己搭了一个struts2+Mybatis+Spring的框架，想通过MapperScannerConfigurer来自动添加Mybatis的mapper，发现一个很奇怪的问题：

如果不使用MapperScannerConfigurer，而采取手动配置添加mapper，一切正常；
如果使用了MapperScannerConfigurer，服务器启动的时候会报错，但是报的是数据源配置读取错误，好像和MapperScannerConfigurer无关。

错误信息和spring配置文件如下：



<?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:tx="http://www.springframework.org/schema/tx"       

	xmlns:jdbc="http://www.springframework.org/schema/jdbc"       

	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/jdbc http://www.springframework.org/schema/jdbc/spring-jdbc-3.0.xsd       

	http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-3.0.xsd       

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

	default-autowire="byName">

    

	<!-- 向spring注册AutowiredAnnotationBeanPostProcessor、CommonAnnotationBeanPostProcessor、

	PersistenceAnnotationBeanPostProcessor 以及 RequiredAnnotationBeanPostProcessor -->

	<context:annotation-config></context:annotation-config>

	<!-- 定义组件扫描的包名 -->

	<context:component-scan base-package="edu.zjut" />

	

	<!-- 导入属性配置文件 -->

	<bean id="propertyConfigurer"

		class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">

		<property name="locations">

			<list>

				<value>classpath:mysql.properties</value>

			</list>

		</property>

	</bean>



	<!-- context:property-placeholder location="classpath:mysql.properties" / -->

	<!-- 定义使用C3P0连接池的数据源 -->

	<bean id="dataSource"

		class="com.mchange.v2.c3p0.ComboPooledDataSource">

		<!-- 指定连接数据库的JDBC驱动 -->

		<property name="driverClass">

			<value>${jdbc.driverClassName}</value>

		</property>

		<!-- 连接数据库所用的URL -->

		<property name="jdbcUrl">

			<value>${jdbc.url}</value>

		</property>

		<!-- 连接数据库的用户名 -->

		<property name="user">

			<value>${jdbc.user}</value>

		</property>

		<!-- 连接数据库的密码 -->

		<property name="password">

			<value>${jdbc.password}</value>

		</property>

		<!-- 设置数据库连接池的最大连接数 -->

		<property name="maxPoolSize">

			<value>${jdbc.maxPoolSize}</value>

		</property>

		<!-- 设置数据库连接池的最小连接数 -->

		<property name="minPoolSize">

			<value>${jdbc.minPoolSize}</value>

		</property>

		<!-- 设置数据库连接池的初始化连接数 -->

		<property name="initialPoolSize">

			<value>${jdbc.initialPoolSize}</value>

		</property>

		<!-- 设置数据库连接池的连接的最大空闲时间,单位为秒 -->

		<property name="maxIdleTime">

			<value>${jdbc.maxIdleTime}</value>

		</property>

	</bean>

	

	<!-- 集成myBaits框架,配置sqlSessionFatory -->

	<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">

		<property name="configLocation" value="classpath:mybatis-config.xml" />

		<property name="dataSource" ref="dataSource" />

	</bean>

	

	<!-- 配置sqlSessionTemplate -->

	<bean id="sqlSessionTemplate" class="org.mybatis.spring.SqlSessionTemplate">

		<constructor-arg name="sqlSessionFactory" ref="sqlSessionFactory"/>

	</bean>

	

    <!-- mybatis自动扫描包下的mapper -->

	<bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">

		<property name="basePackage" value="org.mybatis.spring.sample.mapper" />

		<!-- optional unless there are multiple session factories defined -->

		<property name="sqlSessionFactoryBeanName" value="sqlSessionFactory" />

	</bean> 

    <!-- bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">

        <property name="basePackage" value="config.mybatis.mapper" />

    </bean -->

	

	<!-- 数据库的事务管理器配置 -->

	<bean id="transactionManager"

		class="org.springframework.jdbc.datasource.DataSourceTransactionManager">

		<property name="dataSource" ref="dataSource" />

	</bean>

	<!-- 使用annotation定义数据库事务，这样可以在类或方法中直接使用@Transactional注解来声明事务 -->

	<tx:annotation-driven transaction-manager="transactionManager" />

</beans>

...全文
41986 15 打赏 收藏 转发到动态 举报
写回复
用AI写文章
15 条回复
切换为时间正序
请发表友善的回复…
发表回复
sinat_20182537 2015-01-15
  • 打赏
  • 举报
 回复
因为MapperScannerConigurer实际是在解析加载bean定义阶段的，这个时候要是设置sqlSessionFactory的话，会导致提前初始化一些类，这个时候，PropertyPlaceholderConfigurer还没来得及替换定义中的变量，导致把表达式当作字符串复制了，解决的办法如下： 修改为 原理：使用sqlSessionFactoryBeanName注入，不会立即初始化sqlSessionFactory, 所以不会引发提前初始化问题，同时还应注意在配置org.mybatis.spring.SqlSessionFactoryBean 这个Bean时，id不能为sqlSessionFactory，如果为这样的话会导致MapperScannerConigurer在bean定义加载时，加载PropertyPlaceholderConfigurer还没来得及替换定义中的变量
pangpang514 2013-12-20
  • 打赏
  • 举报
 回复
引用 12 楼 chain416 的回复:
[Quote=引用 10 楼 的回复:] ${jdbc.maxPoolSize}这个肯定没有问题, 原因是你加入了MapperScannerConfigurer 他会优先于PropertyPlaceholderConfigurer执行,所以这个时候,${jdbc.maxPoolSize}还没有被解析呢, 故没有被mysql.properties里面的值所替换,所以出现NumberFormatException就是情理之…… [/Quote] 由于无法自动加载mapper，我跟踪到mybatis和spring源代码里面发现其对于mapper的搜索是基于ClassPathScanningCandidateComponentProvider类的findCandidateComponents方法，但是用来匹配的resourcePattern默认值却是"**/*.class"，无法匹配mapper的xml文件，这是怎么回事？难道要我把xml修改成class？
你这个问题解决没？我去官网上也没看到解决方案！我的也是用自动扫描就报错不能正常解析properties内容。
duguque1 2012-08-13
  • 打赏
  • 举报
 回复
用sqlSessionTemplate就不能用 自动扫描， 用自动扫描 就要用mybatis的接口
chain416 2012-06-04
  • 打赏
  • 举报
 回复
[Quote=引用 6 楼 的回复:]
Caused by: java.lang.NumberFormatException: For input string: "${jdbc.maxPoolSize}"
property中的定义是否后面多了空格。
[/Quote]

没有，不用扫描方式添加mapper都好好的正常工作
chain416 2012-06-04
  • 打赏
  • 举报
 回复
[Quote=引用 10 楼 的回复:]

${jdbc.maxPoolSize}这个肯定没有问题,

原因是你加入了MapperScannerConfigurer

他会优先于PropertyPlaceholderConfigurer执行,所以这个时候,${jdbc.maxPoolSize}还没有被解析呢,

故没有被mysql.properties里面的值所替换,所以出现NumberFormatException就是情理之……
[/Quote]

由于无法自动加载mapper，我跟踪到mybatis和spring源代码里面发现其对于mapper的搜索是基于ClassPathScanningCandidateComponentProvider类的findCandidateComponents方法，但是用来匹配的resourcePattern默认值却是"**/*.class"，无法匹配mapper的xml文件，这是怎么回事？难道要我把xml修改成class？
hezhichou 2012-06-04
  • 打赏
  • 举报
 回复
sping
chain416 2012-06-04
  • 打赏
  • 举报
 回复
[Quote=引用 4 楼 的回复:]
defined in file [D:\Workspaces\MyEclipse 10\.metadata\.me_tcat\webapps\SSM\WEB-INF\classes\applicationContext-common.xml

这里是问题的核心， 更具配置文件创建bean失败， 你要好好看一下你的
配置文件了。


错误描述：
Context initializati……
[/Quote]
谢谢！我的配置文件在1楼贴出来了，我左看右看都没什么问题啊，而且只要将MapperScannerConfigurer所在的bean配置删除或者注释掉，就可以正常工作。MapperScannerConfigurer的bean连名字都没有，应该不会有冲突吧？

这里面没有我自己写的set方法，因为被注入的对象都是系统或者框架提供的类，框架应该不会有问题的吧。

最后请教如何看报错日志
chain416 2012-06-04
  • 打赏
  • 举报
 回复
[Quote=引用 10 楼 的回复:]

${jdbc.maxPoolSize}这个肯定没有问题,

原因是你加入了MapperScannerConfigurer

他会优先于PropertyPlaceholderConfigurer执行,所以这个时候,${jdbc.maxPoolSize}还没有被解析呢,

故没有被mysql.properties里面的值所替换,所以出现NumberFormatException就是情理之……
[/Quote]

谢谢啊，我已经按照解决方法修改了配置文件，启动不再报错，但始终搜索不到包下面的mapper，没有报错，只有提示：“No MyBatis mapper was found in 'config.mybatis' package. Please check your configuration.”

但是这个包下面肯定是有xml的mapper文件的啊！

文件内容如下：



<?xml version="1.0" encoding="UTF-8" ?>

<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">

<!-- 命名空间，一般和对应的类同名，首字母大写 -->

<mapper namespace="User">



<!--  

	<resultMap type="edu.zjut.user.entity.User" id="userResultMap">

		<id property="id" column="id" />

		<result property="userName" column="userName" />

		<result property="password" column="password" />

	</resultMap>

-->

	<insert id="save" parameterType="edu.zjut.user.entity.User">

		insert into user values(#{userName},#{password})

	</insert>

	

	<update id="update" parameterType="edu.zjut.user.entity.User">

		update user set userName=#{userName},password=#{password} 

		where id=#{id}

	</update>

	

	<delete id="delete" parameterType="edu.zjut.user.entity.User">

		delete from user where id=#{id}

	</delete>

	

	<select id="query" parameterType="edu.zjut.user.entity.User"

		resultType="edu.zjut.user.entity.User">

		select * from user where id=#{id}

	</select>

	

	<select id="queryPage" parameterType="edu.zjut.user.entity.User" resultType="edu.zjut.user.entity.User">

		<![CDATA[

		select * from user 

		where username <> #{userName} limit #{start},#{pageSize}

		]]>

	</select>

	

	<select id="queryTotalCount" parameterType="edu.zjut.user.entity.User" resultType="Integer">

		<![CDATA[

		select count(*) from user

		where username <> #{userName}

		]]>

	</select>

	

	<select id="login" parameterType="edu.zjut.user.entity.User"

		resultType="edu.zjut.user.entity.User">

		select * from user where userName=#{userName} and

		password=#{password}

	</select>

	

</mapper>
huangxw000 2012-06-04
  • 打赏
  • 举报
 回复
Caused by: java.lang.NumberFormatException: For input string: "${jdbc.maxPoolSize}"
property中的定义是否后面多了空格。
熙风 2012-06-04
  • 打赏
  • 举报
 回复
还有，楼主，不要贴这么多错误信息出来，，这样看的很烦的，，都贴了3楼，，我擦，，
熙风 2012-06-04
  • 打赏
  • 举报
 回复
defined in file [D:\Workspaces\MyEclipse 10\.metadata\.me_tcat\webapps\SSM\WEB-INF\classes\applicationContext-common.xml

这里是问题的核心， 更具配置文件创建bean失败， 你要好好看一下你的
配置文件了。


错误描述：
Context initialization failed
错误产生原因：
spring注入出现问题：检测spring注入地方
1.注解注入，
是否有冲突
是否该类无法注入
2.配置文件
检测需要注入的具体实现类中，是否需要注入对象set方法编写正确

具体错误内容中会产生
注解注入错误，不容易看出具体哪个注入问题
配置文件注入问题，可以通过看报错日志定位错误
swoky 2012-06-04
  • 打赏
  • 举报
 回复
${jdbc.maxPoolSize}这个肯定没有问题,

原因是你加入了MapperScannerConfigurer

他会优先于PropertyPlaceholderConfigurer执行,所以这个时候,${jdbc.maxPoolSize}还没有被解析呢,

故没有被mysql.properties里面的值所替换,所以出现NumberFormatException就是情理之中了

这是mybatis-spring的一个己经公开的问题

详细解决办法请看
http://code.google.com/p/mybatis/issues/detail?id=414
chain416 2012-06-03
  • 打赏
  • 举报
 回复
Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sqlSessionFactory' defined in file [D:\Workspaces\MyEclipse 10\.metadata\.me_tcat\webapps\SSM\WEB-INF\classes\applicationContext-common.xml]: Cannot resolve reference to bean 'dataSource' while setting bean property 'dataSource'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'dataSource' defined in file [D:\Workspaces\MyEclipse 10\.metadata\.me_tcat\webapps\SSM\WEB-INF\classes\applicationContext-common.xml]: Initialization of bean failed; nested exception is org.springframework.beans.TypeMismatchException: Failed to convert property value of type 'java.lang.String' to required type 'int' for property 'maxPoolSize'; nested exception is java.lang.NumberFormatException: For input string: "${jdbc.maxPoolSize}"
at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:328)
at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:106)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1308)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1067)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:511)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:450)
at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:290)
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222)
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:287)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:189)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireByName(AbstractAutowireCapableBeanFactory.java:1085)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1035)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:511)
... 35 more
Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'dataSource' defined in file [D:\Workspaces\MyEclipse 10\.metadata\.me_tcat\webapps\SSM\WEB-INF\classes\applicationContext-common.xml]: Initialization of bean failed; nested exception is org.springframework.beans.TypeMismatchException: Failed to convert property value of type 'java.lang.String' to required type 'int' for property 'maxPoolSize'; nested exception is java.lang.NumberFormatException: For input string: "${jdbc.maxPoolSize}"
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:521)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:450)
at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:290)
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222)
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:287)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:189)
at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:322)
... 47 more
Caused by: org.springframework.beans.TypeMismatchException: Failed to convert property value of type 'java.lang.String' to required type 'int' for property 'maxPoolSize'; nested exception is java.lang.NumberFormatException: For input string: "${jdbc.maxPoolSize}"
at org.springframework.beans.BeanWrapperImpl.convertForProperty(BeanWrapperImpl.java:457)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.convertForProperty(AbstractAutowireCapableBeanFactory.java:1354)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1313)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1067)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:511)
... 53 more
Caused by: java.lang.NumberFormatException: For input string: "${jdbc.maxPoolSize}"
at java.lang.NumberFormatException.forInputString(NumberFormatException.java:48)
at java.lang.Integer.parseInt(Integer.java:447)
at java.lang.Integer.valueOf(Integer.java:553)
at org.springframework.util.NumberUtils.parseNumber(NumberUtils.java:155)
at org.springframework.beans.propertyeditors.CustomNumberEditor.setAsText(CustomNumberEditor.java:116)
at org.springframework.beans.TypeConverterDelegate.doConvertTextValue(TypeConverterDelegate.java:474)
at org.springframework.beans.TypeConverterDelegate.doConvertValue(TypeConverterDelegate.java:446)
at org.springframework.beans.TypeConverterDelegate.convertIfNecessary(TypeConverterDelegate.java:215)
at org.springframework.beans.TypeConverterDelegate.convertIfNecessary(TypeConverterDelegate.java:154)
at org.springframework.beans.BeanWrapperImpl.convertForProperty(BeanWrapperImpl.java:452)
... 57 more
2012-6-3 22:52:50 org.apache.catalina.core.StandardContext start
严重: Error listenerStart
2012-6-3 22:52:50 org.apache.catalina.core.StandardContext start
严重: Context [/SSM] startup failed due to previous errors
2012-6-3 22:52:50 org.apache.catalina.core.ApplicationContext log
信息: Closing Spring root WebApplicationContext
2012-6-3 22:52:51 org.apache.coyote.http11.Http11Protocol start
信息: Starting Coyote HTTP/1.1 on http-8080
2012-6-3 22:52:51 org.apache.jk.common.ChannelSocket init
信息: JK: ajp13 listening on /0.0.0.0:8009
2012-6-3 22:52:51 org.apache.jk.server.JkMain start
信息: Jk running ID=0 time=0/45 config=null
2012-6-3 22:52:51 org.apache.catalina.startup.Catalina start
信息: Server startup in 11579 ms
chain416 2012-06-03
  • 打赏
  • 举报
 回复
Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'dataSource' defined in file [D:\Workspaces\MyEclipse 10\.metadata\.me_tcat\webapps\SSM\WEB-INF\classes\applicationContext-common.xml]: Initialization of bean failed; nested exception is org.springframework.beans.TypeMismatchException: Failed to convert property value of type 'java.lang.String' to required type 'int' for property 'maxPoolSize'; nested exception is java.lang.NumberFormatException: For input string: "${jdbc.maxPoolSize}"
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:521)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:450)
at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:290)
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222)
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:287)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:189)
at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:322)
... 47 more
Caused by: org.springframework.beans.TypeMismatchException: Failed to convert property value of type 'java.lang.String' to required type 'int' for property 'maxPoolSize'; nested exception is java.lang.NumberFormatException: For input string: "${jdbc.maxPoolSize}"
at org.springframework.beans.BeanWrapperImpl.convertForProperty(BeanWrapperImpl.java:457)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.convertForProperty(AbstractAutowireCapableBeanFactory.java:1354)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1313)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1067)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:511)
... 53 more
Caused by: java.lang.NumberFormatException: For input string: "${jdbc.maxPoolSize}"
at java.lang.NumberFormatException.forInputString(NumberFormatException.java:48)
at java.lang.Integer.parseInt(Integer.java:447)
at java.lang.Integer.valueOf(Integer.java:553)
at org.springframework.util.NumberUtils.parseNumber(NumberUtils.java:155)
at org.springframework.beans.propertyeditors.CustomNumberEditor.setAsText(CustomNumberEditor.java:116)
at org.springframework.beans.TypeConverterDelegate.doConvertTextValue(TypeConverterDelegate.java:474)
at org.springframework.beans.TypeConverterDelegate.doConvertValue(TypeConverterDelegate.java:446)
at org.springframework.beans.TypeConverterDelegate.convertIfNecessary(TypeConverterDelegate.java:215)
at org.springframework.beans.TypeConverterDelegate.convertIfNecessary(TypeConverterDelegate.java:154)
at org.springframework.beans.BeanWrapperImpl.convertForProperty(BeanWrapperImpl.java:452)
... 57 more
2012-6-3 22:52:50 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 'org.mybatis.spring.mapper.MapperScannerConfigurer#0' defined in ServletContext resource [/WEB-INF/classes/applicationContext-common.xml]: Initialization of bean failed; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sqlSessionFactory' defined in file [D:\Workspaces\MyEclipse 10\.metadata\.me_tcat\webapps\SSM\WEB-INF\classes\applicationContext-common.xml]: Cannot resolve reference to bean 'dataSource' while setting bean property 'dataSource'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'dataSource' defined in file [D:\Workspaces\MyEclipse 10\.metadata\.me_tcat\webapps\SSM\WEB-INF\classes\applicationContext-common.xml]: Initialization of bean failed; nested exception is org.springframework.beans.TypeMismatchException: Failed to convert property value of type 'java.lang.String' to required type 'int' for property 'maxPoolSize'; nested exception is java.lang.NumberFormatException: For input string: "${jdbc.maxPoolSize}"
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:521)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:450)
at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:290)
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222)
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:287)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:193)
at org.springframework.beans.factory.support.DefaultListableBeanFactory.getBeansOfType(DefaultListableBeanFactory.java:386)
at org.springframework.context.support.AbstractApplicationContext.invokeBeanFactoryPostProcessors(AbstractApplicationContext.java:582)
at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:405)
at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:272)
at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:196)
at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:47)
at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3827)
at org.apache.catalina.core.StandardContext.start(StandardContext.java:4334)
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:791)
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:771)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:525)
at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:920)
at org.apache.catalina.startup.HostConfig.deployDirectories(HostConfig.java:883)
at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:492)
at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1138)
at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:311)
at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:117)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053)
at org.apache.catalina.core.StandardHost.start(StandardHost.java:719)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)
at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)
at org.apache.catalina.core.StandardService.start(StandardService.java:516)
at org.apache.catalina.core.StandardServer.start(StandardServer.java:710)
at org.apache.catalina.startup.Catalina.start(Catalina.java:566)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:288)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:413)
chain416 2012-06-03
  • 打赏
  • 举报
 回复
2012-06-03 22:52:50 [日志信息] Context initialization failed
org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'org.mybatis.spring.mapper.MapperScannerConfigurer#0' defined in ServletContext resource [/WEB-INF/classes/applicationContext-common.xml]: Initialization of bean failed; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sqlSessionFactory' defined in file [D:\Workspaces\MyEclipse 10\.metadata\.me_tcat\webapps\SSM\WEB-INF\classes\applicationContext-common.xml]: Cannot resolve reference to bean 'dataSource' while setting bean property 'dataSource'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'dataSource' defined in file [D:\Workspaces\MyEclipse 10\.metadata\.me_tcat\webapps\SSM\WEB-INF\classes\applicationContext-common.xml]: Initialization of bean failed; nested exception is org.springframework.beans.TypeMismatchException: Failed to convert property value of type 'java.lang.String' to required type 'int' for property 'maxPoolSize'; nested exception is java.lang.NumberFormatException: For input string: "${jdbc.maxPoolSize}"
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:521)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:450)
at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:290)
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222)
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:287)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:193)
at org.springframework.beans.factory.support.DefaultListableBeanFactory.getBeansOfType(DefaultListableBeanFactory.java:386)
at org.springframework.context.support.AbstractApplicationContext.invokeBeanFactoryPostProcessors(AbstractApplicationContext.java:582)
at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:405)
at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:272)
at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:196)
at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:47)
at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3827)
at org.apache.catalina.core.StandardContext.start(StandardContext.java:4334)
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:791)
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:771)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:525)
at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:920)
at org.apache.catalina.startup.HostConfig.deployDirectories(HostConfig.java:883)
at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:492)
at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1138)
at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:311)
at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:117)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053)
at org.apache.catalina.core.StandardHost.start(StandardHost.java:719)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)
at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)
at org.apache.catalina.core.StandardService.start(StandardService.java:516)
at org.apache.catalina.core.StandardServer.start(StandardServer.java:710)
at org.apache.catalina.startup.Catalina.start(Catalina.java:566)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:288)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:413)
Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sqlSessionFactory' defined in file [D:\Workspaces\MyEclipse 10\.metadata\.me_tcat\webapps\SSM\WEB-INF\classes\applicationContext-common.xml]: Cannot resolve reference to bean 'dataSource' while setting bean property 'dataSource'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'dataSource' defined in file [D:\Workspaces\MyEclipse 10\.metadata\.me_tcat\webapps\SSM\WEB-INF\classes\applicationContext-common.xml]: Initialization of bean failed; nested exception is org.springframework.beans.TypeMismatchException: Failed to convert property value of type 'java.lang.String' to required type 'int' for property 'maxPoolSize'; nested exception is java.lang.NumberFormatException: For input string: "${jdbc.maxPoolSize}"
at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:328)
at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:106)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1308)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1067)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:511)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:450)
at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:290)
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222)
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:287)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:189)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireByName(AbstractAutowireCapableBeanFactory.java:1085)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1035)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:511)
... 35 more
还觉得看spring源码脑壳痛？掌握这套方法，阿里大门向你敞开！
目录 前言 Spring源码学习方法 1、通读Spring官方文档 2、如何正确阅读Spring源码 3、尽情去调试Spring吧 Spring核心技术知识 Spring大厂面试真题 金九银十全套面试资料（均含答案） 前言 都说大厂面试必问源码，可很多人看完Spring、MyBatis等源码记不住，是脑子有问题吗？当然不是！是因为你没有掌握学习源码的技巧。我的朋友子路，很多人都叫他路神，称他为“国内Spring讲解最好的第一人”。子路说他以前学习Spring、Spring boot源码
SpringMvc+Mybatis实现一个简单人事管理系统（一）
这个博客主要记录我暑期在公司实习中学到的SpringMvc+Mybatis知识，并用他们做了一个简单的人事管理系统。本博客也记录了本人在学习中遇到的问题bug还有他们的解决方案。
SpringMvc+Spring+Mybatis+Maven整合
最近项目需要用到SSMM框架   来了此整合 我用的myEclipse 第一步  创建数据库  : 然后随便录入几条数据 第二部 用generator生成映射文件 和实体类 dao generator.xml文件  要改的地方 然后 打开 cmd窗口 转到generator文件夹下 提示:按Shift+鼠标右键 --
SpringBoot分离打包：将jar包与lib依赖、配置文件分开
文章目录一、前言二、正文1.整个项目的目录结构2.系统环境变量配置3.pom文件配置——本文重点，其它部分甚至不用看4. 打包5.测试，测试依赖于前两篇所构建的测试项目，当然这不重要三、总结 一、前言 昨天和项目组内一位经验丰富的老师傅探讨，围绕着SpringBoot打包后动不动就一百多兆，在现场远程维护部署时非常不方便的问题，进行了一番请教。问题的根本是：有时候仅仅改动了一点点东西，却要发给现场替换包含所有依赖的jar包，这非常的笨重不方便。 于是又学到了新知识。抽空浏览了网上的资料，结合工作中的实际使用
Spring事务管理（一）：开篇，对于Spring事务的几个疑问
一、背景 在项目开发的时候，经常会遇到方法加了事务注解，事务却没有生效的情况，请教同事之后，当时的一段代码是没有问题了，但是却不了解为什么，所以抽出一段时间专门学习下Spring的事务管理。 二、范围 本系列只讨论Spring+JDBC（MyBatis）声明式事务的实现原理 三、疑问点 为什么同一个类中，一个方法调用另一个加了事务注解@Transactional注解的方法，事务却没有生效？ 假如有两个加了@Transactional注解的方法，但是他们的transactionManager不一样
Web 开发

81,092

社区成员

341,716

社区内容

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

加载中

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

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

+ 用AI写文章