Some Eclipse Foundation services are deprecated, or will be soon. Please ensure you've read this important communication.

Bug 358608

Summary:	Cursors don't work with partitioned databases but use the default connection
Product:	z_Archived	Reporter:	Michael Pflueger <michael.pflueger>
Component:	Eclipselink	Assignee:	Project Inbox <eclipselink.orm-inbox>
Status:	NEW ---	QA Contact:
Severity:	normal
Priority:	P2	CC:	tom.ware
Version:	unspecified
Target Milestone:	---
Hardware:	PC
OS:	Windows XP
Whiteboard:

Description Michael Pflueger

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

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

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

2022-06-09 10:10:10 EDT

The Eclipselink project has moved to Github: https://github.com/eclipse-ee4j/eclipselink