Disable fetch size property or set it to 0

Ankit96140

Hi,

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

Clément_Stenac

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

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

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