[
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.
