Hi Ian,
Not I. There are lots of 'us' around ;-)
Steve
Ian Blavins wrote:
G'day
Most unlikely but you wouldn't be the Steve Miller who used to work for Clark
County NV would you ?
Ian Blavins
Software performance specialist
.
TEMENOS
The Banking Software Company
.
PeopleBuilding 2, Maylands Av
Hemel Hempstead UK HP2 4NW
.
T: +44 (0) 1442 431 106
E: [EMAIL PROTECTED]
.
www.temenos.com
.
Consider the environment. Please don't print this e-mail unless you really
need to.
-----Original Message-----
From: Steve Miller [mailto:[EMAIL PROTECTED]
Sent: Monday, 3 March 2008 3:42 PM
To: jmeter-user@jakarta.apache.org
Subject: JDBC Batch insert
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]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
