how to use finder methods with cmp?

[Kay Tracid]

Hi,
I have a finder method and try to call this, but I never get a result or an exception. i dont know if the method is really called, how can i know it? I insert some mistakes in my ejb query language, but i get non exception. Call create() works...?!
Can somebody help please?
my ejb-xml:

  
        <entity>
            <description>Models an e_emotion</description>
            <ejb-name>E_Emotion</ejb-name>
            <home>ejb.interfaces.E_EmotionHome</home>
            <remote>ejb.interfaces.E_EmotionRemote</remote>
            <ejb-class>ejb.bean.E_EmotionBean</ejb-class>
            <persistence-type>Container</persistence-type>
            <prim-key-class>java.lang.Integer</prim-key-class>
            <reentrant>false</reentrant>
            <cmp-field>
                <field-name>e_id</field-name>
            </cmp-field>
            <cmp-field>
                <field-name>e_bez</field-name>
            </cmp-field>
            <primkey-field>e_id</primkey-field>
            <query>
                <query-method>
                    <method-name>findAllE_Emotions</method-name>
                    <method-params>
                    </method-params>
                </query-method>
                <ejb-ql><![CDATA[SELECT OBJECT(g) FROM E_EmotionBean g]]></ejb-ql>
            </query>
        </entity>

my home interface:

  
package ejb.interfaces;

import javax.ejb.EJBHome;
import javax.ejb.CreateException;
import javax.ejb.FinderException;
import java.rmi.RemoteException;
import java.util.Collection;
public interface E_EmotionHome extends EJBHome{
    E_EmotionRemote create(Integer e_id, String e_bez) throws CreateException, RemoteException;
    Collection findByAllE_Emotions() throws FinderException, RemoteException;
}

call finder:

  
           ctx = new InitialContext(env);
            Object obj = ctx.lookup("E_Emotion");
            E_EmotionHome home = (E_EmotionHome) PortableRemoteObject.narrow(obj, E_EmotionHome.class);
            Enumeration enum = home.findAllE_Emotions();
            System.out.println("Emotions there:" + enum.hasMoreElements());
            while(enum.hasMoreElements()){
                E_EmotionRemote emotion = (E_EmotionRemote)enum.nextElement();
                System.out.println(emotion);
            }

[ April 03, 2003: Message edited by: Kay Tracid ]
[ April 08, 2003: Message edited by: Kay Tracid ]

[Kay Tracid]

maybe, somebody knows where to look for my mistake?

[Chris Mathews]

First off, I don't see an <abstract-schema-name> defined in your descriptor.
Secondly, CMP is still very dependent on the application server that you are using (much less than in EJB 1.1 though). Therefore, I suggest you give details of your Application Server and other configuration, and post this question in the appropriate forum. JavaRanch has forums for most major Application Servers.

[Kay Tracid]

oh, sorry, i use JBoss 3.0.4 with oracle 9. i added the abstract-schema-name, but i have the same problem as before. i need to know where to look for my mistake. is somewhere in jboss logged which finder methods are there? how do i know that the query in ejb-jar is not ignored? i'm sorry if this is the wrong forum, please move it to jboss forum.
Thanks
[ April 08, 2003: Message edited by: Kay Tracid ]

[Andres Gonzalez]

if you don't see any errors while deploying in jboss try to put some log("") lines and check whether it prints it or not. you can also check your datasource mapping. I think is the mysql-service.xml file located in the deploy directory.
there's another file called standardjbosscmp-jdbc.xml, check it... but they're should be ok if you're not gettn any errors while deploying..
good luck

[Kay Tracid]

Thanks a lot, where i should add the log lines? It seems that the <quest> in ejb-jar.xml is ignored.
I think my OracleDS is working because i can call the home.create() method. I installed jboss 3.0.6 again, and it starts fine. no warnings, no errors.

[Andres Gonzalez]

Originally posted by Kay Tracid:
Thanks a lot, where i should add the log lines? It seems that the <quest> in ejb-jar.xml is ignored.
I think my OracleDS is working because i can call the home.create() method. I installed jboss 3.0.6 again, and it starts fine. no warnings, no errors.

hmm.. what do you mean it starts fine? did JBoss start fine? or did you copy your file to the deploy directory jbossInstalation/server/default/deploy
and JBoss deployed it without any problems?
what <quest> did you mean?
the log (or System.out.println) should go in your bean class, something like:
log("got home interface")
and if your enumeration has actually any elements, print something meaningful..

[Kay Tracid]

i mean both is fine. jboss starts fine and deploy the beans.jar is fine, too. yes i deploy my jar to server/default/deploy without problems.
sorry i mean the <query> tag in my ejb-jar seems to be ignored. i dont know if i should get an exception in case of a syntax error in my ejb ql. tell me please, is jboss pharsing it while deploying? or should i get an exception when i call the finder method? my bean works fine so i dont see a reason to print something out. my only problem is the finder method...
thanks a lot for your help

[Andres Gonzalez]

Yes, if you have a syntax error in your ejb ql you should get an error when you deploy your file into the deploy directory. That's happenned to me many times, specially with EJB QL queries..
I'm just guessing... but if you added the <abstract-schema-name>, maybe you can show us again a snippet of your new ejb-jar.xml and the bean implementation (also a snippet ;-) ). If it is really different at the one you post before..
don't know... hhmmm... let us know..

[Kay Tracid]

ejb-jar.xml

 <?xml version="1.0" encoding="UTF-8"?>
<ejb-jar>
    <description>JBoss BIDOS Application</description>
    <display-name>BIDOS</display-name>
    <abstract-schema-name>BIDOS</abstract-schema-name>
    <enterprise-beans>
               <entity>
            <description>Models an e_emotion</description>
            <ejb-name>E_Emotion</ejb-name>
            <home>ejb.interfaces.E_EmotionHome</home>
            <remote>ejb.interfaces.E_EmotionRemote</remote>
            <ejb-class>ejb.bean.E_EmotionBean</ejb-class>
            <persistence-type>Container</persistence-type>
            <prim-key-class>java.lang.Integer</prim-key-class>
            <reentrant>false</reentrant>
            <query>
                <query-method>
                    <method-name>findByAllE_Emotions</method-name>
                    <method-params>
                    </method-params>
                </query-method>
                <ejb-ql><![CDATA[SELECT OBJECT(g) FROM E_EmotionBean g WHERE g.pk IS NOT NULL]]></ejb-ql>
            </query>
            <cmp-field>
                <field-name>e_id</field-name>
            </cmp-field>
            <cmp-field>
                <field-name>e_bez</field-name>
            </cmp-field>
            <primkey-field>e_id</primkey-field>
        </entity>
    </enterprise-beans>
</ejb-jar> 

E_EmotionHome.java

 package ejb.interfaces;
import javax.ejb.EJBHome;
import javax.ejb.CreateException;
import javax.ejb.FinderException;
import java.rmi.RemoteException;
import java.util.Collection;
public interface E_EmotionHome extends EJBHome{
    E_EmotionRemote create(Integer e_id, String e_bez) throws CreateException, RemoteException;
    Collection findByAllE_Emotions() throws FinderException, RemoteException;
    E_EmotionRemote findByPrimaryKey(java.lang.Integer key) throws FinderException, RemoteException;
}
 

E_EmotionRemote.java

  
package ejb.interfaces;
import javax.ejb.*;
import java.rmi.RemoteException;
public interface E_EmotionRemote extends EJBObject{
    public abstract Integer getE_id() throws RemoteException;
    public abstract void setE_id(Integer e_id) throws RemoteException;
    public abstract String getE_bez() throws RemoteException;
    public abstract void setE_bez(String e_bez) throws RemoteException;
}

E_EmotionBean.java

  
package ejb.bean;
import javax.ejb.*;
import java.rmi.RemoteException;
public class E_EmotionBean implements EntityBean {
    protected EntityContext ect;
    public Integer e_id; //PK
    public String e_bez;
    public E_EmotionBean() {
    }
    public Integer getE_id() {
        return e_id;
    }
    public void setE_id(Integer id) {
        this.e_id = id;
    }
    public String getE_bez() {
        return e_bez;
    }
    public void setE_bez(String e_bez) {
        this.e_bez = e_bez;
    }
    public void ejbActivate() throws EJBException, RemoteException {
    }
    public void ejbLoad() throws EJBException, RemoteException {
    }
    public void ejbPassivate() throws EJBException, RemoteException {
    }
    public void ejbRemove() throws RemoveException, EJBException, RemoteException {
    }
    public void ejbStore() throws EJBException, RemoteException {
    }
    public void setEntityContext(EntityContext entityContext) throws EJBException, RemoteException {
        this.ect = entityContext;
    }
    public void unsetEntityContext() throws EJBException, RemoteException {
        this.ect = null;
    }
    public void ejbPostCreate(Integer e_id, String e_bez) throws RemoteException {
    }
    public Integer ejbCreate(Integer e_id, String e_bez) throws RemoveException, CreateException, RemoteException {
        this.e_id = e_id;
        this.e_bez = e_bez;
        return null;
    }
}

E_EmotionPrimaryKey.java
package ejb.bean;
public class E_EmotionPrimaryKey implements java.io.Serializable {
public Integer e_id;
public E_EmotionPrimaryKey(Integer e_id) {
this.e_id = e_id;
}
public E_EmotionPrimaryKey() {
}
public String toString() {
return e_id.toString();
}
}
call finder:

  
        Properties env = new Properties();
        env.put(Context.INITIAL_CONTEXT_FACTORY, "org.jnp.interfaces.NamingContextFactory");
        env.put(Context.PROVIDER_URL, "myserver:1099");
        env.put("java.naming.factory.url.pkgs", "org.jboss.naming  :-o	  rg.jnp.interfaces");
        Context ctx = null;
        Collection col = null;
        try {
            ctx = new InitialContext(env);
            Object obj = ctx.lookup("E_Emotion");
            E_EmotionHome home = (E_EmotionHome) PortableRemoteObject.narrow(obj, E_EmotionHome.class);
            col = null;
            try {
                col = home.findByAllE_Emotions();
                System.out.println("Emotions empty: " + col.isEmpty()+ "   size: " + col.size());
                System.out.println("look for e_id 2:" + home.findByPrimaryKey((new Integer(2))));
                //home.create(new Integer(6),"testtest");
            } catch (FinderException e) {
                e.printStackTrace();
            } catch (RemoteException e) {
                e.printStackTrace();
            }
        } catch (NamingException e1) {
            e1.printStackTrace();
        } catch (ClassCastException e1) {
            e1.printStackTrace();
        }

thats all i have. i found a single entity with findByPrimarykey(), but the collection for findbyAllE_Emotions is empty.
[ April 09, 2003: Message edited by: Kay Tracid ]

[Kyle Brown]

Abstract schema name should be beneath the entity element, not at the same level. And also, the thing you should be SELECTing from is the Abstract Schema name, not the bean name. Really, I would STRONGLY suggest you take a look at either Richard Monson-Haefel's book or Ed Roman's book -- they have MANY examples of fully working EJB DD's that you can work from. This is pretty basic stuff covered very well in both books. It would be much more productive if you read and worked from one of those rather than floundering around like this.
Kyle
[ April 09, 2003: Message edited by: Kyle Brown ]

[Kay Tracid]

Thanks for help. maybe i'm very stupid, but i didn't found much infomation in Ed Roman's book about ejb-ql and deployment descriptor and jboss. i found something about ejb-ql in the www, maybe it will help.
thx

[Kyle Brown]

Originally posted by Kay Tracid:
Thanks for help. maybe i'm very stupid, but i didn't found much infomation in Ed Roman's book about ejb-ql and deployment descriptor and jboss. i found something about ejb-ql in the www, maybe it will help.
thx

You're not stupid -- just not working from enough information. Buy Richard Monson-Haefel's book. It's EXCELLENT in this regard.
Kyle