`
swbssd
  • 浏览: 56000 次
  • 来自: ...
文章分类
社区版块
存档分类
最新评论

hibernate的一个BUG?~~~~~

阅读更多
我使用了
public Query createSQLQuery(String sql, Map params) {
Query query = session.createSQLQuery(sql);
setParam(query, params);
return query;
}
这个方法进行查询SQL,以前一直是没问题的.
在oracle数据库中,现在碰到一条sql如下:
select t355.W28ID_full as union_EnumID,
       t355.W28LF_full as mun_W28LF_full,
       t355.range_Row,
       t355.W28,
       t355.W28ID,
       t355.W28RG,
       t355.W28LF,
       t355.W28LV,
       t355.C6841,
       t355.C2515,
       t355.C2516,
       t355.C2517,
       t355.C2518,
       t355.C2519,
       t355.C2520,
       t355.C2521,
       t355.C2522,
       t355.C2523,
       t355.C2524,
       t355.C2525,
       t355.C2526,
       t355.C6539,
       t355.C6540,
       t355.C6839
  from (select t355_Enum.W28ID as W28ID_full,
               t355_Enum.W28LF as W28LF_full,
               9 as range_Row,
               t355_Enum.W28 as W28,
               t355_Enum.W28ID as W28ID,
               t355_Enum.W28RG as W28RG,
               t355_Enum.W28LF as W28LF,
               t355_Enum.W28LV as W28LV,
               '序号_1' as C6841,
               null as C2515,
               null as C2516,
               null as C2517,
               t354.C2518 as C2518,
               null as C2519,
               null as C2520,
               null as C2521,
               null as C2522,
               null as C2523,
               null as C2524,
               null as C2525,
               null as C2526,
               null as C6539,
               null as C6540,
               null as C6839
          from (select name      as W28,
                       ID        as W28ID,
                       nodeLevel as W28LV,
                       nodeLeft  as W28LF,
                       nodeRight as W28RG
                  from itrp_EnumDictItem
                 where dictionaryID = '297edff8357b46390135804cb394736d') t355_Enum
          left join (select sum(t354_son.C6675) as C2518,
                           t354_son.W28ID,
                           t354_son.W28RG,
                           t354_son.W28LF,
                           t354_son.W28LV,
                           t354_son.W28
                      from rpd_179s1 t354_son
                     where 1 = 1
                       and t354_son.W1ID =
                           '8a819dd43090ffd50130921bccba0a6e'
                       and t354_son.W2ID = 'treeRoot'
                       and t354_son.isAudit >= '0'
                       and t354_son.isValidVersion >= '1'
                     group by t354_son.W28ID,
                              t354_son.W28RG,
                              t354_son.W28LF,
                              t354_son.W28LV,
                              t354_son.W28) t354 on (t355_Enum.W28ID =
                                                    t354.W28ID)
         where 1 = 1
        union all
        select t354.W28ID as W28ID_full,
               t354.W28LF as W28LF_full,
               10 as range_Row,
               t354.W28 as W28,
               t354.W28ID as W28ID,
               t354.W28RG as W28RG,
               t354.W28LF as W28LF,
               t354.W28LV as W28LV,
               '序号_2' as C6841,
               '其中:重点项目小计' as C2515,
               null as C2516,
               null as C2517,
               sum(t354.C6675) as C2518,
               sum(t354.C6676) as C2519,
               null as C2520,
               null as C2521,
               sum(t354.C6679) as C2522,
               null as C2523,
               null as C2524,
               null as C2525,
               null as C2526,
               null as C6539,
               null as C6540,
               null as C6839
          from rpd_179s1 t354
         where 1 = 1
           and t354.W1ID = '8a819dd43090ffd50130921bccba0a6e'
           and t354.W2ID = 'treeRoot'
           and t354.isAudit >= '0'
           and t354.isValidVersion >= '1'
           and t354.C6835 = '是'
         group by t354.W28ID, t354.W28RG, t354.W28LF, t354.W28LV, t354.W28
        union all
        select t354.W28ID as W28ID_full,
               t354.W28LF as W28LF_full,
               11 as range_Row,
               t354.W28 as W28,
               t354.W28ID as W28ID,
               t354.W28RG as W28RG,
               t354.W28LF as W28LF,
               t354.W28LV as W28LV,
               '序号_3' as C6841,
               t354.C6672 as C2515,
               null as C2516,
               null as C2517,
               t354.C6675 as C2518,
               t354.C6676 as C2519,
               t354.C6677 as C2520,
               t354.C6678 as C2521,
               t354.C6679 as C2522,
               null as C2523,
               t354.C6676 as C2524,
               t354.C6682 as C2525,
               t354.C6683 as C2526,
               t354.C6738 as C6539,
               t354.C6739 as C6540,
               null as C6839
          from rpd_179s1 t354
         where 1 = 1
           and t354.W1ID = '8a819dd43090ffd50130921bccba0a6e'
           and t354.W2ID = 'treeRoot'
           and t354.isAudit >= '0'
           and t354.isValidVersion >= '1') t355
order by t355.W28LF_full asc, t355.range_Row

hiberate日志打印中这列是没有被截取的..
在oracle里面查询,执行的sql也是没有截取掉..但是通过hiberante返回的时候,结果查询出来,只出现'序'这一个字...
分享到:
评论

相关推荐

    Hibernate 3.2.4+ bug

    NULL 博文链接:https://imp9527.iteye.com/blog/438677

    hibernate的xml文件bug

    由jbosstools创建xmll文件出现bug

    Hibernate Synchronizer 插件重大缺陷改正

    Hibernate Synchronizer 插件重大缺陷改正

    hibernate连接池.doc

    一、Apche的DBCP在Hibernate2中受支持,但在Hibernate3中已经不再推荐使用,官方的解释是这个连接池存在缺陷。如果你因为某种原因需要在Hibernate3中使用DBCP,建议采用JNDI方式。 二、默认情况下(即没有配置连接...

    深入浅出Hibernate源码

    本下载包与书籍的实战篇紧密结合. 下载包中的程序是一个简明的示例论坛程序,按照循序渐进的原则,分为不同的步骤: 步骤1: ... * 修正了和webwork相关的一个中文bug v1.0 (2005.4.20) * 初始版本

    HIbernate免注解实现操作数据库 及Hibernate3连接SQL的BUG解决办法

    NULL 博文链接:https://toshibasony.iteye.com/blog/708026

    论坛系统 hibernate jsp hibernate 毕业论文项目

    论坛系统hibernate jsp hibernate 毕业论文项目

    hibernate连接池配置

    一、Apche的DBCP在Hibernate2中受支持,但在Hibernate3中已经不再推荐使用,官方的解释是这个连接池存在缺陷。如果你因为某种原因需要在Hibernate3中使用DBCP,建议采用JNDI方式。 二、默认情况下(即没有配置连接...

    Bug管理系统 struts2+sping2.5+hibernate3(2-2)

    本程序是作者学习struts spring hibernate构架后为了练习开发的一个小程序。开发此程序的目的是为了验证框架技术在项目中的应用。本程序尽量包含了开发当中遇到的一些问题及解决方案。同时欢迎广大网友到作者的群内...

    实现JSP+SERVLET+Hibernate基本分页

    1、可以取消hibernate.cfg.xml中<property name="hbm2ddl.auto">create注释创建表结构 2、可以通过src下的db.sql创建表 V2.0版本更新内容 1、添加struts2.1支持 2、修复没查到数据,组显示负数BUG V1.5版更新内容 1...

    Struts2+hibernate3

    Struts2+hibernate3+mysql+myseclipse 开发项目 常见bug

    hibernate 自连接 emp例子

    hibernate作为底层,通过关系配置,配置Oracle数据库中的EMP表,进行自连接。里面重要的是例子,经过测试的,无bug,放心调试。

    Spring3 MVC +HibernateJPA Eclipse Demo

    1、本示例只是借花献佛,其实网上SpringMVC+...7、附带的另一个附件关于JPQL的学习资料,本示例只提供了CURD四个方法,其他复杂的数据库查询实现需要好好学习JPQL.pdf上的资料 8、写了那么多,希望大家能给我一分

    jQuery改写上一个城市的三级联动(解决浏览器兼容bug)

    与上一个三级联动不同的是:上一个项目是使用dom技术编写的整个js代码,存在一定的不足与bug,即浏览器不兼容,只在火狐中有成效,IE、opera、google等都不能兼容。。。到底是哪个模块导致的不兼容,本人目前正在...

    深入浅出Hibernate

    * 增加了对投票的图形显示 * 修正了和webwork相关的一个中文bug <br/>v1.0 (2005.4.20) * 初始版本 <br/>请访问http://www.redsaga.com/hibernate_book.html,检查此下载包的更新。

    Hibernate的连接池和数据源配置

    一、Apche的DBCP在Hibernate2中受支持,但在Hibernate3中已经不再推荐使用,官方的解释是这个连接池存在缺陷。如果你因为某种原因需要在Hibernate3中使用DBCP,建议采用JNDI方式。 二、默认情况下(即没有配置连接池...

    Hibernate v3.2中文参考手册

    我们也提供一个JIRA问题追踪系统,来搜集bug报告和新功能请求。如果你对开发Hibernate有兴趣,请加入开发者的邮件列表。(Hibernate网站上的用户论坛有一个中文版面,JavaEye也有Hibernate中文版面,您可以在那里交流...

    Hibernate教程26_事务并发处理

    http://blog.csdn.net/e421083458/article/details/8794127 该源码为Hibernate教程配套源码

    Hibernate3.2官方中文参考手册

    我们也提供一个JIRA问题追踪系统,来搜集bug报告和新功能请求。如果你对开发Hibernate有兴趣,请加入开发者的邮件列表。(Hibernate网站上的用户论坛有一个中文版面,JavaEye也有Hibernate中文版面,您可以在那里交流...

    hibernate-2.1.8.part1.rar

    Bug Reports: Hibernate JIRA (preferred) hibernate-devel@lists.sourceforge.net Free Technical Support: http://forum.hibernate.org Commercial Support & Training: ...

Global site tag (gtag.js) - Google Analytics