Re: Unexpected result

Thank you so much for the responses.

I had never used query.setPathOuterJoin("region").  This is strange
considering how long I have been using OJB and how many queries I have built
with it.  This may be the solution.  I will give it a shot later.

It is very possible that region can be null inside of the servicelocation
table.  There are countries without regions (states/provinces) that still
need to be included in this end result.

We are coming out with a new release of http://jobbbank.com in a couple of
weeks, and this is one of the few remaining bugs that came out in testing.

I will let you know how it turns out.

John

-- 
View this message in context: http://www.nabble.com/Unexpected-result-tp16533913p16539109.html
Sent from the Apache DB - ObjectRelationalBridge Users mailing list archive at Nabble.com.