Can a class be mapped to a table and be Embeddable at the same time?

[Timothy Sam]

I have this class called InventoryTransaction... I'm doing this in JPA

@Entity
@Table(name = "inventory_transaction")
@NamedQueries( {
@NamedQuery(name = "InventoryTransaction.findByTransactionId", query = "SELECT i FROM InventoryTransaction i WHERE i.transactionId = :transactionId"),
@NamedQuery(name = "InventoryTransaction.findByUserId", query = "SELECT i FROM InventoryTransaction i WHERE i.userId = :userId"),
@NamedQuery(name = "InventoryTransaction.findByDateCreated", query = "SELECT i FROM InventoryTransaction i WHERE i.dateCreated =  :D ateCreated")
})
public class InventoryTransaction implements Serializable {
 
@Id
  @GeneratedValue(strategy = GenerationType.IDENTITY)  
@Column(name = "transaction_id", nullable = false)
private Integer transactionId;
 
@Column(name = "user_id", nullable = false)
private int userId;
  
  @Embedded
  private Employee employeeId;
  
  @Column(name = "control_id", nullable = true)
  private String controlId; //can be fixed or consumable item
  
@Column(name = "date_created")
@Temporal(TemporalType.TIMESTAMP)
private Date dateCreated;
 
@JoinColumn(name = "transaction_type_id", referencedColumnName = "transaction_type_id")
@ManyToOne
private InventoryTransactionType transactionTypeId;  
 
...

Now, I need userId to be changed from an Integer to a InventoryUser object which is already existing and is mapped to a table.

@Entity
@Table(name = "inventory_user")
@NamedQueries( {
@NamedQuery(name = "InventoryUser.findByUserId", query = "SELECT i FROM InventoryUser i WHERE i.userId = :userId"),
@NamedQuery(name = "InventoryUser.findByEmployeeId", query = "SELECT i FROM InventoryUser i WHERE i.employeeId = :employeeId"),
@NamedQuery(name = "InventoryUser.findByUsername", query = "SELECT i FROM InventoryUser i WHERE i.username = :username"),
@NamedQuery(name = "InventoryUser.findByPassword", query = "SELECT i FROM InventoryUser i WHERE i.password =  :p assword")
})
public class InventoryUser implements Serializable {
 
@Id
        @GeneratedValue(strategy = GenerationType.IDENTITY)        
@Column(name = "user_id", nullable = false)
private Integer userId;
 
//@Column(name = "employee_id")
//private Integer employeeId;
        @Embedded
        private Employee employeeId;
 
@Column(name = "username")
private String username;
 
@Column(name = "password")
private String password;
 
@JoinColumn(name = "user_type_id", referencedColumnName = "user_type_id")
@ManyToOne
private InventoryUserType userTypeId;
 
@OneToMany(cascade = CascadeType.ALL, mappedBy = "assignedBy")
private Collection<FixedItem> fixedItemCollection;

I want my InventoryUser class to be embeddable and at the same time be mapped to a table. Is this possible? Thanks!
[ June 28, 2007: Message edited by: Timothy Sam ]

[Mike Keith]

It looks like InventoryUser is a separate entity and should be mapped as a one-to-one to your InventoryTransaction entity. It has a PK, named queries and everything, so it isn't an embedded entity at all. I guess I'm not clear on why you want to make it one...

An embedded entity is one that by definition does not have its own identity but depends upon that of its owning entity, and must therefore also be stored in the table of its owning entity.

[Timothy Sam]

Hi!

In my design, the following should defined as

an inventory transaction has many to one user
a user has one to many transactions

a user has a one to many inventory item
an inventory item has many to 1 user


I just don't know how to incorporate this with my JPA mapping... Have I supplied enough information? Thanks!

[Timothy Sam]

Uhmmm... Can I get a help with this?

Caused by: Exception [TOPLINK-7244] (Oracle TopLink Essentials - 2006.8 (Build 060830)): oracle.toplink.essentials.exceptions.ValidationException
Exception Description: An incompatible mapping has been encountered between [class com.wp.wpinventory.model.FixedItem] and [class com.wp.wpinventory.model.InventoryTransaction]. This usually occurs when the cardinality of a mapping does not correspond with the cardinality of its backpointer.

Here's what I've been doing...

@Entity
@Table(name = "inventory_transaction")
@NamedQueries( {
@NamedQuery(name = "InventoryTransaction.findByTransactionId", query = "SELECT i FROM InventoryTransaction i WHERE i.transactionId = :transactionId"),
@NamedQuery(name = "InventoryTransaction.findByUserId", query = "SELECT i FROM InventoryTransaction i WHERE i.userId = :userId"),
@NamedQuery(name = "InventoryTransaction.findByDateCreated", query = "SELECT i FROM InventoryTransaction i WHERE i.dateCreated =  :D ateCreated")
})
public class InventoryTransaction implements Serializable {
 
@Id
  @GeneratedValue(strategy = GenerationType.IDENTITY)  
@Column(name = "transaction_id", nullable = false)
private Integer transactionId;
 
  /**
   *@TODO: Map this to InventoryUser
   */
@Column(name = "user_id", nullable = false)
private int userId;
  
  /*
  @JoinColumn(name = "user_id", referencedColumnName = "user_id")
  @OneToOne
  private InventoryUser inventoryUser;
   */
 
  @Embedded
  private Employee employeeId;
  
  
  @Column(name = "control_id", nullable = true)
  private String controlId; //can be fixed or consumable item
  
  
  @JoinColumn(name = "user_id", referencedColumnName = "user_id")
  @ManyToOne
  private FixedItem fixedItem;
  
@Column(name = "date_created")
@Temporal(TemporalType.TIMESTAMP)
private Date dateCreated;
  
  
  
@JoinColumn(name = "transaction_type_id", referencedColumnName = "transaction_type_id")
@ManyToOne
private InventoryTransactionType transactionTypeId;  

in FixedItem.java

@Entity
@Table(name = "fixed_item")
@NamedQueries( {
@NamedQuery(name = "FixedItem.findByFixedItemId", query = "SELECT f FROM FixedItem f WHERE f.fixedItemId = :fixedItemId"),
@NamedQuery(name = "FixedItem.findByControlId", query = "SELECT f FROM FixedItem f WHERE f.controlId = :controlId"),
@NamedQuery(name = "FixedItem.findByItemName", query = "SELECT f FROM FixedItem f WHERE f.itemName = :itemName"),
@NamedQuery(name = "FixedItem.findBySerialNo", query = "SELECT f FROM FixedItem f WHERE f.serialNo = :serialNo"),
@NamedQuery(name = "FixedItem.findByModelNo", query = "SELECT f FROM FixedItem f WHERE f.modelNo = :modelNo"),
@NamedQuery(name = "FixedItem.findByEmployeeId", query = "SELECT f FROM FixedItem f WHERE f.employeeId = :employeeId"),
@NamedQuery(name = "FixedItem.findByInvoiceRef", query = "SELECT f FROM FixedItem f WHERE f.invoiceRef = :invoiceRef"),
@NamedQuery(name = "FixedItem.findByInvoiceAmount", query = "SELECT f FROM FixedItem f WHERE f.invoiceAmount = :invoiceAmount"),
@NamedQuery(name = "FixedItem.findByDepartmentId", query = "SELECT f FROM FixedItem f WHERE f.departmentId =  :D epartmentId"),
@NamedQuery(name = "FixedItem.findByDatePurchased", query = "SELECT f FROM FixedItem f WHERE f.datePurchased =  :D atePurchased"),
@NamedQuery(name = "FixedItem.findByDateChecked", query = "SELECT f FROM FixedItem f WHERE f.dateChecked =  :D ateChecked")
})
public class FixedItem implements Serializable {
 
@Id
        @GeneratedValue(strategy = GenerationType.IDENTITY)          
@Column(name = "fixed_item_id", nullable = false)
private Integer fixedItemId;
 
@Column(name = "control_id")
private String controlId;
 
@Column(name = "item_name")
private String itemName;
 
@Column(name = "serial_no")
private String serialNo;
 
@Column(name = "model_no")
private String modelNo;
 
//@Column(name = "assigned_to", nullable = false)
//private int assignedTo;
        
 
        //@Column(name = "assigned_to", nullable = false)
        @Embedded
        private Employee employeeId;
        //private Employee assignedTo;
        
@Lob
@Column(name = "description")
private String description;
 
@Column(name = "invoice_ref")
private String invoiceRef;
 
@Column(name = "invoice_amount")
private BigDecimal invoiceAmount;
 
  /*
@Column(name = "department_id")
private Integer departmentId;
  */
  @Embedded
  private Department departmentId;
  
@Column(name = "date_purchased")
@Temporal(TemporalType.TIMESTAMP)
private Date datePurchased;
 
@Column(name = "date_checked")
@Temporal(TemporalType.TIMESTAMP)
private Date dateChecked;
 
@JoinColumn(name = "fixed_item_type_id", referencedColumnName = "fixed_item_type_id")
@ManyToOne
private FixedItemType fixedItemTypeId;
 
@JoinColumn(name = "supplier_id", referencedColumnName = "supplier_id")
@ManyToOne
private InventorySupplier supplierId;
 
@JoinColumn(name = "assigned_by", referencedColumnName = "user_id")
@ManyToOne
private InventoryUser assignedBy;
 
@JoinColumn(name = "item_condition_id", referencedColumnName = "item_condition_id")
@ManyToOne
private ItemCondition itemConditionId;
  
  @OneToMany(cascade = CascadeType.ALL, mappedBy = "controlId")
  private Collection<InventoryTransaction> inventoryTransactionCollection;

The mappings were originally generated by netbeans for me. But now that I'm doing everything manually I'm really having problems especially with joins. Thanks!
[ July 03, 2007: Message edited by: Timothy Sam ]