Com. Microsoft. sqlserver. JDBC. sqlserverexception: The system memory is insufficient. Use the server-side cursor: Java heap space for large resultset. Res

Com. Microsoft. sqlserver. JDBC. sqlserverexception: The system memory is insufficient. Use the server-side cursor: Java heap space for large resultset. Resultset size: 417,666,054. Total JVM memory size: 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.exe cutequery (unknown source) <br/> at com.org. XCS. safecheck. user. dao. userdao. getusertaskinfoby (userdao. java: 78) <br/> at com.org.xcs.safecheck.user.action.usertasklistaction.exe cute (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)

 

 

This exception occurs when the SQL statement is too poorly written.

(Multi-table join query is performed here. I used a simple Select column from a, B, c, d Where. X = B. X and B. y = C. Y and C. z = D. z)

Later, rewrite the SQL statement using inner join... on ).