Skip to Main Content
Spotfire Ideas Portal
Status Future Consideration
Product Spotfire
Created by Guest
Created on Feb 6, 2016

Cancel the opening of a DXP file while reading data from a data source (Information Link) - query to database should be cancelled

When a user cancels the opening of an analysis file and the analysis file is connected to an information link and reading the data; *the Spotfire Server should send a cancel to the database to cancel the query*. Currently, even though the user has canceled the requested (from client), the Spotfire Server seems to run all the queries submitted to the database to completion. It does not really cancel. It should be like when you are using a DB visualizer or database tool; after submitting the query, there may be an option to cancel query.

  • Attach files
  • Guest
    Reply
    |
    Jun 8, 2016

    Not all data sources support this feature and not all drivers implement it but it will great to implement it on the major ones. Microsoft SQL Server and Oracle both support user query cancels and they have implemented this feature on their respective JDBC drivers.