com.microsoft.sqlserver.jdbc.SQLServerException: 系統記憶體不足。請對大型 ResultSet 使用伺服器端遊標: Java heap space。Res

com.microsoft.sqlserver.jdbc.SQLServerException: 系統記憶體不足。請對大型 ResultSet 使用伺服器端遊標: Java heap space。ResultSet 大小:417,666,054。JVM 總記憶體大小:66,650,112。<br />at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(Unknown Source)<br />at com.microsoft.sqlserver.jdbc.DBComms.receive(Unknown Source)<br />at com.microsoft.sqlserver.jdbc.IOBuffer.sendCommand(Unknown Source)<br />at com.microsoft.sqlserver.jdbc.SQLServerStatement.sendExecute(Unknown Source)<br />at com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteQuery(Unknown Source)<br />at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeQuery(Unknown Source)<br />at com.org.xcs.safecheck.user.dao.UserDAO.getUserTaskInfoBy(UserDAO.java:78)<br />at com.org.xcs.safecheck.user.action.UserTaskListAction.execute(UserTaskListAction.java:30)<br />at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:431)<br />at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:236)<br />at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196)<br />at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414)<br />at javax.servlet.http.HttpServlet.service(HttpServlet.java:617)<br />at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)<br />at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)<br />at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)<br />at com.org.xcs.safecheck.core.util.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:118)<br />at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)<br />at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)<br />at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)<br />at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)<br />at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)<br />at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)<br />at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)<br />at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286)<br />at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:845)<br />at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)<br />at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)<br />at java.lang.Thread.run(Thread.java:619)

 

 

SQL語句寫得太爛造成這個異常的

(這裡進行了多表關聯查詢,我使用了簡單 select column from A a,B b,C c,D d where a.x = b.x and b.y = c.y and c.z = d.z)

後來將sql語句使用inner join...on進行改寫即可(論具體情況)。