Results 1 to 4 of 4
  1. #1
    Join Date
    Aug 2007

    Unanswered: How to cancel a running operation


    I've the following question:

    How can I cancel a running operation, for example a select statement, stored procedure, ... ?
    It should be done by a client, which sends the request after a user clicked a button.

    Any ideas?

    Thanks in advance


  2. #2
    Join Date
    Jan 2004
    Croatia, Europe
    Provided Answers: 5
    How did you create a front-end application? Is it a Forms Builder? If so, I'm not sure you can do that (other than asking your DBA to kill the process or, alternatively, you could terminate Forms session by yourself and start over).

  3. #3
    Join Date
    Jun 2003
    West Palm Beach, FL


    It gets more difficult if you are using some kind of middle-tier software (like Application Server, Tomcat, etc...) which establish a pool of connections to manage the user requests.

    The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

  4. #4
    Join Date
    Aug 2007
    Actually I'm using an Application Server...

    The front end application is made via j2ee

    Tools like Golden and PLEdit can cancel the operation somehow...
    So there is no real chance to do so, hm?

    Looks like I need to cancel the operation for the client only and let the server go on. So at least the user can continue the work...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts