What if SFSB_2 has not yet been created? Here is what i am trying to do. I have 3 tables: Person, Room and Attendance. I used the reverse engineer hibernate tool to build JBoss seam framework for all 3. I have added a check box to the findPerson jsf such that when they click on that I need to create an Attendance record from the PersonFinderBean SFSB EJB. The Attendance record has PersonId, RoomId and some other fields.

How do I create that Attendance record from the within the PersonFinderBean EJB?

This, obviously does not work (look at the checkIn() method:

PersonFinderBean.java

package testSeam;

// Generated Sep 23, 2006 1:30:01 PM by Hibernate Tools 3.2.0.beta7

import java.util.HashMap;
import java.util.List;
import java.util.Map;
import java.util.Map.Entry;
import java.util.Random;
import java.util.Date;
import javax.ejb.Remove;
import javax.ejb.Stateful;
import javax.interceptor.Interceptors;
import javax.persistence.EntityManager;
import javax.persistence.Query;
import org.jboss.seam.ScopeType;
import org.jboss.seam.annotations.Destroy;
import org.jboss.seam.annotations.In;
import org.jboss.seam.annotations.Name;
import org.jboss.seam.annotations.RequestParameter;
import org.jboss.seam.annotations.Scope;
import org.jboss.seam.annotations.datamodel.DataModel;
import org.jboss.seam.annotations.datamodel.DataModelSelection;
import org.jboss.seam.ejb.SeamInterceptor;

@Name("personFinder")
@Stateful
@Scope(ScopeType.SESSION)
@Interceptors(SeamInterceptor.class)
public class PersonFinderBean implements PersonFinder {

 private Person example = new Person();

 public Person getExample() {
 return example;
 }

 Users instance = new Users();

 @In(required=false)
 private Login login;

 private AttendanceEditor attendanceRecord = ;

 private int pageNumber = 0;
 private int pageSize = 20;
 private boolean registered = false;

 public String getSecurityCode() {
 return "83738392";
 }

 public void setRegistered(boolean value) {
 registered = value;
 }

 public boolean getRegistered() {
 return registered;
 }

 public void setPageSize(int size) {
 pageSize = size;
 }

 public int getPageSize() {
 return pageSize;
 }

 public boolean isPreviousPage() {
 return personList != null && pageNumber > 0;
 }

 public boolean isNextPage() {
 return personList != null && personList.size() == pageSize;
 }

 @DataModel
 private List<Person> personList;

 @DataModelSelection
 private Person selectedPerson;

 @In(create = true)
 private EntityManager entityManager;

 private void executeQuery() {
 Map<String, Object> parameters = new HashMap<String, Object>();
 StringBuffer queryString = new StringBuffer();
 if (example.getId() != 0) {
 queryString.append(" and person.id = :id");
 parameters.put("id", example.getId());
 }
 if (example.getRoomId() != 0) {
 queryString.append(" and person.roomId = :roomId");
 parameters.put("roomId", example.getRoomId());
 }
 if (example.getOrganizationId() != 0) {
 queryString.append(" and person.organizationId = :organizationId");
 parameters.put("organizationId", example.getOrganizationId());
 }
 if (example.getFirstName() != null && example.getFirstName().length() > 0) {
 queryString.append(" and person.firstName like :firstName");
 parameters.put("firstName", '%' + example.getFirstName() + '%');
 }
 if (example.getMiddleName() != null
 && example.getMiddleName().length() > 0) {
 queryString.append(" and person.middleName like :middleName");
 parameters.put("middleName", '%' + example.getMiddleName() + '%');
 }
 if (example.getLastName() != null && example.getLastName().length() > 0) {
 queryString.append(" and person.lastName like :lastName");
 parameters.put("lastName", '%' + example.getLastName() + '%');
 }
 if (example.getAddress1() != null && example.getAddress1().length() > 0) {
 queryString.append(" and person.address1 like :address1");
 parameters.put("address1", '%' + example.getAddress1() + '%');
 }
 if (example.getCity() != null && example.getCity().length() > 0) {
 queryString.append(" and person.city like :city");
 parameters.put("city", '%' + example.getCity() + '%');
 }
 if (example.getState() != null && example.getState().length() > 0) {
 queryString.append(" and person.state like :state");
 parameters.put("state", '%' + example.getState() + '%');
 }
 if (example.getZip() != null && example.getZip().length() > 0) {
 queryString.append(" and person.zip like :zip");
 parameters.put("zip", '%' + example.getZip() + '%');
 }
 if (example.getEmail() != null && example.getEmail().length() > 0) {
 queryString.append(" and person.email like :email");
 parameters.put("email", '%' + example.getEmail() + '%');
 }
 if (example.getBirthday() != null) {
 queryString.append(" and person.birthday = :birthday");
 parameters.put("birthday", example.getBirthday());
 }
 if (example.getSex() != null) {
 queryString.append(" and person.sex = :sex");
 parameters.put("sex", example.getSex());
 }
 if (example.getHomePhone() != null
 && example.getHomePhone().length() > 0) {
 queryString.append(" and person.homePhone like :homePhone");
 parameters.put("homePhone", '%' + example.getHomePhone() + '%');
 }
 if (example.getWorkPhone() != null
 && example.getWorkPhone().length() > 0) {
 queryString.append(" and person.workPhone like :workPhone");
 parameters.put("workPhone", '%' + example.getWorkPhone() + '%');
 }
 if (example.getBeeperPhone() != null
 && example.getBeeperPhone().length() > 0) {
 queryString.append(" and person.beeperPhone like :beeperPhone");
 parameters.put("beeperPhone", '%' + example.getBeeperPhone() + '%');
 }
 if (example.getCellPhone() != null
 && example.getCellPhone().length() > 0) {
 queryString.append(" and person.cellPhone like :cellPhone");
 parameters.put("cellPhone", '%' + example.getCellPhone() + '%');
 }
 if (example.getExtraPhone() != null
 && example.getExtraPhone().length() > 0) {
 queryString.append(" and person.extraPhone like :extraPhone");
 parameters.put("extraPhone", '%' + example.getExtraPhone() + '%');
 }
 if (example.getExtraPhoneMemo() != null
 && example.getExtraPhoneMemo().length() > 0) {
 queryString
 .append(" and person.extraPhoneMemo like :extraPhoneMemo");
 parameters.put("extraPhoneMemo",
 '%' + example.getExtraPhoneMemo() + '%');
 }
 if (example.getSchool() != null && example.getSchool().length() > 0) {
 queryString.append(" and person.school like :school");
 parameters.put("school", '%' + example.getSchool() + '%');
 }
 if (example.getSchoolGrade() != null
 && example.getSchoolGrade().length() > 0) {
 queryString.append(" and person.schoolGrade like :schoolGrade");
 parameters.put("schoolGrade", '%' + example.getSchoolGrade() + '%');
 }
 if (example.getContact() != null && example.getContact().length() > 0) {
 queryString.append(" and person.contact like :contact");
 parameters.put("contact", '%' + example.getContact() + '%');
 }
 if (example.getParentName() != null
 && example.getParentName().length() > 0) {
 queryString.append(" and person.parentName like :parentName");
 parameters.put("parentName", '%' + example.getParentName() + '%');
 }
 if (example.getComments() != null && example.getComments().length() > 0) {
 queryString.append(" and person.comments like :comments");
 parameters.put("comments", '%' + example.getComments() + '%');
 }
 if (example.getMinsitry() != null && example.getMinsitry().length() > 0) {
 queryString.append(" and person.minsitry like :minsitry");
 parameters.put("minsitry", '%' + example.getMinsitry() + '%');
 }
 if (example.getDrama() != null) {
 queryString.append(" and person.drama = :drama");
 parameters.put("drama", example.getDrama());
 }
 if (example.getMusic() != null) {
 queryString.append(" and person.music = :music");
 parameters.put("music", example.getMusic());
 }
 if (example.getStatus() != null) {
 queryString.append(" and person.status = :status");
 parameters.put("status", example.getStatus());
 }
 if (example.getVisitor() != null) {
 queryString.append(" and person.visitor = :visitor");
 parameters.put("visitor", example.getVisitor());
 }
 if (example.getMailList() != null) {
 queryString.append(" and person.mailList = :mailList");
 parameters.put("mailList", example.getMailList());
 }
 if (example.getLeader() != null) {
 queryString.append(" and person.leader = :leader");
 parameters.put("leader", example.getLeader());
 }
 if (example.getLastAttended() != null) {
 queryString.append(" and person.lastAttended = :lastAttended");
 parameters.put("lastAttended", example.getLastAttended());
 }
 if (example.getCreated() != null) {
 queryString.append(" and person.created = :created");
 parameters.put("created", example.getCreated());
 }
 if (example.getUpdated() != null) {
 queryString.append(" and person.updated = :updated");
 parameters.put("updated", example.getUpdated());
 }
 if (example.getVcall() != null) {
 queryString.append(" and person.vcall = :vcall");
 parameters.put("vcall", example.getVcall());
 }
 if (example.getVhouseCall() != null) {
 queryString.append(" and person.vhouseCall = :vhouseCall");
 parameters.put("vhouseCall", example.getVhouseCall());
 }
 if (example.getTeam() != null && example.getTeam().length() > 0) {
 queryString.append(" and person.team like :team");
 parameters.put("team", '%' + example.getTeam() + '%');
 }
 if (example.getPhotoFile() != null
 && example.getPhotoFile().length() > 0) {
 queryString.append(" and person.photoFile like :photoFile");
 parameters.put("photoFile", '%' + example.getPhotoFile() + '%');
 }
 if (example.getUniqueId() != null && example.getUniqueId().length() > 0) {
 queryString.append(" and person.uniqueId like :uniqueId");
 parameters.put("uniqueId", '%' + example.getUniqueId() + '%');
 }
 if (queryString.length() == 0) {
 queryString.append("select person from Person person");
 } else {
 queryString.delete(0, 4).insert(0,
 "select person from Person person where");
 }

 if (order != null) {
 queryString.append(" order by person.").append(order);
 if (descending)
 queryString.append(" desc");
 }

 Query query = entityManager.createQuery(queryString.toString());
 for (Entry<String, Object> param : parameters.entrySet()) {
 query.setParameter(param.getKey(), param.getValue());
 }
 personList = (List<Person>) query.setMaxResults(pageSize)
 .setFirstResult(pageSize * pageNumber).getResultList();
 }

 public String findFirstPage() {
 pageNumber = 0;
 executeQuery();
 return null;
 }

 public String findNextPage() {
 pageNumber++;
 executeQuery();
 return null;
 }

 public String findPreviousPage() {
 pageNumber--;
 executeQuery();
 return null;
 }

 public void refresh() {
 if (personList != null)
 executeQuery();
 }

 public String clear() {
 personList = null;
 example = new Person();
 return null;
 }

 public Person getSelection() {
 return entityManager.merge(selectedPerson);
 }

 @Destroy
 @Remove
 public void destroy() {
 }

 private String order;

 private boolean descending = false;

 @RequestParameter
 private String orderBy;
 private int id;

 public String reorder() {
 if (orderBy.equals(order)) {
 descending = !descending;
 } else {
 descending = false;
 }
 order = orderBy;
 executeQuery();
 return null;
 }

 public String checkIn() {
 int parmId = id;
 // insert new record into attendance table
 System.out.println("I check'd em in...:"+id);
 System.out.println("I am from church:"+login.getInstance().getOrganizationId());
 int organization = login.getInstance().getOrganizationId();

 java.util.Random rNum = new Random(123456);
 Attendance attend = attendanceRecord.getInstance();

 attend.setCheckedByUserId(login.getInstance().getId());
 attend.setDateTimeEntry(new Date());
 attend.setPersonId(example.getId());
 attend.setRoomId(example.getRoomId());
 attend.setSecurityCode(""+rNum.nextInt());
 attend.setType("In");
 attendanceRecord.create();

 return "code:"+rNum.nextInt();
 }
}

package testSeam;

// Generated Oct 6, 2006 12:57:37 AM by Hibernate Tools 3.2.0.beta7

import java.util.Map;
import javax.ejb.Remove;
import javax.ejb.Stateful;
import javax.ejb.TransactionAttribute;
import static javax.ejb.TransactionAttributeType.NOT_SUPPORTED;
import javax.faces.application.FacesMessage;
import javax.faces.context.FacesContext;
import javax.interceptor.Interceptors;
import javax.persistence.EntityManager;
import org.hibernate.validator.Valid;
import org.jboss.seam.annotations.Begin;
import org.jboss.seam.annotations.Destroy;
import org.jboss.seam.annotations.End;
import org.jboss.seam.annotations.IfInvalid;
import org.jboss.seam.annotations.In;
import org.jboss.seam.annotations.Name;
import org.jboss.seam.annotations.Outcome;
import org.jboss.seam.ejb.SeamInterceptor;

@Name("attendanceEditor")
@Stateful
@Interceptors(SeamInterceptor.class)
public class AttendanceEditorBean implements AttendanceEditor {

 @In(create = true)
 private EntityManager entityManager;

 @Valid
 private Attendance instance = new Attendance();

 @TransactionAttribute(NOT_SUPPORTED)
 public Attendance getInstance() {
 return instance;
 }

 public void setInstance(Attendance instance) {
 this.instance = instance;
 }

 private boolean isNew = true;

 @TransactionAttribute(NOT_SUPPORTED)
 public boolean isNew() {
 return isNew;
 }

 public void setNew(boolean isNew) {
 this.isNew = isNew;
 }

 private String doneOutcome = "find";

 public void setDoneOutcome(String outcome) {
 doneOutcome = outcome;
 }

 @In(required = false)
 private transient AttendanceFinder attendanceFinder;

 @In(create = true)
 private transient Map messages;

 @Begin(join = true)
 @IfInvalid(outcome = Outcome.REDISPLAY)
 public String create() {
 if (entityManager.find(Attendance.class, instance.getId()) != null) {
 FacesContext.getCurrentInstance().addMessage(
 null,
 new FacesMessage(messages.get("Attendance_id") + " "
 + messages.get("AlreadyExists")));
 return null;
 }
 entityManager.persist(instance);
 isNew = false;
 refreshFinder();
 return "editAttendance";
 }

 @IfInvalid(outcome = Outcome.REDISPLAY)
 public String update() {
 refreshFinder();
 return null;
 }

 @End(ifOutcome = "find")
 public String delete() {
 entityManager.remove(instance);
 refreshFinder();
 return doneOutcome;
 }

 @End(ifOutcome = "find")
 public String done() {
 if (!isNew)
 entityManager.refresh(instance);
 return doneOutcome;
 }

 private void refreshFinder() {
 if (attendanceFinder != null)
 attendanceFinder.refresh();
 }

 @Destroy
 @Remove
 public void destroy() {
 }

}

package testSeam;

// Generated Oct 6, 2006 12:57:37 AM by Hibernate Tools 3.2.0.beta7

import java.util.Date;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.Id;
import javax.persistence.Table;

/**
 * Attendance generated by hbm2java
 */
@Entity
@Table(name = "attendance", catalog = "checkin", uniqueConstraints = {})
public class Attendance implements java.io.Serializable {

 // Fields

 private int id;

 private String type;

 private int personId;

 private Date dateTimeEntry;

 private int checkedByUserId;

 private String securityCode;

 private int roomId;

 // Constructors

 /** default constructor */
 public Attendance() {
 }

 /** full constructor */
 public Attendance(int id, String type, int personId, Date dateTimeEntry,
 int checkedByUserId, String securityCode, int roomId) {
 this.id = id;
 this.type = type;
 this.personId = personId;
 this.dateTimeEntry = dateTimeEntry;
 this.checkedByUserId = checkedByUserId;
 this.securityCode = securityCode;
 this.roomId = roomId;
 }

 // Property accessors
 @Id
 @Column(name = "ID", unique = true, nullable = false, insertable = true, updatable = true)
 public int getId() {
 return this.id;
 }

 public void setId(int id) {
 this.id = id;
 }

 @Column(name = "Type", unique = false, nullable = false, insertable = true, updatable = true, length = 10)
 public String getType() {
 return this.type;
 }

 public void setType(String type) {
 this.type = type;
 }

 @Column(name = "PersonID", unique = false, nullable = false, insertable = true, updatable = true)
 public int getPersonId() {
 return this.personId;
 }

 public void setPersonId(int personId) {
 this.personId = personId;
 }

 @Column(name = "DateTimeEntry", unique = false, nullable = false, insertable = true, updatable = true, length = 19)
 public Date getDateTimeEntry() {
 return this.dateTimeEntry;
 }

 public void setDateTimeEntry(Date dateTimeEntry) {
 this.dateTimeEntry = dateTimeEntry;
 }

 @Column(name = "CheckedByUserId", unique = false, nullable = false, insertable = true, updatable = true)
 public int getCheckedByUserId() {
 return this.checkedByUserId;
 }

 public void setCheckedByUserId(int checkedByUserId) {
 this.checkedByUserId = checkedByUserId;
 }

 @Column(name = "SecurityCode", unique = false, nullable = false, insertable = true, updatable = true, length = 50)
 public String getSecurityCode() {
 return this.securityCode;
 }

 public void setSecurityCode(String securityCode) {
 this.securityCode = securityCode;
 }

 @Column(name = "RoomId", unique = false, nullable = false, insertable = true, updatable = true)
 public int getRoomId() {
 return this.roomId;
 }

 public void setRoomId(int roomId) {
 this.roomId = roomId;
 }

}

Thanks. All I needed to see was:

1) Ask attendanceEditor for a new attendance record