Use @ValuePartition
to represent a specific value partition that will be routed to a specific connection pool.
Annotation Elements
Table 2-76 describes this annotation's elements.
Table 2-76 @ValuePartition Annotation Elements
Annotation Element | Description | Default |
---|---|---|
|
The connection pool to which to route queries to for the |
|
|
The |
Examples
Example 2-122 shows how to use the @ValuePartition
and @ValuePartitioning
annotations.
Example 2-122 Using @ValuePartition Annotation
@Entity @Table(name = "PART_EMPLOYEE") @IdClass(EmployeePK.class) @ValuePartitioning( name="ValuePartitioningByLOCATION", partitionColumn=@Column(name="LOCATION"), unionUnpartitionableQueries=true, defaultConnectionPool="default", partitions={ @ValuePartition(connectionPool="node2", value="Ottawa"), @ValuePartition(connectionPool="node3", value="Toronto") }) @Partitioned("ValuePartitioningByLOCATION") public class Employee implements Serializable, Cloneable { ... }
Example 2-123 shows how to use the <partition>
element in the eclipselink-orm.xml
file.
Example 2-123 Using <partition> XML
<entity name="Employee" class="Employee" access="FIELD"> <table name="PART_EMPLOYEE"/> <id-class class="EmployeePK"/> <value-partitioning name="ValuePartitioningByLOCATION" union-unpartitionable-queries="true" default-connection-pool="default"> <partition-column name="LOCATION"/> <partition connection-pool="node2" value="Ottawa"/> <partition connection-pool="node3" value="Toronto"/> </value-partitioning> <partitioned>ValuePartitioningByLOCATION</partitioned>
See Also
For more information, see: