Help Please

[Gowher Naik]

hi
can anyone pass me a simple example using relationship(entity beans with relationship).I am not able to find any simple example so that i will be able to understand concept.i tried google search also but i was not successfull.
I tried roster example for sun but it is bit complex to understand.

Thanks

[Christophe Verré]

I'll send you mine, but I can't use email. I'll try to post the code at the ranch tomorrow, but you'll have to do the container config yourself. I've used J2EE RI.
[ March 22, 2007: Message edited by: Satou kurinosuke ]

[Christophe Verré]

I'm sending you my java files and the descriptor generated by the Deploytool.
You'll have to generate client stubs, SQL...
I've tested it with J2EE RI and Cloudscape. It's pretty dirty and almost no comment, but I hope it can help.
Movie and Trailer entity beans have a One-To-One relationship.
This code checks :
1. The One-To-One relationship
2. Finder method
3. Select method
4. Home business method

The Movie entity bean

------------------------------------------
Local Component IF
------------------------------------------
package beans;
 
import javax.ejb.EJBLocalObject;
 
public interface Movie extends EJBLocalObject {

public String getName();
public Trailer getMovieTrailer();
public void setMovieTrailer(Trailer trailer);
}
 
------------------------------------------
Local Home IF
------------------------------------------
package beans;
 
import java.util.Collection;
 
import javax.ejb.CreateException;
import javax.ejb.EJBLocalHome;
import javax.ejb.FinderException;
 
public interface MovieHome extends EJBLocalHome {

public Movie findByPrimaryKey(String id) throws FinderException;
public Movie create(String id, String name) throws CreateException;

// finder method
public Collection findAllMovies() throws FinderException;
// home business method using a select method
public Trailer getTrailerFor(String movieName) throws FinderException;

}
 
------------------------------------------
Bean class
------------------------------------------
package beans;
 
import javax.ejb.CreateException;
import javax.ejb.EntityBean;
import javax.ejb.EntityContext;
import javax.ejb.FinderException;
 
public abstract class MovieBean implements EntityBean {

private EntityContext ctx;

// CMP Fields
public abstract void setMovieId(String id);
public abstract String getMovieId();
public abstract void setMovieName(String name);
public abstract String getMovieName();
// Relationship fields
public abstract Trailer getTrailer();
public abstract void setTrailer(Trailer trailer);

public void setEntityContext(EntityContext context) {
ctx = context;
}

public void unsetEntityContext() {
}

public String ejbCreate(String id, String name) throws CreateException {
setMovieId(id);
setMovieName(name);
return null;
}

public void ejbPostCreate(String id, String name) {
ctx.getEJBLocalHome();
}

public void ejbActivate() {}
public void ejbPassivate() {}
public void ejbLoad() {}
public void ejbStore() {}
public void ejbRemove() {}


public String getName() {
return getMovieName();
}

public Trailer getMovieTrailer() {
return getTrailer();
}
public void setMovieTrailer(Trailer trailer) {
setTrailer(trailer);
}
 
// home business method
public Trailer ejbHomeGetTrailerFor(String movieName) throws FinderException {
return ejbSelectGetTrailerFor(movieName);
}

// select method
public abstract Trailer ejbSelectGetTrailerFor(String movieName) throws FinderException;
}

[ March 22, 2007: Message edited by: Satou kurinosuke ]

[Christophe Verré]

The Trailer entity bean

------------------------------------------
Local Component IF
------------------------------------------
package beans;
 
import javax.ejb.EJBLocalObject;
 
public interface Trailer extends EJBLocalObject {
 
public Movie getTrailerMovie();
public void setTrailerMovie(Movie movie);
public String getTrailerDescription();
}
 
------------------------------------------
Local Home IF
------------------------------------------
package beans;
 
import javax.ejb.CreateException;
import javax.ejb.EJBLocalHome;
import javax.ejb.FinderException;
 
public interface TrailerHome extends EJBLocalHome {

public Trailer findByPrimaryKey(String id) throws FinderException;
public Trailer create(String id, String desc) throws CreateException;
}
 
------------------------------------------
Bean class
------------------------------------------
package beans;
 
import javax.ejb.CreateException;
import javax.ejb.EntityBean;
import javax.ejb.EntityContext;
 
public abstract class TrailerBean implements EntityBean {

private EntityContext ctx;

// CMP fields
public abstract void setTrailerId(String id);
public abstract String getTrailerId();
public abstract void setDescription(String desc);
public abstract String getDescription();
// Relationship
public abstract Movie getMovie();
public abstract void setMovie(Movie movie);

public void setEntityContext(EntityContext context) {
ctx = context;
}

public void unsetEntityContext() {
}

public String ejbCreate(String id, String desc) throws CreateException {
setTrailerId(id);
setDescription(desc);
return null;
}

public void ejbPostCreate(String id, String desc) {
ctx.getEJBLocalHome();
}

public void ejbActivate() {}
public void ejbPassivate() {}
public void ejbLoad() {}
public void ejbStore() {}
public void ejbRemove() {}


public Movie getTrailerMovie() {
return getMovie();
}
public void setTrailerMovie(Movie movie) {
setMovie(movie);
}


public String getTrailerDescription() {
return getDescription();
}

}

[Christophe Verré]

The MovieMaker session bean (makes a moive, a trailer, and sets each other)

------------------------------------------
Remote Component IF
------------------------------------------
package beans;
 
import java.rmi.RemoteException;
import java.util.Collection;
 
import javax.ejb.EJBObject;
 
public interface MovieMaker extends EJBObject {
 
public String makeMovie() throws RemoteException;
public Collection getAllMovies() throws RemoteException;
public String getTrailerDescByName(String movieName) throws RemoteException;
}
 
------------------------------------------
Remote Home IF
------------------------------------------
package beans;
 
import java.rmi.RemoteException;
 
import javax.ejb.CreateException;
import javax.ejb.EJBHome;
 
public interface MovieMakerHome extends EJBHome {
 
public MovieMaker create() throws CreateException, RemoteException;

}
 
------------------------------------------
Bean class
------------------------------------------
package beans;
 
import java.util.ArrayList;
import java.util.Collection;
import java.util.Iterator;
 
import javax.ejb.CreateException;
import javax.ejb.EJBException;
import javax.ejb.FinderException;
import javax.ejb.SessionBean;
import javax.ejb.SessionContext;
import javax.naming.Context;
import javax.naming.InitialContext;
import javax.naming.NamingException;
 
public class MovieMakerBean implements SessionBean {
 
private SessionContext ctx;

/**
 * 
 */
private static final long serialVersionUID = 1L;
 
/* (non-Javadoc)
 * @see javax.ejb.SessionBean#ejbActivate()
 */
public void ejbActivate() {
}
 
/* (non-Javadoc)
 * @see javax.ejb.SessionBean#ejbPassivate()
 */
public void ejbPassivate() {
}
 
/* (non-Javadoc)
 * @see javax.ejb.SessionBean#ejbRemove()
 */
public void ejbRemove() {
}
 
/* (non-Javadoc)
 * @see javax.ejb.SessionBean#setSessionContext(javax.ejb.SessionContext)
 */
public void setSessionContext(SessionContext context)  {
ctx = context;
}
 
public void ejbCreate() {
ctx.getEJBHome();
}

public String makeMovie() {
MovieHome movieHome = null;
TrailerHome trailerHome = null;

System.out.println("Business method called. ");

try { 
Context ctx = new InitialContext();
movieHome = (MovieHome)ctx.lookup("java:comp/env/ejb/Movie");
System.out.println("Got Movie Home IF.");
trailerHome = (TrailerHome)ctx.lookup("java:comp/env/ejb/Trailer");
System.out.println("Got Trailer Home IF.");
} catch( NamingException e ) {
e.printStackTrace();
throw new EJBException("Naming error", e);
}

// Get a movie
Movie movie = null;
try { 
movie = movieHome.create("RB1", "Return of the Beans");
} catch( CreateException e ) {
try {
movie = movieHome.findByPrimaryKey("RB1");
} catch( FinderException findException ) {
findException.printStackTrace();
throw new EJBException("Find error", findException);
}
}
System.out.println("Got Movie Component IF.");

// Get a trailer
Trailer trailer = null;
try { 
trailer = trailerHome.create("TR1", "Trailer for RB1");
} catch( CreateException e ) {
try {
trailer = trailerHome.findByPrimaryKey("TR1");
} catch( FinderException findException ) {
findException.printStackTrace();
throw new EJBException("Find error", findException);
}
}
System.out.println("Got Trailer Component IF.");

// Set the trailer. The relation is One-To-One, so the movie will also be set in the trailer
System.out.println("Setting relationship.");
movie.setMovieTrailer(trailer);
// Check the relation
Movie theMovie = trailer.getTrailerMovie();
String name = theMovie.getName();
System.out.println("Movie name : " + name);
return name;

}

public Collection getAllMovies() {

System.out.println("Getting all movies.");
MovieHome movieHome = null;

try {
Context ctx = new InitialContext();
movieHome = (MovieHome)ctx.lookup("java:comp/env/ejb/Movie");
Collection movies = movieHome.findAllMovies();
System.out.println("Found " + movies.size() );
Iterator it = movies.iterator();
Collection movieNames = new ArrayList();
while( it.hasNext() ) {
Movie movie = (Movie)it.next();
movieNames.add(movie.getName());
}
return movieNames;
} catch( NamingException e ) {
throw new EJBException("Naming error", e);
} catch( FinderException e ) {
throw new EJBException("Find error", e);
}
}

public String getTrailerDescByName(String movieName) {

System.out.println("Getting trailer description for : " + movieName);
MovieHome movieHome = null;

try {
Context ctx = new InitialContext();
movieHome = (MovieHome)ctx.lookup("java:comp/env/ejb/Movie");
Trailer trailer = movieHome.getTrailerFor(movieName);
return trailer.getTrailerDescription();
} catch( NamingException e ) {
throw new EJBException("Naming error", e);
} catch( FinderException e ) {
throw new EJBException("Find error", e);
}
}
}

[Christophe Verré]

Finally, the client app

package client;
 
import java.rmi.RemoteException;
import java.util.Collection;
import java.util.Iterator;
 
import javax.ejb.CreateException;
import javax.naming.Context;
import javax.naming.InitialContext;
import javax.naming.NamingException;
import javax.rmi.PortableRemoteObject;
 
import beans.MovieMaker;
import beans.MovieMakerHome;
 
public class EntityTest {
 
public static void main(String[] args) { 

MovieMakerHome movieMakerHome = null;

try { 
Context ctx = new InitialContext();
movieMakerHome = (MovieMakerHome)PortableRemoteObject.narrow(ctx.lookup("MovieMaker"), MovieMakerHome.class);
System.out.println("Got home IF.");
} catch( NamingException e ) {
e.printStackTrace();
return;
}

try {
MovieMaker movieMaker = null;
try { 
movieMaker = movieMakerHome.create();
System.out.println("Got component IF.");
} catch( CreateException e ) {
e.printStackTrace();
return;
}

//System.out.println("Calling business method.");
String name = movieMaker.makeMovie();
System.out.println("The movie called [" + name + "] has been successfully made ");
System.out.println("Over.");


Collection movies = movieMaker.getAllMovies();
System.out.println("Size: " + movies.size());
Iterator it = movies.iterator();
while ( it.hasNext() ) {
System.out.println(it.next());
}

String trailerDesc = movieMaker.getTrailerDescByName("Return of the Beans");
System.out.println("Trailer Description : " + trailerDesc);

} catch( RemoteException e ) {
e.printStackTrace();
return;
}

}
}

[Christophe Verré]

The deployment descriptor.

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE ejb-jar PUBLIC '-//Sun Microsystems, Inc.//DTD Enterprise JavaBeans 2.0//EN' 'http://java.sun.com/dtd/ejb-jar_2_0.dtd'>
<ejb-jar>
  <display-name>EntityBeanTest JAR</display-name>
  <enterprise-beans>
    <session>
      <display-name>MovieMakerBean</display-name>
      <ejb-name>MovieMakerBean</ejb-name>
      <home>beans.MovieMakerHome</home>
      <remote>beans.MovieMaker</remote>
      <ejb-class>beans.MovieMakerBean</ejb-class>
      <session-type>Stateless</session-type>
      <transaction-type>Container</transaction-type>
      <ejb-local-ref>
        <ejb-ref-name>ejb/Movie</ejb-ref-name>
        <ejb-ref-type>Entity</ejb-ref-type>
        <local-home>beans.MovieHome</local-home>
        <local>beans.Movie</local>
        <ejb-link>ejb-jar-ic.jar#MovieBean</ejb-link>
      </ejb-local-ref>
      <ejb-local-ref>
        <ejb-ref-name>ejb/Trailer</ejb-ref-name>
        <ejb-ref-type>Entity</ejb-ref-type>
        <local-home>beans.TrailerHome</local-home>
        <local>beans.Trailer</local>
        <ejb-link>ejb-jar-ic.jar#TrailerBean</ejb-link>
      </ejb-local-ref>
      <security-identity>
        <description></description>
        <use-caller-identity></use-caller-identity>
      </security-identity>
    </session>
    <entity>
      <display-name>MovieBean</display-name>
      <ejb-name>MovieBean</ejb-name>
      <local-home>beans.MovieHome</local-home>
      <local>beans.Movie</local>
      <ejb-class>beans.MovieBean</ejb-class>
      <persistence-type>Container</persistence-type>
      <prim-key-class>java.lang.String</prim-key-class>
      <reentrant>False</reentrant>
      <cmp-version>2.x</cmp-version>
      <abstract-schema-name>Movie</abstract-schema-name>
      <cmp-field>
        <description>no description</description>
        <field-name>movieId</field-name>
      </cmp-field>
      <cmp-field>
        <description>no description</description>
        <field-name>movieName</field-name>
      </cmp-field>
      <primkey-field>movieId</primkey-field>
      <security-identity>
        <description></description>
        <use-caller-identity></use-caller-identity>
      </security-identity>
      <query>
        <description></description>
        <query-method>
          <method-name>ejbSelectGetTrailerFor</method-name>
          <method-params>
            <method-param>java.lang.String</method-param>
          </method-params>
        </query-method>
        <result-type-mapping>Local</result-type-mapping>
        <ejb-ql>SELECT OBJECT(t) FROM Movie m, Trailer t WHERE m.movieName = ?1 and m.movieId = t.movie.movieId</ejb-ql>
      </query>
      <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>
    </entity>
    <entity>
      <display-name>TrailerBean</display-name>
      <ejb-name>TrailerBean</ejb-name>
      <local-home>beans.TrailerHome</local-home>
      <local>beans.Trailer</local>
      <ejb-class>beans.TrailerBean</ejb-class>
      <persistence-type>Container</persistence-type>
      <prim-key-class>java.lang.String</prim-key-class>
      <reentrant>False</reentrant>
      <cmp-version>2.x</cmp-version>
      <abstract-schema-name>Trailer</abstract-schema-name>
      <cmp-field>
        <description>no description</description>
        <field-name>trailerId</field-name>
      </cmp-field>
      <cmp-field>
        <description>no description</description>
        <field-name>description</field-name>
      </cmp-field>
      <primkey-field>trailerId</primkey-field>
      <security-identity>
        <description></description>
        <use-caller-identity></use-caller-identity>
      </security-identity>
    </entity>
  </enterprise-beans>
  <relationships>
    <ejb-relation>
      <ejb-relationship-role>
        <ejb-relationship-role-name>MovieBean</ejb-relationship-role-name>
        <multiplicity>One</multiplicity>
        <relationship-role-source>
          <ejb-name>MovieBean</ejb-name>
        </relationship-role-source>
        <cmr-field>
          <cmr-field-name>trailer</cmr-field-name>
        </cmr-field>
      </ejb-relationship-role>
      <ejb-relationship-role>
        <ejb-relationship-role-name>TrailerBean</ejb-relationship-role-name>
        <multiplicity>One</multiplicity>
        <cascade-delete />
        <relationship-role-source>
          <ejb-name>TrailerBean</ejb-name>
        </relationship-role-source>
        <cmr-field>
          <cmr-field-name>movie</cmr-field-name>
        </cmr-field>
      </ejb-relationship-role>
    </ejb-relation>
  </relationships>
  <assembly-descriptor>
    <method-permission>
      <unchecked />
      <method>
        <ejb-name>MovieMakerBean</ejb-name>
        <method-intf>Home</method-intf>
        <method-name>remove</method-name>
        <method-params>
          <method-param>java.lang.Object</method-param>
        </method-params>
      </method>
      <method>
        <ejb-name>MovieMakerBean</ejb-name>
        <method-intf>Remote</method-intf>
        <method-name>makeMovie</method-name>
        <method-params />
      </method>
      <method>
        <ejb-name>MovieMakerBean</ejb-name>
        <method-intf>Remote</method-intf>
        <method-name>getHandle</method-name>
        <method-params />
      </method>
      <method>
        <ejb-name>MovieMakerBean</ejb-name>
        <method-intf>Home</method-intf>
        <method-name>remove</method-name>
        <method-params>
          <method-param>javax.ejb.Handle</method-param>
        </method-params>
      </method>
      <method>
        <ejb-name>MovieMakerBean</ejb-name>
        <method-intf>Home</method-intf>
        <method-name>getHomeHandle</method-name>
        <method-params />
      </method>
      <method>
        <ejb-name>MovieMakerBean</ejb-name>
        <method-intf>Remote</method-intf>
        <method-name>getPrimaryKey</method-name>
        <method-params />
      </method>
      <method>
        <ejb-name>MovieMakerBean</ejb-name>
        <method-intf>Home</method-intf>
        <method-name>getEJBMetaData</method-name>
        <method-params />
      </method>
      <method>
        <ejb-name>MovieMakerBean</ejb-name>
        <method-intf>Remote</method-intf>
        <method-name>remove</method-name>
        <method-params />
      </method>
      <method>
        <ejb-name>MovieMakerBean</ejb-name>
        <method-intf>Home</method-intf>
        <method-name>create</method-name>
        <method-params />
      </method>
      <method>
        <ejb-name>MovieMakerBean</ejb-name>
        <method-intf>Remote</method-intf>
        <method-name>getAllMovies</method-name>
        <method-params />
      </method>
      <method>
        <ejb-name>MovieMakerBean</ejb-name>
        <method-intf>Remote</method-intf>
        <method-name>isIdentical</method-name>
        <method-params>
          <method-param>javax.ejb.EJBObject</method-param>
        </method-params>
      </method>
      <method>
        <ejb-name>MovieMakerBean</ejb-name>
        <method-intf>Remote</method-intf>
        <method-name>getTrailerDescByName</method-name>
        <method-params>
          <method-param>java.lang.String</method-param>
        </method-params>
      </method>
      <method>
        <ejb-name>MovieMakerBean</ejb-name>
        <method-intf>Remote</method-intf>
        <method-name>getEJBHome</method-name>
        <method-params />
      </method>
    </method-permission>
    <method-permission>
      <unchecked />
      <method>
        <ejb-name>MovieBean</ejb-name>
        <method-intf>LocalHome</method-intf>
        <method-name>remove</method-name>
        <method-params>
          <method-param>java.lang.Object</method-param>
        </method-params>
      </method>
      <method>
        <ejb-name>MovieBean</ejb-name>
        <method-intf>Local</method-intf>
        <method-name>getEJBLocalHome</method-name>
        <method-params />
      </method>
      <method>
        <ejb-name>MovieBean</ejb-name>
        <method-intf>LocalHome</method-intf>
        <method-name>getTrailerFor</method-name>
        <method-params>
          <method-param>java.lang.String</method-param>
        </method-params>
      </method>
      <method>
        <ejb-name>MovieBean</ejb-name>
        <method-intf>Local</method-intf>
        <method-name>getMovieTrailer</method-name>
        <method-params />
      </method>
      <method>
        <ejb-name>MovieBean</ejb-name>
        <method-intf>Local</method-intf>
        <method-name>getName</method-name>
        <method-params />
      </method>
      <method>
        <ejb-name>MovieBean</ejb-name>
        <method-intf>LocalHome</method-intf>
        <method-name>findByPrimaryKey</method-name>
        <method-params>
          <method-param>java.lang.String</method-param>
        </method-params>
      </method>
      <method>
        <ejb-name>MovieBean</ejb-name>
        <method-intf>Local</method-intf>
        <method-name>getPrimaryKey</method-name>
        <method-params />
      </method>
      <method>
        <ejb-name>MovieBean</ejb-name>
        <method-intf>Local</method-intf>
        <method-name>remove</method-name>
        <method-params />
      </method>
      <method>
        <ejb-name>MovieBean</ejb-name>
        <method-intf>LocalHome</method-intf>
        <method-name>findAllMovies</method-name>
        <method-params />
      </method>
      <method>
        <ejb-name>MovieBean</ejb-name>
        <method-intf>LocalHome</method-intf>
        <method-name>create</method-name>
        <method-params>
          <method-param>java.lang.String</method-param>
          <method-param>java.lang.String</method-param>
        </method-params>
      </method>
      <method>
        <ejb-name>MovieBean</ejb-name>
        <method-intf>Local</method-intf>
        <method-name>isIdentical</method-name>
        <method-params>
          <method-param>javax.ejb.EJBLocalObject</method-param>
        </method-params>
      </method>
      <method>
        <ejb-name>MovieBean</ejb-name>
        <method-intf>Local</method-intf>
        <method-name>setMovieTrailer</method-name>
        <method-params>
          <method-param>beans.Trailer</method-param>
        </method-params>
      </method>
    </method-permission>
    <method-permission>
      <unchecked />
      <method>
        <ejb-name>TrailerBean</ejb-name>
        <method-intf>Local</method-intf>
        <method-name>setTrailerMovie</method-name>
        <method-params>
          <method-param>beans.Movie</method-param>
        </method-params>
      </method>
      <method>
        <ejb-name>TrailerBean</ejb-name>
        <method-intf>LocalHome</method-intf>
        <method-name>remove</method-name>
        <method-params>
          <method-param>java.lang.Object</method-param>
        </method-params>
      </method>
      <method>
        <ejb-name>TrailerBean</ejb-name>
        <method-intf>Local</method-intf>
        <method-name>getTrailerDescription</method-name>
        <method-params />
      </method>
      <method>
        <ejb-name>TrailerBean</ejb-name>
        <method-intf>Local</method-intf>
        <method-name>getEJBLocalHome</method-name>
        <method-params />
      </method>
      <method>
        <ejb-name>TrailerBean</ejb-name>
        <method-intf>LocalHome</method-intf>
        <method-name>findByPrimaryKey</method-name>
        <method-params>
          <method-param>java.lang.String</method-param>
        </method-params>
      </method>
      <method>
        <ejb-name>TrailerBean</ejb-name>
        <method-intf>Local</method-intf>
        <method-name>getTrailerMovie</method-name>
        <method-params />
      </method>
      <method>
        <ejb-name>TrailerBean</ejb-name>
        <method-intf>Local</method-intf>
        <method-name>getPrimaryKey</method-name>
        <method-params />
      </method>
      <method>
        <ejb-name>TrailerBean</ejb-name>
        <method-intf>Local</method-intf>
        <method-name>remove</method-name>
        <method-params />
      </method>
      <method>
        <ejb-name>TrailerBean</ejb-name>
        <method-intf>LocalHome</method-intf>
        <method-name>create</method-name>
        <method-params>
          <method-param>java.lang.String</method-param>
          <method-param>java.lang.String</method-param>
        </method-params>
      </method>
      <method>
        <ejb-name>TrailerBean</ejb-name>
        <method-intf>Local</method-intf>
        <method-name>isIdentical</method-name>
        <method-params>
          <method-param>javax.ejb.EJBLocalObject</method-param>
        </method-params>
      </method>
    </method-permission>
    <container-transaction>
      <method>
        <ejb-name>MovieMakerBean</ejb-name>
        <method-intf>Remote</method-intf>
        <method-name>getAllMovies</method-name>
        <method-params />
      </method>
      <trans-attribute>Required</trans-attribute>
    </container-transaction>
    <container-transaction>
      <method>
        <ejb-name>MovieMakerBean</ejb-name>
        <method-intf>Remote</method-intf>
        <method-name>getTrailerDescByName</method-name>
        <method-params>
          <method-param>java.lang.String</method-param>
        </method-params>
      </method>
      <trans-attribute>Required</trans-attribute>
    </container-transaction>
    <container-transaction>
      <method>
        <ejb-name>MovieMakerBean</ejb-name>
        <method-intf>Remote</method-intf>
        <method-name>makeMovie</method-name>
        <method-params />
      </method>
      <trans-attribute>Required</trans-attribute>
    </container-transaction>
    <container-transaction>
      <method>
        <ejb-name>MovieBean</ejb-name>
        <method-intf>Local</method-intf>
        <method-name>getMovieTrailer</method-name>
        <method-params />
      </method>
      <trans-attribute>Required</trans-attribute>
    </container-transaction>
    <container-transaction>
      <method>
        <ejb-name>MovieBean</ejb-name>
        <method-intf>LocalHome</method-intf>
        <method-name>create</method-name>
        <method-params>
          <method-param>java.lang.String</method-param>
          <method-param>java.lang.String</method-param>
        </method-params>
      </method>
      <trans-attribute>Required</trans-attribute>
    </container-transaction>
    <container-transaction>
      <method>
        <ejb-name>MovieBean</ejb-name>
        <method-intf>Local</method-intf>
        <method-name>getName</method-name>
        <method-params />
      </method>
      <trans-attribute>Required</trans-attribute>
    </container-transaction>
    <container-transaction>
      <method>
        <ejb-name>MovieBean</ejb-name>
        <method-intf>Local</method-intf>
        <method-name>setMovieTrailer</method-name>
        <method-params>
          <method-param>beans.Trailer</method-param>
        </method-params>
      </method>
      <trans-attribute>Required</trans-attribute>
    </container-transaction>
    <container-transaction>
      <method>
        <ejb-name>MovieBean</ejb-name>
        <method-intf>LocalHome</method-intf>
        <method-name>remove</method-name>
        <method-params>
          <method-param>java.lang.Object</method-param>
        </method-params>
      </method>
      <trans-attribute>Required</trans-attribute>
    </container-transaction>
    <container-transaction>
      <method>
        <ejb-name>MovieBean</ejb-name>
        <method-intf>Local</method-intf>
        <method-name>remove</method-name>
        <method-params />
      </method>
      <trans-attribute>Required</trans-attribute>
    </container-transaction>
    <container-transaction>
      <method>
        <ejb-name>MovieBean</ejb-name>
        <method-intf>LocalHome</method-intf>
        <method-name>findByPrimaryKey</method-name>
        <method-params>
          <method-param>java.lang.String</method-param>
        </method-params>
      </method>
      <trans-attribute>Required</trans-attribute>
    </container-transaction>
    <container-transaction>
      <method>
        <ejb-name>TrailerBean</ejb-name>
        <method-intf>LocalHome</method-intf>
        <method-name>create</method-name>
        <method-params>
          <method-param>java.lang.String</method-param>
          <method-param>java.lang.String</method-param>
        </method-params>
      </method>
      <trans-attribute>Required</trans-attribute>
    </container-transaction>
    <container-transaction>
      <method>
        <ejb-name>TrailerBean</ejb-name>
        <method-intf>LocalHome</method-intf>
        <method-name>remove</method-name>
        <method-params>
          <method-param>java.lang.Object</method-param>
        </method-params>
      </method>
      <trans-attribute>Required</trans-attribute>
    </container-transaction>
    <container-transaction>
      <method>
        <ejb-name>TrailerBean</ejb-name>
        <method-intf>Local</method-intf>
        <method-name>getTrailerDescription</method-name>
        <method-params />
      </method>
      <trans-attribute>Required</trans-attribute>
    </container-transaction>
    <container-transaction>
      <method>
        <ejb-name>TrailerBean</ejb-name>
        <method-intf>Local</method-intf>
        <method-name>setTrailerMovie</method-name>
        <method-params>
          <method-param>beans.Movie</method-param>
        </method-params>
      </method>
      <trans-attribute>Required</trans-attribute>
    </container-transaction>
    <container-transaction>
      <method>
        <ejb-name>TrailerBean</ejb-name>
        <method-intf>Local</method-intf>
        <method-name>remove</method-name>
        <method-params />
      </method>
      <trans-attribute>Required</trans-attribute>
    </container-transaction>
    <container-transaction>
      <method>
        <ejb-name>TrailerBean</ejb-name>
        <method-intf>LocalHome</method-intf>
        <method-name>findByPrimaryKey</method-name>
        <method-params>
          <method-param>java.lang.String</method-param>
        </method-params>
      </method>
      <trans-attribute>Required</trans-attribute>
    </container-transaction>
    <container-transaction>
      <method>
        <ejb-name>TrailerBean</ejb-name>
        <method-intf>Local</method-intf>
        <method-name>getTrailerMovie</method-name>
        <method-params />
      </method>
      <trans-attribute>Required</trans-attribute>
    </container-transaction>
  </assembly-descriptor>
</ejb-jar>

[Gowher Naik]

Thanks Satou kurinosuke
Now i will try this example.
Please send me .ear file of above example.

[Gowher Naik]

my email id is [email protected]

[Christophe Verré]

gowher,
I wanted to send you the ear, but I can't use email.
I've made this sample at my office, and the security policy is really strict.(no mail, no ftp. I'm lucky enough to be able to use the ranch !)
I hope you can make one yourself. It's not difficult to make one with Deploytool. Sorry for the inconvenience.

[Gowher Naik]

i deployed and run above bean successfully.
I have some doubts which i will ask you.
Thanks

[Gowher Naik]

Hi Satou
Tables created by above bean are as follows

SQL> select * from "TrailerBeanTable";

_movie_movieId description trailerId
------------- ----------- --------
RB1 Trailer for RB1 TR1

SQL> select * from "MovieBeanTable";

_trailer_trailerId movieId movieName
------------------ --------- ----------
TR1 RB1 Return of the beans

In "TrailerBeanTable" table what is _movie_movieId?

In "MovieBeanTable" table what is _trailer_trailerId?

if they are Foreign keys then why DB let me insert row(using oracle console directly) for "TrailerBeanTable" which is not present in "MovieBeanTable" table?

Thanks

[Christophe Verré]

It depends on the way the tool creates tables. It may not be foreign keys. In the Deploytool, you can check the generated SQLs when using "Auto generate SQL". It might be only standard columns refering to another table's column.