0 Replies Latest reply on Apr 30, 2004 12:05 PM by caesarkim

    problem for executing EJB QL in CMP

    caesarkim Newbie

      I have a cmp like this.

      public abstract class RegistrationBean implements EntityBean
      {
      /*****
      // extra code.
      ***/

      public abstract Collection ejbFindByUsername(String username)throws FinderException;

      public Collection ejbGetUsernameByUsername(String username) throws FinderException
      {
      return ejbFindByUsername(username);
      }
      }

      public interface RegistrationHome extends EJBHome
      {
      public Collection getByUsername(String username) throws FinderException;

      public RegistrationRemote create(Integer id) throws CreateException, RemoteException;

      public RegistrationRemote findByPrimaryKey(Integer id) throws FinderException, RemoteException;
      }

      public interface RegistrationRemote extends EJBObject
      {
      public Collection GetByUsername(String username) throws FinderException,RemoteException;
      }

      /******************* ejb-jar.xml **********************/

      <query-method>
      <method-name>findByUsername</method-name>
      <method-params>
      <method-param>java.lang.String</method-param>
      </method-params>
      </query-method>
      <ejb-ql>
      SELECT OBJECT( c ) FROM ADMINISTRATOR AS c WHERE c.username = ?1
      </ejb-ql>


      /******************************************************/

      I want to access "GetByUserName" in client side, but i am a little bit confused about how to access it.

      please show me how to do it..


      thanks...