[
Date Prev][
Date Next][
Thread Prev][
Thread Next][
Date Index][
Thread Index]
[
List Home]
Re: [eclipselink-users] Oracle: Anyway to disable FIRST_ROWS hint on paginated queries?
|
Hi Tim,
Try using a session customizer and calling:
((DatabasePlatform)session.getDatasourcePlatform()).setShouldUseRownumFiltering(false)
-Tom
Tim Hollosy wrote:
We've run into a situation where the FIRST_ROWS hint is causing major
pain, selecting against a view. Worked fine on our 10g database,
production is 9i though and it's just dying on 9i, any clue on how to
tell eclipselink to leave the hint out? When I leave it out, the query
runs fine. I saw a post from 2009 that said it wasn't possible to
disable it without modifying EL source.
As an alternative, any oracle wizards now how I might tell Oracle to
ignore that hint?
Thanks,
Tim
------------------------------------------------------------------------
_______________________________________________
eclipselink-users mailing list
eclipselink-users@xxxxxxxxxxx
https://dev.eclipse.org/mailman/listinfo/eclipselink-users