JMeter - JDBC Request

Card Puncher Data Processing

About

Basic information on the The inter-wiki (JmComp) does not exist and there is no default inter-wiki defined.JDBC Request.

Class Path

In the Test Plan Node, You can add you JDBC Driver or in the directory Jmeter_Home/lib

Jmeter Classpath

How to

get variable values

Simple Test Plan:

Jmeter Jdbc Confirguation Pool Variable Name

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

Jmeter Jdbc Request Select

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

Jmeter Debug Sampler Jdbc Variable

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

Support

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

Jmeter Jdbc Connection Configuration Pool







Share this page:
Follow us:
Task Runner