JDBCSamplerController is currently the only alternative Sampler that JMeter comes with (actually, there is an FTPSamplerController,
but JMeter is not configured to make it available in the GUI by default).
The GUI for JDBCSamplerController lets you do the following:
- Enter a username
- Enter a username that JMeter should use to connect to the database.
- Enter a password
- Enter a password that JMeter should use to connect to the database.
- Enter connect string
- Enter a connect string, or "URL" for JMeter to use to connect to the database.
example: jdbc:mysql://domain.com:3306/databasename
- Enter driver
- Enter a driver class name. example: org.mm.gjt.mysql.Driver
- Enter SQL query
- Enter an SQL query string - example: select * from users where username='jsmith'
The JDBCSamplerController will submit your SQL string to the database with as many threads as you selected in the
thread group panel. Currently, this is the extent of the functionality of the JDBCSamplerController.