# Multiple jdbc feeders, random strategy, the same selected db record

**URL:** <https://community.gatling.io/t/multiple-jdbc-feeders-random-strategy-the-same-selected-db-record/3186>\
**Category:** Gatling (Open-Source)\
**Created:** [August 10, 2016, 2:04pm UTC](https://community.gatling.io/t/multiple-jdbc-feeders-random-strategy-the-same-selected-db-record/3186 "2016-08-10T14:04:38Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Patrik\_Mihalcin](https://avatars.discourse-cdn.com/v4/letter/p/d6d6ee/32.png) [@Patrik\_Mihalcin](https://community.gatling.io/u/Patrik_Mihalcin)\
**Post date:** [August 10, 2016, 2:04pm UTC](https://community.gatling.io/t/multiple-jdbc-feeders-random-strategy-the-same-selected-db-record/3186/1 "2016-08-10T14:04:38Z")

</div>

Hi,  
I am trying to solve the following problem:

I have

val articleNumberFeeder = jdbcFeeder(jdbcUrl, jdbcUser, jdbcPasswd, “SELECT ARTICLE\_NUMBER FROM STM\_STATEMENT”).circular  
val periodStartFeeder = jdbcFeeder(jdbcUrl, jdbcUser, jdbcPasswd, “SELECT TO\_CHAR(PERIOD\_START\_DT,‘YYYY-MM-DD’) AS PERIOD\_START\_DT FROM STM\_STATEMENT”).circular  
val periodEndFeeder = jdbcFeeder(jdbcUrl, jdbcUser, jdbcPasswd, “SELECT TO\_CHAR(PERIOD\_END\_DT,‘YYYY-MM-DD’) AS PERIOD\_END\_DT FROM STM\_STATEMENT”).circular

The reason I use circular strategy is to make sure attributes returned from feeders are from the same db row.

But, I’d like to achieve random pick

Is there any way how to achieve this?

Thanks

---

<div class="post-metadata">

**Author:** ![Anupam\_Das](https://avatars.discourse-cdn.com/v4/letter/a/7bcc69/32.png) [@Anupam\_Das](https://community.gatling.io/u/Anupam_Das)\
**Post date:** [April 9, 2019, 1:42pm UTC](https://community.gatling.io/t/multiple-jdbc-feeders-random-strategy-the-same-selected-db-record/3186/2 "2019-04-09T13:42:31Z")

</div>

Hello Patrik,

Can you please send me the scenario section where you are using all these 3 feeders ?

Regards