[jboss-user] [EJB 3.0] - EJB 3 OneToMany with Composite Key
Hi all,
Having a problem setting up my first EJB 3 OneToMany relationship with a composite key.
Here's the error:
14:09:01,812 WARN [JDBCExceptionReporter] SQL Error: 957, SQLState: 42000
14:09:01,812 ERROR [JDBCExceptionReporter] ORA-00957: duplicate column name
The 'One' Entity:
|
|
| import javax.persistence.*;
| import java.io.Serializable;
| import java.util.Collection;
|
|
|
| @Entity
| @Table(name = "COMMS_MESSAGES")
| public class CommsMessage implements Serializable
| {
|
| private int messageId;
|
| /**
| * Any attachments.
| */
| private Collection<CommsAttachment> commsAttachments;
|
|
| public CommsMessage()
| {
| }
|
|
| @Id
| @GeneratedValue(strategy = GenerationType.AUTO)
| public int getMessageId()
| {
| return messageId;
| }
|
| public void setMessageId(int messageId)
| {
| this.messageId = messageId;
| }
|
| @OneToMany(mappedBy = "commsMessage", cascade = {CascadeType.PERSIST,
CascadeType.REMOVE}, fetch=FetchType.LAZY)
| public Collection<CommsAttachment> getCommsAttachments()
| {
| return commsAttachments;
| }
|
| public void setCommsAttachments(Collection<CommsAttachment> commsAttachments)
| {
| this.commsAttachments = commsAttachments;
| }
|
|
|
| }
|
|
The 'Many' Entity:
|
|
| import javax.persistence.*;
| import java.io.Serializable;
|
| /**
| * Comms Message Entity Bean
| *
| * @author Dean Pullen
| * @since 03-Jul-2007
| */
| @Entity
| @Table(name = "COMMS_MESSAGE_RECIPIENTS")
| @IdClass(CommsMessageRecipientPK.class)
| public class CommsMessageRecipient implements Serializable
| {
| private CommsMessage commsMessage;
|
| private int messageId;
|
| private int recipientUserId;
|
|
| public CommsMessageRecipient()
| {
| }
|
| @ManyToOne
| @JoinColumn(name = "messageid")
| public CommsMessage getCommsMessage()
| {
| return commsMessage;
| }
|
| public void setCommsMessage(CommsMessage commsMessage)
| {
| this.commsMessage = commsMessage;
| }
|
| @Id
| public int getMessageId()
| {
| return messageId;
| }
|
| public void setMessageId(int messageId)
| {
| this.messageId = messageId;
| }
|
| @Id
| public int getRecipientUserId()
| {
| return recipientUserId;
| }
|
| public void setRecipientUserId(int recipientUserId)
| {
| this.recipientUserId = recipientUserId;
| }
| }
|
|
The Composite Key:
| package com.msp.ejb.lms.comms;
|
| import java.io.Serializable;
|
| public class CommsMessageRecipientPK implements Serializable
| {
| private int messageId;
|
| private int recipientUserId;
|
|
| public CommsMessageRecipientPK()
| {
| }
|
| public CommsMessageRecipientPK(int messageId, int recipientUserId)
| {
| this.messageId = messageId;
| this.recipientUserId = recipientUserId;
| }
|
|
| public int getMessageId()
| {
| return messageId;
| }
|
| public void setMessageId(int messageId)
| {
| this.messageId = messageId;
| }
|
| public int getRecipientUserId()
| {
| return recipientUserId;
| }
|
| public void setRecipientUserId(int recipientUserId)
| {
| this.recipientUserId = recipientUserId;
| }
|
|
| public boolean equals(Object o)
| {
| if (this == o) return true;
| if (o == null || getClass() != o.getClass()) return false;
|
| CommsMessageRecipientPK that = (CommsMessageRecipientPK) o;
|
| return messageId == that.messageId && recipientUserId ==
that.recipientUserId;
|
| }
|
| public int hashCode()
| {
| int result;
| result = messageId;
| result = 31 * result + recipientUserId;
| return result;
| }
| }
|
|
As you can see, I'm trying to map the CommsMessage to multiple CommsRecipients using
the 'messageid' value found in both tables.
Any help greatly appreciated.
View the original post :
http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4060466#...
Reply to the post :
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&a...