Community Conundrum 25: Feature Visualization is now live! Read More

Disable fetch size property or set it to 0

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
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?

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 

Dataiker
Dataiker

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