Are you not using a separate jdbc sampler for each query?
I am doing a similar test and since a single thread executes 8300
queries, I'm using a csv file with a single query per line and a csv
dataset to loop through the queries .... Each thread uses a copy (not
really, i use symlinks) of the csv file.
i have a bit of BeanSheel script in the single jdbc sampler that
looks at the query and sets the query type accordingly.
It sounds to me like you are putting multiple queries in one single
jdbc sampler, so you need to either use one sampler per query or do
something like i'm doing (one sampler but one query at a time)....
I hope this helps!
On Jan 18, 2007, at 7:24 AM, 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.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
