Jmeter JDBC Connection Configuration Parametrization of Database URL for accessing MySQL Database

Question

How to parametrize Database URL under JDBC Connection Configuration? Normal parametrization is not working here.

This doesn't work:

Database URL: jdbc:mysql://${mysql_hostname}:${mysql_port}/${mysql_database}
JDBC Driver Class: com.mysql.jdbc.Driver
Username: ${mysql_username}
Password: ${mysql_username}

Answer 1

The point is that JDBC Connection Configuration test element is being initialized before JMeter Variables so if you want to parameterize it you should be doing it a little bit differently to wit:

• Use __P() function where required like:

  Database URL: jdbc:mysql://${__P(mysql_hostname,)}:${__P(mysql_port,)}/${__P(mysql_database,)}
  JDBC Driver Class: com.mysql.jdbc.Driver
  Username: ${__P(mysql_username,)}
  Password: ${__P(mysql_password,)}
  

The relevant JMeter Properties can be set either in user.properties file like:

mysql_hostname=localhost
mysql_port=3306
mysql_database=test
mysql_username=johndoe
mysql_passowrd=secret

Or via -J command-line argument like:

jmeter -Jmysql_hostname=localhost -Jmysql_port=3306 -Jmysql_database=test -Jmysql_usename=johndoe -Jmysql_password=secret

See Apache JMeter Properties Customization Guide for more information on JMeter Properties and ways of setting and overriding them

Answer 2

in Jmeter (5.1.1) you can use 'User Defined Variables'. Add-> Config Element -> User Defined Variables.