jmeter-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Lukáš Šembera <>
Subject JDBC sampler with multiple users
Date Tue, 08 Apr 2014 15:11:47 GMT

I would like to test the database using JDBC with a certain amount of
distinct concurrent users (e.g. test_user_{1-100}).

I created a thread group with JDBC connection configuration where username
was defined as: "test_user_{$__threadNum}". Unfortunately this doesn't work
because __threadNum is not accessible in configuration elements (in other
words there is a single JDBC connection pool with N max connections for the
whole thread pool, whereas I probably need N JDBC connection pools with 1
max connections).

I was thiking about the Only Once Controller to define my resource pool
before actual queries are sent to the database, but I'm stuck again because
it is not possible to create JDBC connection configuration with username
such as test_user_{$someThreadScopedVariable}.

Any suggestions and hints are welcome.

Thank you.

  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message