DataNucleus JIRA is now in read-only mode. Raise any new issues in GitHub against the plugin that it applies to. DataNucleus JIRA will remain for the foreseeable future but will eventually be discontinued
Issue Details (XML | Word | Printable)

Type: Improvement Improvement
Status: Closed Closed
Resolution: Duplicate
Priority: Major Major
Assignee: Unassigned
Reporter: Yang ZHONG
Votes: 0
Watchers: 0

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:
    public String getRangeByRowNumberColumn()
        return "row_number()over()";

This fix is required:

Andy Jefferson made changes - 16/Jul/10 09:50 AM
Field Original Value New Value
Summary DB2 SQL actually supports range long time ago Support setRange() natively in datastore for DB2
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

Andy Jefferson made changes - 13/Oct/10 05:30 PM
Status Open [ 1 ] Resolved [ 5 ]
Resolution Duplicate [ 3 ]
Andy Jefferson made changes - 20/Oct/10 09:30 AM
Status Resolved [ 5 ] Closed [ 6 ]