解决方法严重: Servlet.service() for servlet default threw exception org.hibernate.TransactionException: Transaction not successfully

修正Hibernate查询异常

最新推荐文章于 2023-03-07 16:46:56 发布

原创最新推荐文章于 2023-03-07 16:46:56 发布 · 7.7k 阅读

2 ·

CC 4.0 BY-SA版权

文章标签：

#exception #servlet #null #session #sql #string

SSH 专栏收录该内容

30 篇文章

订阅专栏

本文介绍了一个关于Hibernate框架中查询操作的常见错误及其修正方法。错误出现在尝试在事务提交后获取查询结果，导致运行时异常。通过调整代码逻辑，将获取查询结果的操作提前到事务提交之前，解决了此问题。

程序代码：

public List<WenshuInfo> findBySql(String sql) { log.debug("findBuSql WenshuInfo instances"); Transaction tran = null; Session session = HibernateSessionFactory.getSession(); try { tran = session.beginTransaction(); Query queryObject = session.createQuery(sql); session.flush(); tran.commit(); return queryObject.list(); } catch (RuntimeException re) { if (null != tran) { tran.rollback(); tran = null; } log.error("findBuSql failed", re); re.printStackTrace(); return null; } }

关键代码：return queryObject.list(); 放在了commit后面所以会出现下面的异常。

修改后的代码：

public List<WenshuInfo> findBySql(String sql) { log.debug("findBuSql WenshuInfo instances"); Transaction tran = null; Session session = HibernateSessionFactory.getSession(); try { tran = session.beginTransaction(); Query queryObject = session.createQuery(sql); List<WenshuInfo> list = queryObject.list(); session.flush(); tran.commit(); return list; } catch (RuntimeException re) { if (null != tran) { tran.rollback(); tran = null; } log.error("findBuSql failed", re); re.printStackTrace(); return null; } }

异常信息：

at org.hibernate.transaction.JDBCTransaction.rollback(JDBCTransaction.java:149) at com.mylegist.lawgeneral.dao.WenshuInfoDaoIMP.findBySql(WenshuInfoDaoIMP.java:86) at com.mylegist.lawgeneral.service.WenshuInfoServiceIMP.findBySql(WenshuInfoServiceIMP.java:28) at com.mylegist.lawgeneral.action.WenshuAction.execute(WenshuAction.java:35) 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 com.opensymphony.xwork2.DefaultActionInvocation.invokeAction(DefaultActionInvocation.java:404) at com.opensymphony.xwork2.DefaultActionInvocation.invokeActionOnly(DefaultActionInvocation.java:267) at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:229) at com.opensymphony.xwork2.interceptor.DefaultWorkflowInterceptor.doIntercept(DefaultWorkflowInterceptor.java:221) at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:86) at com.opensymphony.xwork2.DefaultActionInvocation$2.doProfiling(DefaultActionInvocation.java:224) at com.opensymphony.xwork2.DefaultActionInvocation$2.doProfiling(DefaultActionInvocation.java:223) at com.opensymphony.xwork2.util.profiling.UtilTimerStack.profile(UtilTimerStack.java:455) at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:221) at com.opensymphony.xwork2.validator.ValidationInterceptor.doIntercept(ValidationInterceptor.java:150)