Creating server side cursors

c开发者_Python百科om.microsoft.sqlserver.jdbc.SQLServerException: The system is out of memory. Use server side cursors for large result sets:Java heap space. Result set size:280,236,031. JVM total memory size:423,297,024.

I am trying to fetch a big data set from SQL and I get following error. Let me know if anyone have seen something similar and willing to drop a line.

Have you tried increasing the amount of memory available to your JVM? On the command line, add -Xmx1024m to increase the JVMs memory footprint to 1Gig. Its not a long term solution, but it will solve your immediate problem.