kknight2046
Programmer
I was told that when fetching rows which contain CLOB columns using Oracle JDBC, the fetch size is always set to 1, no matter what fetch size you set in the program. Is it true? Can anyone give me a URL that discusses this problem?
For example, the following code fetches CLOB rows from a database table:
sql = "select id, aCLOB from foo";
pstmt = conn.prepareStatement(sql);
pstmt.setFetchSize(100);
rset = pstmt.executeQuery();
while (rset.next()) {
/* Process the data*/
}
In this example, pstmt.setFetchSize(100) will not take effect. The fetch size is always 1 since there is CLOB data in the query.
Is it true?
Thanks.
For example, the following code fetches CLOB rows from a database table:
sql = "select id, aCLOB from foo";
pstmt = conn.prepareStatement(sql);
pstmt.setFetchSize(100);
rset = pstmt.executeQuery();
while (rset.next()) {
/* Process the data*/
}
In this example, pstmt.setFetchSize(100) will not take effect. The fetch size is always 1 since there is CLOB data in the query.
Is it true?
Thanks.
