Hibernate - Batch update returned unexpected row count from update 0 actual row count 0 expected 1

Question

I get following hibernate error  I am able to identify the function which causes the issue  Unfortunately there are several DB calls in the function  I am unable to find the line which causes the issue since hibernate flush the session at the end of the transaction  The below mentioned hibernate error looks like a general error  It doesn t even mentioned which Bean causes the issue  Anyone familiar with this hibernate error   org hibernate StaleStateException  Batch update returned unexpected row count from update  0 actual row count  0 expected  1         at org hibernate jdbc BatchingBatcher checkRowCount BatchingBatcher java 93          at org hibernate jdbc BatchingBatcher checkRowCounts BatchingBatcher java 79          at org hibernate jdbc BatchingBatcher doExecuteBatch BatchingBatcher java 58          at org hibernate jdbc AbstractBatcher executeBatch AbstractBatcher java 195          at org hibernate engine ActionQueue executeActions ActionQueue java 235          at org hibernate engine ActionQueue executeActions ActionQueue java 142          at org hibernate event def AbstractFlushingEventListener performExecutions AbstractFlushingEventListener java 297          at org hibernate event def DefaultFlushEventListener onFlush DefaultFlushEventListener java 27          at org hibernate impl SessionImpl flush SessionImpl java 985          at org hibernate impl SessionImpl managedFlush SessionImpl java 333          at org hibernate transaction JDBCTransaction commit JDBCTransaction java 106          at org springframework orm hibernate3 HibernateTransactionManager doCommit HibernateTransactionManager java 584          at org springframework transaction support AbstractPlatformTransactionManager processCommit AbstractPlatformTransacti onManager java 500          at org springframework transaction support AbstractPlatformTransactionManager commit AbstractPlatformTransactionManag er java 473          at org springframework transaction interceptor TransactionAspectSupport doCommitTransactionAfterReturning Transaction AspectSupport java 267          at org springframework transaction interceptor TransactionInterceptor invoke TransactionInterceptor java 106          at org springframework aop framework ReflectiveMethodInvocation proceed ReflectiveMethodInvocation java 170          at org springframework aop framework JdkDynamicAopProxy invoke JdkDynamicAopProxy java 176

User · Answer

Few ways I debugged this error     As suggested in the accepted answer- turn on show sql   I found there is some issue with setting up the id in the hibernate sql   Found that I was missing  GeneratedValue strategy GenerationType IDENTITY

User · Answer

I was facing same issue  The code was working in the testing environment  But it was not working in staging environment   org hibernate jdbc BatchedTooManyRowsAffectedException  Batch update returned unexpected row count from update  0   actual row count  3  expected  1   The problem was the table had single entry for each primary key in testing DB table  But in staging DB there was multiple entry for same primary key    Problem is in staging DB the table didn t had any primary key constraints also there was multiple entry    So every time on update operation it gets failed  It tries to update single record and expect to get update count as 1  But since there was 3 records in the table for the same primary key  The result update count finds 3  Since expected update count and actual result update count didn t match  It throws exception and rolls back   After the I removed all the records which have duplicate primary key and added primary key constraints  It is working fine   Hibernate - Batch update returned unexpected row count from update  0 actual row count  0 expected  1   actual row count  0    means no record found to update update  0    means no record found so nothing update expected  1    means expected at least 1 record with key in db table     Here the problem is that the query trying to update a record for some key  But hibernate didn t find any record with the key

User · Answer

As Julius says this happens when an update Occurs on an Object that has its children being deleted   Probably because there was a need for an update for the whole Father Object and sometimes we prefer to delete the children and re -insert them on the Father   new   old doesnt matter  along with any other updates the father could have on any of its other plain fields  So    in order for this to work delete the children  within a Transaction  by calling childrenList clear    Dont loop through the children and delete each one with some childDAO delete childrenList get i  delete     and setting   OneToMany cascade   CascadeType XXX  orphanRemoval true  on the Side of the Father Object  Then update the father  fatherDAO update father     Repeat for every father object  The result is that children have their link to their father stripped off  and then they are being removed as orphans by the framework

User · Answer

I ran into this issue when I was manually beginning and committing transactions inside of method annotated as  Transactional   I fixed the problem by detecting if an active transaction already existed     Detect underlying transaction if  session getTransaction      null  amp  amp  session getTransaction   isActive          myTransaction   session getTransaction        preExistingTransaction   true    else       myTransaction   session beginTransaction        Then I allowed Spring to handle committing the transaction   private void finishTransaction         if   preExistingTransaction            try               tx commit              catch  HibernateException he                if  tx    null                    tx rollback                              log error he             finally               if  newSessionOpened                    SessionFactoryUtils closeSession session                   newSessionOpened   false                  maxResults   0

User · Answer

I got this error when I tried to update an object with an id that did not exist in the database  The reason for my mistake was that I had manually assigned a property with the name  id  to the client side JSON-representation of the object and then when deserializing the object on the server side this  id  property would overwrite the instance variable  also called  id   that Hibernate was supposed to generate  So be careful of naming collisions if you are using Hibernate to generate identifiers

User · Answer

Without code and mappings for your transactions  it ll be next to impossible to investigate the problem   However  to get a better handle as to what causes the problem  try the following    In your hibernate configuration  set hibernate show sql to true  This should show you the SQL that is executed and causes the problem  Set the log levels for Spring and Hibernate to DEBUG  again this will give you a better idea as to which line causes the problem  Create a unit test which replicates the problem without configuring a transaction manager in Spring  This should give you a better idea of the offending line of code    Hope that helps

User · Answer

In my case  it s because a trigger is triggered before a insert cause   actually it means to split a big table in several tables using timestamp   and then return null  So I met this problem when I used springboot jpa save   function  In addition to change the trigger to SET NOCOUNT ON  Mr  TA mentioned above  the solution can also be using native query  insert into table values nextval  table id seq    value1

User · Answer

This happened if you change something in data set using native sql query but persisted object for same data set is present in session cache  Use session evict yourObject

User · Answer

In my case there was an issue with the Database as one of the Stored Procs was consuming all the CPU causing high DB response times  Once this was killed issue got resolved

User · Answer

In my case  I came to this exception in two similar cases    In a method annotated with  Transactional I had a call to another service  with long times of response   The method updates some properties of the entity  after the method  the entity still exists in the database   If the user requests two times the method  as he thinks it doesn t work the first time  when exiting from the transactional method the second time  Hibernate tries to update an entity which already changed its state from the beginning of the transaction  As Hibernate search for an entity in a state  and found the same entity but already changed by the first request  it throws an exception as it can t update the entity  It s like a conflict in GIT  I had automatic requests  for monitoring the platform  which update an entity  and the manual rollback a few seconds later   But this platform is already used by a test team  When a tester performs a test in the same entity as the automatic requests   within the same hundredth of a millisecond   I get the exception  As in the previous case  when exiting from the second transaction  the entity previously fetched already changed    Conclusion  in my case  it wasn t a problem which can be found in the code  This exception is thrown when Hibernate founds that the entity first fetched from the database changed during the current transaction  so it can t flush it to the database as Hibernate doesn t know which is the correct version of the entity  the one the current transaction fetch at the beginning  or the one already stored in the database   Solution  to solve the problem  you will have to play with the Hibernate LockMode to find the one which best fit your requirements

User · Answer

I also came across the same challenge  In my case I was updating an object which was not even existing  using hibernateTemplate    Actually in my application I was getting a DB object to update  And while updating its values  I also updated its ID by mistake  and went ahead to update it and came across the said error    I am using hibernateTemplate for CRUD operations

User · Answer

Solution  In the Hibernate mapping file for the id property  if you use any generator class  for that property you should not set the value explicitly by using a setter method   If you set the value of the Id property explicitly  it will lead the error above  Check this to avoid this error  or  It s error show when you mention in the mapping file the field  generator  native  or  incremental  and in your  DATABASE the table mapped is not auto incremented  Solution  Go to your DATABASE and update your table to set auto increment

User · Answer

This happened to me once by accident when I was assigning specific IDs to some objects  testing  and then I was trying to save them in the database  The problem was that in the database there was an specific policy for setting up the IDs of the objects  Just do not assign an ID if you have a policy at Hibernate level

User · Answer

This happened to me too  because I had my id as Long  and I was receiving from the view the value 0  and when I tried to save in the database I got this error  then I fixed it by set the id to null

User · Answer

It also can happen when you try to UPDATE a PRIMARY KEY

User · Answer

This can happen when trigger s  execute additional DML  data modification  queries which affect the row counts  My solution was to add the following at the top of my trigger   SET NOCOUNT ON

User · Answer

i got the same problem and i verified this may occur because of Auto increment primary key  To solve this problem do not inset auto increment value with data set  Insert data without the primary key

User · Answer

I got the same message  After looking for a code related source it got to me that running the application on a local machine interferes with the dev stage  because the share the same DB  So sometimes one server has deleted an entry already while the other just wanted to do the same

User · Answer

Actually  it happen to me when I didn t store the object as reference variable  in Entity class  Like this code     ses get InsurancePolicy class  101   After that  I stored the object in entity s reference variable so problem solved for me  policy  InsurancePolicy ses get InsurancePolicy class  101   After that  I updated the object and it worked fine

User · Answer

This problem mainly occurs when we are trying to save or update the object which are already fetched into memory by a running session   If you ve fetched object from the session and you re trying to update in the database  then this exception may be thrown   I used session evict    to remove the cache stored in hibernate first or if you don t wanna take risk of loosing data  better you make another object for storing the data temp        try               if  session isOpen                          session EmployeyDao getSessionFactory   openSession                          tx session beginTransaction             session evict e           session saveOrUpdate e           tx commit             EmployeyDao shutDown session             catch HibernateException exc                exc printStackTrace            tx rollback

User · Answer

Hibernate caches objects from the session  If object is accessed and modified by more than 1 user then org hibernate StaleStateException may be be thrown  It may be solved with merge refresh entity method before saving or using lock  More info  http   java-fp blogspot lt 2011 09 orghibernatestalestateexception-batch html

User · Answer

In our case we finally found out the root cause of StaleStateException   In fact we were deleting the row twice in a single hibernate session  Earlier we were using ojdbc6 lib  and this was ok in this version   But when we upgraded to odjc7 or ojdbc8  deleting records twice was throwing exception  There was bug in our code where we were deleting twice  but that was not evident in ojdbc6   We were able to reproduce with this piece of code   Detail detail   getDetail Long valueOf 1396451    session delete detail   session flush    session delete detail   session flush      On first flush hibernate goes and makes changes in database  During 2nd flush hibernate compares session s object with actual table s record  but could not find one  hence the exception

User · Answer

I encountered this problem where we had one-many relationship   In the hibernate hbm mapping file for master  for object with set type arrangement  added cascade  save-update  and it worked fine   Without this  by default hibernate tries to update for a non-existent record and by doing so it inserts instead

User · Answer

I got the same exception while deleting a record by Id that does not exists at all   So check that record you are updating Deleting actually exists in DB

User · Answer

I just encountered this problem and found out I was deleting a record and trying to update it afterwards in a Hibernate transaction

User · Answer

its happen when you try to delete the same object and then again update the same object use this after delete  session clear

User · Answer

This happens when you declared the JSF Managed Bean as    RequestScoped    when you should declare as   SessionScoped    Regards

User · Answer

I was facing this exception  and hibernate was working well  I tried to insert manually one record using pgAdmin  here the issue became clear  SQL insert query returns 0 insert  and there is a trigger function that cause this issue because it returns null  so I have only to set it to return new  and finally I solved the problem   hope that helps any body

User · Answer

After reading all answers did  t find anyone to talk about inverse atribute of hibernate    In my my opinion you should also verify in your relationships mapping whether inverse key word is appropiately setted  Inverse keyword is created to defines which side is the owner to maintain the relationship  The procedure for updating and inserting varies cccording to this attribute   Let s suppose we have two tables   principal table  middle table  with a relationship of one to many  The hiberntate mapping classes are Principal and Middle respectively    So the Principal class has a SET of Middle objects  The xml mapping file should be like following    lt hibernate-mapping gt       lt class name  path to class Principal  table  principal table      gt               lt set name  middleObjects  table  middle table  inverse  true  fetch  select  gt           lt key gt               lt column name  PRINCIPAL ID  not-null  true    gt           lt  key gt           lt one-to-many class  path to class Middel    gt       lt  set gt            As inverse is set to    true     it means    Middle    class is the relationship owner  so Principal class will NOT UPDATE the relationship   So the procedure for updating could be implemented like this   session beginTransaction     Principal principal   new Principal    principal setSomething  1    principal setSomethingElse  2      Middle middleObject   new Middle    middleObject setSomething  1     middleObject setPrincipal principal   principal getMiddleObjects   add middleObject    session saveOrUpdate principal   session saveOrUpdate middleObject      NOTICE  you will need to save it manually  session getTransaction   commit      This worked for me  bu you can suggest some editions in order to improve the solution  That way we all will be learning

User · Answer

Hibernate 5 4 1 and HHH-12878 issue Prior to Hibernate 5 4 1  the optimistic locking failure exceptions  e g   StaleStateException or OptimisticLockException  didn t include the failing statement  The HHH-12878 issue was created to improve Hibernate so that when throwing an optimistic locking exception  the JDBC PreparedStatement implementation is logged as well  if   expectedRowCount  gt  rowCount         throw new StaleStateException               quot Batch update returned unexpected row count from update   quot                        batchPosition    quot    actual row count   quot    rowCount                        quot   expected   quot    expectedRowCount    quot   statement executed   quot                        statement           Testing Time  I created the BatchingOptimisticLockingTest in my High-Performance Java Persistence GitHub repository to demonstrate how the new behavior works   First  we will define a Post entity that defines a  Version property  therefore enabling the implicit optimistic locking mechanism   Entity name    quot Post quot    Table name    quot post quot   public class Post         Id      GeneratedValue strategy   GenerationType SEQUENCE      private Long id       private String title        Version     private short version       public Long getId             return id             public Post setId Long id            this id   id          return this             public String getTitle             return title             public Post setTitle String title            this title   title          return this             public short getVersion             return version           We will enable the JDBC batching using the following 3 configuration properties  properties put  quot hibernate jdbc batch size quot    quot 5 quot    properties put  quot hibernate order inserts quot    quot true quot    properties put  quot hibernate order updates quot    quot true quot     We are going to create 3 Post entities  doInJPA entityManager - gt        for  int i   1  i  lt   3  i              entityManager persist              new Post                    setTitle String format  quot Post no   d quot   i                         And Hibernate will execute a JDBC batch insert  SELECT nextval   hibernate sequence   SELECT nextval   hibernate sequence   SELECT nextval   hibernate sequence    Query        INSERT INTO post  title  version  id       VALUES               Params        Post no  1  0  1         Post no  2  0  2         Post no  3  0  3     So  we know that JDBC batching works just fine  Now  let s replicate the optimistic locking issue  doInJPA entityManager - gt        List lt Post gt  posts   entityManager createQuery  quot  quot  quot          select p          from Post p          quot  quot  quot   Post class       getResultList         posts forEach          post - gt  post setTitle              post getTitle      quot  - 2nd edition quot                        executeSync             - gt  doInJPA  entityManager - gt                Post post    entityManager createQuery  quot  quot  quot                  select p                  from Post p                 order by p id                  quot  quot  quot   Post class               setMaxResults 1               getSingleResult                 post setTitle post getTitle      quot  - corrected quot                           The first transaction selects all Post entities and modifies the title properties  However  before the first EntityManager is flushed  we are going to execute a second transition using the executeSync method  The second transaction modifies the first Post  so its version is going to be incremented  Query       UPDATE          post      SET          title               version          WHERE          id     AND          version         Params         Post no  1 - corrected   1  1  0     Now  when the first transaction tries to flush the EntityManager  we will get the OptimisticLockException  Query       UPDATE          post      SET          title               version          WHERE          id     AND          version         Params         Post no  1 - 2nd edition   1  1  0          Post no  2 - 2nd edition   1  2  0          Post no  3 - 2nd edition   1  3  0     o h e j b i AbstractBatchImpl - HHH000010  On release of batch it still contained JDBC statements  o h e j b i BatchingBatch - HHH000315  Exception executing batch       org hibernate StaleStateException       Batch update returned unexpected row count from update  0        actual row count  0       expected  1       statement executed           PgPreparedStatement               update post set title  Post no  3 - 2nd edition   version 1 where id 3 and version 0               SQL  update post set title    version   where id   and version    So  you need to upgrade to Hibernate 5 4 1 or newer to benefit from this improvement

User · Answer

Another way to get this error is if you have a null item in a collection

User · Answer

This happens to me because I am missing ID  declaration in bean class

User · Answer

I got this error because I mistakenly mapped the ID column using Id x   gt  x Id   id   GeneratedBy   Assigned       Issue resolved by using  Id x   gt  x Id   id   GeneratedBy   Identity

User · Answer

One of the case  SessionFactory sf new Configuration   configure   buildSessionFactory    Session session sf openSession     UserDetails user new UserDetails     session beginTransaction    user setUserName  update user agian    user setUserId 12   session saveOrUpdate user   session getTransaction   commit    System out println  user    user getUserName      sf close

[java] Hibernate - Batch update returned unexpected row count from update: 0 actual row count: 0 expected: 1

Examples related to java

Examples related to hibernate