Java – sets the difference between the extraction size on the statement and the resultset

What is the difference between setting the extraction size on the statement and the resultset? The Oracle document says that if the get size is set on the statement, the resultset will also use the same size, as long as the get size is set before getting the result set What is the difference if I set it on the statement or resultset? I am using Oracle database The following is the Oracle documentation about it:

Solution

The only place where getting size is really important is resultset When creating a resultset, it gets its size from the statement used to create it, but it can be changed later

Treat the extraction size of the statement as the default value and pass it to all resultsets it creates If you do not want to use this default value, you can override it

The content of this article comes from the network collection of netizens. It is used as a learning reference. The copyright belongs to the original author.
THE END
分享
二维码
< <上一篇
下一篇>>