I've got some JDBC samplers running, and for one of them what I really
want to do is a prepared statement that inserts many (from 10 to 100)
rows at once. JDBC has the PreparedStatement.addBatch() method, along
with PreparedStatement.executeBatch(). Is there a convenient way to do
the equivalent with JMeter? I've seen an Oracle 'kludge' that allows you
to do a 'batch insert' with an sql statement like:
INSERT INTO table (column 1, column 2) VALUES (
select value1a, value2a from dual union all
select value1b, value2b from dual union all
...
select value1...,value2... from dual
);
but that would clearly get very awkward at best using the parameter
values and parameter type input fields on the JDBC sampler.
thanks,
Steve
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
