Added two new connection options:
read_timeout(time limit to receive a response from the server) andwrite_timeout(time limit to send data to the server). Both options default toNone, which sets the timeout to indefinitely. (Bug #115788, Bug #36922645, WL #16381)Added the
read_timeoutandwrite_timeoutoptions for both connections and cursors. These set the transaction timeout (sending and receiving data to and from the server), and default toNonethat sets the wait time to indefinitely. (WL #16381)-
The single and multiple statement execution mechanic was unified, when before a
multicursor.execute()option was required to execute multiple statements.Changes include removing the
multioption and adding the optionalmap_resultsoption, and adding the fetchsets() and nextset() methods. (WL #16285)
The configuration option parser was modified to use
ast.literal_eval()instead ofeval(). For additional information, see Connector/Python Option-File Support. (Bug #37145655)-
When passing in multiple statements, the connector did not properly traverse (and execute) each query when the last query was preceded by a comment. (Bug #36126909)
References: This issue is a regression of: Bug #35710145.
The mechanism to execute and retrieve multiple statements was improved. Changes include: the removal of
execute()'smultiparameter, the addition of thenextset()andfetchsets()methods, and a newmap_resultsoption for theexecute()method. For additional information, see Executing Multiple Statements. (Bug #35810050, WL #16285)Fixed two memory leaks coming from the
get_rows()connection API command of the C-extension implementation. (Bug #115082, Bug #36702939)