Problem in Writing select * query in EJB

[Amey-Mogare]

Hi all,

I'm writing select * from BIT_OEM in entity bean, but it is not validating the query saying this ==> EJB QL statement is invalid. See General User Output View for details.

And General User output View is not showing any error description..

pls help me with this..

regards,

Amey

[former_member341974 · Accepted solution]

try the following ejb query for selecting records

select object(o) from DataBeanname o

here databeanname is name of ur databean

[Former Member]

Hi,

Try this one..

Select Object(p) from <EntityBean Name > as p

Hope this would helps u..

Regards

LakshmiNarayana

[Former Member]

Hi,

Try to specify the column names instead of '*'.

http://java.sun.com/j2ee/1.4/docs/tutorial/doc/EJBQL5.html

Regards

Ayyapparaj