Node-oracledb: Question: Kill long running queries

Created on 22 Feb 2017  路  2Comments  路  Source: oracle/node-oracledb

How can we kill long running queries on the database, can there be support for sending interrupt to the existing running query from the client which kills the session on the database and throws errors to the client, which initiated the session.

Something like in java using Statement.Cancel() on the other thread.

Or what can be possible workaround for that.

question

Most helpful comment

I have on my 'to look at' list the OCI call timeout attributes They map to Oracle Net parameters (note the unit is different) which you could set in a sqlnet.ora file right now without waiting for node-oracledb to have an API to set them.

All 2 comments

I have on my 'to look at' list the OCI call timeout attributes They map to Oracle Net parameters (note the unit is different) which you could set in a sqlnet.ora file right now without waiting for node-oracledb to have an API to set them.

Was this page helpful?
0 / 5 - 0 ratings