You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@jmeter.apache.org by charan sethi <ch...@gmail.com> on 2014/01/23 06:57:51 UTC
How to ensure the values i submitted with the request have saved in
the required db table using jmeter?
I want to check if 1000 concurrent users log in a website within a
specified period of time and register and provide payment details then for
every User i wanna check the details submitted in the database are
accurate for each user.
Is it possible that i can add a JDBC request which can provide me the
details for every user immediately after the registeration for the user is
complete.
I know this would increase my response time but that is not an issue for
us.
I need to do a functional test where if 1000 users register than for all
these users accurate details get stored. the criteria is to ensure that if
concurrent registerations take place the data for users is accurate and
information does not get mixed up for the users if they access the site
concurrently under load.
Is there any other better approach of doing this with jmeter?
Thanks
Re: How to ensure the values i submitted with the request have saved
in the required db table using jmeter?
Posted by charan sethi <ch...@gmail.com>.
i want to fully achieve this through jmeter. For every user registration
that takes place and the details saved in the database can be verified
based on the registration request. So how can i achieve this in the most
optimized manner. Thank you Naveen for your quick reply but i'd really
appreciate if you can help me achieve this with the help of jmeter.
On Thu, Jan 23, 2014 at 12:27 PM, charan sethi <ch...@gmail.com>wrote:
> I wanna make sure that the test continues only if accurate details per
> user are submitted. Querying the database and comparing is a solution but i
> would prefer automating this instead.
>
>
> On Thu, Jan 23, 2014 at 12:15 PM, NaveenKumar Namachivayam <
> catchnaveen.psgtech@gmail.com> wrote:
>
>> I hope you have access to DB. Query it from DB. Do not use the Jmeter for
>> validation.
>>
>>
>> On Thu, Jan 23, 2014 at 12:07 PM, charan sethi <charan.sethi1@gmail.com
>> >wrote:
>>
>> > But i need to do this for concurrent 1000 users. How do i achieve this
>> > approach. How to extract the unique ID and Timestamp when i run 1000
>> users
>> > with a ramp up of 10 minutes. Can you please elaborate a little.
>> >
>> >
>> > On Thu, Jan 23, 2014 at 11:51 AM, NaveenKumar Namachivayam <
>> > catchnaveen.psgtech@gmail.com> wrote:
>> >
>> > > After the execution is done, you can query the details from the
>> database,
>> > > instead of adding JDBC step in your test plan.
>> > >
>> > > I hope each payment will have an unique id. Before run your test note
>> > down
>> > > the latest ID and its timestamp. After the run again note down the
>> > values.
>> > > So that you can find the difference.
>> > >
>> > > I feel this is better approach. Thanks!
>> > >
>> > > NaveenKumar N
>> > > Excellent Jmeter Training. Register www.QAInsights.com/services
>> > >
>> > >
>> > > On Thu, Jan 23, 2014 at 11:27 AM, charan sethi <
>> charan.sethi1@gmail.com
>> > > >wrote:
>> > >
>> > > > I want to check if 1000 concurrent users log in a website within a
>> > > > specified period of time and register and provide payment details
>> then
>> > > for
>> > > > every User i wanna check the details submitted in the database are
>> > > > accurate for each user.
>> > > >
>> > > > Is it possible that i can add a JDBC request which can provide me
>> the
>> > > > details for every user immediately after the registeration for the
>> user
>> > > is
>> > > > complete.
>> > > >
>> > > > I know this would increase my response time but that is not an
>> issue
>> > for
>> > > > us.
>> > > >
>> > > > I need to do a functional test where if 1000 users register than for
>> > all
>> > > > these users accurate details get stored. the criteria is to ensure
>> that
>> > > if
>> > > > concurrent registerations take place the data for users is accurate
>> and
>> > > > information does not get mixed up for the users if they access the
>> site
>> > > > concurrently under load.
>> > > >
>> > > > Is there any other better approach of doing this with jmeter?
>> > > >
>> > > > Thanks
>> > > >
>> > >
>> > >
>> > >
>> > > --
>> > > Thank you,
>> > >
>> > > Regards,
>> > > NaveenKumar N
>> > > Visit www.QAInsights.com and www.Testifications.com and
>> > www.MyTechCube.com
>> > >
>> >
>>
>>
>>
>> --
>> Thank you,
>>
>> Regards,
>> NaveenKumar N
>> Visit www.QAInsights.com and www.Testifications.com and
>> www.MyTechCube.com
>>
>
>
Re: How to ensure the values i submitted with the request have saved
in the required db table using jmeter?
Posted by charan sethi <ch...@gmail.com>.
I wanna make sure that the test continues only if accurate details per user
are submitted. Querying the database and comparing is a solution but i
would prefer automating this instead.
On Thu, Jan 23, 2014 at 12:15 PM, NaveenKumar Namachivayam <
catchnaveen.psgtech@gmail.com> wrote:
> I hope you have access to DB. Query it from DB. Do not use the Jmeter for
> validation.
>
>
> On Thu, Jan 23, 2014 at 12:07 PM, charan sethi <charan.sethi1@gmail.com
> >wrote:
>
> > But i need to do this for concurrent 1000 users. How do i achieve this
> > approach. How to extract the unique ID and Timestamp when i run 1000
> users
> > with a ramp up of 10 minutes. Can you please elaborate a little.
> >
> >
> > On Thu, Jan 23, 2014 at 11:51 AM, NaveenKumar Namachivayam <
> > catchnaveen.psgtech@gmail.com> wrote:
> >
> > > After the execution is done, you can query the details from the
> database,
> > > instead of adding JDBC step in your test plan.
> > >
> > > I hope each payment will have an unique id. Before run your test note
> > down
> > > the latest ID and its timestamp. After the run again note down the
> > values.
> > > So that you can find the difference.
> > >
> > > I feel this is better approach. Thanks!
> > >
> > > NaveenKumar N
> > > Excellent Jmeter Training. Register www.QAInsights.com/services
> > >
> > >
> > > On Thu, Jan 23, 2014 at 11:27 AM, charan sethi <
> charan.sethi1@gmail.com
> > > >wrote:
> > >
> > > > I want to check if 1000 concurrent users log in a website within a
> > > > specified period of time and register and provide payment details
> then
> > > for
> > > > every User i wanna check the details submitted in the database are
> > > > accurate for each user.
> > > >
> > > > Is it possible that i can add a JDBC request which can provide me
> the
> > > > details for every user immediately after the registeration for the
> user
> > > is
> > > > complete.
> > > >
> > > > I know this would increase my response time but that is not an issue
> > for
> > > > us.
> > > >
> > > > I need to do a functional test where if 1000 users register than for
> > all
> > > > these users accurate details get stored. the criteria is to ensure
> that
> > > if
> > > > concurrent registerations take place the data for users is accurate
> and
> > > > information does not get mixed up for the users if they access the
> site
> > > > concurrently under load.
> > > >
> > > > Is there any other better approach of doing this with jmeter?
> > > >
> > > > Thanks
> > > >
> > >
> > >
> > >
> > > --
> > > Thank you,
> > >
> > > Regards,
> > > NaveenKumar N
> > > Visit www.QAInsights.com and www.Testifications.com and
> > www.MyTechCube.com
> > >
> >
>
>
>
> --
> Thank you,
>
> Regards,
> NaveenKumar N
> Visit www.QAInsights.com and www.Testifications.com and www.MyTechCube.com
>
Re: How to ensure the values i submitted with the request have saved
in the required db table using jmeter?
Posted by NaveenKumar Namachivayam <ca...@gmail.com>.
I hope you have access to DB. Query it from DB. Do not use the Jmeter for
validation.
On Thu, Jan 23, 2014 at 12:07 PM, charan sethi <ch...@gmail.com>wrote:
> But i need to do this for concurrent 1000 users. How do i achieve this
> approach. How to extract the unique ID and Timestamp when i run 1000 users
> with a ramp up of 10 minutes. Can you please elaborate a little.
>
>
> On Thu, Jan 23, 2014 at 11:51 AM, NaveenKumar Namachivayam <
> catchnaveen.psgtech@gmail.com> wrote:
>
> > After the execution is done, you can query the details from the database,
> > instead of adding JDBC step in your test plan.
> >
> > I hope each payment will have an unique id. Before run your test note
> down
> > the latest ID and its timestamp. After the run again note down the
> values.
> > So that you can find the difference.
> >
> > I feel this is better approach. Thanks!
> >
> > NaveenKumar N
> > Excellent Jmeter Training. Register www.QAInsights.com/services
> >
> >
> > On Thu, Jan 23, 2014 at 11:27 AM, charan sethi <charan.sethi1@gmail.com
> > >wrote:
> >
> > > I want to check if 1000 concurrent users log in a website within a
> > > specified period of time and register and provide payment details then
> > for
> > > every User i wanna check the details submitted in the database are
> > > accurate for each user.
> > >
> > > Is it possible that i can add a JDBC request which can provide me the
> > > details for every user immediately after the registeration for the user
> > is
> > > complete.
> > >
> > > I know this would increase my response time but that is not an issue
> for
> > > us.
> > >
> > > I need to do a functional test where if 1000 users register than for
> all
> > > these users accurate details get stored. the criteria is to ensure that
> > if
> > > concurrent registerations take place the data for users is accurate and
> > > information does not get mixed up for the users if they access the site
> > > concurrently under load.
> > >
> > > Is there any other better approach of doing this with jmeter?
> > >
> > > Thanks
> > >
> >
> >
> >
> > --
> > Thank you,
> >
> > Regards,
> > NaveenKumar N
> > Visit www.QAInsights.com and www.Testifications.com and
> www.MyTechCube.com
> >
>
--
Thank you,
Regards,
NaveenKumar N
Visit www.QAInsights.com and www.Testifications.com and www.MyTechCube.com
Re: How to ensure the values i submitted with the request have saved
in the required db table using jmeter?
Posted by charan sethi <ch...@gmail.com>.
But i need to do this for concurrent 1000 users. How do i achieve this
approach. How to extract the unique ID and Timestamp when i run 1000 users
with a ramp up of 10 minutes. Can you please elaborate a little.
On Thu, Jan 23, 2014 at 11:51 AM, NaveenKumar Namachivayam <
catchnaveen.psgtech@gmail.com> wrote:
> After the execution is done, you can query the details from the database,
> instead of adding JDBC step in your test plan.
>
> I hope each payment will have an unique id. Before run your test note down
> the latest ID and its timestamp. After the run again note down the values.
> So that you can find the difference.
>
> I feel this is better approach. Thanks!
>
> NaveenKumar N
> Excellent Jmeter Training. Register www.QAInsights.com/services
>
>
> On Thu, Jan 23, 2014 at 11:27 AM, charan sethi <charan.sethi1@gmail.com
> >wrote:
>
> > I want to check if 1000 concurrent users log in a website within a
> > specified period of time and register and provide payment details then
> for
> > every User i wanna check the details submitted in the database are
> > accurate for each user.
> >
> > Is it possible that i can add a JDBC request which can provide me the
> > details for every user immediately after the registeration for the user
> is
> > complete.
> >
> > I know this would increase my response time but that is not an issue for
> > us.
> >
> > I need to do a functional test where if 1000 users register than for all
> > these users accurate details get stored. the criteria is to ensure that
> if
> > concurrent registerations take place the data for users is accurate and
> > information does not get mixed up for the users if they access the site
> > concurrently under load.
> >
> > Is there any other better approach of doing this with jmeter?
> >
> > Thanks
> >
>
>
>
> --
> Thank you,
>
> Regards,
> NaveenKumar N
> Visit www.QAInsights.com and www.Testifications.com and www.MyTechCube.com
>
Re: How to ensure the values i submitted with the request have saved
in the required db table using jmeter?
Posted by NaveenKumar Namachivayam <ca...@gmail.com>.
After the execution is done, you can query the details from the database,
instead of adding JDBC step in your test plan.
I hope each payment will have an unique id. Before run your test note down
the latest ID and its timestamp. After the run again note down the values.
So that you can find the difference.
I feel this is better approach. Thanks!
NaveenKumar N
Excellent Jmeter Training. Register www.QAInsights.com/services
On Thu, Jan 23, 2014 at 11:27 AM, charan sethi <ch...@gmail.com>wrote:
> I want to check if 1000 concurrent users log in a website within a
> specified period of time and register and provide payment details then for
> every User i wanna check the details submitted in the database are
> accurate for each user.
>
> Is it possible that i can add a JDBC request which can provide me the
> details for every user immediately after the registeration for the user is
> complete.
>
> I know this would increase my response time but that is not an issue for
> us.
>
> I need to do a functional test where if 1000 users register than for all
> these users accurate details get stored. the criteria is to ensure that if
> concurrent registerations take place the data for users is accurate and
> information does not get mixed up for the users if they access the site
> concurrently under load.
>
> Is there any other better approach of doing this with jmeter?
>
> Thanks
>
--
Thank you,
Regards,
NaveenKumar N
Visit www.QAInsights.com and www.Testifications.com and www.MyTechCube.com