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.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
