Mailing-List: contact user-help@jmeter.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "JMeter Users List" <user@jmeter.apache.org>
Received-SPF: pass (nike.apache.org: domain of semberal@gmail.com designates
 209.85.216.174 as permitted sender)
MIME-Version: 1.0
Date: Tue, 8 Apr 2014 17:11:47 +0200
Message-ID: 
 <CALHpz2FvxNV_AYj0XWLM4FxDOQ-zhPRL8zoNZaXgtMGuW9AEvA@mail.gmail.com>
Subject: JDBC sampler with multiple users
From: =?ISO-8859-2?Q?Luk=E1=B9_=A9embera?= <semberal@gmail.com>
To: user@jmeter.apache.org
Content-Type: multipart/alternative; boundary=047d7bdc7fc61eaf8204f68967a7

--047d7bdc7fc61eaf8204f68967a7
Content-Type: text/plain; charset=ISO-8859-1

Hi,

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.

--047d7bdc7fc61eaf8204f68967a7--