Skip to main content

Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » EclipseLink » Range Partition Across multiple level relationships
icon5.gif  Range Partition Across multiple level relationships [message #1073523] Thu, 25 July 2013 01:20
Oliver Zhou is currently offline Oliver ZhouFriend
Messages: 41
Registered: February 2012

I'm trying to work with EclipseLink range partition.
I'm using the examples from EclipseLink documentation.
But I need some tweaks for original example.

1) I want to use RangePartition instead of HashPartition.
I use Customer Id as partition column, and range 0 - 100 goes to connection 1, and others to connection 2.
2) I need that customer's related Order goes to the same partition with the customer,
3) The related OrderLine goes to the same partition with the customer as well.

I can make 1) and 2) work but I don't know how to achieve 3).

That's what I have done:
I define RangePartitionPolicy on Customer entity, reference this policy in Customer entity.
I reference this policy in Order entity as well, it will work since it has foreign key column that reference partition column of Customer entity
But in OrderLine entity, there's no way to reference partition column of Customer entity.

So my question is how to achieve this when there's no direct relationship with an entity that has RangePartition policy?

[Updated on: Thu, 25 July 2013 02:24]

Report message to a moderator

Previous Topic:Help for persist optimization
Next Topic:EclipseLink Bug in DatabaseQuery.checkPrepare
Goto Forum:

Current Time: Mon Jun 25 00:49:56 GMT 2018

Powered by FUDForum. Page generated in 0.01356 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software

Back to the top