The JDBC Test controller is a generative controller whose function is to create a single test case for FTP applications.
The JDBC Test allows you to configure an FTP sample:
- Username: Username to use to connect to server
- Password: Password to user to connect to server
- Database URL: This includes the host name plus database name. It should be in the correct format for the database being tested (usually hostname/database name)
- Sub Protocol: The sub-protocol to use with your specific database (ie "mysql" for MySQL)
- Driver Class: The full class name of your driver (ie org.gjt.mm.mysql.Driver)
- Number of Connections in Pool: JMeter will use a pool of connections that you can configure. Set here how many connections you would like the pool to maintain
- Max usage for each connection: JMeter will automatically re-initialize SQL connections that have been used a certain number of times. You can change the max usage for each connection here.
- SQL Query String: Finally, the actual SQL query you want to test.
Note: If you were going to test multiple SQL queries, you would probably want to add a "Database Login" config element to the top of your test tree, and configure the username, password, database URL, sub-protocol, and Driver class in just the one place. You can similarly add a "Database Connection Pool" config element.