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
above, 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(
).
Copyright © 2003. Sybase Inc. All rights reserved. |
![]() |