title: How does "cancel query" work in SQL Developer
body: <p>In SQL Developer, clicking on the Cancel Task button stops the execution of a query immidiately. I have to implement the same functionality in our project.</p>
  
  <p><img src="https://i.stack.imgur.com/MzbSX.png" alt="cancel query iamge"></p>
  
  <p>I am using BC4J as an ORM tool to execute the queries. I have to cancel a search query execution called thorugh view objects that calls several database functions/procedures to get the result.</p>
  
  <p>I have tried using <code>viewObject.cancelQuery();</code> but it doesn't have any effect; the query  keeps executing to the end. </p>
  
  <p>I am connected through JDBC connection pooling, handled by BC4J.</p>