failed to lazily initialize a collection of role: no session or session was closed (Hibernate) 解决方法（延迟加载问题）

最新推荐文章于 2019-07-03 10:29:00 发布
最新推荐文章于 2019-07-03 10:29:00 发布
阅读量4.4k 收藏
点赞数
文章标签： session hibernate module url jsp 数据库
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/veverrr/article/details/6077343
版权

在学着编写OA 权限管理时，在jsp  页面中通过已取得的 父模块来获取该模块的所有子模块

 

 

JSP 代码片段：

 

     <c:forEach  items="${modules}" var="module">

 

   <c:forEach items="${module.children}" var="child">

 

 <td>    ${child.name }</td>

 

 

 

 

 

java 代码：

 

@OneToMany(mappedBy="parent")
    public Set<Module> getChildren() {
        return children;
    }

 

在这段代码中没有对延迟加载进行设置，在JSP页面显示时报了failed to lazily initialize a collection of role: no session or session was closed (Hibernate) 的错误。

 

 

通过BAIdu 一下，发现我犯了延迟hibernate 延迟加载方面的错误。

修改代码后

    @OneToMany(mappedBy="parent", fetch = FetchType.EAGER)
    public Set<Module> getChildren() {
        return children;
    }

 

Hibernate: select module0_.id as id3_, module0_.name as name3_, module0_.orderNum as orderNum3_, module0_.parentId as parentId3_, module0_.sn as sn3_, module0_.url as url3_ from Module module0_ where module0_.parentId is null limit ?
Hibernate: select children0_.parentId as parentId1_, children0_.id as id1_, children0_.id as id3_0_, children0_.name as name3_0_, children0_.orderNum as orderNum3_0_, children0_.parentId as parentId3_0_, children0_.sn as sn3_0_, children0_.url as url3_0_ from Module children0_ where children0_.parentId=?
Hibernate: select children0_.parentId as parentId1_, children0_.id as id1_, children0_.id as id3_0_, children0_.name as name3_0_, children0_.orderNum as orderNum3_0_, children0_.parentId as parentId3_0_, children0_.sn as sn3_0_, children0_.url as url3_0_ from Module children0_ where children0_.parentId=?
Hibernate: select children0_.parentId as parentId1_, children0_.id as id1_, children0_.id as id3_0_, children0_.name as name3_0_, children0_.orderNum as orderNum3_0_, children0_.parentId as parentId3_0_, children0_.sn as sn3_0_, children0_.url as url3_0_ from Module children0_ where children0_.parentId=?
Hibernate: select children0_.parentId as parentId1_, children0_.id as id1_, children0_.id as id3_0_, children0_.name as name3_0_, children0_.orderNum as orderNum3_0_, children0_.parentId as parentId3_0_, children0_.sn as sn3_0_, children0_.url as url3_0_ from Module children0_ where children0_.parentId=?
Hibernate: select children0_.parentId as parentId1_, children0_.id as id1_, children0_.id as id3_0_, children0_.name as name3_0_, children0_.orderNum as orderNum3_0_, children0_.parentId as parentId3_0_, children0_.sn as sn3_0_, children0_.url as url3_0_ from Module children0_ where children0_.parentId=?
Hibernate: select children0_.parentId as parentId1_, children0_.id as id1_, children0_.id as id3_0_, children0_.name as name3_0_, children0_.orderNum as orderNum3_0_, children0_.parentId as parentId3_0_, children0_.sn as sn3_0_, children0_.url as url3_0_ from Module children0_ where children0_.parentId=?
Hibernate: select children0_.parentId as parentId1_, children0_.id as id1_, children0_.id as id3_0_, children0_.name as name3_0_, children0_.orderNum as orderNum3_0_, children0_.parentId as parentId3_0_, children0_.sn as sn3_0_, children0_.url as url3_0_ from Module children0_ where children0_.parentId=?
Hibernate: select children0_.parentId as parentId1_, children0_.id as id1_, children0_.id as id3_0_, children0_.name as name3_0_, children0_.orderNum as orderNum3_0_, children0_.parentId as parentId3_0_, children0_.sn as sn3_0_, children0_.url as url3_0_ from Module children0_ where children0_.parentId=?
Hibernate: select children0_.parentId as parentId1_, children0_.id as id1_, children0_.id as id3_0_, children0_.name as name3_0_, children0_.orderNum as orderNum3_0_, children0_.parentId as parentId3_0_, children0_.sn as sn3_0_, children0_.url as url3_0_ from Module children0_ where children0_.parentId=?
Hibernate: select children0_.parentId as parentId1_, children0_.id as id1_, children0_.id as id3_0_, children0_.name as name3_0_, children0_.orderNum as orderNum3_0_, children0_.parentId as parentId3_0_, children0_.sn as sn3_0_, children0_.url as url3_0_ from Module children0_ where children0_.parentId=?
Hibernate: select children0_.parentId as parentId1_, children0_.id as id1_, children0_.id as id3_0_, children0_.name as name3_0_, children0_.orderNum as orderNum3_0_, children0_.parentId as parentId3_0_, children0_.sn as sn3_0_, children0_.url as url3_0_ from Module children0_ where children0_.parentId=?
Hibernate: select children0_.parentId as parentId1_, children0_.id as id1_, children0_.id as id3_0_, children0_.name as name3_0_, children0_.orderNum as orderNum3_0_, children0_.parentId as parentId3_0_, children0_.sn as sn3_0_, children0_.url as url3_0_ from Module children0_ where children0_.parentId=?
Hibernate: select children0_.parentId as parentId1_, children0_.id as id1_, children0_.id as id3_0_, children0_.name as name3_0_, children0_.orderNum as orderNum3_0_, children0_.parentId as parentId3_0_, children0_.sn as sn3_0_, children0_.url as url3_0_ from Module children0_ where children0_.parentId=?
Hibernate: select children0_.parentId as parentId1_, children0_.id as id1_, children0_.id as id3_0_, children0_.name as name3_0_, children0_.orderNum as orderNum3_0_, children0_.parentId as parentId3_0_, children0_.sn as sn3_0_, children0_.url as url3_0_ from Module children0_ where children0_.parentId=?
Hibernate: select children0_.parentId as parentId1_, children0_.id as id1_, children0_.id as id3_0_, children0_.name as name3_0_, children0_.orderNum as orderNum3_0_, children0_.parentId as parentId3_0_, children0_.sn as sn3_0_, children0_.url as url3_0_ from Module children0_ where children0_.parentId=?
Hibernate: select children0_.parentId as parentId1_, children0_.id as id1_, children0_.id as id3_0_, children0_.name as name3_0_, children0_.orderNum as orderNum3_0_, children0_.parentId as parentId3_0_, children0_.sn as sn3_0_, children0_.url as url3_0_ from Module children0_ where children0_.parentId=?
Hibernate: select children0_.parentId as parentId1_, children0_.id as id1_, children0_.id as id3_0_, children0_.name as name3_0_, children0_.orderNum as orderNum3_0_, children0_.parentId as parentId3_0_, children0_.sn as sn3_0_, children0_.url as url3_0_ from Module children0_ where children0_.parentId=?
Hibernate: select children0_.parentId as parentId1_, children0_.id as id1_, children0_.id as id3_0_, children0_.name as name3_0_, children0_.orderNum as orderNum3_0_, children0_.parentId as parentId3_0_, children0_.sn as sn3_0_, children0_.url as url3_0_ from Module children0_ where children0_.parentId=?
Hibernate: select children0_.parentId as parentId1_, children0_.id as id1_, children0_.id as id3_0_, children0_.name as name3_0_, children0_.orderNum as orderNum3_0_, children0_.parentId as parentId3_0_, children0_.sn as sn3_0_, children0_.url as url3_0_ from Module children0_ where children0_.parentId=?
Hibernate: select children0_.parentId as parentId1_, children0_.id as id1_, children0_.id as id3_0_, children0_.name as name3_0_, children0_.orderNum as orderNum3_0_, children0_.parentId as parentId3_0_, children0_.sn as sn3_0_, children0_.url as url3_0_ from Module children0_ where children0_.parentId=?
Hibernate: select children0_.parentId as parentId1_, children0_.id as id1_, children0_.id as id3_0_, children0_.name as name3_0_, children0_.orderNum as orderNum3_0_, children0_.parentId as parentId3_0_, children0_.sn as sn3_0_, children0_.url as url3_0_ from Module children0_ where children0_.parentId=?
Hibernate: select children0_.parentId as parentId1_, children0_.id as id1_, children0_.id as id3_0_, children0_.name as name3_0_, children0_.orderNum as orderNum3_0_, children0_.parentId as parentId3_0_, children0_.sn as sn3_0_, children0_.url as url3_0_ from Module children0_ where children0_.parentId=?
Hibernate: select children0_.parentId as parentId1_, children0_.id as id1_, children0_.id as id3_0_, children0_.name as name3_0_, children0_.orderNum as orderNum3_0_, children0_.parentId as parentId3_0_, children0_.sn as sn3_0_, children0_.url as url3_0_ from Module children0_ where children0_.parentId=?
Hibernate: select children0_.parentId as parentId1_, children0_.id as id1_, children0_.id as id3_0_, children0_.name as name3_0_, children0_.orderNum as orderNum3_0_, children0_.parentId as parentId3_0_, children0_.sn as sn3_0_, children0_.url as url3_0_ from Module children0_ where children0_.parentId=?
Hibernate: select children0_.parentId as parentId1_, children0_.id as id1_, children0_.id as id3_0_, children0_.name as name3_0_, children0_.orderNum as orderNum3_0_, children0_.parentId as parentId3_0_, children0_.sn as sn3_0_, children0_.url as url3_0_ from Module children0_ where children0_.parentId=?
Hibernate: select children0_.parentId as parentId1_, children0_.id as id1_, children0_.id as id3_0_, children0_.name as name3_0_, children0_.orderNum as orderNum3_0_, children0_.parentId as parentId3_0_, children0_.sn as sn3_0_, children0_.url as url3_0_ from Module children0_ where children0_.parentId=?
Hibernate: select children0_.parentId as parentId1_, children0_.id as id1_, children0_.id as id3_0_, children0_.name as name3_0_, children0_.orderNum as orderNum3_0_, children0_.parentId as parentId3_0_, children0_.sn as sn3_0_, children0_.url as url3_0_ from Module children0_ where children0_.parentId=?
Hibernate: select children0_.parentId as parentId1_, children0_.id as id1_, children0_.id as id3_0_, children0_.name as name3_0_, children0_.orderNum as orderNum3_0_, children0_.parentId as parentId3_0_, children0_.sn as sn3_0_, children0_.url as url3_0_ from Module children0_ where children0_.parentId=?
Hibernate: select children0_.parentId as parentId1_, children0_.id as id1_, children0_.id as id3_0_, children0_.name as name3_0_, children0_.orderNum as orderNum3_0_, children0_.parentId as parentId3_0_, children0_.sn as sn3_0_, children0_.url as url3_0_ from Module children0_ where children0_.parentId=?
Hibernate: select children0_.parentId as parentId1_, children0_.id as id1_, children0_.id as id3_0_, children0_.name as name3_0_, children0_.orderNum as orderNum3_0_, children0_.parentId as parentId3_0_, children0_.sn as sn3_0_, children0_.url as url3_0_ from Module children0_ where children0_.parentId=?
Hibernate: select children0_.parentId as parentId1_, children0_.id as id1_, children0_.id as id3_0_, children0_.name as name3_0_, children0_.orderNum as orderNum3_0_, children0_.parentId as parentId3_0_, children0_.sn as sn3_0_, children0_.url as url3_0_ from Module children0_ where children0_.parentId=?
Hibernate: select children0_.parentId as parentId1_, children0_.id as id1_, children0_.id as id3_0_, children0_.name as name3_0_, children0_.orderNum as orderNum3_0_, children0_.parentId as parentId3_0_, children0_.sn as sn3_0_, children0_.url as url3_0_ from Module children0_ where children0_.parentId=?
Hibernate: select children0_.parentId as parentId1_, children0_.id as id1_, children0_.id as id3_0_, children0_.name as name3_0_, children0_.orderNum as orderNum3_0_, children0_.parentId as parentId3_0_, children0_.sn as sn3_0_, children0_.url as url3_0_ from Module children0_ where children0_.parentId=?
Hibernate: select children0_.parentId as parentId1_, children0_.id as id1_, children0_.id as id3_0_, children0_.name as name3_0_, children0_.orderNum as orderNum3_0_, children0_.parentId as parentId3_0_, children0_.sn as sn3_0_, children0_.url as url3_0_ from Module children0_ where children0_.parentId=?
Hibernate: select children0_.parentId as parentId1_, children0_.id as id1_, children0_.id as id3_0_, children0_.name as name3_0_, children0_.orderNum as orderNum3_0_, children0_.parentId as parentId3_0_, children0_.sn as sn3_0_, children0_.url as url3_0_ from Module children0_ where children0_.parentId=?
Hibernate: select children0_.parentId as parentId1_, children0_.id as id1_, children0_.id as id3_0_, children0_.name as name3_0_, children0_.orderNum as orderNum3_0_, children0_.parentId as parentId3_0_, children0_.sn as sn3_0_, children0_.url as url3_0_ from Module children0_ where children0_.parentId=?
Hibernate: select children0_.parentId as parentId1_, children0_.id as id1_, children0_.id as id3_0_, children0_.name as name3_0_, children0_.orderNum as orderNum3_0_, children0_.parentId as parentId3_0_, children0_.sn as sn3_0_, children0_.url as url3_0_ from Module children0_ where children0_.parentId=?
Hibernate: select children0_.parentId as parentId1_, children0_.id as id1_, children0_.id as id3_0_, children0_.name as name3_0_, children0_.orderNum as orderNum3_0_, children0_.parentId as parentId3_0_, children0_.sn as sn3_0_, children0_.url as url3_0_ from Module children0_ where children0_.parentId=?
Hibernate: select children0_.parentId as parentId1_, children0_.id as id1_, children0_.id as id3_0_, children0_.name as name3_0_, children0_.orderNum as orderNum3_0_, children0_.parentId as parentId3_0_, children0_.sn as sn3_0_, children0_.url as url3_0_ from Module children0_ where children0_.parentId=?
Hibernate: select children0_.parentId as parentId1_, children0_.id as id1_, children0_.id as id3_0_, children0_.name as name3_0_, children0_.orderNum as orderNum3_0_, children0_.parentId as parentId3_0_, children0_.sn as sn3_0_, children0_.url as url3_0_ from Module children0_ where children0_.parentId=?

虽然这种方式在查找模块时会进行大量的SQL操作，但在本次实践中作为一个练习是可行的。

 

 

 

页面显示正常，能够获取到该模块的子模块。通过查看hibernate打印出的sql 语句，可以看出hibernate在取出父模块的同时也将其关联的子模块全部取出。

 

 

 

为了验证  @OneToMany(mappedBy="parent", fetch = FetchType.LAZY)
    public Set<Module> getChildren() {
        return children;
    }

是否能够取得理想效果，我修改了代码后，JSP 页面仍然报同样的错误，提示不能加载子模块。

虽然设置了延迟加载，如果是在java 代码中应该可以实现延迟加载功能。但是在这里，使用jsp 页面调用的方式，Action 将参赛传递到JSP页面中后，session  已经关闭，而JSP页面中的modules 是通过session 从Action中获取的。在session 已经关闭时，希望通过modules 延迟加载（也就是重新发SQL 语句到数据库中取到其子模块的实体类） 是不可能实现的。

查看hibernate 打印的sql 语句证实了其只能查询出该实体类本身的属性，而不能查询出与其关联的属性

 

 

 

Hibernate: select module0_.id as id3_, module0_.name as name3_, module0_.orderNum as orderNum3_, module0_.parentId as parentId3_, module0_.sn as sn3_, module0_.url as url3_ from Module module0_ where module0_.parentId is null limit ?

 

 

 

 

 

为了弄清楚延迟加载，又baidu了一把，总结下延迟加载：

A，实体对象的延迟加载： 通常在用  load（）  方法时使用。此时返回的是实体类的代理类。而在对该实体类进行操作时，hibernate才会去数据库获取真正的实体类对象

B,集合类型的延迟加载：  就是本文提到的父模块与子模块之间的关系，在这里提醒一下，在实体类中定义子对象集时，必须使用set 集合。

C, 属性延迟加载：  通常对某个实体类进行细分，设置该实体类的某些属性为延迟加载，但需要对这些属性进行操作时，才去读取这些属性在数据库中的column 值

 

 

 

 

veverrr
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
react-lazily-img:React Wrapper组件使用IntersectionObserver API延迟加载图像
05-11
懒惰地ReactIMG React Lazily IMG是一个React Wrapper组件，用于延迟加载图像。 目标是使用方便且已知的标准HTML标记，并只是延迟加载它们。特征图片标签和IMG srcset支持Webp检测占位符HTML && CSS图像支持下载图像...
Hibernate异常之 org.hibernate.LazyInitializationException: failed to lazily initialize a collecio....
静若清池，动如涟漪_
08-02 490
1、异常描述 org.hibernate.LazyInitializationException: failed to lazily initialize a collection of role: cn.wang.entity.Clazz.studentSet,no session or session was closed 备注： 此处hibernate版本号：3.6...
failed to lazily initialize a collection of role:no session or session was close
互联网码农jack
12-21 166
解决方法（延迟加载问题） 把fetch= FetchType.LAZY 改成 fetch = FetchType.EAGER 1、OpenSessionInView模式： 以下有2种方法，第1种是结合SPRING，第2种是采用了拦截器 Spring+Hibernate中，     集合映射如果使用lazy="true"， 当PO传到View层时， 出现未初始化session...
failed to lazily initialize a collection of role:
lirengming的专栏
08-12 3424
大中小   环境 spring＋hibernate3＋struts 今天又碰到错误 failed to lazily initialize a collection of ro
org.hibernate.LazyInitializationException: failed to lazily initialize a collection of role:XXX
szl的专栏
06-27 858
org.hibernate.LazyInitializationException: failed to lazily initialize a collection of role: com.zznode.inms.pdm.data.ProjectBatchUpdateTask.devicePrjChangeTasks, no session or session was closed at
failed to lazily initialize a collection of role: no session or session was closed (Hibernate) 解决...
yangshen998
12-15 168
在学着编写OA 权限管理时，在jsp 页面中通过已取得的 父模块来获取该模块的所有子模块 JSP 代码片段： &lt;c:forEach items="${modules}" var="module"&gt; &lt;c:forEach items="${module.children}" var="child"&gt; &lt;td&gt; ${c
Qazy:延迟加载 - 没有 SEO 负面影响
06-09
延迟加载 - 没有 SEO 负面影响 Qazy 是一个图像延迟加载器，并且与库无关（没有 jQuery）。 Qazy 消除了。 这就是它与其他惰性加载器的不同之处。 尽快在网页中加载脚本，以便它可以开始跟踪图像并延迟加载它们。 ...
react-lazily-render:延迟安装昂贵的组件，直到将占位符组件滚动到视图中为止
05-06
延迟安装昂贵的组件，直到占位符组件滚动到视图中为止。 安装 npm install --save react-lazily-render 用法 （） import React from 'react' ; import LazilyRender from 'react-lazily-render' ; ...lots of ...
Android组件ViewStub基本使用方法详解
01-05
“A ViewStub is an invisible, zero-sized View that can be used to lazily inflate layout resources at runtime. When a ViewStub is made visible, or when inflate() is invoked, the layout resource is ...
cinnamon:一个简单的部署工具
05-14
名称 Cinnamon-简约的部署工具 概要 use strict; use warnings; # Exports some commands use Cinnamon::DSL; my $application = 'My::App';...# Lazily evaluated if passed as a code set lazy_value => sub { #.
转failed to lazily initialize a collection of role: no session or session was clo
iteye_15998的博客
05-02 126
今天遇到这人问题，以下这文章讲得比较清楚! 转自:[url]http://blog.csdn.net/veverrr/archive/2010/12/15/6077343.aspx[/url] 在学着编写OA 权限管理时，在jsp 页面中通过已取得的 父模块来获取该模块的所有子模块 JSP 代码片段： ${child.name } ...
failed to lazily initialize a collection of role: ......, no session or session was closed
C.
03-01 1740
我在用ssh框架编写图书管理系统的时候遇到了这样的错误org.hibernate.LazyInitializationException: failed to lazily initialize a collection of role: com.cc.library.domain.Reader.borrowInfos, no session or session was closed at
解决： failed to lazily initialize a collection of role: no session or session was closed问题
说：/~不了的专栏
08-18 3459
org.hibernate.LazyInitializationException: failed to lazily initialize a collection of role: cn.itcast.domain.User.posts, no session or session was closed
解决Failed to lazily initialize a collection (原创)
jangta的专栏
07-27 899
今天在维护项目维护开发过程中出了个问题。 报错是：“ Failed to lazily initialize a collection - no session or session was closed”一看这个错误就知道是lazyLoad问题。 先在网上找了相关问题解决方式，在转载的文章中(http://wujt.iteye.com/admin/blogs/433788)学习一...
failed to lazily initialize a collection of role: com..., could not initialize proxy - no Session
chenyun19900528的博客
07-03 1371
net.sf.json.JSONException: org.hibernate.LazyInitializationException: failed to lazily initialize a collection of role: com.gwl.bos.model.Region...
failed to lazily initialize a collection of role:XXX, no session or session was closed解决方法
杨煜冬煜杨的博客
04-28 1519
在使用hibernate时，我们经常会遇到题目上所说的问题，在上网搜索后，我们发现只需要在web.xml文件中加入以下两段代码 hibernateFilter org.springframework.orm.hibernate.support.OpenSessionInViewFilter hibernateFilter *.do 但是，我在添加该代码后，
failed to lazily initialize a collection of role: XXXXXXXX no session or session was closed
技术空间站
05-13 3256
这个异常大致意思是说在多对一的时候（并且lazy="false"），对象的实例失败，多数出现的情况有1、粗心造成实例对象类名写错之类的2、逻辑错误如之前就已经传递过来一个实体对象，然后调用实体对象的方法时牵涉到1对多的情况，但此时SESSION已经关闭，所以根本无法进行一对多的操作，解决方法如下：1、OpenSessionInView模式：以下有2种方法，第1种是结合SPR
struts2报异常failed to lazily initialize a collection of role: no Session问题的解决
taotao的博客
07-22 710
今天在写一个新的ssh项目的时候，遇到了failed to lazily initialize a collection of role: com.crm.domain.Customer.linkmans, could not initialize proxy - no Session异常， 一开始从前半部分字面意思上理解，似乎是延迟加载出了问题，但是我的类和映射文件是hibernate生成工具...
failed to lazily initialize a collection of role: com.hmglog.cis.model.Product.ebookDetailProductRels, could not initialize proxy - no Session
最新发布
05-24
这个错误通常是因为在使用 Hibernate 进行数据库操作时，当使用到懒加载（Lazy Loading）的时候，Session 已经关闭了，导致无法获取到相关数据。解决这个问题的方法是，使用 Eager Loading 或者在需要使用懒加载时保持 Session 处于打开状态。 Eager Loading 是指在查询主实体的同时，也将关联实体一并查询出来。这样就不会出现 Session 关闭后无法获取到相关数据的情况。你可以在查询时使用 fetch 关键字实现 Eager Loading，例如： ```java Query query = session.createQuery("from Product p left join fetch p.ebookDetailProductRels"); List<Product> products = query.list(); ``` 另外一种解决方法是，在需要使用懒加载的时候保持 Session 处于打开状态。例如： ```java Session session = sessionFactory.openSession(); Transaction tx = session.beginTransaction(); Product product = (Product) session.get(Product.class, productId); Hibernate.initialize(product.getEbookDetailProductRels()); tx.commit(); session.close(); ``` 这样就可以在需要使用懒加载的时候保持 Session 处于打开状态，避免出现上述错误。但是需要注意的是，在使用完毕后要及时关闭 Session，否则会出现内存泄漏等问题。

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值