开发者

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'.

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜