事务影响懒加载 no session or session was closed

最新推荐文章于 2020-10-28 00:07:52 发布

转载最新推荐文章于 2020-10-28 00:07:52 发布 · 176 阅读

0 ·

CC 4.0 BY-SA版权

原文链接：https://my.oschina.net/u/2277088/blog/3056344

公司跑批时，因原先事务配置删除，访问数据库拿到数据后就关闭session，导致懒加载无法正常进行并报错。懒加载需用到数据时才去数据库加载，而关闭的session无法实现此功能。加回事务配置后，session不再用完即关，问题得以解决。

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

2019独角兽企业重金招聘Python工程师标准>>>

公司有个跑批，原先的事务配置删了，导致访问数据库拿到数据后就关了session

众所周知，懒加载就是用到该数据时才去数据库加载，但session都关了，还谈何加载，并报了下面这个错

2019-05-28 09:45:00,191 cn.com.sinosoft.job.StaffWelfareInsuredJob.doJob(StaffWelfareInsuredJob.java:98) INFO   -员工福利承保任务：进行承保操作。订单号为：B0001552097
2019-05-28 09:45:00,191 org.hibernate.LazyInitializationException.<init>(LazyInitializationException.java:42) ERROR  -failed to lazily initialize a collection of role: cn.com.sinosoft.iecs.online.domain.sale.GeStaffPolicy.geStaffInfos, no session or session was closed
org.hibernate.LazyInitializationException: failed to lazily initialize a collection of role: cn.com.sinosoft.iecs.online.domain.sale.GeStaffPolicy.geStaffInfos, no session or session was closed
	at org.hibernate.collection.AbstractPersistentCollection.throwLazyInitializationException(AbstractPersistentCollection.java:383)
	at org.hibernate.collection.AbstractPersistentCollection.throwLazyInitializationExceptionIfNotConnected(AbstractPersistentCollection.java:375)
	at org.hibernate.collection.AbstractPersistentCollection.readSize(AbstractPersistentCollection.java:122)
	at org.hibernate.collection.PersistentBag.size(PersistentBag.java:248)
	at cn.com.sinosoft.iecs.online.sale.service.impl.StaffWelfareSaleServiceImpl.getStaffWelfareInfo(StaffWelfareSaleServiceImpl.java:96)
	at cn.com.sinosoft.job.StaffWelfareInsuredJob.doJob(StaffWelfareInsuredJob.java:99)
	at sun.reflect.GeneratedMethodAccessor12895.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:498)
	at org.springframework.util.MethodInvoker.invoke(MethodInvoker.java:269)
	at cn.com.sinosoft.springframework.scheduling.quartz.BeanInvokingJobDetailFactoryBean$BeanInvokingJob.execute(BeanInvokingJobDetailFactoryBean.java:486)
	at org.quartz.core.JobRunShell.run(JobRunShell.java:223)
	at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:549)

加回事务配置后，session不再是用完就关，问题解决。

@Transactional(value="transactionManager",isolation=Isolation.READ_UNCOMMITTED)

转载于:https://my.oschina.net/u/2277088/blog/3056344