Skip to main content

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index] [List Home]
[eclipselink-users] Error when removing entity - XAException from commit1: 100

I am getting the following error when trying to remove an entity and can't
find any help on the oracle site or elsewhere.

org.springframework.transaction.UnexpectedRollbackException - JTA
transaction unexpectedly rolled back (maybe due to a timeout); nested
exception is javax.transaction.RollbackException: Received an XAException
from commit1: 100

I am using the following calls to remove the entity

    Object managedEntity = em.find(entity.getClass(), id);
    em.remove(managedEntity);

My entities are defined as follows

@Entity
@NamedQuery(name = "Product.findAll", query = "select o from Product o")
@Table(name = "PRODUCT")
public class Product implements Serializable{
  @Id
  @Column(nullable = false)
  private String id;
  
  @OneToMany(mappedBy = "product", fetch = FetchType.EAGER,
cascade={CascadeType.ALL})
  private List<ProductName> productNameList;
  
  @OneToMany(mappedBy = "product", fetch = FetchType.EAGER,
cascade={CascadeType.REFRESH, CascadeType.REMOVE, CascadeType.PERSIST})
  private List<ProductData> productDataList;
  
  @OneToMany(mappedBy = "product", fetch = FetchType.EAGER,
cascade={CascadeType.ALL})
  private List<ProductEvent> productEventList;
}

@Entity
@NamedQuery(name = "ProductName.findAll", query = "select o from ProductName
o")
@Table(name = "PRODUCT_NAME")
@IdClass(ProductNamePK.class)
public class ProductName implements Serializable {
  
  @Id
  @Column(name="DISTBN_TECHNOLOGY_NO", nullable = false)
  private Integer distbnTechnologyNo;
  
  @Id
  @Column(name="LOCALE_NO", nullable = false)
  private Integer localeNo;
  
  @Column(nullable = false)
  private String name;
  
  @Id
  @Column(name="PR_ID", nullable = false, insertable = false, updatable =
false)
  private String prId;
  
  @ManyToOne
  @JoinColumn(name = "PR_ID", referencedColumnName = "ID")
  private Product product;
}

@Entity
@NamedQuery(name = "ProductData.findAll", query = "select o from ProductData
o")
@Table(name = "PRODUCT_DATA")
@IdClass(ProductDataPK.class)
public class ProductData implements Serializable{
  
  @Id
  @Column(nullable = false)
  private String id;
  
  @Id
  @Column(name="PR_ID", nullable = false, insertable = false, updatable =
false)
  private String prId;
  
  @ManyToOne
  @JoinColumn(name = "PR_ID", referencedColumnName = "ID")
  private Product product;
}

@Entity
@NamedQuery(name = "ProductEvent.findAll", query = "select o from
ProductEvent o"),
@Table(name = "PRODUCT_EVENT")
@IdClass(ProductEventPK.class)
public class ProductEvent implements Serializable{
  
  @Temporal(TemporalType.TIMESTAMP)  
  @Column(name="DATE_TIME", nullable = false)
  private Date dateTime;
  
  @Id
  @Column(nullable = false)
  private String id;
  
  private String narrative;
  
  @Id
  @Column(name="PR_ID", nullable = false)
  private String prId;
  
  @ManyToOne
  @JoinColumn(name = "PR_ID", referencedColumnName = "ID", insertable =
false, updatable = false)
  private Product product;
}



My log output is
08/09/30 09:59:36  Average Time : 000000, Total Searches : 000000, Total
time : 000000, Shortest time : 000000, Longest time : 000000, First time : ,
Last time : 

[EL Fine]: 2008.09.30
09:59:50.657--ClientSession(24952598)--Connection(26883761)--Thread(Thread[HTTPThreadGroup-4,5,HTTPThreadGroup])--DELETE
FROM PRODUCT_NAME WHERE (((DISTBN_TECHNOLOGY_NO = ?) AND (LOCALE_NO = ?))
AND (PR_ID = ?))
	bind => [0, 1, 3]
[EL Fine]: 2008.09.30
09:59:50.657--ClientSession(24952598)--Connection(26883761)--Thread(Thread[HTTPThreadGroup-4,5,HTTPThreadGroup])--DELETE
FROM PRODUCT_NAME WHERE (((DISTBN_TECHNOLOGY_NO = ?) AND (LOCALE_NO = ?))
AND (PR_ID = ?))
	bind => [0, 6, 3]
[EL Fine]: 2008.09.30
09:59:50.657--ClientSession(24952598)--Connection(26883761)--Thread(Thread[HTTPThreadGroup-4,5,HTTPThreadGroup])--DELETE
FROM PRODUCT_NAME WHERE (((DISTBN_TECHNOLOGY_NO = ?) AND (LOCALE_NO = ?))
AND (PR_ID = ?))
	bind => [2, 1, 3]
[EL Fine]: 2008.09.30
09:59:50.657--ClientSession(24952598)--Connection(26883761)--Thread(Thread[HTTPThreadGroup-4,5,HTTPThreadGroup])--DELETE
FROM PRODUCT_NAME WHERE (((DISTBN_TECHNOLOGY_NO = ?) AND (LOCALE_NO = ?))
AND (PR_ID = ?))
	bind => [2, 5, 3]
[EL Fine]: 2008.09.30
09:59:50.657--ClientSession(24952598)--Connection(26883761)--Thread(Thread[HTTPThreadGroup-4,5,HTTPThreadGroup])--DELETE
FROM PRODUCT_NAME WHERE (((DISTBN_TECHNOLOGY_NO = ?) AND (LOCALE_NO = ?))
AND (PR_ID = ?))
	bind => [1, 3, 3]
[EL Fine]: 2008.09.30
09:59:50.657--ClientSession(24952598)--Connection(26883761)--Thread(Thread[HTTPThreadGroup-4,5,HTTPThreadGroup])--DELETE
FROM PRODUCT_NAME WHERE (((DISTBN_TECHNOLOGY_NO = ?) AND (LOCALE_NO = ?))
AND (PR_ID = ?))
	bind => [0, 3, 3]
[EL Fine]: 2008.09.30
09:59:50.657--ClientSession(24952598)--Connection(26883761)--Thread(Thread[HTTPThreadGroup-4,5,HTTPThreadGroup])--DELETE
FROM PRODUCT_NAME WHERE (((DISTBN_TECHNOLOGY_NO = ?) AND (LOCALE_NO = ?))
AND (PR_ID = ?))
	bind => [2, 6, 3]
[EL Fine]: 2008.09.30
09:59:50.657--ClientSession(24952598)--Connection(26883761)--Thread(Thread[HTTPThreadGroup-4,5,HTTPThreadGroup])--DELETE
FROM PRODUCT_NAME WHERE (((DISTBN_TECHNOLOGY_NO = ?) AND (LOCALE_NO = ?))
AND (PR_ID = ?))
	bind => [3, 4, 3]
[EL Fine]: 2008.09.30
09:59:50.657--ClientSession(24952598)--Connection(26883761)--Thread(Thread[HTTPThreadGroup-4,5,HTTPThreadGroup])--DELETE
FROM PRODUCT_NAME WHERE (((DISTBN_TECHNOLOGY_NO = ?) AND (LOCALE_NO = ?))
AND (PR_ID = ?))
	bind => [1, 4, 3]
[EL Fine]: 2008.09.30
09:59:50.657--ClientSession(24952598)--Connection(26883761)--Thread(Thread[HTTPThreadGroup-4,5,HTTPThreadGroup])--DELETE
FROM PRODUCT_NAME WHERE (((DISTBN_TECHNOLOGY_NO = ?) AND (LOCALE_NO = ?))
AND (PR_ID = ?))
	bind => [1, 6, 3]
[EL Fine]: 2008.09.30
09:59:50.657--ClientSession(24952598)--Connection(26883761)--Thread(Thread[HTTPThreadGroup-4,5,HTTPThreadGroup])--DELETE
FROM PRODUCT_NAME WHERE (((DISTBN_TECHNOLOGY_NO = ?) AND (LOCALE_NO = ?))
AND (PR_ID = ?))
	bind => [1, 2, 3]
[EL Fine]: 2008.09.30
09:59:50.657--ClientSession(24952598)--Connection(26883761)--Thread(Thread[HTTPThreadGroup-4,5,HTTPThreadGroup])--DELETE
FROM PRODUCT_NAME WHERE (((DISTBN_TECHNOLOGY_NO = ?) AND (LOCALE_NO = ?))
AND (PR_ID = ?))
	bind => [0, 5, 3]
[EL Fine]: 2008.09.30
09:59:50.657--ClientSession(24952598)--Connection(26883761)--Thread(Thread[HTTPThreadGroup-4,5,HTTPThreadGroup])--DELETE
FROM PRODUCT_NAME WHERE (((DISTBN_TECHNOLOGY_NO = ?) AND (LOCALE_NO = ?))
AND (PR_ID = ?))
	bind => [3, 6, 3]
[EL Fine]: 2008.09.30
09:59:50.657--ClientSession(24952598)--Connection(26883761)--Thread(Thread[HTTPThreadGroup-4,5,HTTPThreadGroup])--DELETE
FROM PRODUCT_NAME WHERE (((DISTBN_TECHNOLOGY_NO = ?) AND (LOCALE_NO = ?))
AND (PR_ID = ?))
	bind => [2, 0, 3]
[EL Fine]: 2008.09.30
09:59:50.657--ClientSession(24952598)--Connection(26883761)--Thread(Thread[HTTPThreadGroup-4,5,HTTPThreadGroup])--DELETE
FROM PRODUCT_NAME WHERE (((DISTBN_TECHNOLOGY_NO = ?) AND (LOCALE_NO = ?))
AND (PR_ID = ?))
	bind => [3, 0, 3]
[EL Fine]: 2008.09.30
09:59:50.657--ClientSession(24952598)--Connection(26883761)--Thread(Thread[HTTPThreadGroup-4,5,HTTPThreadGroup])--DELETE
FROM PRODUCT_NAME WHERE (((DISTBN_TECHNOLOGY_NO = ?) AND (LOCALE_NO = ?))
AND (PR_ID = ?))
	bind => [0, 2, 3]
[EL Fine]: 2008.09.30
09:59:50.657--ClientSession(24952598)--Connection(26883761)--Thread(Thread[HTTPThreadGroup-4,5,HTTPThreadGroup])--DELETE
FROM PRODUCT_NAME WHERE (((DISTBN_TECHNOLOGY_NO = ?) AND (LOCALE_NO = ?))
AND (PR_ID = ?))
	bind => [2, 4, 3]
[EL Fine]: 2008.09.30
09:59:50.657--ClientSession(24952598)--Connection(26883761)--Thread(Thread[HTTPThreadGroup-4,5,HTTPThreadGroup])--DELETE
FROM PRODUCT_NAME WHERE (((DISTBN_TECHNOLOGY_NO = ?) AND (LOCALE_NO = ?))
AND (PR_ID = ?))
	bind => [0, 0, 3]
[EL Fine]: 2008.09.30
09:59:50.657--ClientSession(24952598)--Connection(26883761)--Thread(Thread[HTTPThreadGroup-4,5,HTTPThreadGroup])--DELETE
FROM PRODUCT_NAME WHERE (((DISTBN_TECHNOLOGY_NO = ?) AND (LOCALE_NO = ?))
AND (PR_ID = ?))
	bind => [1, 5, 3]
[EL Fine]: 2008.09.30
09:59:50.657--ClientSession(24952598)--Connection(26883761)--Thread(Thread[HTTPThreadGroup-4,5,HTTPThreadGroup])--DELETE
FROM PRODUCT_NAME WHERE (((DISTBN_TECHNOLOGY_NO = ?) AND (LOCALE_NO = ?))
AND (PR_ID = ?))
	bind => [2, 2, 3]
[EL Fine]: 2008.09.30
09:59:50.657--ClientSession(24952598)--Connection(26883761)--Thread(Thread[HTTPThreadGroup-4,5,HTTPThreadGroup])--DELETE
FROM PRODUCT_NAME WHERE (((DISTBN_TECHNOLOGY_NO = ?) AND (LOCALE_NO = ?))
AND (PR_ID = ?))
	bind => [0, 4, 3]
[EL Fine]: 2008.09.30
09:59:50.657--ClientSession(24952598)--Connection(26883761)--Thread(Thread[HTTPThreadGroup-4,5,HTTPThreadGroup])--DELETE
FROM PRODUCT_NAME WHERE (((DISTBN_TECHNOLOGY_NO = ?) AND (LOCALE_NO = ?))
AND (PR_ID = ?))
	bind => [1, 1, 3]
[EL Fine]: 2008.09.30
09:59:50.657--ClientSession(24952598)--Connection(26883761)--Thread(Thread[HTTPThreadGroup-4,5,HTTPThreadGroup])--DELETE
FROM PRODUCT_NAME WHERE (((DISTBN_TECHNOLOGY_NO = ?) AND (LOCALE_NO = ?))
AND (PR_ID = ?))
	bind => [1, 0, 3]
[EL Fine]: 2008.09.30
09:59:50.657--ClientSession(24952598)--Connection(26883761)--Thread(Thread[HTTPThreadGroup-4,5,HTTPThreadGroup])--DELETE
FROM PRODUCT_NAME WHERE (((DISTBN_TECHNOLOGY_NO = ?) AND (LOCALE_NO = ?))
AND (PR_ID = ?))
	bind => [3, 2, 3]
[EL Fine]: 2008.09.30
09:59:50.657--ClientSession(24952598)--Connection(26883761)--Thread(Thread[HTTPThreadGroup-4,5,HTTPThreadGroup])--DELETE
FROM PRODUCT_NAME WHERE (((DISTBN_TECHNOLOGY_NO = ?) AND (LOCALE_NO = ?))
AND (PR_ID = ?))
	bind => [3, 3, 3]
[EL Fine]: 2008.09.30
09:59:50.657--ClientSession(24952598)--Connection(26883761)--Thread(Thread[HTTPThreadGroup-4,5,HTTPThreadGroup])--DELETE
FROM PRODUCT_NAME WHERE (((DISTBN_TECHNOLOGY_NO = ?) AND (LOCALE_NO = ?))
AND (PR_ID = ?))
	bind => [2, 3, 3]
[EL Fine]: 2008.09.30
09:59:50.657--ClientSession(24952598)--Connection(26883761)--Thread(Thread[HTTPThreadGroup-4,5,HTTPThreadGroup])--DELETE
FROM PRODUCT_NAME WHERE (((DISTBN_TECHNOLOGY_NO = ?) AND (LOCALE_NO = ?))
AND (PR_ID = ?))
	bind => [3, 5, 3]
[EL Fine]: 2008.09.30
09:59:50.657--ClientSession(24952598)--Connection(26883761)--Thread(Thread[HTTPThreadGroup-4,5,HTTPThreadGroup])--DELETE
FROM PRODUCT_NAME WHERE (((DISTBN_TECHNOLOGY_NO = ?) AND (LOCALE_NO = ?))
AND (PR_ID = ?))
	bind => [3, 1, 3]
[EL Fine]: 2008.09.30
09:59:50.657--ClientSession(24952598)--Connection(26883761)--Thread(Thread[HTTPThreadGroup-4,5,HTTPThreadGroup])--DELETE
FROM PRODUCT_DATA WHERE ((ID = ?) AND (PR_ID = ?))
	bind => [1, 3]
[EL Fine]: 2008.09.30
09:59:50.657--ClientSession(24952598)--Connection(26883761)--Thread(Thread[HTTPThreadGroup-4,5,HTTPThreadGroup])--DELETE
FROM PRODUCT_EVENT WHERE ((ID = ?) AND (PR_ID = ?))
	bind => [1, 3]
[EL Fine]: 2008.09.30
09:59:50.657--ClientSession(24952598)--Connection(26883761)--Thread(Thread[HTTPThreadGroup-4,5,HTTPThreadGroup])--DELETE
FROM PRODUCT WHERE (ID = ?)
	bind => [3]
30-Sep-2008 09:59:50 oracle.j2ee.util.LoggingUtils logAndReturnMessage
WARNING: Commit failed.

-- 
View this message in context: http://www.nabble.com/Error-when-removing-entity---XAException-from-commit1%3A-100-tp19738771p19738771.html
Sent from the EclipseLink - Users mailing list archive at Nabble.com.



Back to the top