Caused by: org.hibernate.MappingException: No Dialect mapping for JDBC type: -4

最新推荐文章于 2021-08-09 10:46:26 发布
最新推荐文章于 2021-08-09 10:46:26 发布
阅读量3.3k 收藏
点赞数
CC 4.0 BY-SA版权
分类专栏： Mysql hibernate xml配置 Tomcat报错 文章标签： jdbc exception hibernate mysql
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.youkuaiyun.com/Java_Mr_Zheng/article/details/49423341
本文探讨了在使用Hibernate时遇到的MappingException异常，特别是针对JDBC类型为-4的情况，并提供了两种解决方案：一种是通过在SQL查询中使用CONVERT或CAST函数将text类型转换为varchar；另一种是通过自定义Dialect类来注册text类型。同时，介绍了如何在实际场景中应用这些方法，以避免在执行SQL查询时遇到此类异常。

摘要生成于 C知道 ，由 DeepSeek-R1 满血版支持， 前往体验 >

错误代码：

org.springframework.orm.hibernate3.HibernateSystemException: No Dialect mapping for JDBC type: -4; nested exception is org.hibernate.MappingException: No Dialect mapping for JDBC type: -4
    at org.springframework.orm.hibernate3.SessionFactoryUtils.convertHibernateAccessException(SessionFactoryUtils.java:659)
    at org.springframework.orm.hibernate3.HibernateAccessor.convertHibernateAccessException(HibernateAccessor.java:412)
    at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:377)
    at org.springframework.orm.hibernate3.HibernateTemplate.executeFind(HibernateTemplate.java:342)
    at com.hrrm.xglm.third.basic.dao.impl.GenericDaoImpl.findBySqlNoT(GenericDaoImpl.java:541)
    at com.hrrm.xglm.third.card.dao.impl.Hibernate3PageSupportDaoImpl.findBySqlNoT(Hibernate3PageSupportDaoImpl.java:90)
    at com.hrrm.gaa.task.dao.impl.TaskDaoImpl.getGuaranteeTime(TaskDaoImpl.java:518)
    at com.hrrm.gaa.task.service.impl.TaskServiceImpl.getGuaranteeTime(TaskServiceImpl.java:1626)
    at sun.reflect.GeneratedMethodAccessor156.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    at java.lang.reflect.Method.invoke(Method.java:597)
    at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:309)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
    at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:107)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
    at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:89)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
    at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
    at $Proxy44.getGuaranteeTime(Unknown Source)
    at com.hrrm.gaa.info.action.TaskAction.getGuaranteeTime(TaskAction.java:1596)
    at sun.reflect.GeneratedMethodAccessor155.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    at java.lang.reflect.Method.invoke(Method.java:597)
    at ognl.OgnlRuntime.invokeMethod(OgnlRuntime.java:851)
    at ognl.OgnlRuntime.callAppropriateMethod(OgnlRuntime.java:1253)
    at ognl.ObjectMethodAccessor.callMethod(ObjectMethodAccessor.java:68)
    at com.opensymphony.xwork2.ognl.accessor.XWorkMethodAccessor.callMethodWithDebugInfo(XWorkMethodAccessor.java:106)
    at com.opensymphony.xwork2.ognl.accessor.XWorkMethodAccessor.callMethod(XWorkMethodAccessor.java:90)
    at ognl.OgnlRuntime.callMethod(OgnlRuntime.java:1329)
    at ognl.OgnlRuntime.callMethod(OgnlRuntime.java:1305)
    at com.opensymphony.xwork2.ognl.accessor.CompoundRootAccessor.callMethod(CompoundRootAccessor.java:197)
    at ognl.OgnlRuntime.callMethod(OgnlRuntime.java:1329)
    at ognl.ASTMethod.getValueBody(ASTMethod.java:90)
    at ognl.SimpleNode.evaluateGetValueBody(SimpleNode.java:212)
    at ognl.SimpleNode.getValue(SimpleNode.java:258)
    at ognl.Ognl.getValue(Ognl.java:494)
    at ognl.Ognl.getValue(Ognl.java:458)
    at com.opensymphony.xwork2.ognl.OgnlUtil.getValue(OgnlUtil.java:196)
    at com.opensymphony.xwork2.ognl.OgnlValueStack.findValue(OgnlValueStack.java:229)
    at org.apache.struts2.components.Component.findValue(Component.java:248)
    at org.apache.struts2.components.Set.end(Set.java:101)
    at org.apache.struts2.views.jsp.ComponentTagSupport.doEndTag(ComponentTagSupport.java:42)
    at org.apache.jsp.task.taskList_jsp._jspx_meth_s_005fset_005f0(taskList_jsp.java:705)
    at org.apache.jsp.task.taskList_jsp._jspx_meth_s_005fiterator_005f1(taskList_jsp.java:567)
    at org.apache.jsp.task.taskList_jsp._jspService(taskList_jsp.java:220)
    at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
    at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:377)
    at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313)
    at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:646)
    at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:436)
    at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:374)
    at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:302)
    at org.apache.struts2.dispatcher.ServletDispatcherResult.doExecute(ServletDispatcherResult.java:154)
    at org.apache.struts2.dispatcher.StrutsResultSupport.execute(StrutsResultSupport.java:186)
    at com.opensymphony.xwork2.DefaultActionInvocation.executeResult(DefaultActionInvocation.java:361)
    at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:265)
    at org.apache.struts2.interceptor.TokenInterceptor.handleValidToken(TokenInterceptor.java:178)
    at org.apache.struts2.interceptor.TokenInterceptor.doIntercept(TokenInterceptor.java:144)
    at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:87)
    at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:236)
    at com.hrrm.xglm.PageSupportInterceptor.intercept(PageSupportInterceptor.java:44)
    at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:236)
    at com.opensymphony.xwork2.interceptor.DefaultWorkflowInterceptor.doIntercept(DefaultWorkflowInterceptor.java:163)
    at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:87)
    at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:236)
    at com.opensymphony.xwork2.validator.ValidationInterceptor.doIntercept(ValidationInterceptor.java:249)
    at org.apache.struts2.interceptor.validation.AnnotationValidationInterceptor.doIntercept(AnnotationValidationInterceptor.java:68)
    at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:87)
    at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:236)
    at com.opensymphony.xwork2.interceptor.ConversionErrorInterceptor.intercept(ConversionErrorInterceptor.java:122)
    at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:236)
    at com.opensymphony.xwork2.interceptor.ParametersInterceptor.doIntercept(ParametersInterceptor.java:195)
    at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:87)
    at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:236)
    at com.opensymphony.xwork2.interceptor.ParametersInterceptor.doIntercept(ParametersInterceptor.java:195)
    at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:87)
    at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:236)
    at com.opensymphony.xwork2.interceptor.StaticParametersInterceptor.intercept(StaticParametersInterceptor.java:148)
    at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:236)
    at org.apache.struts2.interceptor.CheckboxInterceptor.intercept(CheckboxInterceptor.java:93)
    at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:236)
    at org.apache.struts2.interceptor.FileUploadInterceptor.intercept(FileUploadInterceptor.java:235)
    at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:236)
    at com.opensymphony.xwork2.interceptor.ModelDrivenInterceptor.intercept(ModelDrivenInterceptor.java:89)
    at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:236)
    at com.opensymphony.xwork2.interceptor.ScopedModelDrivenInterceptor.intercept(ScopedModelDrivenInterceptor.java:128)
    at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:236)
    at org.apache.struts2.interceptor.ProfilingActivationInterceptor.intercept(ProfilingActivationInterceptor.java:104)
    at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:236)
    at org.apache.struts2.interceptor.debugging.DebuggingInterceptor.intercept(DebuggingInterceptor.java:267)
    at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:236)
    at com.opensymphony.xwork2.interceptor.ChainingInterceptor.intercept(ChainingInterceptor.java:126)
    at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:236)
    at com.opensymphony.xwork2.interceptor.PrepareInterceptor.doIntercept(PrepareInterceptor.java:138)
    at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:87)
    at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:236)
    at com.opensymphony.xwork2.interceptor.I18nInterceptor.intercept(I18nInterceptor.java:148)
    at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:236)
    at org.apache.struts2.interceptor.ServletConfigInterceptor.intercept(ServletConfigInterceptor.java:164)
    at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:236)
    at com.opensymphony.xwork2.interceptor.AliasInterceptor.intercept(AliasInterceptor.java:128)
    at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:236)
    at com.opensymphony.xwork2.interceptor.ExceptionMappingInterceptor.intercept(ExceptionMappingInterceptor.java:176)
    at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:236)
    at com.hrrm.xglm.LoginInterceptor.intercept(LoginInterceptor.java:28)
    at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:236)
    at org.apache.struts2.impl.StrutsActionProxy.execute(StrutsActionProxy.java:52)
    at org.apache.struts2.dispatcher.Dispatcher.serviceAction(Dispatcher.java:468)
    at org.apache.struts2.dispatcher.ng.ExecuteOperations.executeAction(ExecuteOperations.java:77)
    at org.apache.struts2.dispatcher.ng.filter.StrutsPrepareAndExecuteFilter.doFilter(StrutsPrepareAndExecuteFilter.java:76)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    at com.xglm.common.util.CharacterEncodingFilter.doFilter(CharacterEncodingFilter.java:34)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
    at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
    at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
    at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
    at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
    at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
    at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:852)
    at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
    at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
    at java.lang.Thread.run(Thread.java:619)
Caused by: org.hibernate.MappingException: No Dialect mapping for JDBC type: -4
    at org.hibernate.dialect.TypeNames.get(TypeNames.java:56)
    at org.hibernate.dialect.TypeNames.get(TypeNames.java:81)
    at org.hibernate.dialect.Dialect.getHibernateTypeName(Dialect.java:369)
    at org.hibernate.loader.custom.CustomLoader$Metadata.getHibernateType(CustomLoader.java:559)
    at org.hibernate.loader.custom.CustomLoader$ScalarResultColumnProcessor.performDiscovery(CustomLoader.java:485)
    at org.hibernate.loader.custom.CustomLoader.autoDiscoverTypes(CustomLoader.java:501)
    at org.hibernate.loader.Loader.getResultSet(Loader.java:1796)
    at org.hibernate.loader.Loader.doQuery(Loader.java:674)
    at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:236)
    at org.hibernate.loader.Loader.doList(Loader.java:2220)
    at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2104)
    at org.hibernate.loader.Loader.list(Loader.java:2099)
    at org.hibernate.loader.custom.CustomLoader.list(CustomLoader.java:289)
    at org.hibernate.impl.SessionImpl.listCustomQuery(SessionImpl.java:1695)
    at org.hibernate.impl.AbstractSessionImpl.list(AbstractSessionImpl.java:142)
    at org.hibernate.impl.SQLQueryImpl.list(SQLQueryImpl.java:152)
    at com.hrrm.xglm.third.basic.dao.impl.GenericDaoImpl$2.doInHibernate(GenericDaoImpl.java:612)
    at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:372)
    ... 128 more

单独取sql执行之后是这样：

执行之后变成了text类型

原因：
org.hibernate.MappingException: No Dialect mapping for JDBC type: -1异常是因为hibernate不支持数据库中的text类型，就是说hibernate没有注册该类型，而我们往往要用到这个类型

解决方法一：
从sql上面的函数下手：
用CONVERT函数，将text转成varchar
例如：CONVERT(varchar(100), isnull(bz, ”))
bz是text类型变量名，isnull函数判断下是否为空
或者
用CAST函数，将text转成varchar
例如：CAST(GROUP_CONCAT(a.flightExecuteTime) AS CHAR) AS flightExecuteTime

结果看图片：
用cast执行的结果

解决方法二：（网上找的，没尝试过）

    问题原因：数据库表中有text类型的字段，而Hibernate在native查询中没有注册这个字段，因此发生这个错误。   
    解决方法：写一个类、修改hibernate配置文件。 写一个Dialect的子类，这里我 extends MySQL5Dialect类：   
    package xxx.xxx;    //xxx.xxx自己根据情况来写 import java.sql.Types;   
    import org.hibernate.dialect.MySQL5Dialect;   
    public class DialectForInkfish extends MySQL5Dialect {   
        public DialectForInkfish() {   
            super();   
            registerHibernateType(Types.LONGVARCHAR, 65535, "text");   
        }   
    }   
    修改Hibernate配置文件hibernate.cfg.xml，把  
    <property name="dialect">org.hibernate.dialect.MySQL5Dialect</property>   
    修改为：  
    <property name="dialect">com.ibm.crl.inkfish.config.DialectForInkfish</property>
jpa org.hibernate.MappingException: No Dialect mapping for JDBC type: -9
海淀吴彦祖的博客
03-10 627
我们项目用的是Oracle数据库，这个错误是一类的，还包含jpa org.hibernate.MappingException: No Dialect mapping for JDBC type:2 还有jpa org.hibernate.MappingException: No Dialect mapping for JDBC type:12等等。 导致这个问题的原因是jpa和数据库字段映射...
Caused by: org.hibernate.MappingException: Repeated column in mapping for entity: cn.itcast.entity.C
qq_44837994的博客
02-18 805
1.异常描述 Caused by: org.hibernate.MappingException: Repeated column in mapping for entity: cn.itcast.entity.Customer column: custLevel (should be mapped with insert=“false” update=“false”) 2.实体类和映射文件的对...
org.hibernate.MappingException: No Dialect mapping for JDBC type: -1 搞定！
数据库天地
05-02 296
继承于MySQLDialect ，引入 registerHibernateType(Types.LONGVARCHAR, Hibernate.TEXT.getName()); import java.sql.Types;import org.hibernate.Hibernate;import org.hibernate.dialect.MySQLDialect;public class...
报错： org.hibernate.MappingException: No Dialect mapping for JDBC type: -16
m0_47397104的博客
07-02 921
报错说明：hibernate不能将这种数据类型映射到你的java类中 解决方案：自定义一个Hibernate Dialect，方言映射 type: -16 对应 Types.LONGNVARCHAR package com.v2.framework.dialect; import java.sql.Types; import org.hibernate.Hibernate; import org.hibernate.dialect.SQLServerDialect; /** * MSSQL数据库的Di
org.hibernate.MappingException: No Dialect mapping for JDBC type: -16
name_liv的专栏
05-01 4931
Java代码：   Java代码   public List getPlateNumberAndDate(){             return getHibernateTemplate().executeFind(new HibernateCallback(){                 public Object doInHibernate(Session se
hibernate:No Dialect mapping for JDBC type: -4
weixin_34240657的博客
03-22 300
2019独角兽企业重金招聘Python工程师标准>>> ...
Hibernate异常之Caused by: org.hibernate.MappingException: Repeated column in mapping for entity: cn...
静若清池，动如涟漪_
08-02 724
1、异常描述 Caused by: org.hibernate.MappingException: Repeated column in mapping for entity: cn.wang.entity.Student column: cid (should be mapped with insert="false" update="false") 备注： 此处hibe...
Caused by: org.hibernate.hql.internal.ast.QuerySyntaxException: Student is not mapped
游海东的技术专栏
02-23 1941
1、错误描述org.hibernate.hql.internal.ast.QuerySyntaxException: Student is not mapped [from Student ] at org.hibernate.hql.internal.ast.QuerySyntaxException.generateQueryException(QuerySyntaxException.jav
Caused by: java.lang.AbstractMethodError: org.hibernate.validator.internal.engine.ConfigurationImpl
游海东的技术专栏
07-19 5268
1、错误描述严重: StandardWrapper.Throwable org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'org.springframework.validation.beanvalidation.OptionalValidatorFactoryBean#0
was异常：org.hibernate.MappingException: No Dialect mapping for JDBC type: -9
coolchaobing的博客
11-11 1026
在websphere上访问项目直接报org.springframework.web.util.NestedServletException: Request processing failed; org.hibernate.MappingException: No Dialect mapping for JDBC type: -9
org.hibernate.MappingException: No Dialect mapping for JDBC type:
热门推荐
05-09 2万+
今天写原生态SQL调用Hibernate查询数据库报以下异常：
org.hibernate.MappingException: No Dialect mapping for JDBC type: -9
蛆蛆bug记录
08-09 552
报错：org.hibernate.MappingException: No Dialect mapping for JDBC type: -9 原因：Hibernate框架的方言（Dialect ）没有数据库中数据类型nvarchar的映射，只有varchar类型的映射。所以在启动时出现此异常。 解决： 创建自定义方言类 package com.mf.util; import org.hibernate.dialect.SQLServer2008Dialect; public class SqlSe
jpa查询blob数据抛出异常:No Dialect mapping for JDBC type -4
security08的专栏
06-26 3308
<br /> 用entityManager.createNativeQuery(sql).list()查询blob数据时，抛出了下面的异常：<br />Caused by: org.hibernate.MappingException: No Dialect mapping for JDBC type: -4<br />     at org.hibernate.dialect.TypeNames.get(TypeNames.java:56)<br />     at org.hibernate.dia
Hibernate blob No Dialect mapping for JDBC type: -4
lhi705的专栏
03-29 2602
严重: Servlet.service() for servlet action threw exception org.hibernate.MappingException: No Dialect mapping for JDBC type: -4  at org.hibernate.dialect.TypeNames.get(TypeNames.java:56) 是因为服务器端的数据类型
org.hibernate.MappingException: No Dialect mapping for JDBC type: -1 解决方法搜藏
上班搞IT，下班搞ITF。
09-08 1万+
<br />错误代码：<br />org.hibernate.MappingException: No Dialect mapping for JDBC type: -1 at org.hibernate.dialect.TypeNames.get(TypeNames.java:79) at org.hibernate.dialect.TypeNames.get(TypeNames.java:104) at org.hibernate.dialect.Dialect.getHibernateTy
org.hibernate.MappingException: No Dialect mapping for JDBC type: -9【问题发现与解决】
DUANyaxin的博客
08-12 3715
一、发现问题： 在我的项目中，运用SpringMVC框架。因为直接查询视图，数据较多，响应时间很慢。于是，运用左连接查询数据库取需要的字段属性，存到一个实体类中。 于是用Hibernate的Query query = session.createSQLQuery(sql);来查询数据库，并存放到List中List list = query.list();具体实现如下： String sql
Caused by: org.hibernate.PropertyNotFoundException:
最新发布
03-12
<think>嗯，用户遇到了Hibernate的PropertyNotFoundException异常，需要找出原因和解决方案。首先，我应该回忆一下Hibernate的相关知识。这个异常通常和属性映射有关，对吧？ 根据用户提供的引用，特别是引用3，问题可能出在POJO类中没有对应的get或set方法，或者属性名不匹配。比如，hbm文件中定义的属性在Java类中没有正确的方法，或者属性名有拼写错误。另外，可能还有映射文件中的属性名有空格，导致Hibernate无法找到对应的getter/setter方法。 接下来，我需要整理常见的原因。首先，属性名称不一致，比如hbm文件中的属性是userName，而Java类中使用的是username，大小写不一致。其次，getter/setter方法不符合规范，比如boolean类型的属性isActive，生成的getter应该是isActive()，而不是getIsActive()。然后，映射文件中的属性名可能有拼写错误或者多余的空格，例如" user"这样的空格会导致问题。还有，是否使用了Lombok的注解，但编译时没有生成方法，这也会导致Hibernate找不到方法。 解决方案方面，需要逐一检查这些可能性。首先核对hbm文件中的属性名和POJO类中的属性名是否完全一致，包括大小写。然后检查getter和setter方法是否符合命名规范，特别是布尔类型的属性。接着，检查映射文件是否有隐藏的空格或特殊字符，可能需要用文本编辑器查看。如果使用Lombok，确保IDE安装了插件，并在编译时生成了方法。最后，通过日志或调试确认Hibernate加载的类是否正确，排除类路径问题。 用户可能还想知道如何预防这类问题，比如代码规范、使用注解代替XML配置、自动化测试等。此外，可能相关的异常还有PropertyValueException，比如引用2中的情况，虽然原因不同，但也是映射配置的问题，可以一并提醒用户注意。 需要确保回答结构清晰，分点列出原因和解决方案，并引用提供的参考资料。同时，生成相关问题帮助用户深入理解其他可能的Hibernate异常。</think>### org.hibernate.PropertyNotFoundException异常原因及解决方案 #### 一、异常原因分析 1. **属性与POJO类方法不匹配** Hibernate映射文件（`.hbm.xml`）中定义的属性在Java实体类中缺少对应的`getter`或`setter`方法，例如映射文件中定义了`$userName$`属性，但实体类中只有`getUsername()`方法（大小写不匹配）[^3]。 2. **属性名称拼写错误或格式问题** - 映射文件中属性名称存在拼写错误（如`$userName$`写成`$usernam$`）。 - 属性名称包含隐藏空格或特殊字符（如`$ user$`），导致Hibernate无法识别[^3]。 3. **布尔类型属性命名不规范** 布尔类型字段的`getter`方法未遵循`isXxx()`格式。例如字段`$active$`的`getter`应为`isActive()`，而非`getActive()`。 4. **Lombok等工具未正确生成方法** 使用Lombok的`@Data`或`@Getter/@Setter`注解时，若IDE未正确编译或插件缺失，可能导致方法未生成。 --- #### 二、解决方案 1. **检查属性与方法命名一致性** - 核对映射文件中的属性名与实体类属性名**完全一致**（包括大小写）。 - 验证`getter/setter`方法命名是否符合规范，例如： ```java // 正确示例 private String userName; public String getUserName() { return userName; } public void setUserName(String userName) { this.userName = userName; } ``` 2. **排查映射文件格式问题** - 用文本编辑器打开`.hbm.xml`文件，检查属性定义是否有隐藏字符或空格： ```xml <!-- 错误示例 --> <property name=" user " column="user"/> <!-- 正确示例 --> <property name="user" column="user"/> ``` 3. **验证Lombok配置** - 确认IDE已安装Lombok插件（如IntelliJ需启用`Enable annotation processing`）。 - 执行`mvn clean compile`或`gradle build`确保代码生成生效。 4. **启用Hibernate日志定位问题** 在`log4j.properties`中增加以下配置，查看Hibernate加载实体类时的详细错误： ```properties log4j.logger.org.hibernate=DEBUG ``` --- #### 三、相关案例参考 - **引用案例1**：映射文件属性名与实体类方法不匹配导致异常。 - **引用案例2**：`not-null`约束与空值传递冲突引发的`PropertyValueException`（需检查级联操作和空值处理）[^2]。 ---
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值