Hey Felix,
Yes by default "Max Number of Connections" to "0". Let me explain my Config
& test plan hierarchy.. Under Thread group -> CSV Data Set config, Jdbc
request & View Results Tree components are added as per mentioned order.
*1. Thread group* : No of threads: 2 ; Ramp up time : 1 Sec ; Loop count
:2
*2. CSV Data Set Config *- *Filename*: changelog_mysql.sql ; *Variable name*:
conn ;* ignore first line:*false ; *Allow quoted data*: false ; *Recycle on
EOF:* True; *Stop thread on Eof *; *sharing mode*: All threads
*3. **Jdbc request - Query* *: *${conn} ; *Handle Resultset* : Store as
String
*4*. *JDBC config *:*Connection Pool Configuration : Max no of connections*:
0 ; *Transaction isolation* : default & rest of settings of this config are
kept same as by default.
So problem statement is --- query#1 is getting executed twice for User 1 &
query#2( next query ) is getting twice executed for User 2.
*But what I want is that --query #1 & query#2 should get executed for User
1 & User 2*
On Mon, Aug 20, 2018 at 5:19 PM, Felix Schumacher <
felix.schumac...@internetallee.de> wrote:
>
>
> Am 20.08.2018 um 12:23 schrieb Prateek Dua:
>
>> Hi,
>>
>> I'm trying to execute DB queries ( input via CSV Config file) for
>> multiple Users. But problem is that for every user , query is getting
>> executed as per single row i.e. row 1 query is getting executed for User
>> 1; row 2 query is getting executed for User 2 ..
>>
>> What I needed is that row 1 query & row 2 query should get execute for
>> both User 1 & User 2. please find attached screenshots of Test Plan.
>>
> Screenshots get regularly removed by the mailing list, so we can't see
> your screenshot. Try to describe what you see by text, only.
>
> Have you tried to set "Max Number of Connections" to "0"? See
> http://jmeter.apache.org/usermanual/component_reference.
> html#JDBC_Connection_Configuration for more information about the
> possible values of that field.
>
> Regards,
> Felix
>
>
>>
>>
>>
>>
>> ::DISCLAIMER::
>>
>> ------------------------------------------------------------
>> ------------------------------------------------------------
>> ----------------------------
>>
>>
>> This message is intended only for the use of the addressee and may
>> contain information that is privileged, confidential and exempt from
>> disclosure under applicable law. If the reader of this message is not the
>> intended recipient, or the employee or agent responsible for delivering the
>> message to the intended recipient, you are hereby notified that any
>> dissemination, distribution or copying of this communication is strictly
>> prohibited. If you have received this e-mail in error, please notify us
>> immediately by return e-mail and delete this e-mail and all attachments
>> from your system.
>>
>>
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: user-unsubscr...@jmeter.apache.org
>> For additional commands, e-mail: user-h...@jmeter.apache.org
>>
>
>
--
::DISCLAIMER::
----------------------------------------------------------------------------------------------------------------------------------------------------
This message is intended only for the use of the addressee and may
contain information that is privileged, confidential and exempt from
disclosure under applicable law. If the reader of this message is not the
intended recipient, or the employee or agent responsible for delivering the
message to the intended recipient, you are hereby notified that any
dissemination, distribution or copying of this communication is strictly
prohibited. If you have received this e-mail in error, please notify us
immediately by return e-mail and delete this e-mail and all attachments
from your system.
