JMeter - JDBC Request

get variable values

Simple Test Plan:

• A Thread Group
  • A usermanual/component_reference.html
  • A JmComp>#JDBC Connection Configuration|JDBC Connection Configuration]]

You have to enter in the database connection configuration the JDBC URL and the Driver Class

• A JDBC Request with the same pool name than the configuration (Pool1) and with Variables

select 11 as FirstColumn, 21 as SecondColumn from dual
union
select 12, 22  from dual
union
select 13, 23  from dual

• A Debug Sampler
• A View Results Tree A View Result Tree is needed to view the result of the Debug Sampler

You can then use this variable in a new component such as a JDBC Request with for instance the following SQL:

select ${FirstVariableName_1} from dual

It will return:

11

Could not create enough Components to service your request (Timed out)

You may get this error in the Response data

Could not create enough Components to service your request (Timed out).

and this exception in the sampler result

org.apache.avalon.excalibur.datasource.NoAvailableConnectionException

It means that a users (threads) can not get a Jdbc Connection in your thread pool when the wait time of the Pool Timeout is over, you get this message.

To resolve this problem, you can try to increase :

• the number of database connection in your pool
• the Pool Time out