MovieBean in HFEJB p396

[Suman Sarker]

Hi All,
I tried to create the Movie bean showed in page 396 of HFEJB. I also created the Director Bean. The Director Bean is working fine, I can create or remove directors from the database. But the problem is with the Movie Bean. Whenever I try to insert a new movie in the database, JBoss shows the following error

14:03:21,771 ERROR [MovieBean] Could not create entity
java.sql.SQLException: General error, message from server: "Column 'DirectorID' cannot be null"

Following is the code snippet from my Movie Bean

public abstract class MovieBean implements EntityBean {
    private EntityContext entityContext;
 
    public Integer ejbCreate(Integer movieID, String title, String genre,
                             Integer directorId)
        throws CreateException {
        setMovieID(movieID);
        setTitle(title);
        setGenre(genre);
        return null;
    }
 
    public void ejbPostCreate(Integer movieID, String title, String genre,
                              Integer directorId)
        throws CreateException {
        try {
            javax.naming.InitialContext ctx = new javax.naming.InitialContext();
            DirectorHome directorHome = (DirectorHome) ctx.lookup("Director");
            Director director = directorHome.findByPrimaryKey(directorId);
            setDirector(director);
        }
        catch (Exception ex) {
            System.out.println(ex.getMessage());
        }
    }
    
    ...
}

I dont know what to do as this is my first attempt in creating an Entity Bean. Please help me.

Thanks
Suman

[Suman Sarker]

After a lot of experiment, I found out that I need the CMP field "directorId" to get the bean working. But the book says(page 400) that, the "directorId" field should not be declared because we already have a CMR field for director.
But I could not make the MovieBean work without declaring the CMP field for directorId.
Am I doing something wrong?

[Girija Siva]

Did you declare directorId as cmp field for the Director entity

[Roger Chung-Wee]

Can you tell us what value is being returned from the findByPrimaryKey() method.

[T Rob Darrough]

I have had similiar experiences. If I don't put the directorId field in Movie the container will not generate anything similiar (i.e. a foriegn key in Movie to Director). If I do put directorId into Movie then the container will not manage it.

[Suman Sarker]

Hi All,

Hi Girija,
I did declare "directorId" as cmp field for the Director entity. Here is the DirectorBean

public abstract class DirectorBean implements EntityBean {
    EntityContext entityContext;
 
    public Integer ejbCreate(Integer directorId, Integer degrees,
                             String name, String oscarWinner)
        throws CreateException {
 
        setDirectorId(directorId);
        setDegrees(degrees);
        setName(name);
        setOscarWinner(oscarWinner);
        return null;
    }
 
    public void ejbPostCreate(Integer directorId, Integer degrees,
                             String name, String oscarWinner)
       throws CreateException {
    }
 
    ...
 
    public void setEntityContext(EntityContext entityContext) {
        this.entityContext = entityContext;
    }
 
    public void unsetEntityContext() {
        this.entityContext = null;
    }
 
    public abstract Integer getDirectorId();
    public abstract void setDirectorId(Integer directorId);
 
    public abstract Integer getDegrees();
    public abstract void setDegrees(Integer degrees);
 
    public abstract String getName();
    public abstract void setName(String name);
 
    public abstract String getOscarWinner();
    public abstract void setOscarWinner(String oscarWinner);
 
    public abstract Collection getMovie();
    public abstract void setMovie(Collection movie);
}
 

Hi Roger,
Here is the findByPrimaryKey() method from my MovieHome interface

public Movie findByPrimaryKey(Integer movieID) throws FinderException;  

Hi Rob,
How did you get around this problem?

Thanks
Suman

[Roger Chung-Wee]

Ah, maybe I didn't make my question clear. I'm asking what value is returned from this at runtime.

Director director = directorHome.findByPrimaryKey(directorId);

I'm wondering if it is returning null, thus causing the problem when inserting the DirectorID field into the DB.

[Suman Sarker]

Hi Roger,
Line 16 in the following code snippet is never executed as it is in ejbPostCreate() and I get the exception from ejbCreate() method. I was able to verify it because I saw the following in JBoss console

   INFO  [STDOUT] Called ejbCreate().
   ERROR [MovieBean] Could not create entity
java.sql.SQLException: General error, message from server: "Column 'DirectorID' cannot be null"

Here is code snippet from my MovieBean class. Please note that, the MovieBean works fine if I keep line #8, line #29, line #30 and add the cmp field "directorId" in the xml files.

01 public abstract class MovieBean implements EntityBean {
02    private EntityContext entityContext;
 
03    public Integer ejbCreate(String genre, Integer movieID, String title,
                             Integer directorId)
        throws CreateException {
04        System.out.println("Called ejbCreate().");
05        setMovieID(movieID);
06        setTitle(title);
07        setGenre(genre);
08        setDirectorId(directorId);
09        return null;
10    }
 
11    public void ejbPostCreate(String genre, Integer movieID, String title,
                              Integer directorId)
        throws CreateException {
12        System.out.println("Called ejbPostCreate().");
13        try {
14            javax.naming.InitialContext ctx = new javax.naming.InitialContext();
15            DirectorHome directorHome = (DirectorHome) ctx.lookup("Director");
16            Director director = directorHome.findByPrimaryKey(directorId);
17            setDirector(director);
18        }
19        catch (Exception ex) {
20            System.out.println(ex.getMessage());
21        }
22    }
 
23    public void setEntityContext(EntityContext entityContext) {
24        this.entityContext = entityContext;
25    }
 
26    public void unsetEntityContext() {
27        this.entityContext = null;
28    }
 
29    public abstract Integer getDirectorId();
30    public abstract void setDirectorId(Integer directorId);
    
31    public abstract String getGenre();
32    public abstract void setGenre(String genre);
    
33    public abstract Integer getMovieID();
34    public abstract void setMovieID(Integer movieID);
    
35    public abstract String getTitle();
36    public abstract void setTitle(String title);
    
37    public abstract Director getDirector();
38    public abstract void setDirector(Director director);
39 }

[ May 24, 2004: Message edited by: Suman Sarker ]

[Sean Lee]

Hi Kathy or other moderators,

please help us to clarify this issue? Whether we direcotrID CMP and related set method in order to insert movie record with directorID? Thanks.