An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.
One of a set of tools we're offering as a way of saying thank you for being a part of the community.
Solved
JPA Master-Detail Rollback Problem
Posted on 2012-03-21
Hello everbody,
Normally, inserting master-detail object to database follow these steps.
1- insert master to database cache.
When error occurred, do rollback.
2- insert detail to database cache.
When error occurred, do rollback.
3-if no error, commit transaction.
But in jpa transaction rollback is not working same, I think.
I have two objects to persist. Like these:
KeyOption optionValue is unique in database.
When I call jpa persist I have trouble with these object. JPA insert ConditionKey to database cache. KeyOption optionValue is unique. When I insert already inserted optionValue
JPA throw en UniqunessException but ConditionKey is already changed. But database not.
How can I solve these rollback problem in JPA? (EclipseLink)
public void insertConditionKey(Conditi
EntityManager em = entityManagerFactory.creat
try {
em.getTransaction().begin(
em.persist(conditionKey);
em.flush();
em.getTransaction().commit
} catch (Exception e) {
if (em.getTransaction().isAct
em.getTransaction().rollba
}
throw e;
} finally {
em.close();
}
}
Normally, inserting master-detail object to database follow these steps.
1- insert master to database cache.
When error occurred, do rollback.
2- insert detail to database cache.
When error occurred, do rollback.
3-if no error, commit transaction.
But in jpa transaction rollback is not working same, I think.
I have two objects to persist. Like these:
public class ConditionKey implements Serializable {
private static final long serialVersionUID = 1L;
@Id
@GeneratedValue(strategy = GenerationType.SEQUENCE)
@Column(name = "KEY_ID")
private Integer keyId;
@OneToMany(mappedBy = "conditionKey", fetch = FetchType.EAGER, cascade = CascadeType.ALL, orphanRemoval = true)
private List<KeyOption> keyOptions;
private static final long serialVersionUID = 1L;
@Id
@GeneratedValue(strategy = GenerationType.SEQUENCE)
@Column(name = "KEY_ID")
private Integer keyId;
@OneToMany(mappedBy = "conditionKey", fetch = FetchType.EAGER, cascade = CascadeType.ALL, orphanRemoval = true)
private List<KeyOption> keyOptions;
@Entity
@Table(name = "KEY_OPTION")
public class KeyOption implements Serializable {
private static final long serialVersionUID = 1L;
@Id
@GeneratedValue(strategy = GenerationType.SEQUENCE)
@Column(name = "KEY_OPTION_ID")
private Integer keyOptionId;
@Column(name = "OPTION_VALUE")
private String optionValue;
@ManyToOne(fetch = FetchType.EAGER)
@JoinColumn(name = "KEY_ID")
private ConditionKey conditionKey;
@Table(name = "KEY_OPTION")
public class KeyOption implements Serializable {
private static final long serialVersionUID = 1L;
@Id
@GeneratedValue(strategy = GenerationType.SEQUENCE)
@Column(name = "KEY_OPTION_ID")
private Integer keyOptionId;
@Column(name = "OPTION_VALUE")
private String optionValue;
@ManyToOne(fetch = FetchType.EAGER)
@JoinColumn(name = "KEY_ID")
private ConditionKey conditionKey;
KeyOption optionValue is unique in database.
When I call jpa persist I have trouble with these object. JPA insert ConditionKey to database cache. KeyOption optionValue is unique. When I insert already inserted optionValue
JPA throw en UniqunessException but ConditionKey is already changed. But database not.
How can I solve these rollback problem in JPA? (EclipseLink)
public void insertConditionKey(Conditi
EntityManager em = entityManagerFactory.creat
try {
em.getTransaction().begin(
em.persist(conditionKey);
em.flush();
em.getTransaction().commit
} catch (Exception e) {
if (em.getTransaction().isAct
em.getTransaction().rollba
}
throw e;
} finally {
em.close();
}
}
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
Featured Post
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
Containers like Docker and Rocket are getting more popular every day. In my conversations with customers, they consistently ask what containers are and how they can use them in their environment. If you’re as curious as most people, read on. . .
By, Vadim Tkachenko. In this article we’ll look at ClickHouse on its one year anniversary.
Viewers will learn about if statements in Java and their use
The if statement:
The condition required to create an if statement:
Variations of if statements:
An example using if statements:
This video teaches viewers about errors in exception handling.
Suggested Courses
Course of the Month10 days, 3 hours left to enroll
609 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.