public PageViewObject getOnePageMultiResult(Session session,
Query queryObj,Query otherQuery, Integer pageCount,
Integer currPage) throws
HibernateException {
PageViewObject pageViewObject = new PageViewObject();
String sqlCount = null;
List ls = queryObj.list();
List ls1 = otherQuery.list();
int totalSize = 0;
if (ls != null && ls.size() > 0)
totalSize = ls.size();
if (ls1 != null && ls1.size() > 0)
totalSize = totalSize + ls1.size();
int perPageCount = pageCount.intValue();
int currentPage = currPage.intValue();
if (perPageCount == 0)
perPageCount = totalSize;
queryObj.setFirstResult(perPageCount *
( (currentPage == 0) ? 0 :
currentPage - 1));
queryObj.setMaxResults(perPageCount);
List results = queryObj.list();
List results_1 = otherQuery.list();
results.addAll(results_1);
pageViewObject.setRowList(results);
pageViewObject.setTotalCount(totalSize);
pageViewObject.setPerPageCount(perPageCount);
return pageViewObject;
}
这是hibernate的自带分页吧？我在查询的时候用这个分页，数据量小（300条内）的时候就能显示在页面，当数据量大（上千条）的时候事物就自动回滚了（我打印了下时间执行分页前后数据量多的时候用了90多秒），后台显示这个：
2011-11-15 12:21:52 org.objectweb.jotm.TransactionImpl timeoutExpired
信息: set rollback only (tx=bb14:38:0:0100b496591fb984b3...0f7005:)
org.springframework.transaction.TransactionSystemException: Could not commit Hibernate transaction; nested exception is net.sf.hibernate.TransactionException: Commit failed with exception:
net.sf.hibernate.TransactionException: Commit failed with exception:
at net.sf.hibernate.transaction.JTATransaction.commit(JTATransaction.java:61)
at org.springframework.orm.hibernate.HibernateTransactionManager.doCommit(HibernateTransactionManager.java:472)
at org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:397)
at org.springframework.transaction.interceptor.TransactionAspectSupport.doCommitTransactionAfterReturning(TransactionAspectSupport.java:243)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:66)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:144)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:174)
at $Proxy20.getWholeSheetAlerts(Unknown Source)
at com.hollycrm.unicom.sheet.monitor.web.SheetMonitorAction.execTotalSheetMonitor(SheetMonitorAction.java:312)
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:324)
at com.hollycrm.springframework.web.struts.DispatchActionSupport.dispatchMethod(DispatchActionSupport.java:327)
at com.hollycrm.springframework.web.struts.DispatchActionSupport.execute(DispatchActionSupport.java:226)
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)
at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:525)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at com.hollycrm.springframework.web.filter.RequestEncodeFilter.doFilter(RequestEncodeFilter.java:46)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:856)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:744)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
at java.lang.Thread.run(Thread.java:534)
Caused by: javax.transaction.RollbackException
at org.objectweb.jotm.TransactionImpl.commit(TransactionImpl.java:228)
at org.objectweb.jotm.Current.commit(Current.java:475)
at net.sf.hibernate.transaction.JTATransaction.commit(JTATransaction.java:56)
... 37 more页面有时出500 显示：
HTTP Status 500 - Dispatch[/monitor] to method totalSheetMonitor returned an exception--------------------------------------------------------------------------------type Status reportmessage Dispatch[/monitor] to method totalSheetMonitor returned an exceptiondescription The server encountered an internal error (Dispatch[/monitor] to method totalSheetMonitor returned an exception) that prevented it from fulfilling this request.
--------------------------------------------------------------------------------Apache Tomcat/5.5.9
Query queryObj,Query otherQuery, Integer pageCount,
Integer currPage) throws
HibernateException {
PageViewObject pageViewObject = new PageViewObject();
String sqlCount = null;
List ls = queryObj.list();
List ls1 = otherQuery.list();
int totalSize = 0;
if (ls != null && ls.size() > 0)
totalSize = ls.size();
if (ls1 != null && ls1.size() > 0)
totalSize = totalSize + ls1.size();
int perPageCount = pageCount.intValue();
int currentPage = currPage.intValue();
if (perPageCount == 0)
perPageCount = totalSize;
queryObj.setFirstResult(perPageCount *
( (currentPage == 0) ? 0 :
currentPage - 1));
queryObj.setMaxResults(perPageCount);
List results = queryObj.list();
List results_1 = otherQuery.list();
results.addAll(results_1);
pageViewObject.setRowList(results);
pageViewObject.setTotalCount(totalSize);
pageViewObject.setPerPageCount(perPageCount);
return pageViewObject;
}
这是hibernate的自带分页吧？我在查询的时候用这个分页，数据量小（300条内）的时候就能显示在页面，当数据量大（上千条）的时候事物就自动回滚了（我打印了下时间执行分页前后数据量多的时候用了90多秒），后台显示这个：
2011-11-15 12:21:52 org.objectweb.jotm.TransactionImpl timeoutExpired
信息: set rollback only (tx=bb14:38:0:0100b496591fb984b3...0f7005:)
org.springframework.transaction.TransactionSystemException: Could not commit Hibernate transaction; nested exception is net.sf.hibernate.TransactionException: Commit failed with exception:
net.sf.hibernate.TransactionException: Commit failed with exception:
at net.sf.hibernate.transaction.JTATransaction.commit(JTATransaction.java:61)
at org.springframework.orm.hibernate.HibernateTransactionManager.doCommit(HibernateTransactionManager.java:472)
at org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:397)
at org.springframework.transaction.interceptor.TransactionAspectSupport.doCommitTransactionAfterReturning(TransactionAspectSupport.java:243)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:66)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:144)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:174)
at $Proxy20.getWholeSheetAlerts(Unknown Source)
at com.hollycrm.unicom.sheet.monitor.web.SheetMonitorAction.execTotalSheetMonitor(SheetMonitorAction.java:312)
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:324)
at com.hollycrm.springframework.web.struts.DispatchActionSupport.dispatchMethod(DispatchActionSupport.java:327)
at com.hollycrm.springframework.web.struts.DispatchActionSupport.execute(DispatchActionSupport.java:226)
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)
at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:525)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at com.hollycrm.springframework.web.filter.RequestEncodeFilter.doFilter(RequestEncodeFilter.java:46)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:856)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:744)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
at java.lang.Thread.run(Thread.java:534)
Caused by: javax.transaction.RollbackException
at org.objectweb.jotm.TransactionImpl.commit(TransactionImpl.java:228)
at org.objectweb.jotm.Current.commit(Current.java:475)
at net.sf.hibernate.transaction.JTATransaction.commit(JTATransaction.java:56)
... 37 more页面有时出500 显示：
HTTP Status 500 - Dispatch[/monitor] to method totalSheetMonitor returned an exception--------------------------------------------------------------------------------type Status reportmessage Dispatch[/monitor] to method totalSheetMonitor returned an exceptiondescription The server encountered an internal error (Dispatch[/monitor] to method totalSheetMonitor returned an exception) that prevented it from fulfilling this request.
--------------------------------------------------------------------------------Apache Tomcat/5.5.9
Caused by: javax.transaction.RollbackException
at org.objectweb.jotm.TransactionImpl.commit(TransactionImpl.java:325)
at org.objectweb.jotm.Current.commit(Current.java:452)
at org.ow2.easybeans.transaction.interceptors.CMTRequiredTransactionInterceptor.intercept(CMTRequiredTransactionInterceptor.java:154)