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

最新推荐文章于 2019-03-19 09:56:48 发布
最新推荐文章于 2019-03-19 09:56:48 发布
阅读量1.8k 收藏
点赞数
分类专栏： java oracle
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/spencer_tseng/article/details/80392676
版权
java 同时被 2 个专栏收录
392 篇文章 1 订阅
订阅专栏
oracle
59 篇文章 0 订阅
订阅专栏 


2018-05-21 15:12:26,000 INFO [org.springframework.flex.servlet.MessageBrokerHandlerAdapter] - Channel endpoint my-amf received request.
2018-05-21 15:12:26,062 INFO [org.springframework.flex.servlet.MessageBrokerHandlerAdapter] - Channel endpoint my-amf received request.
Hibernate: 
    SELECT
        COUNT(a.id) 
    FROM
        Bus_Asset a 
    LEFT JOIN
        Bsc_AssetType b 
            ON a.typeid = b.id 
    LEFT JOIN
        Bsc_Organ c 
            ON a.organid = c.id 
    LEFT JOIN
        Acc_User d 
            ON a.whsemgrid = d.id 
    LEFT JOIN
        Bsc_WareHouse e 
            ON a.whseid = e.id 
    LEFT JOIN
        Bsc_ChngMthd f 
            ON a.chngmthdid = f.id 
    LEFT JOIN
        (
            SELECT
                h.chngmthdid,
                i.assetid,
                j.name 
            FROM
                Bus_AssetReduce h 
            LEFT JOIN
                Bus_AssetReduceItem i 
                    ON h.id = i.fthrId 
            LEFT JOIN
                Bsc_ChngMthd j 
                    ON h.chngmthdid = j.id
            ) x 
                ON a.id = x.assetid 
        LEFT JOIN
            Bsc_Status k 
                ON a.statusid = k.id 
        WHERE
            1 = 1 
            AND a.state = ? 
Hibernate: 
    SELECT
        top 30 a.id AS ID,
        b.name AS TYPENAME,
        a.code AS CODE,
        a.name AS ASSETNAME,
        a.spenmdl AS SPENMDL,
        a.msrunit AS MSRUNIT,
        a.cnt AS CNT,
        a.amt AS AMT,
        a.XACTDT AS XACTDT,
        a.deadln AS DEADLN,
        c.name AS ORGNAME,
        d.name AS MGRNAME,
        e.name AS WHNAME,
        a.memo AS MEMO 
    FROM
        Bus_Asset a 
    LEFT JOIN
        Bsc_AssetType b 
            ON a.typeid = b.id 
    LEFT JOIN
        Bsc_Organ c 
            ON a.organid = c.id 
    LEFT JOIN
        Acc_User d 
            ON a.whsemgrid = d.id 
    LEFT JOIN
        Bsc_WareHouse e 
            ON a.whseid = e.id 
    LEFT JOIN
        Bsc_ChngMthd f 
            ON a.chngmthdid = f.id 
    LEFT JOIN
        (
            SELECT
                h.chngmthdid,
                i.assetid,
                j.name 
            FROM
                Bus_AssetReduce h 
            LEFT JOIN
                Bus_AssetReduceItem i 
                    ON h.id = i.fthrId 
            LEFT JOIN
                Bsc_ChngMthd j 
                    ON h.chngmthdid = j.id
            ) x 
                ON a.id = x.assetid 
        LEFT JOIN
            Bsc_Status k 
                ON a.statusid = k.id 
        WHERE
            1 = 1 
            AND a.state = ?  
        ORDER BY
            a.typeid,
            a.code
2018-05-21 15:12:28,656 ERROR [ce.pub.exception.FlexExceptionTranslator] - org.hibernate.MappingException: No Dialect mapping for JDBC type: -9
org.hibernate.MappingException: No Dialect mapping for JDBC type: -9
	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 ce.assets.report.AstInfoDAO.load(AstInfoDAO.java:68)
	at ce.assets.report.AstInfoRpt.doLoad(AstInfoRpt.java:39)
	at ce.assets.report.AstInfoRpt$$FastClassByCGLIB$$b008b101.invoke(<generated>)
	at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:149)
	at org.springframework.aop.framework.Cglib2AopProxy$CglibMethodInvocation.invokeJoinpoint(Cglib2AopProxy.java:692)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
	at org.springframework.aop.framework.adapter.MethodBeforeAdviceInterceptor.invoke(MethodBeforeAdviceInterceptor.java:50)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
	at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:108)
	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.Cglib2AopProxy$DynamicAdvisedInterceptor.intercept(Cglib2AopProxy.java:625)
	at ce.assets.report.AstInfoRpt$$EnhancerByCGLIB$$dc7437a8.doLoad(<generated>)
	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 flex.messaging.services.remoting.adapters.JavaAdapter.invoke(JavaAdapter.java:421)
	at flex.messaging.services.RemotingService.serviceMessage(RemotingService.java:183)
	at flex.messaging.MessageBroker.routeMessageToService(MessageBroker.java:1503)
	at flex.messaging.endpoints.AbstractEndpoint.serviceMessage(AbstractEndpoint.java:884)
	at flex.messaging.endpoints.AbstractEndpoint$$FastClassByCGLIB$$1a3ef066.invoke(<generated>)
	at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:149)
	at org.springframework.aop.framework.Cglib2AopProxy$CglibMethodInvocation.invokeJoinpoint(Cglib2AopProxy.java:692)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
	at org.springframework.flex.core.MessageInterceptionAdvice.invoke(MessageInterceptionAdvice.java:66)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
	at org.springframework.aop.framework.adapter.ThrowsAdviceInterceptor.invoke(ThrowsAdviceInterceptor.java:124)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
	at org.springframework.aop.framework.Cglib2AopProxy$FixedChainStaticTargetInterceptor.intercept(Cglib2AopProxy.java:576)
	at flex.messaging.endpoints.AMFEndpoint$$EnhancerByCGLIB$$9238b4b4.serviceMessage(<generated>)
	at flex.messaging.endpoints.amf.MessageBrokerFilter.invoke(MessageBrokerFilter.java:121)
	at flex.messaging.endpoints.amf.LegacyFilter.invoke(LegacyFilter.java:158)
	at flex.messaging.endpoints.amf.SessionFilter.invoke(SessionFilter.java:44)
	at flex.messaging.endpoints.amf.BatchProcessFilter.invoke(BatchProcessFilter.java:67)
	at flex.messaging.endpoints.amf.SerializationFilter.invoke(SerializationFilter.java:146)
	at flex.messaging.endpoints.BaseHTTPEndpoint.service(BaseHTTPEndpoint.java:278)
	at flex.messaging.endpoints.AMFEndpoint$$EnhancerByCGLIB$$9238b4b4.service(<generated>)
	at org.springframework.flex.servlet.MessageBrokerHandlerAdapter.handle(MessageBrokerHandlerAdapter.java:101)
	at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:771)
	at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:716)
	at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:647)
	at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:563)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:643)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:723)
	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.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:103)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
	at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:861)
	at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:620)
	at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
	at java.lang.Thread.run(Thread.java:662)




============================================================================

本文MS SERVER 2000数据库，由于之前MS SERVER 2008数据库，导致驱动程序JAR版本不对造成的。

同理ORACLE也是~ ~ ~ 

今天弄固定资产系统的时候发现。。。。。太久没弄了。。。

============================================================================

1：准确使用hibernate对应的数据库方言


2：准确使用数据库驱动程序



spencer_tseng
关注
专栏目录
jpa org.hibernate.MappingException: No Dialect mapping for JDBC type: -9
海淀吴彦祖的博客
03-10 529
我们项目用的是Oracle数据库，这个错误是一类的，还包含jpa org.hibernate.MappingException: No Dialect mapping for JDBC type:2 还有jpa org.hibernate.MappingException: No Dialect mapping for JDBC type:12等等。 导致这个问题的原因是jpa和数据库字段映射...
SSH：nested exception is org.hibernate.MappingException:No Dialect mapping for JDBC type: -1（个人日常记录）
多放孜然多放辣的博客
03-16 687
在工作中遇到的BUG，记录一下天天写BUG的我不BB直接上代码！ 不BB直接上代码！ 首先介绍一下之前的配置 这是我之前的数据库表，请注意并没有主键！但是我后来又插入了一个字段ID也并没有设置它的主键！ hbm.xml插入设置id之后的配置实体类配置文件 我没有设置主键，只是写了一个id! 运行出来就会报一个No Dialect mapping for JDBC type: -1的bug显示我...
1.org.hibernate.MappingException: No Dialect mapping for JDBC type: -9
weixin_34413065的博客
09-28 506
  org.hibernate.MappingException: No Dialect mapping for JDBC type: -9 原因：Hibernate框架的方言（Dialect ）没有数据库中数据类型nvarchar的映射，只有varchar类型的映射。所以在启动时出现此异常。 解决方法： 方法一： 将数据库字段的nvarchar类型改为varchar类型。 方...
org.hibernate.MappingException: No Dialect mapping for JDBC type: -9(-*)
solinyi的博客
06-17 657
SqlServer 异常类型： public final static int BIT   = -7; public final static int TINYINT  = -6; public final static int SMALLINT =   5; public final static int INTEGER  =  4; public final static int
org.hibernate.MappingException: No Dialect mapping for JDBC type: -1 解决方法
ITzhanghao的博客
07-28 8137
错误代码： [c-sharp] view plaincopy org.hibernate.MappingException: No Dialect mapping for JDBC type: -1      at org.hibernate.dialect.TypeNames.get(TypeNames.java:79)      at org.hibernate.dia
SQLite+Hibernate No Dialect mapping for JDBC type: 0
xiangliling的专栏
10-22 2844
前几天做一个小系统，数据库选了SQLite，从网上下载了一个SQLite与Hibernate整合的方言类配进系统import java.sql.Types;import org.hibernate.Hibernate;import org.hibernate.dialect.Dialect;import org.hibernate.dialect.function.SQLFunctionTempl
No Dialect mapping for JDBC type 错误分析
yang254143的专栏
10-08 966
出现这个问题可能的原因： 1、数据库字段类型和JAVA类型不匹配。 2、Hibernate中错误地配置了数据库方言。 原因1解决方法： 查看java.sql.Types找到对应的类型。 1 ARRAY 2003 2 BIGINT -5 3 BINARY -2 4 BIT -7 5 BLOB 2004 6
No Dialect mapping for JDBC type: -9
weixin_34392906的博客
10-27 111
由于项目中使用的是hibernate 4.35版本和sqlserver 2008数据库。所以，自定义方言时，需要和老版本做区别： public class MySQLServerDialect extends SQLServerDialect { public MySQLServerDialect() { super(); registerHibernateT...
Activiti 5.0版本出现 org.hibernate.MappingException: No Dialect mapping for JDBC type: -9错误。
Arog的博客
03-19 176
需求： 需要查询 我的已办。 想法： 可能是映射出错，可以使用以下措施。（本人使用的这个措施） 解决： 将sql语句select XXX，修改为 select to_char(cast(xxx as nvarchar2(100))) from act_xx表,其中xxx是act_xx表中的字段，act_xx表字段加下划线别忘记了。 例子： 错误的语句： select * from act_h...
org.hibernate.MappingException: No Dialect mapping for JDBC type: -1
u012339998的专栏
01-10 301
org.hibernate.MappingException: No Dialect mapping for JDBC type: -1 Hibernate配置映射映射错误消息： 19:00:50,252 WARN Oracle9Dialect:60 - The Oracle9Dialect dialect has been deprecated;...
was异常：org.hibernate.MappingException: No Dialect mapping for JDBC type: -9
coolchaobing的博客
11-11 1000
在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: -9解决
qi923701的博客
08-21 3712
出现环境：sqlserver数据库需要存储 䶮 这个字，发现存进去之后就变成？号如图 需要将字段改为utf8编码，sqlserver中varchar存储汉字可能会出现乱码，所以将字段改为nvarchar，然后显示正常，如图 但是当项目中用jpa进行查询时出现 org.hibernate.MappingException: No Dialect mapping for JDBC typ...
org.hibernate.MappingException: No Dialect mapping for JDBC type: -4
itmyhome的专栏
06-11 4102
Stacktraces org.hibernate.MappingException: No Dialect mapping for JDBC type: -4 org.hibernate.dialect.TypeNames.get(TypeNames.java:56) org.hibernate.dialect.TypeNames.get(TypeNames.java:81)
org.hibernate.MappingException: No Dialect mapping for JDBC type: -9【问题发现与解决】
DUANyaxin的博客
08-12 3647
一、发现问题： 在我的项目中，运用SpringMVC框架。因为直接查询视图，数据较多，响应时间很慢。于是，运用左连接查询数据库取需要的字段属性，存到一个实体类中。 于是用Hibernate的Query query = session.createSQLQuery(sql);来查询数据库，并存放到List中List list = query.list();具体实现如下： String sql
org.hibernate.MappingException: Unknown entity
最新发布
06-10
这个异常通常出现在使用 Hibernate 进行数据库操作时，原因是 Hibernate 找不到相应的实体类。 解决方法是在 hibernate.cfg.xml 文件中添加对应的实体类的映射关系，或者在实体类上添加 @Entity 注解来告诉 Hibernate 这是一个实体类。另外，也需要检查实体类的包路径是否正确。
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值