Hi
you need sharing mode "Current thread" if you want each thread to read the
same data
https://jmeter.apache.org/usermanual/component_reference.html#CSV_Data_Set_Config
- See sharing mode
On Mon, Aug 20, 2018 at 6:53 AM Prateek Dua <prateek....@go-mmt.com> wrote:
> 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.
>
