Does ngdbc support fetchSize

[former_member1379625]

Hi all,

Do you know if the latest jdbc driver for hana (ngdbc.jar) supports fetchSize ? when we call setFetchSize of the preparedstatement like below, will this be regarded by the server?

stmt.setFetchSize(1000)

Regards,

Bai

[Former Member]

Thank you for visiting SAP Community to get answers to your questions. Since you're asking a question here for the first time, I recommend that you familiarize yourself with: https://community.sap.com/resources/questions-and-answers, as it provides tips for preparing questions that draw responses from our members.

For example, you can:

- outline what steps you took to find answers (and why they weren't helpful)

- share screenshots of what you've seen/done

- make sure you've applied the appropriate tags

- use a more descriptive subject line

The more details you provide, the more likely it is that members will be able to respond. Feel free to also take our Q&A tutorial at: https://developers.sap.com/tutorials/community-qa.html

Should you wish, you can revise your question by selecting Actions, then Edit.

Best,

Your SAP Community moderator

[selim_derouiche]

Hello,

Yes it is supported for our config

You can check M_SQL_CLIENT_NETWORK_IO, with bigger fetchsize you got less rows in that table.