nutmix opened a new issue, #6467: URL: https://github.com/apache/jmeter/issues/6467
### Use case 1. Often we need to run many statements (e.g. to drop then create the tables, indexes and keys needed by a test) Splitting each of these into individual samplers is tedious and doesn't help in that they either all work or all fail. 2. Inserting lots of static data ready for a testing is something which really needs the ability to run as a script (i.e. all the inserts in a single sampler). 3. combine dependent inserts (i.e those joined by foreign key) into one transaction and sampler). E.g. a user and their address. ### Possible solution a new sampler called "JDBC Script Request", which can execute any number of statements pasted into the "Script" window (which is more or less the same as the "Query" window). Ideally a check box to run the script in a separate transaction, with an auto rollback after completion (i.e. we would need to add a commit; statement as the last line of the script, in which case the rollback does nothing. that way if one statement fails, they all fail (and get rolled back). ### Possible workarounds _No response_ ### JMeter Version 5.6.3 ### Java Version 21 (zulu) ### OS Version win 11 -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: dev-unsubscr...@jmeter.apache.org.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org