The API documentation explains it pretty well, but a number of programmers seem to have a misconception of its functionality. The first thing to note is that it may do nothing at all; it is only a hint, even to a JDBC Compliant driver. setFetchSize() is really a request for a certain sized blocking factor, that is, how much data to send at a time.
Because trips to the server are expensive, sending a larger number of rows can be more efficient. It may be more efficient on the server side as well, depending on the particular SQL statement and the DB engine. That would be true if the data could be read straight off an index and the DB engine paid attention to the fetch size. In that case, the DB engine could return only enough data per request to match the fetch size. Don't count on that behavior. In general, the fetch size will be transparent to your program and only determines how often requests are sent to the server as you traverse the data. Also, both Statement and ResultSet have setFetchSize methods. If used with a Statement, all ResultSets returned by that Statement will have the same fetch size. The method can be used at any time to change the fetch size for a given ResultSet. To determine the current or default size, use the getFetchSize methods.
Posted Date:- 2021-09-04 05:41:33
If I Use The Jdbc Api, Do I Have To Use Odbc Underneath?
Where Can I Find Info, Frameworks And Example Source For Writing A Jdbc Driver?
How Can I Create A Custom Rowsetmetadata Object From Scratch?
How Does A Custom Rowsetreader Get Called From A Cachedrowset?
What Driver Should I Use For Scalable Oracle Jdbc Applications?
What are the isolation levels of connections in JDBC?
What is JDBC Transaction Management and why is it needed?
How Do I Receive A Resultset From A Stored Procedure?
How Can I Write To The Log Used By Drivermanager And Jdbc Drivers?
How Do I Check In My Code Whether A Maximum Limit Of Database Connections Have Been Reached?
Why Do I Get Unsatisfiedlinkerror When I Try To Use My Jdbc Driver?
Db2 Universal Claims To Support Jdbc 2.0, But I Can Only Get Jdbc 1.0 Functionality. What Can I Do?
How Do I Disallow Null Values In A Table?
What Are The Considerations For Deciding On Transaction Boundaries?
How Can I Determine Where A Given Table Is Referenced Via Foreign Keys?
What causes “No suitable driver†error?
Explain the usage of the getter and setter methods in ResultSet.
Can I Use Jdbc To Execute Non-standard Features That My Dbms Provides?
What Is The Significance Of Databasemetadata.tableindexstatistics? How To Obtain And Use It?
What Types Of Datasource Objects Are Specified In The Optional Package?
Which Java And Java.sql Data Types Map To My Specific Database Types?
When An Sql Select Statement Doesn't Return Any Rows, Is An Sqlexception Thrown?
What Is Optimistic Concurrency?
What Is Pessimistic Concurrency?
How Can I Tell If My Jdbc Driver Normalizes Java.sql.date And Java.sql.time Objects?
What is JDBC Batch Processing and what are it’s benefits?
I Need To Have Result Set On A Page Where The User Can Sort On The Column Headers. Any Ideas?
What Jdbc Objects Generate Sqlwarnings?
What Does Normalization Mean For Java.sql.date And Java.sql.time?
What Scalar Functions Can I Expect To Be Supported By Jdbc?
What Does Setfetchsize() Really Do?
How Can I Connect From An Applet To A Database On The Server?
What Is The Advantage Of Using A Preparedstatement?
What Is The Difference Between Directive Include And Jsp Include?
How To Pass Information From Jsp To Included Jsp?
Explain the types of RowSet available in JDBC.
What is the use of setFetchSize() and setMaxRows() methods in Statement?
Result Set’s index Starts with 0 or 1?