Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

[BUG] Paging statement not support oracle 11g #35

Closed
zgcgwin opened this issue Sep 22, 2020 · 4 comments
Closed

[BUG] Paging statement not support oracle 11g #35

zgcgwin opened this issue Sep 22, 2020 · 4 comments

Comments

@zgcgwin
Copy link

zgcgwin commented Sep 22, 2020

Exception happened when execute query:

select * from jobrunr_jobs_stats ORDER BY total ASC OFFSET ? ROWS FETCH NEXT ? ROWS ONLY

The OFFSET syntax is not support in Oracle 11g.
@rdehuyss
Copy link
Contributor

rdehuyss commented Sep 22, 2020 •
edited

Hi, I'm afraid JobRunr supports Oracle 12c and up only which added support for the offset clause.

Are you still running on 11g? For the moment, I decided not to support it as it has seen end of live since 2015.

@zgcgwin
Copy link
Author

zgcgwin commented Sep 22, 2020

Release 11.2.0.1.0

@rdehuyss
Copy link
Contributor

Release 11.2.0.1.0

See my updated comment. Are there plans to upgrade your Oracle 11 version?

@zgcgwin
Copy link
Author

zgcgwin commented Sep 22, 2020

The version is determined by our customer.

@zgcgwin zgcgwin closed this as completed Sep 22, 2020
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
2 participants
@rdehuyss @zgcgwin