Gatling JDBC feeders

[Kush]

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)

[Stéphane LANDELLE]

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

Stéphane Landelle

Lead developer

slan...@gatling.io

--
You received this message because you are subscribed to the Google Groups "Gatling User Group" group.
To unsubscribe from this group and stop receiving emails from it, send an email to gatling+u...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[CHEN YANQING]

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.