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?
Answers
-
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?
-
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
-
Thanks for the details, we'll be looking at making this disableable