JDBC fetchSize and setAutoCommit false relationship

Question

I want to know is there any inter relationship between autocommit and fetchsize in JDBC. I checked, all my connection is autocommit = true. I have set fetch size is 100. Is it correct? I want to know fetch size is working or not?

In my application am handling 500k record using a single db connection in SQL server or Oracle DB. So, what is the recommended fetch size?

http://stackoverflow.com/questions/3682614/how-to-read-all-rows-from-huge-table — Sivaraj Thavamani, Aug 10 '16 at 13:18

score 0 · Answer 1 · answered Aug 10 '16 at 12:02

0

setFetchSize is not always supported by your driver so you might need to check the implementation, and generated SQL, to determine if it is being applied

answered Aug 10 '16 at 12:02

farrellmr

1,805
1
14
26

How to check whether fetch size is affected or not? I am using normal JDBC implemenation – Sivaraj Thavamani Aug 10 '16 at 13:20
This is a good guide https://webmoli.com/2009/02/01/jdbc-performance-tuning-with-optimal-fetch-size/ – farrellmr Aug 10 '16 at 13:23
I am using "com.microsoft.sqlserver.jdbc.SQLServerDriver" to get the connection – Sivaraj Thavamani Aug 10 '16 at 13:59
http://stackoverflow.com/questions/15074037/set-a-default-row-prefetch-in-sql-server-using-jdbc-driver – farrellmr Aug 10 '16 at 14:04
You mention both oracle and sql server in your question – farrellmr Aug 10 '16 at 14:04
Yes. Please consider now MSSQL – Sivaraj Thavamani Aug 10 '16 at 14:13

JDBC fetchSize and setAutoCommit false relationship

1 Answers1