hibernate 错误（转载）

最新推荐文章于 2024-09-14 07:00:00 发布

monmobear053

最新推荐文章于 2024-09-14 07:00:00 发布

阅读量330

点赞数

CC 4.0 BY-SA版权

本文链接：https://blog.youkuaiyun.com/monmobear053/article/details/26962055

本文详细记录了一次因MySQL VARCHAR类型长度设置不当导致Hibernate原生态SQL错误的问题，并提供了具体的解决办法。

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

hibernate 异常（转载）

mysql varchar长度过大引起hibernate原生态SQL 错误:No Dialect mapping for JDBC type: -1 错误的解决方法

2009年06月24日星期三下午 09:16

先把异常抛出来:

Hibernate: select sum(num) from ( select count(*) as num from cm_facility_wrong as fw left outer join cm_conf as cf on fw.faw_room_id=cf.conf_id left outer join cm_facility as f on fw.fa_id=f.fa_id where 1=1 and fw.faw_room_type=0 union all select count(*) as num from cm_facility_wrong as fw left outer join cm_classroom as cr on fw.faw_room_id=cr.cr_id left outer join cm_facility as f on fw.fa_id=f.fa_id where 1=1 and fw.faw_room_type=1 ) as t

Hibernate: select fw.faw_id,fw.faw_room_id,fw.faw_room_type, fw.fa_id,fw.faw_type,fw.,fw.faw_time,fw.faw_man, fw.faw_r_company,fw.faw_man,fw.faw_phone,fw.faw_r_time, fw.,fw.faw_state, cr.cr_name,f.fa_no,f.fa_name from cm_facility_wrong as fw left outer join cm_classroom as cr on fw.faw_room_id=cr.cr_id left outer join cm_facility as f on fw.fa_id=f.fa_id where 1=1 and fw.faw_room_type=1 limit ?
WARN - Unhandled Exception thrown: class org.hibernate.MappingException
2009-6-24 20:40:15 org.apache.catalina.core.StandardWrapperValve invoke
严重: Servlet.service() for servlet action threw exception

at org.hibernate.loader.custom.CustomLoader$Metadata.getHibernateType(CustomLoader.java:559)
at or…………………………………………………………………………

原文：http://www.verydemo.com/demo_c146_i11547.html