Skip to Content.
Sympa Menu

grouper-users - Re: [grouper-users] problem and solution of adding a mass of members using grouper-1.1 API

Subject: Grouper Users - Open Discussion List

List archive

Re: [grouper-users] problem and solution of adding a mass of members using grouper-1.1 API

Chronological Thread 
  • From: Chris Hyzer <>
  • Cc:
  • Subject: Re: [grouper-users] problem and solution of adding a mass of members using grouper-1.1 API
  • Date: Wed, 25 Apr 2007 22:50:48 -0400

Assuming there is not a larger problem here (seems weird to get this error, and that it goes away with no prepared statement caching), perhaps we should check that this setting is appropriate when using oracle, and throw descriptive exception if not on startup? If this is a useful addition, I volunteer to tackle this for the fall release (sounds like a good starter bug for me, and we will use oracle).


冯娟 wrote:
hello everyone
I have some experiences to share with you, I hope it is helpful to you.

When I added members to a group, I found that when a add several members, it is ok. But when I add a mass of person, it always throw an exception:

Caused by: net.sf.hibernate.HibernateException : hibernate commit error: Row was
updated or deleted by another transaction (or unsaved-value mapping was incorrec
t) for edu.internet2.middleware.grouper.Attribute instance with identifier: 4028
at edu.internet2.middleware.grouper.HibernateHelper.saveAndDelete(Hibern
... 25 more
Caused by: net.sf.hibernate.StaleObjectStateException : Row was updated or delete
d by another transaction (or unsaved-value mapping was incorrect) for edu.intern
et2.middleware.grouper.Attribute instance with identifier: 4028728111b175270111b
at net.sf.hibernate.persister.AbstractEntityPersister.check(AbstractEnti
at net.sf.hibernate.persister.EntityPersister.update(EntityPersister.jav
at net.sf.hibernate.persister.EntityPersister.update (EntityPersister.jav
at net.sf.hibernate.impl.ScheduledUpdate.execute (
at net.sf.hibernate.impl.SessionImpl.execute(
at net.sf.hibernate.impl.SessionImpl.executeAll (
at net.sf.hibernate.impl.SessionImpl.execute (
at net.sf.hibernate.impl.SessionImpl.flush(
at net.sf.hibernate.transaction.JDBCTransaction.commit (JDBCTransaction.j
at edu.internet2.middleware.grouper.HibernateHelper.saveAndDelete (Hibern
... 25 more


I noticed that in, there is:
# NOTE: If using Oracle you will need to disable preparared statement
# caching by setting:
# = 0

so I did and it is resolved.

Archive powered by MHonArc 2.6.16.

Top of Page