JDBC SQL Server Out of Memory Exception
I am writing a small utility that index's a SQL Server 2005 table data to LUCENE data store. i am using a JDBC SQL Server driver for connectivity. The result set returned from the server has around 2 mill开发者_如何学JAVAion rows. This always throws a Out of Memory Exception. I have increased the Heap size for the client machine to around 1.6 GB, but to no avail. How can i fetch such large data sets, using JDBC giving limited memory .
Kind Regards
Have you looked at LIMIT and TOP in SQL? Also, try Googling for phrases like 'SQL query pagination'.
精彩评论