Announcing the winners & finalists of the Dataiku Frontrunner Awards 2021! Read their inspiring stories

Disable fetch size property or set it to 0

Ankit96140
Level 2
Disable fetch size property or set it to 0

Hi,

How to disable the setFetchSize property while using sql datasets ? also is there any way to set it as 0?

3 Replies
Clément_Stenac
Dataiker
Dataiker

Hi,

You should be able to set this to 0 in the connection settings. Is there any particular reason why you would want to disable this setting completely?

Ankit96140
Level 2
Author

Thanks for the information, Currently we are using Dataiku to import various datasets from Sybase DB. we do understand that Dataiku doesn't provide any support for Sybase DB. 

The normal data fetch works fine but when we try to execute Sybase procedure then we get cursor related errors.

we further debugged and found that it could occur due to below method 

Statement stmt=con.createStatement();

stmt.setFetchSize(100);

this methods sets the fetch size as well as defines a cursor name. we want to disable this property. one way to disable this property is by setting it to 0 but i think it still doesn't work in Dataiku 

Clément_Stenac
Dataiker
Dataiker

Thanks for the details, we'll be looking at making this disableable

A banner prompting to get Dataiku DSS