Disable fetch size property or set it to 0

Ankit96140
Ankit96140 Registered Posts: 9 ✭✭✭✭

Hi,

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

Answers

  • Clément_Stenac
    Clément_Stenac Dataiker, Dataiku DSS Core Designer, Registered Posts: 753 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
    Ankit96140 Registered Posts: 9 ✭✭✭✭

    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
    Clément_Stenac Dataiker, Dataiku DSS Core Designer, Registered Posts: 753 Dataiker

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

Setup Info
    Tags
      Help me…