Correct EJB-QL generates faulty SQL. any ideas?

[cwad0000]

When looking in my server.log I see the following is created:

17:53:36,498 DEBUG: EJB-QL: SELECT OBJECT(o) FROM GenericRelation o WHERE (o.parent_type = ?1)
17:53:36,498 DEBUG: SQL: SELECT FROM glb_gen_relation t0_o WHERE ((t0_o.parent_type = ?))

I was expecting it to generate this SQL:
17:53:36,498 DEBUG: SQL: SELECT t0_o.id FROM glb_gen_relation t0_o WHERE ((t0_o.parent_type = ?))

Can anyone see what might be wrong? Naturally, I get Sql Exceptions regarding faulty Sql when I call that finder method..

I am using MySql, and my query definition and my table:


<query-method>
<method-name>findItemsBelongingToParent</method-name>
<method-params>
<method-param>java.lang.Integer</method-param>
</method-params>
</query-method>
<ejb-ql>SELECT OBJECT(o) FROM GenericRelation o WHERE (o.parent_type = ?1)</ejb-ql>


create table glb_gen_relation (
id INT AUTO_INCREMENT, primary key (id),
parent_type int not null,
node int not null
);

[lafr]

Show us the whole bean declaration to look at
- abstract-schema
- primary-key
- ...

I use the key word "AS" between the abstract-table-name and the alias, but I think this is not needed (FROM GenericRelation AS o).

[cwad0000]

came to work, fired up emacs, loaded the deployment descriptor, got my coffe, started to looking at it, after 10 seconds:
"hang on, where is my <primkey-field>id</primkey-field> tag?"

it works fine now, cheers for the reply lafr