Sometimes I get QueryResults.size=2 on a query, but there's only one object in
QueryResults.
E.g.
query = db.getOQLQuery("SELECT a FROM hansen.playground.Actor a WHERE
a.name=$1");
query.bind("Keanu Reeves");
This should only return one object, but QueryResults.size() is 2.
If I fetch the first object, QueryResults.hasMore() however returns false.
There is a many-to-many relation from actor to movie, and Castor generates an SQL
statement like this:
SELECT actor.id,actor.name,actor_movie.id_movie FROM actor LEFT OUTER JOIN actor_movie
ON actor.id=actor_movie.id_actor WHERE (actor.name = ?)
I'd say that size=2 is wrong. What's the explanation?
/Keld
-----------------------------------------------------------
If you wish to unsubscribe from this mailing, send mail to
[EMAIL PROTECTED] with a subject of:
unsubscribe castor-dev
