[Persistence, JBoss/CMP, Hibernate, Database] - entitymanager cache corrupted on rollback
by deanhiller
I was hoping I could use a long running "user/application" transaction or what is sometimes called conversation in a certain scenario like so....
1. begin conversation
2. tx 1....load list of stuff I need to process
3. tx 2...process first item in list
4. tx 3...process second item in list
5. tx 4...process third item in list
6. etc. etc. etc.
If 4 fails and gets rolled back, I want 5 to still go. I would almost expect the entire cache at step 4 to be flushed so my changes would not be persisted. It seems though with hibernate that step 5 is dead because step 4 failed....Here is my test code below.....
| EntityManagerFactory sf = Persistence.createEntityManagerFactory(
| "xcoreNonJta", null);
|
| EntityManager mgr = sf.createEntityManager();
| org.hibernate.Session session = (org.hibernate.Session) mgr.getDelegate();
| session.setFlushMode(org.hibernate.FlushMode.MANUAL);
|
| //verify we are in flush manual mode first by NOT flushing!!
| mgr.getTransaction().begin();
| Users user = Users.getUserById(mgr, "admin");
| user.setCountry("USACCCCC");
| mgr.getTransaction().commit();
|
|
| mgr.getTransaction().begin();
|
|
| user.setAddress1("addr1CCCCC"); //written to db 3 lines later during commit!!!
| mgr.flush(); //NOTE: whatever changes are above flush are persisted at commit time
| user.setAddress2("addr2CCCCC"); //not written to db at all due to rollback and after flush
| mgr.getTransaction().commit();
|
| mgr.getTransaction().begin();
|
| user.setCity("city1"); //not written to db because of the rollback even though flush is called
|
| mgr.flush();
| mgr.getTransaction().rollback();
|
| mgr.getTransaction().begin();
|
| user.setAddress1("addr1DDDDD"); //not written to db, the cache appears to be forever dead!!!
| mgr.flush();
| user.setAddress2("addr2DDDDD");
| mgr.getTransaction().commit();
|
| mgr.close();
| sf.close();
|
View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=4228021#4228021
Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=4228021
14 years, 11 months
[Persistence, JBoss/CMP, Hibernate, Database] - Hibernate One To Many, multiple relationships off a single f
by taggat
I have a table (that can't be changed)
that is a one to one mapping from multiple entites to a single table
the table has 2 fields
int key1
String info
i have a mapping in table one
@OneToMany(fetch=javax.persistence.FetchType.LAZY, mappedBy="associationsCalendar")
private List associationRelators;
and in table 2
@OneToMany(fetch=javax.persistence.FetchType.LAZY, mappedBy="associationsAdvisory")
private List associationRelators; //Associations
in the end table i have the following relationships.
@ManyToOne(fetch=javax.persistence.FetchType.LAZY, optional=true)
@JoinColumn(name="PRNT_CNTNT_ID", insertable=false, updatable=false, nullable=true)
private Calendar associationsCalendar; //Associations
@ManyToOne(fetch=javax.persistence.FetchType.LAZY, optional=true)
@JoinColumn(name="PRNT_CNTNT_ID", insertable=false, updatable=false, nullable=true)
private Advisory associationsAdvisory; //Associations
I have a web service that is serialising the records, and i only want to serialise the join on the record that actually exists.
i.e. calendar and advisory take their primary keys from the same sequence.
if the reference is for a advisory and i call getAssociationsCalendar() i get
org.hibernate.PropertyAccessException: could not set a field value by reflection setter of .....
I need a way of having the exception not thrown, or a way to get around this issue. I have multiple tables that have the same issue, and am using a library to serialise the objects.
any help will be much appreciated.
View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=4228018#4228018
Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=4228018
14 years, 11 months