...
Code Block |
---|
title | JPQL.java |
---|
borderStyle | solid |
---|
|
...
// Select a collection of embeddables
Query q = em.createQuery("SELECT u FROM User u , in (u.addresses) a WHERE a.state='xx'");
// TODO -- add more!
...
|
Relationships from Embeddables
...
Code Block |
---|
title | JPQL.java |
---|
borderStyle | solid |
---|
|
...
// Embedded -> relationship traversal
Query q = em.createQuery("SELECT u FROM User u , in (u.addresses) a WHERE a.coordinates.longitude=xxx");
// TODO -- add more!
...
|
Nested Embeddables
In the code snippet below, there is a User Entity which has an embedded ContactInfo. ContactInfo contains two other embeddeded embeddables, Address and Phone.
...
Code Block |
---|
title | JPQL.java |
---|
borderStyle | solid |
---|
|
...
// Nested embeddables traversal
Query q = em.createQuery("SELECT u FROM User u WHERE u.contactInfo.homePhone.number='507-555-5555' AND u.contactInfo.homePhone.type='cell'");
// TODO -- add more!
...
|