title: JMeter JDBC manual commit
body: <p>I'm using JMeter to do some load testing, and need to run a test which inserts a few thousand records. Part of the requirement is that it should not commit each individual update, but only commit every thousand records. Seems pretty straightforward, but I cannot find any examples or documentation explaining how to do a manual commit in JMeter, and I can't get it to work.</p>
  <p>I've got it set up to read a few entries from a csv file, plus a counter variable for an incrementing ID field. If auto commit is enabled, that works fine.<br />
  When I disable auto commit, nothing gets committed -- as you'd expect. But how DO I get it committed? I can't even get it to commit every update without auto commit, let alone a specified rate.</p>
  <ul>
  <li>I tried adding a JDBC post processor with a commit statement and/or
  commit query type, on the same DB connection pool, only one thread on
  that pool and in the test, but that doesn't work.</li>
  <li>Tried doing the same as a separate JDBC request, that didn't work either.</li>
  <li>Tried adding the commit to my update statement itself, no luck.</li>
  <li>Tried changing transaction isolation, but none of those values seem to make
  a difference.</li>
  <li>Tried opening a transaction with a pre-processor or a
  request or within the existing request, but that also hasn't helped.</li>
  </ul>
  <p>I assume my problem might be that the commit is going into a separate transaction from the actual update statements...but I can't find any way to change that...</p>