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

Reply via email to