How can I interrupt a JDBC query
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 ...
Forum Discussion
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 test
or ORDER BY customerId LIMIT x OFFSET y
I 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 ONLY
is 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! 😞
