查询数据库内存不足java.lang.OutOfMemoryError: Java heap space
select语句大约查询出来6百万的id,ResultSet貌似都放到内存里了。。导致内存不足
我设置了fetchSize,也不行。求高手指教
Exception in thread "main" java.lang.OutOfMemoryError: Java heap space
String select = "select itemid from " + ITEMS + " where itemid>91592607 "; String update = "update " + ITEMS + " set view=? where itemid=?"; int[] iids = new int[5]; try { pstmt = conn.prepareStatement(select); pstmt2 = conn.prepareStatement(update); rs = pstmt.executeQuery();//报错行at GetUserData.main(GetUserData.java:52) rs.setFetchSize(1000);