Issue Details (XML | Word | Printable)

Key: NUCRDBMS-434
Type: Improvement Improvement
Status: Closed Closed
Resolution: Duplicate
Priority: Major Major
Assignee: Unassigned
Reporter: Yang ZHONG
Votes: 0
Watchers: 0
Operations

If you were logged in you would be able to see more operations.
DataNucleus Store RDBMS

Support setRange() natively in datastore for DB2

Created: 14/Jul/10 10:14 PM   Updated: 20/Oct/10 09:30 AM   Resolved: 13/Oct/10 05:30 PM
Component/s: Queries
Affects Version/s: 2.0.4, 2.1.0.m1, 2.1.0.m2, 2.1.0.m3, 2.1.0.release, 2.1.1
Fix Version/s: None

Environment: Java 5, Linux

Datastore: IBM DB2


 Description  « Hide
Query#setRange DataNucleus implementation currently reads in every single row and stores as strongly referenced objects, including all rows before the range on DB2. We see Out of Memory.

Actually, DB2 SQL does support range, long time ago. Just for the only purpose of Proof of Concept, adding this into .rdbms.adapter.DB2Adapter seems working:
    @Override
    public String getRangeByRowNumberColumn()
    {
        return "row_number()over()";
    }

This fix is required:
HTTP://WWW.DataNucleus.org/servlet/jira/browse/NUCRDBMS-433

Sort Order: Ascending order - Click to sort in descending order
Andy Jefferson added a comment - 13/Oct/10 05:30 PM
NUCRDBMS-433 already exists, so just put all comments on there since it is the exact same thing