EJBQL error

[Christophe Verré]

I'm trying to execute a finder method on my local entity bean.
The finder method is called from a remote session bean.
I'm getting the following exception (J2EE RI) :

ejb20Finder method = public abstract java.util.Collection beans.MovieHome.findAllMovies() throws javax.ejb.FinderException
ejb20Finder ejbql  = SELECT OBJECT(m) FROM Movie m
ejb20Finder query  = sql not generated yet
javax.ejb.TransactionRolledbackLocalException: Exception thrown from bean; nested exception is: javax.ejb.EJBException: nested exception is: SQL Exception: Syntax error: Encountered "sql" at line 1, column 1.
javax.ejb.EJBException: nested exception is: SQL Exception: Syntax error: Encountered "sql" at line 1, column 1.
SQL Exception: Syntax error: Encountered "sql" at line 1, column 1.

"Movie" is a defined abstract schema of the Movie entity.
SQL is defined as :

     <query>
        <description></description>
        <query-method>
          <method-name>findAllMovies</method-name>
          <method-params />
        </query-method>
        <ejb-ql>SELECT OBJECT(m) FROM Movie m</ejb-ql>
      </query>

Any idea why an exception is being thrown ?

[Christophe Verré]

The problem was that I did not generate the client side SQL from the deploytool. I'm now getting another kind of exception, but I'll try to figure it out before asking.

[Christophe Verré]

Finally got it right. The last exception I had was because the return type was not serializable.

[Gowher Naik]

Hi Satou kurinosuke
Can you pass me example(entity beans with relationship)which you have developed.
I trying for last many days but i am not abe to find any example which discuss simple 1:1 relationship.My email id is [e-mail]
Thanks