OJB ignores search criteria

[la...@allianz.de]

Hello everybody,

I have five tables

A ----- B ----- C ----- D ----- E

and doing a query on E like

Criteria crit = new Criteria();
crit.addEqualTo("dbName","foo1");
crit.addEqualTo("D.C.groupName","foo2");
crit.addEqualTo("D.C.B.A.userName","foo3");
Query q = QueryFactory.newQuery(E.class, crit,true);

Up to now everything is fine. I'm doing the query and get only the
objects of type E I was looking for.
But, if I'm navigating back from E to D (I haven't commited the
transaction yet nor closed the broker), OJB is just using the dbName
restriction and ignoring my C.groupName A.userName restriction.
The generated SQL is just a very short one on table D with where
condition on dbName (dbNr technically) from table E.
Is this a bug or a feature or am I doing something wrong. I assumed
that I can navigate through the objects and only get the one which
apply to my search conditions.

Regards
Lasse
___

>  Lasse Lambrecht
>  Allianz Lebensversicherungs-AG
>  IS-LF1 K6, Produktdatenbank
>  +49 711 663 5412  #  1021-5412





---------------------------------------------------------------------
To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-user-help@db.apache.org