I am using JDBC as datasource queries and usually return a limited number of rows (say customer IDs) for testing. In a couple of cases, after editing a query and re-running the test, I found that I accidentally commented out the limiting clause (say in DB2: Order by rand() fetch first 400 rows only) of my first CTE so the query is selecting every single customerId in the database and it takes forever to return any results! Is there a way in ReadyAPI (I'm using Ver 3.45.0) to somehow close the connection and interrupt the query, or stop/cancel the test? I've been closing ReadyAPI but this seems to be a bit extreme...

In that case, it is possible to have different jdbc tests steps with different filters, so that run appropriate step instead of commenting part of sql. Another possibility is to reduce the timeout.

I was referring to "accidentally commented the filtering part" in the question.

The "accident" happens more often than what I'd like to. As part of my WHERE clause I have a general: ORDER BY RAND() FETCH FIRST n ROWS ONLY -- Vary n to the number of customer IDs you want to testor ORDER BY customerId LIMIT x OFFSET yI also have above: AND custimerId IN ('xxxxxx','yyyyyy','zzzzzz')and I comment out one or the other to allow me to test multiple random, multiple sequential chunks or individual customerIds. So, if I'm testing an individual case so ORDER BY RAND() FETCH FIRST n ROWS ONLYis commented out, and then I want to test random customerIds, I comment the AND custimerId IN ('xxxxxx','yyyyyy','zzzzzz')and before I know it, I hit execute so I'm selecting ALL customerIds since both clauses are now commented out! 😞

How can I interrupt a JDBC query | SmartBear Community

Forum Discussion

Recent Discussions

Vulnerable jetty files
4 days ago
rik123
RunTestCase input and return proeprties of the same name
14 days ago
Musketeer
Import API Definition in Ready API
15 days ago
Rak19

Forum Discussion

Recent Discussions

Vulnerable jetty files

RunTestCase input and return proeprties of the same name

Import API Definition in Ready API

Related Content

datasource-JDBC-Query

Checking unordered result sets from JDBC query

How to determine that test was interrupted?