Is it possible to perform a join in OQL using the ODMG implementation. I've got 2
classes namely Country and Region. I want to perform the equivalent of the following
SQL for efficiency purpose :
SQL Equivalent Statement:
select * from country c, regions r where c.regionId = r.regionId and r.name
like 'A%'
I have tried to folow the ODMG standard and create the following OQL query but I keep
getting an unexpected token
select c from c in com.meridianinfo.hr.biz.Country, x in
com.meridianinfo.hr.biz.Region
where c.regionId = x.regionId and
r.name like "A%"
I keep getting an unexpected token : in message
followed by a null pointer exception org.apache.ojb.odmg.oql.OQLQueryImpl.create
Regards
Denis St Flour
--
To unsubscribe, e-mail: <mailto:ojb-user-unsubscribe@;jakarta.apache.org>
For additional commands, e-mail: <mailto:ojb-user-help@;jakarta.apache.org>
