aspose file tools*
The moose likes JDBC and the fly likes setFetchSize on preparestatement vs setFetchSize on resultset Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "setFetchSize on preparestatement vs setFetchSize on resultset" Watch "setFetchSize on preparestatement vs setFetchSize on resultset" New topic
Author

setFetchSize on preparestatement vs setFetchSize on resultset

avihai marchiano
Ranch Hand

Joined: Jan 10, 2007
Posts: 342
setFetchSize on preparestatement vs setFetchSize on resultset what is the different?
how to know the optimal value?

Thank you
Leonardo Carreira
Ranch Hand

Joined: Apr 07, 2009
Posts: 489

Sir..

What is your purpose in using setFetchSize?..

what do i can to make similar it with limit function in query?

Thanks in advance..


Sorry, perhaps my english language isn't too good.. Prepare for SCJP 6, Please God help me.. ☼
References : [Java.Boot] [JavaChamp] [JavaPrepare]
avihai marchiano
Ranch Hand

Joined: Jan 10, 2007
Posts: 342
limit is not standard.
Leonardo Carreira
Ranch Hand

Joined: Apr 07, 2009
Posts: 489

avihai marchiano wrote:limit is not standard.


upset..

usually i uses Limit in my query...
if i use JDBC, do i have to use setFetchSize/setMaxRows on my preparedStatement?

Thanks sir..
avihai marchiano
Ranch Hand

Joined: Jan 10, 2007
Posts: 342
no no no , no upset at all.

As far as i know limit Standard, so when you want to set the bulk size you need to set it on the max rows.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: setFetchSize on preparestatement vs setFetchSize on resultset