[
Date Prev][
Date Next][
Thread Prev][
Thread Next][
Date Index][
Thread Index]
[
List Home]
|
Re: [eclipselink-users] Error when removing entity - XAException from commit1: 100
|
>From your log it looks like the EclipseLink commit occurred without errors.
The error seems to be an XA issue, perhaps something to do with your
database, JDBC driver, or JTA. Does the issue only occur on deletion, and
not insert or update? Try setting your logging level to finest and see if
there are any other issues.
What application server and database are you using? Perhaps try switching
to a non JTA DataSource or internal connection pooling to confirm the error
is in JTA.
ageing student wrote:
>
> 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.
>
>
-----
---
http://wiki.eclipse.org/User:James.sutherland.oracle.com James Sutherland
http://www.eclipse.org/eclipselink/
EclipseLink , http://www.oracle.com/technology/products/ias/toplink/
TopLink
Wiki: http://wiki.eclipse.org/EclipseLink EclipseLink ,
http://wiki.oracle.com/page/TopLink TopLink
Forums: http://forums.oracle.com/forums/forum.jspa?forumID=48 TopLink ,
http://www.nabble.com/EclipseLink-f26430.html EclipseLink
Book: http://en.wikibooks.org/wiki/Java_Persistence Java Persistence
--
View this message in context: http://www.nabble.com/Error-when-removing-entity---XAException-from-commit1%3A-100-tp19738771p19745241.html
Sent from the EclipseLink - Users mailing list archive at Nabble.com.
