Gatling JDBC feeders

Hi ,

I am facing an issue related to gatling , below I have copied only the relevant parts of my code

val data = jdbcFeeder(“jdbc:oracle:thin:@IP:HOST”,“XXX”,“XXXX”,“select orderdid from phtorder where orderdid = (select orderdid from phtorderassignment where orderitemdid =(select orderitemdid from phtorderitem where idencoding =‘071020150000753’))”)

val scn = scenario(“BatchCreateReturn”)

.exec(session => session.set(“orderdid”, data))

.formParam(“orderDids”, “${orderdid}”)

I am getting below error

Exception in thread “main” java.lang.IllegalStateException: Feeder is now empty, stopping engine
at io.gatling.core.action.SingletonFeed$$anonfun$receive$1.applyOrElse(SingletonFeed.scala:60)
at io.gatling.core.akka.BaseActor.aroundReceive(BaseActor.scala:24)
at akka.dispatch.Mailbox.processMailbox(Mailbox.scala:254)
at akka.dispatch.Mailbox.exec(Mailbox.scala:231)
at scala.concurrent.forkjoin.ForkJoinTask.doExec(
at scala.concurrent.forkjoin.ForkJoinPool$WorkQueue.pollAndExecAll(
at scala.concurrent.forkjoin.ForkJoinPool$WorkQueue.runTask(
at scala.concurrent.forkjoin.ForkJoinPool.runWorker(

If you need fast and reliable answers, you should consider getting a Support contract.


I got this error once. The cause was: no result return from the sql request.

Make sure your sql request returns some “orderdid” from the tables.