hi,
Thank you for ur reply
hey i got it, earlier i had not kept mysqlconnector.jar file in the lib
folder of jmeter and we have to specify the path in the environmental variables
so that when we call the database it will uses this files.
In view results tree we can see the query results that is data records of all
50 users and the response time.
cheers
sebb <[EMAIL PROTECTED]> wrote:
On 06/12/05, naveen gs wrote:
> Hi All,
> I am doing performance testing of a sql query, In the database of our web
> applicaton i have around 50 users i want to use jbbc request two retrieve all
> the 50 users records.
>
> The test plan looks like this
>
> Test Plan
> Jdbc Users(Thread Group)
> jdbc request ( From sampler)
>
> jdbc url: jdbc: mysql:/localhost:3306/databasename
> jdbc driver: org.gjt.mm.mysql.Driver
>
> i have entered passwd and username with
> # of connections in pool -50
> max Usage for each connection-50
>
> with sql query SELECT * FROM USERS;
>
> i have used two listeners to view the results
>
> 1. Graph Results
> 2. View results tree
>
> if i run this testplan, in View results tree i am getting requests
> in red color i.e the test plan has failed,
You mean the _sample_ has failed.
This could be because the view tree was originally intended for HTTP samples.
What else are you seeing? e.g. What are the response code and response message?
> so i want know how to retrieve these data and if it is retrieved where
> can i see all the 50 user's records
Did you set "Query only" to True or False?
> if anyone has worked on it pls reply ASAP
>
> Thanks in advance
>
> Naveen GS
>
>
> ---------------------------------
> Yahoo! DSL Something to write home about. Just $16.99/mo. or less
>
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------
Yahoo! Personals
Skip the bars and set-ups and start using Yahoo! Personals for free
