Entity With Secondary Table
File: EmployeeService.java import javax.ejb.Stateless; import javax.persistence.EntityManager; import javax.persistence.PersistenceContext; @Stateless public class EmployeeService implements EmployeeServiceLocal, EmployeeServiceRemote { @PersistenceContext(unitName="EmployeeService") EntityManager em; public EmployeeService() { } public void doAction(){ Employee cust = new Employee(); cust.setFirstName("B"); cust.setLastName("B"); cust.setStreet("Street"); cust.setCity("Boston"); cust.setState("MA"); em.persist(cust); em.flush(); System.out.println("saved"); } } File: EmployeeServiceLocal.java import java.util.Collection; import javax.ejb.Local; @Local public interface EmployeeServiceLocal { public void doAction(); } File: EmployeeServiceRemote.java import java.util.Collection; import javax.ejb.Remote; @Remote public interface EmployeeServiceRemote{ public void doAction(); } File: Employee.java import java.io.Serializable; import javax.persistence.*; @Entity @Table(name="Employee_TABLE") @SecondaryTable(name="ADDRESS_TABLE", pkJoinColumns={ @PrimaryKeyJoinColumn(name="ADDRESS_ID")}) public class Employee implements java.io.Serializable { private long id; private String firstName; private String lastName; private String street; private String city; private String state; @Id @GeneratedValue public long getId() { return id; } public void setId(long id) { this.id = id; } public String getFirstName() { return firstName; } public void setFirstName(String first) { this.firstName = first; } public String getLastName() { return lastName; } public void setLastName(String last) { this.lastName = last; } @Column(name="STREET", table="ADDRESS_TABLE") public String getStreet() { return street; } public void setStreet(String street) { this.street = street; } @Column(name="CITY", table="ADDRESS_TABLE") public String getCity() { return city; } public void setCity(String city) { this.city = city; } @Column(name="STATE", table="ADDRESS_TABLE") public String getState() { return state; } public void setState(String state) { this.state = state; } } File: Main.java import java.util.Collection; import javax.naming.InitialContext; public class Main { public static void main(String[] a) throws Exception { EmployeeServiceRemote service = null; // Context compEnv = (Context) new InitialContext().lookup("java:comp/env"); // service = (HelloService)new InitialContext().lookup("java:comp/env/ejb/HelloService"); service = (EmployeeServiceRemote) new InitialContext().lookup("EmployeeService/remote"); service.doAction(); } } File: jndi.properties java.naming.factory.initial=org.jnp.interfaces.NamingContextFactory java.naming.factory.url.pkgs=org.jboss.naming:org.jnp.interfaces java.naming.provider.url=localhost:1099
1. | Set Primary Key Join Column For Secondary Table | ![]() | |
2. | EJB Tutorial from JBoss: secondary table | ![]() |