spring-projects / spring-projects/spring-batch
SybasePagingQueryProvider's windowing approach does not work for Sybase ASE [BATCH-1580]
Nobody has claimed this yet.
- Dominant language
- Java
- Stars
- 3k
- Forks
- 2.5k
- Avg merge
- 6d 53m
- Merged PRs (30d)
- 3
Description
Morten Andersen-Gott opened BATCH-1580 and commented
The windowing approach to paging in SybasePagingQueryProvider does not work for Sybase Adaptive Server Enterprise (ASE), only for Sybase Anywhere. Sybase ASE the product for larger enterprise system, while Sybase Anywhere is for smaller systems. Not sure if one should differentiate between ASE and Anywhere or create a PagingQueryProvider that works for both.
I came over this issue when using Spring Batch Admin and browsing the next 20 job executions. Stacktrace attached.
Affects: 2.1.1
Attachments:
- sybasepagingquery_stacktrace.txt (6.39 kB)
Contributor guide
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Research direction
Start with SybasePagingQueryProvider and inspect the attached sybasepagingquery_stacktrace.txt, using the Spring Batch Admin browsing flow as the reproduction context. Determine whether paging should distinguish Sybase ASE from Sybase Anywhere or support both, then verify that browsing the next 20 job executions works on Sybase ASE.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- java, sql
- Domain
- backend, database
- Issue type
- Bug
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Activity status
- Stale
- Clarity
- Needs clarification
- Newbie friendliness
- 32/100