Replies: 2 comments 4 replies
-
We have seen something similar with H2 and are actively working on a resolution. This looks like it is happening with the JPA store. If it is the same issue, you can work around this temporarily by disabling scrollable iterators. That can be done in Elide 6 by setting the last parameter in the You would need to pull in Elide 6 (the constructor parameter doesn't exit in 5) and override the bean above. |
Beta Was this translation helpful? Give feedback.
1 reply
-
We believe this is the fix: |
Beta Was this translation helpful? Give feedback.
3 replies
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
-
Using Elide (5.1.0) with a Postgres database, I'm trying to incorporate the async api into my project. The asyncQuery and tableExport endpoints seem to work fine when I use the default page size. When I add pagination to the tableExport request, I still get a response back but it only includes 1 row and in the logs I'm receiving a CompositeException that basically says the ResultSet is closed. Am I missing something?
Request:
{ "data": { "type": "tableExport", "id": "ba31ca4e-ed8f-4be0-a0f3-12088fa9263a", "attributes": { "query": "/example?page%5Btotals%5D=true&page%5Bnumber%5D=1&page%5Bsize%5D=10&sort=startDate", "queryType": "JSONAPI_V1_0", "status": "QUEUED", "resultType": "CSV" } } }
application.yml
elide: modelPackage: 'example.api.domain' pageSize: 10 maxPageSize: 500 json-api: path: ${API_PREFIX:/api} enabled: true swagger: path: ${SWAGGER_PATH:/doc} enabled: ${SWAGGER_ENABLED:true} name: @artifactId@ #version: @version@ async: enabled: true threadPoolSize: 5 maxRunTime: 65 cleanupEnabled: true queryCleanupDays: 2 defaultAsyncQueryDAO: true export: enabled: true path: /export skipCSVHeader: false storageDestination: /tmp aggregation-store: enabled: false default-dialect: Postgres enableMetaDataStore: false dynamic-config: path: src/main/resources/analytics enabled: false
Logs:
Beta Was this translation helpful? Give feedback.
All reactions