Some Eclipse Foundation services are deprecated, or will be soon. Please ensure you've read this important communication.
Bug 358608 - Cursors don't work with partitioned databases but use the default connection
Summary: Cursors don't work with partitioned databases but use the default connection
Status: NEW
Alias: None
Product: z_Archived
Classification: Eclipse Foundation
Component: Eclipselink (show other bugs)
Version: unspecified   Edit
Hardware: PC Windows XP
: P2 normal with 1 vote (vote)
Target Milestone: ---   Edit
Assignee: Project Inbox CLA
QA Contact:
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2011-09-22 11:21 EDT by Michael Pflueger CLA
Modified: 2022-06-09 10:10 EDT (History)
1 user (show)

See Also:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Michael Pflueger CLA 2011-09-22 11:21:09 EDT
Build Identifier: 2.3 nightly

CursoredStreams (and thus probably also Scrollablecursors which were not tested) always seem to use the default connection pool ina  partitioned DB environment, thus they don't adhere to the partitioning policies in effect.

Those two features share a common use case, handling of large tables/datasets, where you probably want to have both cursors and partitioning.
That's why i think fixing this would make eclipselink much better suited for this use case.

Fixing this even for UnionPartition probably would require some more work but would be nice aswell.

Reproducible: Always

Steps to Reproduce:
1. Apply a partitioning policy to your model or supply a policy with a queryhint
2. load data from a partitioned table using cursors
3.
Comment 1 Michael Pflueger CLA 2011-09-22 11:33:19 EDT
What i forgot to mention, i use PostgreSQL as database and thus i can only use cursors in a transaction context.
i thus call em.getTransaction().begin() and jpaEm.getUnitOfWork().beginEarlyTransaction() before starting the query.
Comment 2 Tom Ware CLA 2011-10-31 13:31:19 EDT
Setting target and priority.  See the following page for the meanings of these fields:

http://wiki.eclipse.org/EclipseLink/Development/Bugs/Guidelines

Community: Please vote for this bug if it is important to you.  Votes are one of the main criteria we use to determine which bugs to fix next.
Comment 3 Eclipse Webmaster CLA 2022-06-09 10:10:10 EDT
The Eclipselink project has moved to Github: https://github.com/eclipse-ee4j/eclipselink