Is it possible to have a JMeter script that would load and cycle through HTTP recorded tests? I want to control what is monitored via a SQL DB that would release what sites and variables that are to be used by the script. That would include an appropriate HTTP Recorded Test. I don't want to have multiple scripts or one hugely long script to monitor these sites. I know I can do it with just the HTTP status checks, but I need to do some in-depth synthetic transactions to control these sites adequately. It would be a lot easier to automate things like maintenance modes, decommissions, and recording script modifications if I can do it this way.
0
votes
don't get from your description - you already got your http requests recorded? stored in the database? and you want to pull it out & configure to run dynamically from JMeter?
- Yuri G
The goal is a generic script that will get it's variables from a csv file created by a SQL server. The file will contain all the information for the monitoring script. Since I can't guarantee that the sites to use the same template for login and transactions, each one would have to be recorded. I want to specify a local path to each recording. So in essence, I want to do individual recordings, save them to individual files, and have the monitoring script load and execute them (much like a variable from a csv file would be loaded).
- SGG
1 Answers
0
votes
You can execute SQL statements like INSERT or UPDATE using JMeter. You will need to:
- Add the relevant JDBC driver for your database somewhere to JMeter Classpath and restart JMeter to pick the driver up
- Add JDBC Connection Configuration element to your Test Plan and specify database URL and credentials there
Use one of the following Test Elements:
Assuming all above you should be able to run the necessary SQL queries and store what you need.
See The Real Secret to Building a Database Test Plan With JMeter for detailed instructions and example.
