OceanBase Client for Java is a JDBC 4.2 compatible driver, used to connect applications developed in Java to OceanBase Database Server.
GNU Lesser General Public License v2.1
28
stars
10
forks
source link
[Bug]: 海量数据查询报OOM错误 #5
Open
jokin132 opened 8 months ago
Describe the bug
通过jdbc oracle企业版在查询海量数据的时候，如1亿以上，报OOM。同样代码在ORACLE下无问题，部分代码如下： stmt = conn.prepareStatement(sql, ResultSet.TYPE_FORWARD_ONLY, ResultSet.CONCUR_READ_ONLY, ResultSet.HOLD_CURSORS_OVER_COMMIT); stmt.setFetchDirection(ResultSet.FETCH_FORWARD); stmt.setFetchSize(1000); rs = stmt.executeQuery(); // 内存溢出
Environment
驱动版本2.4.3
Fast reproduce steps
/
Expected behavior
No response
Actual behavior
No response
Additional context
No response