Passing a variable from Taurus yaml file to Jmeter script to switch JDBC connection

Question

I currently have a jmeter script which I would like to switch it's jdbc connections in the script, by passing a variable at runtime through the taurus yaml.

The aim is to switch environment by setting the variable in the yaml.

Using the guide provided by Taurus, I created an environment variable under settings in the yaml file as follows:

settings: env: ENV_VARIABLE: randomvariabletest

Then using the variable, I call on that in the Jmeter script as follows

I want the JDBC request to then call the JDBC connection which I have named as randomvariabletest. I was expecting that the JDBC request would read the value which I passed in.

This doesn't work as expected as I am getting the following error:

java.lang.IllegalArgumentException: Variable Name must not be null in GET MAX ORDER ID

What am I doing wrong here, any help would be appreciated.

Answer 1

You're using wrong function, __P() function reads a JMeter Property and if you plan to use JMeter Properties for parameterization you need to follow this chapter

If you plan to continue using environment variables you either need to:

• either use __env() custom JMeter Function like ${__env(ENV_VARIABLE,,)}
• or go for __groovy() built-in function like ${__groovy(System.getenv('ENV_VARIABLE'),)}

Answer 2

Variable Name for connection pool in JDBC Connection Configuration elements must match with the Variable Name of Pool declared in JDBC Connection Configuration in JDBC Request

Connections and JDBC Requests are connected using this variable.