CANCEL_ALL is a Boolean-valued connection property for specifying the behavior of the Statement.cancel method.
In jConnect version 4.0 and earlier, the default for
CANCEL_ALL is "true." In jConnect version 4.1 and later,
to comply with the JDBC specification, if you set the connection
property JCONNECT_VERSION to “4” or later,
the default setting for CANCEL_ALL is "false."
The settings for CANCEL_ALL have the following effect on Statement.cancel( ):
If CANCEL_ALL is "false," invoking Statement.cancel cancels only the Statement object it is invoked on. Thus, if stmtA is a Statement object, stmtA.cancel cancels the execution of the SQL statement contained in stmtA in the database, but no other statements are affected. stmtA is canceled whether it is in cache waiting to execute or has started to execute and is waiting for results.
If CANCEL_ALL is "true," invoking Statement.cancel cancels not only the object it is invoked on, but also any other Statement objects on the same connection that have executed and are waiting for results.
The following example sets CANCEL_ALL to "false." In the example, props is a Properties object for specifying connection properties:
props.put("CANCEL_ALL", "false");
To cancel the execution of all Statement objects
on a connection, regardless of whether or not they have begun execution
on the server, use the extension method SybConnection.cancel.
