| CriteriaQuery<Boolean> fails with NoResultException but works when running generated SQL manua [message #651301] |
Fri, 28 January 2011 14:32  |
 Matthew Denison
Messages: 6
Registered: January 2011 |
Junior Member |
|
|
Hi All,
Hope someone can shed some light on a problem I have been having.
I have two objects - Object1 and Object2. Object1 and Object2 have a bidirectional OneToOne mapping to each other. Object1 owns the relationship. Object2 has a number of Boolean fields that are protected fields of a MappedSuperclass. Those boolean fields are what I want to query for.
Here are two queries I have tried.
Query 1: (This is the query I want to work)
CriteriaQuery<Boolean> cq = cb.createQuery(Boolean.class);
Root<Object1> obj1 = cq.from(Object1.class);
Join<Object1, Object2> obj2 = obj1.join(Object1_.object2);
cq.select(obj2.get(A_METHOD_ARG));
cq.where(
cb.and(
cb.equal(obj1.get(Object1_.field1), A_METHOD_ARG),
cb.equal(obj1.get(Object1_.field2), A_METHOD_ARG)
)
);
TypedQuery<Boolean> query = em.createQuery(cq);
I get a NoResultException when I run this. The SQL that is being generated by EclipseLink 2.2 is "SELECT t0.MYBOOLEAN FROM Object2 t0, Object1 t1 WHERE (((t1.FIELD1 = 1) AND (t1.FIELD2 = 1)) AND (t0.ID = t1.OBJECT2_ID))" and if I run this directly on the MySQL 5.5 database I get a single column with a 1 value in it so the query is working when run manually. Confused on that...
Query 2: (I can make this work but not optimal)
CriteriaQuery<Object1> cq = cb.createQuery(Object1.class);
Root<Object1> obj1 = cq.from(Object1.class);
cq.select(obj1);
cq.where(
cb.and(
cb.equal(obj1.get(Object1_.field1), A_METHOD_ARG),
cb.equal(obj1.get(Object1_.field2), A_METHOD_ARG)
)
);
TypedQuery< Object1> query = em.createQuery(cq);
This works and retrieves my Object1 using the same parameters. I can then retrieve Object2 and manually get the Boolean value that is stored in the DB. Is the join causing problems somehow?
Thanks for any help!
|
|
|
] 
Search
Help
Register
Login
Home
