It seems to me that I can't be the only person that ever wanted an outer
join to a secondary table, but I have spent a whole day searching the
internet for a solution, and haven't seen one (except for a
Hibernate-specific one). I have a main employee table that may or may not
have some extra data populated in a related secondary table. If there is
data in the secondary table, then I would like my Employee entity to have
those fields filled in. If there isn't data for a given employee in the
secondary table, then I would like my Employee entity to have nulls in
those fields. Right now, if there's no row in the secondary table for a
given employee, I get nothing. Is there any way to force openjpa to do an
OUTER JOIN to the secondary table? I am using the version of openjpa that
comes in the WebSphere 6.1 feature pack, so I believe I am constrained to
use openjpa 1.0.1, unless someone can give me a method to replace the IBM
supplied jars.
Here's example code:
@Entity
@Table("EMPLOYEE")
@SecondaryTable("EMPLOYEE_EXTRA",
[EMAIL PROTECTED](name="EMPLOYEE_KEY"))
public class Employee implements java.io.Serializable {
private static final long serialVersionUID = -3789770304634576481L;
@Column(table="EMPLOYEE_EXTRA",
name="EMPLOYEE_EXTRA_DATA",nullable=true)
private String employeeExtraData;
@Id
@GeneratedValue(strategy=GenerationType.IDENTITY)
@Column(name="EMPLOYEE_KEY")
private Long employeeKey;
...etc
}
Gretchen Chiaramonte
Sun Certified Java Programmer
IBM Certified MQSeries Engineer
IBM Systems & Technology Group, Development
Tel: 1-919-517-1750
Tie: 255-1750
email: [EMAIL PROTECTED]
