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?
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.set...@gmail.comwrote: 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?
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.set...@gmail.comwrote: 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.psgt...@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.set...@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?
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.psgt...@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.set...@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.psgt...@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.set...@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?
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 charan.set...@gmail.comwrote: 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.psgt...@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.set...@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.psgt...@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.set...@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
