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”)

.feed(data)
.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 akka.actor.Actor$class.aroundReceive(Actor.scala:465)
at io.gatling.core.akka.BaseActor.aroundReceive(BaseActor.scala:24)
at akka.actor.ActorCell.receiveMessage(ActorCell.scala:516)
at akka.actor.ActorCell.invoke(ActorCell.scala:487)
at akka.dispatch.Mailbox.processMailbox(Mailbox.scala:254)
at akka.dispatch.Mailbox.run(Mailbox.scala:221)
at akka.dispatch.Mailbox.exec(Mailbox.scala:231)
at scala.concurrent.forkjoin.ForkJoinTask.doExec(ForkJoinTask.java:260)
at scala.concurrent.forkjoin.ForkJoinPool$WorkQueue.pollAndExecAll(ForkJoinPool.java:1253)
at scala.concurrent.forkjoin.ForkJoinPool$WorkQueue.runTask(ForkJoinPool.java:1346)
at scala.concurrent.forkjoin.ForkJoinPool.runWorker(ForkJoinPool.java:1979)
at scala.concurrent.forkjoin.ForkJoinWorkerThread.run(ForkJoinWorkerThread.java:107)

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

Hi,

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.