四、Invalid property 'dataSource' of bean class [xxx.dao.JdbcUserDao]: Bean property

本文分析了一个关于Spring框架中配置DataSource时出现的错误,并详细解释了如何正确地为JdbcUserDao设置DataSource。
org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'jdbcUserDao' defined in class path resource [schema.xml]: Error setting property values; nested exception is org.springframework.beans.NotWritablePropertyException: Invalid property 'dataSource' of bean class [chentailei.dao.JdbcUserDao]: Bean property 'dataSource' is not writable or has an invalid setter method. Does the parameter type of the setter match the return type of the getter?
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1279)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1010)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:472)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory$1.run(AbstractAutowireCapableBeanFactory.java:409)
	at java.security.AccessController.doPrivileged(Native Method)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:380)
	at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:264)
	at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222)
	at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:261)
	at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:185)
	at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:164)
	at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:429)
	at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:728)
	at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:380)
	at org.springframework.context.support.ClassPathXmlApplicationContext.<init>(ClassPathXmlApplicationContext.java:139)
	at org.springframework.context.support.ClassPathXmlApplicationContext.<init>(ClassPathXmlApplicationContext.java:83)
	at chentailei.test.TestUserDao.findById(TestUserDao.java:76)
	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.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:44)
	at org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:15)
	at org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:41)
	at org.junit.internal.runners.statements.InvokeMethod.evaluate(InvokeMethod.java:20)
	at org.junit.internal.runners.statements.RunBefores.evaluate(RunBefores.java:28)
	at org.junit.internal.runners.statements.RunAfters.evaluate(RunAfters.java:31)
	at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:73)
	at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:46)
	at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:180)
	at org.junit.runners.ParentRunner.access$000(ParentRunner.java:41)
	at org.junit.runners.ParentRunner$1.evaluate(ParentRunner.java:173)
	at org.junit.internal.runners.statements.RunBefores.evaluate(RunBefores.java:28)
	at org.junit.internal.runners.statements.RunAfters.evaluate(RunAfters.java:31)
	at org.junit.runners.ParentRunner.run(ParentRunner.java:220)
	at org.eclipse.jdt.internal.junit4.runner.JUnit4TestReference.run(JUnit4TestReference.java:46)
	at org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:38)
	at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:467)
	at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:683)
	at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:390)
	at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:197)
Caused by: org.springframework.beans.NotWritablePropertyException: Invalid property 'dataSource' of bean class [xxx.dao.JdbcUserDao]: 
Bean property 'dataSource' is not writable or has an invalid setter method. Does the parameter type of the setter match the return type of the getter?
	at org.springframework.beans.BeanWrapperImpl.setPropertyValue(BeanWrapperImpl.java:801)
	at org.springframework.beans.BeanWrapperImpl.setPropertyValue(BeanWrapperImpl.java:651)
	at org.springframework.beans.AbstractPropertyAccessor.setPropertyValues(AbstractPropertyAccessor.java:78)
	at org.springframework.beans.AbstractPropertyAccessor.setPropertyValues(AbstractPropertyAccessor.java:59)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1276)
	... 40 more

原因:

private JdbcTemplate template;
    public void setTemplate(DataSource dataSource){
        //相当于this.getJdbcTemplate()
        template = new JdbcTemplate(dataSource);
        
    }

方法调用出错:

应该是setDataSource

private JdbcTemplate template;
    public void setDataSource(DataSource dataSource){
        //相当于this.getJdbcTemplate()
        template = new JdbcTemplate(dataSource);
        
    }



Error creating bean with name 'bannerController': Unsatisfied dependency expressed through field 'service'; nested exception is org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'bannerService': Unsatisfied dependency expressed through field 'dao'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'ds1BannerDao' defined in file [D:\shd\亚楠\全面预算\后端代码\cmb-sy-biz-tbm-srv\target\classes\com\cmb\sy\dao\BannerDao.class]: Cannot resolve reference to bean 'ds1SqlSessionTemplate' while setting bean property 'sqlSessionTemplate'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'ds1SqlSessionFactory': Invocation of init method failed; nested exception is org.springframework.core.NestedIOException: Failed to parse mapping resource: 'file [D:\shd\亚楠\全面预算\后端代码\cmb-sy-biz-tbm-srv\target\classes\mybatis\mapper\CorporateBuggetMapper.xml]'; nested exception is org.apache.ibatis.builder.BuilderException: Error parsing Mapper XML. The XML location is 'file [D:\shd\亚楠\全面预算\后端代码\cmb-sy-biz-tbm-srv\target\classes\mybatis\mapper\CorporateBuggetMapper.xml]'. Cause: java.lang.IllegalStateException: Type handler was null on parameter mapping for property 'submissionDate'. It was either not specified and/or could not be found for the javaType (lombok.Data) : jdbcType (null) combination. 这个错误怎么解决
10-18
package com.buka.controller; import com.buka.service.BankService; import org.apache.ibatis.annotations.Param; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Controller; import org.springframework.web.servlet.ModelAndView; import javax.annotation.Resource; @Controller public class BankController { @Resource private BankService bankService; public ModelAndView login(@Param("name")String name,@Param("password")Integer password, ModelAndView mv){ int bank=bankService.check(name,password); mv.addObject("bank",bank); mv.setViewName("account.jsp"); return mv; } } package com.buka.dao; import com.buka.po.BankCard; import org.apache.ibatis.annotations.Mapper; import org.apache.ibatis.annotations.Param; @Mapper public interface BankDao { public BankCard login(@Param("name") String name, @Param("password") Integer password); } package com.buka.service; import com.buka.dao.BankDao; import com.buka.po.BankCard; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Service; import javax.annotation.Resource; @Service public class BankService { @Resource BankDao bankDao; public int check(String name,Integer password){ BankCard bankCard= bankDao.login(name,password); if (bankCard != null) { return 1; } else { return 0; } } } <?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="com.buka.dao.BankDao"> <select id="login" parameterType="com.buka.po.BankCard" > SELECT * FROM bank_card WHERE name = #{name} AND password = #{password} </select> </mapper>
09-25
```text org.springframework.beans.NullValueInNestedPathException: Invalid property 'contractAfterSaleTerms[0].afterSaleInterval' of bean class [xxx.Contract]: Invalid nested path: "contractAfterSaleTerms[0]". Property referencing non-existent bean? ``` --- ### ❓ 异常解释 `NullValueInNestedPathException` 是 Spring 框架在进行 **数据绑定(Data Binding)** 或通过反射访问嵌套属性时抛出的异常。 你遇到的这个异常: > `Invalid property 'contractAfterSaleTerms[0].afterSaleInterval' of bean class [...]` 表示: Spring 尝试设置或获取 `contract.contractAfterSaleTerms[0].afterSaleInterval` 的值,但发现 `contractAfterSaleTerms[0]` 为 `null` —— 即列表中第 0 个元素是 `null`,无法继续访问其内部字段 `.afterSaleInterval`。 --- ### 🧨 根本原因分析 #### ✅ 正常情况: ```java contract.getContractAfterSaleTerms().get(0) != null ``` → 可以安全地访问 `.afterSaleInterval` #### ❌ 实际情况: ```java contract.getContractAfterSaleTerms().get(0) == null ``` → 当 Spring 的 `BeanWrapper`、`DataBinder` 或 `PropertyAccessor` 尝试访问该位置时,就会抛出 `NullValueInNestedPathException`。 常见场景如下: | 场景 | 描述 | |------|------| | 1. 前端传了空数组项 | JSON 中 `"contractAfterSaleTerms": [null, {...}]` | | 2. List 初始化不完整 | Java 代码中 `new ArrayList<>()` 后只 add 了一部分对象,中间插入了 null | | 3. 数据绑定期间赋值失败 | 如类型转换错误导致某一项构建失败,变成 null | | 4. 使用表单绑定时索引跳跃 | 如提交 `contractAfterSaleTerms[5].afterSaleInterval=30`,但前面没有初始化大小 | --- ### 🔍 典型触发示例 #### 示例 1:前端发送错误 JSON ```json { "contractAfterSaleTerms": [ null, { "afterSaleInterval": 30 } ] } ``` → Spring MVC 绑定时会尝试绑定 `contractAfterSaleTerms[0].afterSaleInterval` → 报错! #### 示例 2:使用 Spring 表单标签或 REST API 提交越界索引 ```http POST /save Content-Type: application/x-www-form-urlencoded contractAfterSaleTerms[0].afterSaleInterval=10 # 但是 contractAfterSaleTerms 列表本身为空或未初始化 ``` → Spring 创建路径时发现 `contractAfterSaleTerms[0]` 不存在且不能自动实例化(因为是 `null`) --- ### ✅ 解决方案 #### ✅ 方案 1:确保集合中不含 `null` 元素(推荐) 在业务逻辑或 DTO 转换阶段过滤掉 `null`: ```java List<ContractAfterSaleTerm> terms = contract.getContractAfterSaleTerms(); if (terms != null) { terms.removeIf(Objects::isNull); } else { contract.setContractAfterSaleTerms(new ArrayList<>()); } ``` 或者构造时避免添加 null: ```java List<ContractAfterSaleTerm> validTerms = contract.getContractAfterSaleTerms().stream() .filter(Objects::nonNull) .peek(term -> term.setContract(contract)) .collect(Collectors.toList()); ``` --- #### ✅ 方案 2:初始化集合和元素(防止绑定失败) 如果你使用的是 Spring Web Data Binding(如表单提交),可以重写 setter 或使用自定义编辑器。 ##### 方法 A:在实体类中初始化 List ```java public class Contract { private List<ContractAfterSaleTerm> contractAfterSaleTerms = new ArrayList<>(); public List<ContractAfterSaleTerm> getContractAfterSaleTerms() { return contractAfterSaleTerms; } public void setContractAfterSaleTerms(List<ContractAfterSaleTerm> terms) { if (terms == null) { this.contractAfterSaleTerms = new ArrayList<>(); } else { // 过滤 null 并建立双向关联 this.contractAfterSaleTerms = terms.stream() .filter(Objects::nonNull) .peek(term -> term.setContract(this)) .collect(Collectors.toList()); } } } ``` ##### 方法 B:使用 `@PostConstruct` 或构造函数预初始化 ```java public Contract() { this.contractAfterSaleTerms = new ArrayList<>(); } ``` --- #### ✅ 方案 3:前端保证不传 null 元素 ```js // 前端 JS 处理 const validTerms = form.terms.filter(term => term && term.afterSaleType); axios.post('/api/contract', { contractAfterSaleTerms: validTerms }); ``` --- #### ✅ 方案 4:使用 `@InitBinder` 自定义绑定行为(高级) 你可以注册一个 `PropertyEditor` 或启用自动增长列表功能: ```java @InitBinder public void initBinder(WebDataBinder binder) { // 允许自动创建嵌套路径中的集合元素 binder.setAutoGrowNestedPaths(true); // 关键!开启自动扩容 binder.setAutoGrowCollectionLimit(50); // 防止恶意请求 } ``` > ✅ `setAutoGrowNestedPaths(true)` 会让 Spring 在访问 `contractAfterSaleTerms[0]` 时自动创建一个新的 `ContractAfterSaleTerm()` 实例,而不是报错。 ⚠️ 注意:此选项虽然方便,但也可能隐藏数据质量问题(比如用户误填),建议结合校验使用。 --- ### ✅ 最佳实践总结 | 措施 | 说明 | |------|------| | ✅ 初始化集合 | 所有 `List<T>` 字段应在声明或构造函数中初始化 | | ✅ 开启 `autoGrowNestedPaths` | 对于表单场景非常有用,避免空指针 | | ✅ 过滤 null 元素 | 在服务层或 DTO 映射阶段清理无效数据 | | ✅ 使用 `@Valid` + `@NotNull` 校验 | 提前发现问题 | | ✅ 日志打印输入数据 | 调试时输出 `@RequestBody contract` 内容 | --- ### 💡 示例修复后代码(完整安全版) ```java @InitBinder public void initBinder(WebDataBinder binder) { binder.setAutoGrowNestedPaths(true); binder.setAutoGrowCollectionLimit(100); } @PostMapping("/save") public ResponseEntity<?> saveContract(@RequestBody @Valid Contract contract) { // 过滤 null 条款 List<ContractAfterSaleTerm> filtered = contract.getContractAfterSaleTerms().stream() .filter(Objects::nonNull) .peek(term -> { if (term.getAfterSaleType() == null || term.getAfterSaleType().getId() == null) { ExceptionUtil.throwServiceException("售后类型不能为空"); } term.setContract(contract); }) .collect(Collectors.toList()); // 检查重复 Set<Long> ids = filtered.stream() .map(t -> t.getAfterSaleType().getId()) .collect(Collectors.toSet()); if (ids.size() != filtered.size()) { ExceptionUtil.throwServiceException("不能存在相同售后类型"); } contract.setContractAfterSaleTerms(filtered); contractService.save(contract); return ResponseEntity.ok().build(); } ``` ---
评论
成就一亿技术人!
拼手气红包6.0元
还能输入1000个字符
 
红包 添加红包
表情包 插入表情
 条评论被折叠 查看
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值