StaleStateException

[subhashchandra medhiassam]

hi all,
There are three classes in my application. They are:

Author.java:

package roseindia.tutorial.hibernatecollections;
 
import java.util.List;
 
public class Author {
 
    private long id;    
    private String name;
    private List<Book> books;
    public List<Book> getBooks() {
        return books;
    }
    public void setBooks(List<Book> books) {
        this.books = books;
    }
    public long getId() {
        return id;
    }
    public void setId(long id) {
        this.id = id;
    }
    public String getName() {
        return name;
    }
    public void setName(String name) {
        this.name = name;
    }
    
    
 
}
    

Book.java:

 
package roseindia.tutorial.hibernatecollections;
 
public class Book {
    private long id;    
    private String name;    
    public long getId() {        
return id;    
    }    
    public void setId(long id) {        
this.id = id;    
    }    
    public String getName() {
return name;    
    }    
    public void setName(String name) {        
this.name = name;    
    }
}
   

and InsertRecord.java:

package roseindia.tutorial.hibernatecollections;
 
import java.util.ArrayList;
import java.util.List;
 
import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.Transaction;
import org.hibernate.cfg.Configuration;
 
public class InsertRecord {
 
    /**
     * @param args
     */
    public static void main(String[] args) {
// TODO Auto-generated method stub
Session session = null;
try{
    Configuration configuration = new Configuration(); 
    // configuring hibernate        
    SessionFactory sessionFactory = configuration.configure().buildSessionFactory();
    session = sessionFactory.openSession();        
    Transaction tx = session.beginTransaction();        
    Book book1 = new Book();
    book1.setName("Java Book");  
    book1.setId(1);
    //Book book2 = new Book();
    //book2.setName("C Book");
    //book2.setId(2);
    List<Book> list = new ArrayList<Book>();        
    list.add(book1);
    //list.add(book2);
    Author author = new Author();
    author.setName("First Author");
    author.setBooks(list);
    session.save(author);
    tx.commit();;        
    
}catch(Exception e){
     System.out.println(e.getMessage());
 }finally{
     session.flush();
    session.close();
 }
    }
 
}

The configuration files are:
author.hbm.xml:

 
<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC 
"-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
 
<hibernate-mapping>
  <class name="roseindia.tutorial.hibernatecollections.Author" table="Author"> 
       <id name="id" column="id" type="java.lang.Long" unsaved-value="0">
        <generator class="increment"/>
       </id>
         <property name="name" column="name" type="java.lang.String"/>
       <bag name="books" cascade="all" >
         <key column="id"/>
         <one-to-many class="roseindia.tutorial.hibernatecollections.Book"/>
       </bag>    
  </class>
  <class name="roseindia.tutorial.hibernatecollections.Book" table="Book">
       <id name="id" column="id" type="java.lang.Long" unsaved-value="0" >
        <generator class="increment"/>        
       </id>
       <property name="name" column="name" type="java.lang.String"/>    
  </class>
</hibernate-mapping>   

and hibernate.cfg.xml:

<?xml version='1.0' encoding='utf-8'?>
<!DOCTYPE hibernate-configuration PUBLIC
"-//Hibernate/Hibernate Configuration DTD//EN"
"http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">
 
<hibernate-configuration>
<session-factory>
      <property name="hibernate.connection.driver_class">
 
com.mysql.jdbc.Driver</property>
      <property name="hibernate.connection.url">
 
jdbc:mysql://localhost/hibernatetutorial</property>
      <property name="hibernate.connection.username">root</property>
      <property name="hibernate.connection.password">root</property>
      <property name="hibernate.connection.pool_size">10</property>
      <property name="show_sql">true</property>
      <property name="dialect">org.hibernate.dialect.MySQLDialect</property>
      <property name="hibernate.hbm2ddl.auto">update</property>
      <!-- Mapping files -->
      <mapping resource="author.hbm.xml"/>
</session-factory>
</hibernate-configuration>
 
    

When i run InsertRecord.java, two tables, author and book are getting created in the MYSQL database but they are not getting populated with data and the following message is being generated:

log4j:WARN No appenders could be found for logger (org.hibernate.cfg.Environment).
log4j:WARN Please initialize the log4j system properly.
Hibernate: insert into Author (name, id) values (?, ?)
Hibernate: update Book set name=? where id=?
Batch update returned unexpected row count from update: 0 actual row count: 0 expected: 1
Hibernate: update Book set id=? where id=?
Hibernate: update Book set id=? where id=?
Exception in thread "main" 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:88)
at org.hibernate.jdbc.BatchingBatcher.checkRowCounts(BatchingBatcher.java:74)
at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:57)
at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:154)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:226)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:140)
at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:274)
at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:669)
at roseindia.tutorial.hibernatecollections.InsertRecord.main(InsertRecord.java:43)

I would like to know why the tables are not getting populated. Kindly let me know where i went wrong.

[Mark Spritzler]

Well you are not supposed to set the ids. You chose generator type="increment" which says to me that the database has an auto-increment field for that id. And also that Hibernate will only do an insert if the id in your object is not set. If there is an id, it will do an update instead. So for your Books, you set the id, so Hibernate tries an update statement, but there seems to be no record in the Book table with that id, so the update statement fails to update anything, the update statement returns 0 for number of rows affected, and that makes Hibernate throw an Exception.

Mark

[Mark Spritzler]

Please don't duplicate post, I deleted your duplicate.

Mark

[subhashchandra medhiassam]

You were correct. When i removed the statement "book1.setId(1);", the program worked fine.

But now, when i am trying to add details for another book enity, i am again getting the same StaleStateException.

The new code looks like this:

    
public static void main(String[] args) {
// TODO Auto-generated method stub
Session session = null;
try{
    Configuration configuration = new Configuration(); 
    // configuring hibernate        
    SessionFactory sessionFactory = configuration.configure().buildSessionFactory();
    session = sessionFactory.openSession();        
    Transaction tx = session.beginTransaction();        
    Book book1 = new Book();
    book1.setName("Java Book");  
    Book book2 = new Book();
    book2.setName("C Book");
    List<Book> list = new ArrayList<Book>();        
    list.add(book1);
    list.add(book2);
    Author author = new Author();
    author.setName("First Author");
    author.setBooks(list);
    session.save(author);
    tx.commit();;        
    
}catch(Exception e){
     System.out.println(e.getMessage());
 }finally{
     session.flush();
    session.close();
 }
    }
 

The output message is:

    
Exception in thread "main" org.hibernate.StaleStateException: Batch update returned unexpected row count from update: 1 actual row count: 0 expected: 1
at org.hibernate.jdbc.BatchingBatcher.checkRowCount(BatchingBatcher.java:88)
at org.hibernate.jdbc.BatchingBatcher.checkRowCounts(BatchingBatcher.java:74)
at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:57)
at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:154)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:226)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:140)
at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:274)
at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:669)
at roseindia.tutorial.hibernatecollections.InsertRecord.main(InsertRecord.java:43)

Please help me out.

[subhashchandra medhiassam]

Hi all,
Kindly help me.

Thanks in advance,
Subhash

[Mark Spritzler]

Can you change

<bag name="books" cascade="all" >
<key column="id"/>
<one-to-many class="roseindia.tutorial.hibernatecollections.Book"/>
</bag>

To use <list> instead of <bag>?

Here is the Hibernate docs too.

http://www.hibernate.org/hib_docs/v3/reference/en/html/associations.html#assoc-unidirectional-12m

Mark

[subhashchandra medhiassam]

Hi,
I changed the file author.hbm.xml. I am now using "list" instead of "bag". The file now looks like the following:

 <?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC 
"-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
 
<hibernate-mapping>
  <class name="roseindia.tutorial.hibernatecollections.Author" table="Author"> 
       <id name="id" column="id" type="java.lang.Long" unsaved-value="0">
        <generator class="increment"/>
       </id>
         <property name="name" column="name" type="java.lang.String"/>
       <list name="books" cascade="all">
         <key column="id"/>
         <index column="idx"/>
         <one-to-many class="roseindia.tutorial.hibernatecollections.Book"/>
       </list>    
  </class>
  <class name="roseindia.tutorial.hibernatecollections.Book" table="Book">
       <id name="id" column="id" type="java.lang.Long" unsaved-value="0" >
        <generator class="increment"/>
       </id>
       <property name="name" column="name" type="java.lang.String"/>    
  </class>
</hibernate-mapping>   

But when i run the program, i am still getting the StaleStateException. The message looks like this:

log4j:WARN No appenders could be found for logger (org.hibernate.cfg.Environment).
log4j:WARN Please initialize the log4j system properly.
Hibernate: insert into Author (name, id) values (?, ?)
Hibernate: update Book set name=? where id=?
Hibernate: update Book set name=? where id=?
Batch update returned unexpected row count from update: 0 actual row count: 0 expected: 1
Hibernate: update Book set id=?, idx=? where id=?
Hibernate: update Book set id=?, idx=? where id=?
Hibernate: update Book set id=?, idx=? where id=?
Hibernate: update Book set id=?, idx=? where id=?
Exception in thread "main" 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:88)
at org.hibernate.jdbc.BatchingBatcher.checkRowCounts(BatchingBatcher.java:74)
at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:57)
at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:154)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:226)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:140)
at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:274)
at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:669)
at roseindia.tutorial.hibernatecollections.InsertRecord.main(InsertRecord.java:43)


Kindly tell me what to do now. Please help me as i am out of my wits.

[Mark Spritzler]

For some reason, you still have ids being set in the Book objects. If the id is null then Hibernate will do inserts, if it is not null it will do updates. and Hibernate is doing updates

If you have
Update blah where id = 1 and there is no record in the database already with that id then it will fail.

Did you recompile and not that it is still using an old version of your code?

Mark

[subhashchandra medhiassam]

This is the code:

 
public static void main(String[] args) {
// TODO Auto-generated method stub
Session session = null;
try{
    Configuration configuration = new Configuration(); 
    // configuring hibernate        
    SessionFactory sessionFactory = configuration.configure().buildSessionFactory();
    session = sessionFactory.openSession();        
    Transaction tx = session.beginTransaction();        
    Book book1 = new Book();
    book1.setName("Java Book");  
   // book1.setId(1);                      
    Book book2 = new Book();
    book2.setName("C Book");
   // book2.setId(2);
    List<Book> list = new ArrayList<Book>();        
    list.add(book1);
    list.add(book2);
    Author author = new Author();
    author.setName("First Author");
    author.setBooks(list);
    session.save(author);
    tx.commit();;        
     
}catch(Exception e){
     System.out.println(e.getMessage());
 }finally{
     session.flush();
     session.close();
 }
    }
   

when i execute it, i still get the following message:

log4j:WARN No appenders could be found for logger (org.hibernate.cfg.Environment).
log4j:WARN Please initialize the log4j system properly.
Hibernate: insert into Author (name, id) values (?, ?)
Hibernate: insert into Book (name, id) values (?, ?)
Hibernate: insert into Book (name, id) values (?, ?)
Could not execute JDBC batch update
Hibernate: update Book set id=?, idx=? where id=?
Hibernate: update Book set id=?, idx=? where id=?
Hibernate: update Book set id=?, idx=? where id=?
Hibernate: update Book set id=?, idx=? where id=?
Exception in thread "main" org.hibernate.StaleStateException: Batch update returned unexpected row count from update: 1 actual row count: 0 expected: 1
at org.hibernate.jdbc.BatchingBatcher.checkRowCount(BatchingBatcher.java:88)
at org.hibernate.jdbc.BatchingBatcher.checkRowCounts(BatchingBatcher.java:74)
at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:57)
at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:154)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:226)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:140)
at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:274)
at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:669)
at roseindia.tutorial.hibernatecollections.InsertRecord.main(InsertRecord.java:43)


What could be the reason? Kindly help me.

[Mark Spritzler]

Let's try this. Remove " unsaved-value="0" " from your id tags. No reason to have this at all.

Mark

[subhashchandra medhiassam]

I tried. but still it did not work.

[Mark Spritzler]

I am sorry but I don't see anything specific in you code you posted. But the only way Hibernate ever tries to do an update is if the id field of the Java object is not null. So somehow, maybe in that class you are setting the id field in that code. But if it is null Hibernate will do an insert, if it is not null it will do an update. And since it is doing an update, it is being set somehow.

I am Sorry I wasn't of anymore help for you.

Good Luck

Mark