databaseflow icon indicating copy to clipboard operation
databaseflow copied to clipboard

java.lang.IllegalStateException: No limit support for engine [oracle].

Open Shoelace opened this issue 5 years ago • 0 comments

it says in the doco that you havent tested against oracle. well i just did and it didnt work. (see stack track below)

I'm assuming its trying to use the oracle 12c feature "LIMIT/FETCH" but i was using 11g

is 12c a pre-req? or could this be turned of for 11g back ends?

java.lang.IllegalStateException: No limit support for engine [oracle].
        at models.engine.EngineQueries$.selectFrom(EngineQueries.scala:39)
        at services.query.RowDataHelper$.work$1(RowDataHelper.scala:17)
        at services.query.RowDataHelper$.$anonfun$showDataResponse$13(RowDataHelper.scala:60)
        at scala.concurrent.Future$.$anonfun$apply$1(Future.scala:654)
        at scala.util.Success.$anonfun$map$1(Try.scala:251)
        at scala.util.Success.map(Try.scala:209)
        at scala.concurrent.Future.$anonfun$map$1(Future.scala:288)
        at scala.concurrent.impl.Promise.liftedTree1$1(Promise.scala:29)
        at scala.concurrent.impl.Promise.$anonfun$transform$1(Promise.scala:29)
        at scala.concurrent.impl.CallbackRunnable.run(Promise.scala:60)
        at java.util.concurrent.ForkJoinTask$RunnableExecuteAction.exec(Unknown Source)
        at java.util.concurrent.ForkJoinTask.doExec(Unknown Source)
        at java.util.concurrent.ForkJoinPool$WorkQueue.runTask(Unknown Source)
        at java.util.concurrent.ForkJoinPool.runWorker(Unknown Source)
        at java.util.concurrent.ForkJoinWorkerThread.run(Unknown Source)

Shoelace avatar Nov 22 '18 06:11 Shoelace