LANGUAGE_CURSOR Connection Property

LANGUAGE_CURSOR is a Boolean-valued connection property in jConnect that allows you to determine whether cursors are created as protocol cursors or language cursors.

  • If LANGUAGE_CURSOR is false (the default), all cursors created during a session are protocol cursors, which provide better performance. jConnect creates and manipulates the cursors by sending cursor commands as tokens in the TDS protocol.

  • If LANGUAGE_CURSOR is true, all cursors created during a session are language cursors. jConnect creates and manipulates the cursors by sending SQL statements to the database for parsing and compilation.

    There is no known advantage to setting LANGUAGE_CURSOR to true, but the option is provided in case an application displays unexpected behavior when LANGUAGE_CURSOR is false.