I think that each query should have its own JDBC Request sampler. Also, imho, having 1 query it makes writing the test plan and the various response assertions much easier.
http://jakarta.apache.org/jmeter/usermanual/build-db-test-plan.html Sharath Kumar wrote: > > Hi... > I need your help in JMeter as i got trapped in executing SQL queries in > JDBC Request. OK... Let me explain the scenario... > > I am doing performance testing for a java based application using > JMeter. My Applications Back end is SQL 2000 server which i configured > correctly in JDBC Connection Configuration also. I give inputs to the > application and save it. I record this process using SQL Profiler and get > some auto generated queries. I fetch and edit those queries according to > my use. I copy and paste those edited queries in JDBC Request. When i try > to run a (Select)query in JDBC Request, it works and i am happy. But if i > run the set of queries(Select, Insert, Update, Delete)together, it > executes the first query only. > > My doubt here is to select which "Query Type" in JDBC Request to execute > all the Queries as i mentioned above? > > Is there any methods to separate the queries(using commas)? > > I need to execute all the queries to evaluate the performance of that > particular operation. > Please help me to get through this problem... Waiting for your reply... > > Thanks & regards > -Sharath > > > > --------------------------------- > Any questions? Get answers on any topic at Yahoo! Answers. Try it now. > -- View this message in context: http://www.nabble.com/Help-Needed...-tf3034136.html#a8430938 Sent from the JMeter - User mailing list archive at Nabble.com. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
