How I can get list of complex identifiers of object. The OQL conception means that I can select only one object (not set of fields that in generic SQL).
I can use:
select o from Object o;
or
select o.field from Object o;
and I can't use follow:
select o.one, o.two from Object o;
More that else, Castor after call SQL prepareStatement use follow:
if (resultSet.next()) {
Object = resultSet.get(1);
}
Just one object, other are ignored…
So, if I want to get list of ids of object I use:
for single key tables:
select o.id from Object o;
but for multikey table I MUST load FULL object. Is it usefull? :(
Good luck.
