org.hibernate.MappingException: No Dialect mapping for JDBC type: -1

Myth丶恋晨 2022-06-18 05:08 85阅读 0赞

错误代码

rg.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.getHibernateTypeName(Dialect.java:393)  
at org.hibernate.loader.custom.CustomLoader$Metadata.getHibernateType(CustomLoader.java:582)  
at org.hibernate.loader.custom.CustomLoader$ScalarResultColumnProcessor.performDiscovery(CustomLoader.java:508)  
at org.hibernate.loader.custom.CustomLoader.autoDiscoverTypes(CustomLoader.java:524)  
at org.hibernate.loader.Loader.getResultSet(Loader.java:1821)  
at org.hibernate.loader.Loader.doQuery(Loader.java:697)  
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:259)  
at org.hibernate.loader.Loader.doList(Loader.java:2232)  
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2129)  
at org.hibernate.loader.Loader.list(Loader.java:2124)  
at org.hibernate.loader.custom.CustomLoader.list(CustomLoader.java:312)  
at org.hibernate.impl.SessionImpl.listCustomQuery(SessionImpl.java:1723)  
at org.hibernate.impl.AbstractSessionImpl.list(AbstractSessionImpl.java:165)  
at org.hibernate.impl.SQLQueryImpl.list(SQLQueryImpl.java:175)  
at nstr.assess.util.HibernateUtil.findAllBySQL(HibernateUtil.java:251)  
at nstr.assess.util.HibernateUtil$$FastClassBySpringCGLIB$$b446ce07.invoke(<generated>)  
at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204)  
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:700)  
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)  
at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:155)  
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)  
at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:633)  
at nstr.assess.util.HibernateUtil$$EnhancerBySpringCGLIB$$6a8a715f.findAllBySQL(<generated>)  
at nstr.assess.dao.impl.AdminDao.getAllDevice(AdminDao.java:91)  
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)  
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)  
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)  
at java.lang.reflect.Method.invoke(Method.java:601)  
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)  
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)  
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)  
at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:155)  
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)  
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)  
at sun.proxy.$Proxy34.getAllDevice(Unknown Source)  
at nstr.assess.service.impl.AdminService.getAllDevice(AdminService.java:178)  
at nstr.assess.control.AdminController.adminTaskAssignment(AdminController.java:255)  
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)  
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)  
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)  
at java.lang.reflect.Method.invoke(Method.java:601)  
at org.springframework.web.method.support.InvocableHandlerMethod.invoke(InvocableHandlerMethod.java:215)  
at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:132)  
at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:104)  
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandleMethod(RequestMappingHandlerAdapter.java:745)  
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:685)  
at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:80)  
at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:919)  
at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:851)  
at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:953)  
at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:844)  
at javax.servlet.http.HttpServlet.service(HttpServlet.java:624)  
at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:829)  
at javax.servlet.http.HttpServlet.service(HttpServlet.java:731)  
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)  
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)  
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)  
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)  
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)  
at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88)  
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:106)  
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)  
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)  
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220)  
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)  
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:505)  
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:170)  
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)  
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:956)  
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)  
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:423)  
at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1079)  
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:625)  
at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:318)  
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)  
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)  
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)  
at java.lang.Thread.run(Thread.java:722)

查询原因是：hibernate中对于[数据库][Link 1]的Text数据类型不支持。数据库表中有text类型的字段，而Hibernate在native查询中没有注册这个字段，因此发生这个错误。

解决办法：最简单的是用hql文，不用sql。但有时候又不得不用sql语句，可以将text类型改为varchar类型；或者用CONVERT函数，将text转成varchar。个错误。

解决方法2：写一个类、修改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>