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: [email protected] 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]
