It was either not specified and/or could not be found for the javaType (java.util.List) : jdbcType

最新推荐文章于 2024-06-05 10:58:29 发布
最新推荐文章于 2024-06-05 10:58:29 发布
阅读量1.4w 收藏 7
点赞数 2
分类专栏： Mybatis 技巧分享 文章标签： java list mybatis mybatis plus
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/qq_44760609/article/details/125434505
版权

在使用MyBatis-Plus的时候，他会将实体类以及表字段自动关联起来，但是当我们想要指定额外的一对多关系的时候，例如：
订单保存的时候同时需要保存订单详情列表，此时订单与订单详情列表就是 一对多 的关系，因此在定义订单实体类的时候，我们还需要额外的定义一个订单详情列表集合属性，但是此时在保存订单的时候就会报错：

### Error updating database.  Cause: java.lang.IllegalStateException: Type handler was null on parameter mapping for property 'orderDetails'. It was either not specified and/or could not be found for the javaType (java.util.List) : jdbcType (null) combination.
### The error may exist in com/soberw/mall/dao/MallOrderDao.java (best guess)
### The error may involve com.soberw.mall.dao.MallOrderDao.insert
### The error occurred while executing an update
### Cause: java.lang.IllegalStateException: Type handler was null on parameter mapping for property 'orderDetails'. It was either not specified and/or could not be found for the javaType (java.util.List) : jdbcType (null) combination.] with root cause

java.lang.IllegalStateException: Type handler was null on parameter mapping for property 'orderDetails'. It was either not specified and/or could not be found for the javaType (java.util.List) : jdbcType (null) combination.
	at org.apache.ibatis.mapping.ParameterMapping$Builder.validate(ParameterMapping.java:119) ~[mybatis-3.5.9.jar:3.5.9]
	at org.apache.ibatis.mapping.ParameterMapping$Builder.build(ParameterMapping.java:104) ~[mybatis-3.5.9.jar:3.5.9]
	at org.apache.ibatis.builder.SqlSourceBuilder$ParameterMappingTokenHandler.buildParameterMapping(SqlSourceBuilder.java:143) ~[mybatis-3.5.9.jar:3.5.9]
	at org.apache.ibatis.builder.SqlSourceBuilder$ParameterMappingTokenHandler.handleToken(SqlSourceBuilder.java:87) ~[mybatis-3.5.9.jar:3.5.9]
	at org.apache.ibatis.parsing.GenericTokenParser.parse(GenericTokenParser.java:77) ~[mybatis-3.5.9.jar:3.5.9]
	at org.apache.ibatis.builder.SqlSourceBuilder.parse(SqlSourceBuilder.java:50) ~[mybatis-3.5.9.jar:3.5.9]
	at org.apache.ibatis.scripting.xmltags.DynamicSqlSource.getBoundSql(DynamicSqlSource.java:42) ~[mybatis-3.5.9.jar:3.5.9]
	at org.apache.ibatis.mapping.MappedStatement.getBoundSql(MappedStatement.java:305) ~[mybatis-3.5.9.jar:3.5.9]
	at org.apache.ibatis.executor.statement.BaseStatementHandler.<init>(BaseStatementHandler.java:64) ~[mybatis-3.5.9.jar:3.5.9]
	at org.apache.ibatis.executor.statement.PreparedStatementHandler.<init>(PreparedStatementHandler.java:41) ~[mybatis-3.5.9.jar:3.5.9]
	at org.apache.ibatis.executor.statement.RoutingStatementHandler.<init>(RoutingStatementHandler.java:46) ~[mybatis-3.5.9.jar:3.5.9]
	at org.apache.ibatis.session.Configuration.newStatementHandler(Configuration.java:681) ~[mybatis-3.5.9.jar:3.5.9]
	at org.apache.ibatis.executor.SimpleExecutor.doUpdate(SimpleExecutor.java:48) ~[mybatis-3.5.9.jar:3.5.9]
	at org.apache.ibatis.executor.BaseExecutor.update(BaseExecutor.java:117) ~[mybatis-3.5.9.jar:3.5.9]
	at org.apache.ibatis.executor.CachingExecutor.update(CachingExecutor.java:76) ~[mybatis-3.5.9.jar:3.5.9]
	at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:na]
	at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77) ~[na:na]
	at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:na]
	at java.base/java.lang.reflect.Method.invoke(Method.java:568) ~[na:na]
	at org.apache.ibatis.plugin.Invocation.proceed(Invocation.java:49) ~[mybatis-3.5.9.jar:3.5.9]
	at com.baomidou.mybatisplus.extension.plugins.MybatisPlusInterceptor.intercept(MybatisPlusInterceptor.java:106) ~[mybatis-plus-extension-3.5.1.jar:3.5.1]
	at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:62) ~[mybatis-3.5.9.jar:3.5.9]
	at jdk.proxy2/jdk.proxy2.$Proxy97.update(Unknown Source) ~[na:na]
	at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:na]
	at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77) ~[na:na]
	at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:na]
	at java.base/java.lang.reflect.Method.invoke(Method.java:568) ~[na:na]
	at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:64) ~[mybatis-3.5.9.jar:3.5.9]
	at jdk.proxy2/jdk.proxy2.$Proxy97.update(Unknown Source) ~[na:na]
	at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:194) ~[mybatis-3.5.9.jar:3.5.9]
	at org.apache.ibatis.session.defaults.DefaultSqlSession.insert(DefaultSqlSession.java:181) ~[mybatis-3.5.9.jar:3.5.9]
	at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:na]
	at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77) ~[na:na]
	at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:na]
	at java.base/java.lang.reflect.Method.invoke(Method.java:568) ~[na:na]
	at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:427) ~[mybatis-spring-2.0.7.jar:2.0.7]
	at jdk.proxy2/jdk.proxy2.$Proxy76.insert(Unknown Source) ~[na:na]
	at org.mybatis.spring.SqlSessionTemplate.insert(SqlSessionTemplate.java:272) ~[mybatis-spring-2.0.7.jar:2.0.7]
	at com.baomidou.mybatisplus.core.override.MybatisMapperMethod.execute(MybatisMapperMethod.java:59) ~[mybatis-plus-core-3.5.1.jar:3.5.1]
	at com.baomidou.mybatisplus.core.override.MybatisMapperProxy$PlainMethodInvoker.invoke(MybatisMapperProxy.java:148) ~[mybatis-plus-core-3.5.1.jar:3.5.1]
	at com.baomidou.mybatisplus.core.override.MybatisMapperProxy.invoke(MybatisMapperProxy.java:89) ~[mybatis-plus-core-3.5.1.jar:3.5.1]
	at jdk.proxy2/jdk.proxy2.$Proxy79.insert(Unknown Source) ~[na:na]
	at com.baomidou.mybatisplus.extension.service.IService.save(IService.java:63) ~[mybatis-plus-extension-3.5.1.jar:3.5.1]
	at com.soberw.mall.service.impl.MallOrderServiceImpl.save(MallOrderServiceImpl.java:91) ~[classes/:na]
	at com.soberw.mall.service.impl.MallOrderServiceImpl.save(MallOrderServiceImpl.java:29) ~[classes/:na]
	at com.soberw.mall.service.impl.MallOrderServiceImpl$$FastClassBySpringCGLIB$$303bc1b3.invoke(<generated>) ~[classes/:na]
	at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218) ~[spring-core-5.3.19.jar:5.3.19]
	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:793) ~[spring-aop-5.3.19.jar:5.3.19]
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163) ~[spring-aop-5.3.19.jar:5.3.19]
	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:763) ~[spring-aop-5.3.19.jar:5.3.19]
	at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:123) ~[spring-tx-5.3.19.jar:5.3.19]
	at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:388) ~[spring-tx-5.3.19.jar:5.3.19]
	at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:119) ~[spring-tx-5.3.19.jar:5.3.19]
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186) ~[spring-aop-5.3.19.jar:5.3.19]
	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:763) ~[spring-aop-5.3.19.jar:5.3.19]
	at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:708) ~[spring-aop-5.3.19.jar:5.3.19]
	at com.soberw.mall.service.impl.MallOrderServiceImpl$$EnhancerBySpringCGLIB$$cb9b51f3.save(<generated>) ~[classes/:na]
	at com.soberw.mall.controller.MallOrderController.insert(MallOrderController.java:82) ~[classes/:na]
	at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:na]
	at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77) ~[na:na]
	at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:na]
	at java.base/java.lang.reflect.Method.invoke(Method.java:568) ~[na:na]
	at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:205) ~[spring-web-5.3.19.jar:5.3.19]
	at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:150) ~[spring-web-5.3.19.jar:5.3.19]
	at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:117) ~[spring-webmvc-5.3.19.jar:5.3.19]
	at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:895) ~[spring-webmvc-5.3.19.jar:5.3.19]
	at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:808) ~[spring-webmvc-5.3.19.jar:5.3.19]
	at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87) ~[spring-webmvc-5.3.19.jar:5.3.19]
	at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1067) ~[spring-webmvc-5.3.19.jar:5.3.19]
	at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:963) ~[spring-webmvc-5.3.19.jar:5.3.19]
	at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1006) ~[spring-webmvc-5.3.19.jar:5.3.19]
	at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:909) ~[spring-webmvc-5.3.19.jar:5.3.19]
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:681) ~[tomcat-embed-core-9.0.62.jar:4.0.FR]
	at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:883) ~[spring-webmvc-5.3.19.jar:5.3.19]
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:764) ~[tomcat-embed-core-9.0.62.jar:4.0.FR]
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:227) ~[tomcat-embed-core-9.0.62.jar:9.0.62]
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) ~[tomcat-embed-core-9.0.62.jar:9.0.62]
	at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) ~[tomcat-embed-websocket-9.0.62.jar:9.0.62]
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189) ~[tomcat-embed-core-9.0.62.jar:9.0.62]
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) ~[tomcat-embed-core-9.0.62.jar:9.0.62]
	at com.alibaba.druid.support.http.WebStatFilter.doFilter(WebStatFilter.java:124) ~[druid-1.2.9.jar:1.2.9]
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189) ~[tomcat-embed-core-9.0.62.jar:9.0.62]
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) ~[tomcat-embed-core-9.0.62.jar:9.0.62]
	at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:100) ~[spring-web-5.3.19.jar:5.3.19]
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117) ~[spring-web-5.3.19.jar:5.3.19]
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189) ~[tomcat-embed-core-9.0.62.jar:9.0.62]
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) ~[tomcat-embed-core-9.0.62.jar:9.0.62]
	at org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:93) ~[spring-web-5.3.19.jar:5.3.19]
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117) ~[spring-web-5.3.19.jar:5.3.19]
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189) ~[tomcat-embed-core-9.0.62.jar:9.0.62]
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) ~[tomcat-embed-core-9.0.62.jar:9.0.62]
	at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:201) ~[spring-web-5.3.19.jar:5.3.19]
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117) ~[spring-web-5.3.19.jar:5.3.19]
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189) ~[tomcat-embed-core-9.0.62.jar:9.0.62]
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) ~[tomcat-embed-core-9.0.62.jar:9.0.62]
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:197) ~[tomcat-embed-core-9.0.62.jar:9.0.62]
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97) ~[tomcat-embed-core-9.0.62.jar:9.0.62]
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:541) ~[tomcat-embed-core-9.0.62.jar:9.0.62]
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:135) ~[tomcat-embed-core-9.0.62.jar:9.0.62]
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) ~[tomcat-embed-core-9.0.62.jar:9.0.62]
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78) ~[tomcat-embed-core-9.0.62.jar:9.0.62]
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:360) ~[tomcat-embed-core-9.0.62.jar:9.0.62]
	at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:399) ~[tomcat-embed-core-9.0.62.jar:9.0.62]
	at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65) ~[tomcat-embed-core-9.0.62.jar:9.0.62]
	at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:890) ~[tomcat-embed-core-9.0.62.jar:9.0.62]
	at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1743) ~[tomcat-embed-core-9.0.62.jar:9.0.62]
	at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) ~[tomcat-embed-core-9.0.62.jar:9.0.62]
	at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191) ~[tomcat-embed-core-9.0.62.jar:9.0.62]
	at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659) ~[tomcat-embed-core-9.0.62.jar:9.0.62]
	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) ~[tomcat-embed-core-9.0.62.jar:9.0.62]
	at java.base/java.lang.Thread.run(Thread.java:833) ~[na:na]

根本原因就是：

找不到定义的订单详情列表属性的映射字段
肯定找不到啊，因为我们在数据库中就没有定义订单详情的字段，因此在保存的时候忽略掉这个属性就可以了

实现方式很简单：
==在将要忽略的属性上面添加 @TableField(exist = false)==注解即可：

    //订单详情列表
    @TableField(exist = false)  //标志此属性不是表的字段
    private List<MallOrderDetail> orderDetails;
soberw-
关注
  • 2
    点赞
  • 踩
  • 7
    收藏
    觉得还不错? 一键收藏
  • 2
    评论
专栏目录
彻底解决Failed to configure a DataSource: ‘url‘ attribute is not specified and no embedded datasource
renkai721的专栏
01-06 23万+
Failed to configure a DataSource: ‘url‘ attribute is not specified and no embedded datasource
mybatis系列之传参为List数据的使用细节
Nicky's blog
12-13 4521
或许是惯性思维，在mybatis使用foreach循环调用的时候，很多时候都是传一个对象，传一个List的情况很少，所以写代码有时候会不注意就用惯性思维方法做了。 今天向sql传参，传了一个List作为参数，然后在xml里再foreach循环调用。然后报错信息如： mybatis foreach报错It was either not specified and/or could not be f...
It was either not specified and/or could not be found for the javaType (java.time.LocalDateTime)
Bruce_Json的博客
06-27 7931
总所周知，localdatetime是jdk8 推出的关于日期计算非常方便地一个类，一旦开始用上就欲罢不能。但是在使用的时候，坑还是蛮多的。 一、mybatis与LocalDatetime 如果直接将实体里面所有的Date类型换成LocalDatetime之后，运行程序是会报异常的。此时，可以加入以下依赖： <dependency> <groupId>org.myb...
报错总结 Cause: java.lang.IllegalStateException: Type handler was null on parameter mapping for propert
最新发布
qq_50595984的博客
06-05 1332
解决办法：如果在实体类中利用自定义注解@Id在插入到数据库表前生成随机Id值，需要去掉注解，因为这种情况下，我们在新增数据时不需要考虑为新数据的 ID 赋值。
It was either not specified and/or could not be found for the javaType:jdbcType(VARCHAR)combination
siyi1219的博客
01-08 4万+
查找错误原因发现是在xml中的返回值写错了： dao层方法 结果返回值写成了 只要把它改成： resultType="String" 就好了，测试成功
SSM之Mybatis框架报错：It was either not specified and/or could not be found for the javaType (xxx) :
Cx33013的博客
04-21 1万+
org.apache.ibatis.exceptions.PersistenceException: ### Error updating database. Cause: java.lang.IllegalStateException: Type handler was null on parameter mapping for property '__frch_user_0.uClass'. It was either not specified and/or could not be found ..
could not be found for the javaType (java.util.List) : jdbcType (null) combination.
浩浩的博客
08-16 3196
字段类型和操作jdbc类型不一致
mybatis报错could not be found for the javaType
06-02 1万+
一、报错栈： Cause: java.lang.IllegalStateException: Type handler was null on parameter mapping for property '__frch_recordId_0'. It was either not specified and/or could not be found for the javaType (com.xxx.RelUser) : jdbcType (null) combination. at org.myba
Mybatis自定义SQL更新JSON字段抛错
02-23 1223
Cause: java.lang.IllegalStateException: Type handler was null on parameter mapping for property ‘carouselPic’. It was either not specified and/or could not be found for the javaType ([Ljava.lang.Strin...
oss上传：One or more of the specified parts could not be found or the specified entity tag might not ha
飞哥专栏
07-03 2874
使用OSS Browser浏览器上传文件，提示： One or more of the specified parts could not be found or the specified entity tag might not have matched the part's entity tag 通过调试浏览器调试提示 <?xml version="1.0" encoding="UTF-8"?> <Error> <Code>InvalidPart&lt
SpringBoot报错 ：‘url‘ attribute is not specified and no embedded datasource could be configured.
feizhu_的博客
07-24 3945
很明显，这就是我们的工程没有配置好数据源，起初我也是这样想的。然后我打开了度娘，输入了自己的错误！很好，有很多解决方法，但是事不如人愿，我试了所有方法，还是报错！3、最终结果是我的这个依赖没有加版本，因为这是用idea自动生成的springboot工程，这个依赖也是他自动导入的，所以当时也没有注意看！2、然后网上说可能是我的yml或者properties文件没有配置，但是我确确实实是写了的……(前面两种是大部分情况下可以解决的，如果尝试了网上的方法没有解决的可以直接跳至第3步)首先来看看我的报错信息。...
完美解决failed to configure a datasource: ‘url‘ attribute is not specified and no em
热门推荐
计算机毕业论文源码，学生个人网页制作html源码。贴近用户做网络推广和互联网优化。
08-27 28万+
​导致failed to configure a datasource: 'url' attribute is not specified and no em， 原因：项目新搭建的时候，引入了mybatis等框架，但是没有在yml等配置文件中配置链接，所以导致报错。 解决：1.删掉mybatis等框架的引用，2.配置数据库再链接。 如果是spring项目中把shop-web模块中的application.yml文件改成application.properties； 对不同模块中的配置文件，以appli​
Type handler was null on parameter mapping for property ‘createTime‘. It was either not specified an
weixin_44908762的博客
03-10 3247
Type handler was null on parameter mapping for property ‘createTime’. It was either not specified and/or could not be found for the javaType (lombok.Data) : jdbcType (null) combination. 原因是：在创建实体类的时候吧date类型写成data导致类型不匹配 Type handler was null on parameter m
mybatis 引用对象属性映射错误 or could not be found for the javaType (xxx.model) : jdbcType (null) combination.
三生万物
08-13 2万+
宽为限　紧用功　工夫到　滞塞通 mybatis 引用对象属性映射错误 or could not be found for the javaType (xxx) : jdbcType (null) combination.
Type handler was null on parameter mapping for property 'products'. It was either not specified and/
那些年的代码
04-09 1万+
问题总结：数据库用的是postgresql，orm用的是mybatis, mybatis在处理映射的时候，当出现灭有匹配的类型，而你也没有指定其“jdbcType = OTHER”时，会出现 标题的错误 修改前 修改后： ...
could not be found for the javaType (com.alibaba.fastjson.JSONObject) : jdbcType (null) combination
qq_43881656的博客
09-15 3579
但是在使用mybatis对这种类型的字段进行接取的时候，会发现jdbcYype中并没有JSON属性，之前在网上搜索了很多方法，但大多都有重复或方法不可行，这里记录一下实现的具体过程。这个错误说jdbcType没有进行指明，需要指明jdbcType。但是在上面我们明明对data的类型进行了设置。在xml中加入handler的相关配置，进行实现，这里放入一个我自己使用的Handler以供大家参考。通过这样的设置，我们就可以在代码中使用mybatis对数据库中的JSON字段进行操作。
使用mybatisplus时 Cause: java.lang.IllegalStateException: Type handler was null on parameter mapping
m0_58462450的博客
04-29 1686
而Map集合是插入不到数据库当中的，即使它为空并且数据库字段当中也没有，依然会报错，解决办法要么是写一个TypeHandle对它进行全局转换（没必要，毕竟不存入到数据库），要么加一个注解（可以解决）开发背景：原生框架为mybatis+springcloud，自主升级为mybatisplus后调用save方法时出现问题。实体类继承了BaseEntity 在BaseEntity当中有params字段。
java.io.FileNotFoundException: Could not open ServletContext resource [/WEB-INF/action-servlet.xml]
Democreen
03-31 8154
<br />严重: action: null<br />org.springframework.beans.factory.BeanDefinitionStoreException: IOException parsing XML document from ServletContext resource [/WEB-INF/action-servlet.xml]; nested exception is java.io.FileNotFoundException: Could not open Servl
mybatis-plus存储数据类型不匹配问题解决
成の博客
04-14 3799
最近同事使用mybatis-plus处理blob类型数据保存进mysql数据库时报错了，提示如下： java.lang.IllegalStateException: Type handler was null on parameter mapping for property 'embedding'. It was either not specified and/or could not be found for the javaType (java.sql.Blob) : jdbcType (nul
Type handler was null on parameter mapping for property 'carousel'. It was either not specified and/or could not be found for the javaType (java.util.List) : jdbcType (null) combination.
06-03
这个错误提示是在进行 MyBatis 参数映射时出现的。它表明了在进行参数映射时，处理程序（Type handler）为空，可能是因为没有正确指定或找到指定的处理程序。 在 MyBatis 中，参数映射是将 Java 对象转换为 JDBC 参数的过程。在这个过程中，MyBatis 会根据参数的类型和属性信息，自动选择合适的处理程序来完成类型转换。如果找不到对应的处理程序，就会出现这个错误提示。 针对这个问题，你可以检查以下几个方面： 1. 确认参数类型和属性信息是否正确，包括Java对象类型、属性名称和数据类型等。 2. 确认是否在 MyBatis 配置文件中正确配置了处理程序（Type handler），并且处理程序能够处理指定的 Java 类型和 JDBC 类型。 3. 检查是否在 SQL 语句中正确引用了参数，并且参数与 Java 对象属性名称一致。 希望这些提示能帮到你解决问题。
评论 2
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值