On 03/03/2008, Steve Miller <[EMAIL PROTECTED]> wrote: > 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?
Not at present. One could put the insert values in a file and loop over them with an Insert statement. If the batch feature was to be added, how would you expect the input data to be defined? > 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, If there are a lot of rows to be added, I would probably do this before starting the test using whatever utility is most suitable. > Steve > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
