deleteing rows

[Wendy L Gibbons]

i am trying to delete rows i will include everything i can think of (so sorry it is so long)

why is it trying to do an update when i am trying to delete?

Edit: it has just occured to me orderId isn't even in my bean, so where did it get it from

   
Field            Null  Key  Extra           
id               NO    PRI  auto_increment  
orderId          NO    MUL                  
productId        YES   MUL                  
qty              YES                        
productCost      YES                        
discountApplied  YES                        
generatedCode    YES                        
group_id         YES    

Table              Non_unique  Key_name               Seq_in_index  Column_name  Collation  
lcw_order_details  0           PRIMARY                1             id           A                          
lcw_order_details  1           FK_orderdetails_prod   1             productId    A                         
lcw_order_details  1           FK_orderdetails_order  1             orderId      A                                              
 

the beans:

@Entity
@Table(name = "lcw_order_details", catalog = "dg")
public class OrderDetail implements Serializable {

  @Id
  @GeneratedValue(strategy = IDENTITY)
  @Column(name = "id", unique = true, nullable = false)
  public Integer getId() {}

  @ManyToOne(fetch = FetchType.EAGER)
  @JoinColumn(name = "productId", nullable = false)
  public Product getProduct() {}

  @OneToOne(fetch = FetchType.EAGER, targetEntity = CartGroup.class, cascade = CascadeType.REFRESH)
  @JoinColumn(name = "group_id")
  public CartGroup getGroup() {}

  @Column(name = "qty", nullable = false)
  public Integer getQty() {}
 
  @Column(name = "productCost", precision = 10)
  public BigDecimal getProductCost() {}

  @Column(name = "discountApplied", precision = 10)
  public BigDecimal getDiscountApplied() {}

  @Column(name = "generatedCode")
  public String getGeneratedCode() {}

}

@Entity
@Table(name = "lcw_orders", catalog = "dg")
public class Order implements Serializable {

  @OneToMany(targetEntity = OrderDetail.class, cascade = CascadeType.ALL, fetch = FetchType.EAGER)
  @ElementJoinColumn(name = "orderId", referencedColumnName = "id")
  @ElementForeignKey(updateAction = ForeignKeyAction.CASCADE)
  public Set<OrderDetail> getOrderdetails() {
	return _orderDetails;
  }
}

This is all the columns

my delete

public void delete(OrderDetail entity) {
  entity = getEntityManager().getReference(OrderDetail.class,entity.getId());
  getEntityManager().remove(entity);
}

and finally the error message

Caused by: <openjpa-1.2.2-r422266:898935 nonfatal store error> org.apache.openjpa.persistence.EntityExistsException: 
Column 'orderId' cannot be null 
{prepstmnt 8254986 UPDATE lcw_order_details SET orderId = ? WHERE orderId = ? [params=(null) null, (int) 249]} [code=1048, state=23000]

[Pierre Sugar]

The error message says that your orderId is null. Is it possible that you create an object without saving it to database and afterwards deleting it. This would explain why your orderId is null.