Exception while inserting a row using Hibernate

[Pradeep Kumar]

Hi ranchers,
I am new to Hibernate. I just tried a simple one to many association using an item class and a bid class. I somehow inserted a row into the item table using hibernate and later saw that the bid table was not updated with the record. So i deleted the record in the Item table from MySQL command prompt and tried to once again insert into Items table but i am getting the following error.

ERROR AbstractBatcher:51 - Exception executing batch:
org.hibernate.StaleStateException: Batch update returned unexpected row count from update [0]; actual row count: 0; expected: 1
at org.hibernate.jdbc.Expectations$BasicExpectation.checkBatched(Expectations.java:61)
at org.hibernate.jdbc.Expectations$BasicExpectation.verifyOutcome(Expectations.java:46)
at org.hibernate.jdbc.BatchingBatcher.checkRowCounts(BatchingBatcher.java:68)
at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:48)
at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:242)
at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:92)
at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:87)
at org.hibernate.jdbc.AbstractBatcher.prepareBatchStatement(AbstractBatcher.java:218)
at org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:2289)
at org.hibernate.persister.entity.AbstractEntityPersister.updateOrInsert(AbstractEntityPersister.java:2242)
at org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:2542)
at org.hibernate.action.EntityUpdateAction.execute(EntityUpdateAction.java:92)
at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:248)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:232)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:140)
at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:298)
at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1000)
at com.local.hibernate.unidirection.AuctionClient.main(AuctionClient.java:40)
19:07:38,396 ERROR AbstractFlushingEventListener:301 - Could not synchronize database state with session
org.hibernate.StaleStateException: Batch update returned unexpected row count from update [0]; actual row count: 0; expected: 1
at org.hibernate.jdbc.Expectations$BasicExpectation.checkBatched(Expectations.java:61)
at org.hibernate.jdbc.Expectations$BasicExpectation.verifyOutcome(Expectations.java:46)
at org.hibernate.jdbc.BatchingBatcher.checkRowCounts(BatchingBatcher.java:68)
at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:48)
at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:242)
at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:92)
at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:87)
at org.hibernate.jdbc.AbstractBatcher.prepareBatchStatement(AbstractBatcher.java:218)
at org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:2289)
at org.hibernate.persister.entity.AbstractEntityPersister.updateOrInsert(AbstractEntityPersister.java:2242)
at org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:2542)
at org.hibernate.action.EntityUpdateAction.execute(EntityUpdateAction.java:92)
at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:248)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:232)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:140)
at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:298)
at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1000)
at com.local.hibernate.unidirection.AuctionClient.main(AuctionClient.java:40)

ItemBid.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="com.local.hibernate.unidirection.Item" table="Item" >
   <id name="itemId" column="ITEM_ID" 
       type="java.lang.Integer" 
       unsaved-value="0">
     <generator class="increment" />
   </id>
   <property name="sellerId" column="SELLER_ID" type="java.lang.Integer" />
   <property name="name" column="NAME" type="java.lang.String"/>
   <property name="description" column="DESCRIPTION" type="java.lang.String"/>
   <property name="initialPrice" column="INITIAL_PRICE" type="java.lang.Integer"/>
   
   <set name="bids" cascade="save-update">
     <key column="ITEM_ID"/>
     <one-to-many class="com.local.hibernate.unidirection.Bid"/>
   </set>
 </class>
 
 <class name="com.local.hibernate.unidirection.Bid" table="BID" >
   <id name="bidId" column="BID_ID" type="java.lang.Integer" >
     <generator class="increment" />
   </id>
   
   <property name="amount" column="AMOUNT" type="java.lang.Integer"/>
   <property name="itemId" column="ITEM_ID" type="java.lang.Integer"/>
   <many-to-one 
         name="item" 
         column="ITEM_ID" 
         class="com.local.hibernate.unidirection.Item"
         not-null="true"
         insert="false" 
         update="false"/>
 </class>
</hibernate-mapping> 
  

Item.java class

 
package com.local.hibernate.unidirection;

import java.util.Set;

public class Item {
    
    private Set<Bid> bids;
    private int itemId;
    private int sellerId;
    private String name;
    private String description;
    private int initialPrice;

    public int getItemId() {
        return itemId;
    }

    public void setItemId(int itemId) {
        this.itemId = itemId;
    }

    public int getSellerId() {
        return sellerId;
    }

    public void setSellerId(int sellerId) {
        this.sellerId = sellerId;
    }

    public String getName() {
        return name;
    }

    public void setName(String name) {
        this.name = name;
    }

    public String getDescription() {
        return description;
    }

    public void setDescription(String description) {
        this.description = description;
    }

    public int getInitialPrice() {
        return initialPrice;
    }

    public void setInitialPrice(int initialPrice) {
        this.initialPrice = initialPrice;
    }

    public Set<Bid> getBids() {
        return bids;
    }

    public void setBids(Set<Bid> bids) {
        this.bids = bids;
    }
    
    public void addBid(Bid bid){
        bid.setItem(this);
        bids.add(bid);
    }
}

   

Bid.java

package com.local.hibernate.unidirection;

public class Bid {
    
    private Item item;
    private int itemId;
    private int bidId;
    private int amount;

    public int getItemId() {
        return itemId;
    }

    public void setItemId(int itemId) {
        this.itemId = itemId;
    }

    public int getBidId() {
        return bidId;
    }

    public void setBidId(int bidId) {
        this.bidId = bidId;
    }

    public int getAmount() {
        return amount;
    }

    public void setAmount(int amount) {
        this.amount = amount;
    }

    public Item getItem() {
        return item;
    }

    public void setItem(Item item) {
        this.item = item;
    }
}

    

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.url">jdbc:mysql://localhost/fruit</property>
    <property name="hibernate.connection.username">root</property>
    <property name="hibernate.connection.password">welcome</property>
    <property name="connection.driver_class">com.mysql.jdbc.Driver</property>
    <property name="dialect">org.hibernate.dialect.MySQLDialect</property>
    <property name="hibernate.hbm2ddl.auto">update</property>
    <!-- this will show us all sql statements -->
    <property name="hibernate.show_sql">true</property>
 
          <!-- mapping files -->
     <mapping resource="ItemBid.xml"/>

</session-factory>
</hibernate-configuration>
   

AuctionClient.java class

 

package com.local.hibernate.unidirection;

import java.util.HashSet;
import java.util.Set;

import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.Transaction;
import org.hibernate.cfg.Configuration;

public class AuctionClient {

    /**
     * @param args
     */
    public static void main(String[] args) {

        Item item = new Item();
        Configuration cfg = new Configuration().configure("/hibernate.cfg.xml");
        SessionFactory sessionFactory = cfg.buildSessionFactory();
        Session session = sessionFactory.openSession();
        item.setItemId(2);
        item.setInitialPrice(20);
        item.setDescription("anciennt");
        item.setName("Sppon");
        item.setSellerId(45);

        Set<Bid> bids = new HashSet<Bid>();
        Bid bid = new Bid();
        bid.setItemId(2);
        bid.setAmount(50);
        bid.setBidId(1);
        bid.setItem(item);
        bids.add(bid);

        item.setBids(bids);
        try {
            Transaction tx = session.beginTransaction();
            session.saveOrUpdate(item);
            session.flush();
            tx.commit();
        } catch (Exception e) {
            System.out.println("Proudly came here");
            e.printStackTrace();
        }
    }
}

   

I am using MySQL 5.0. Kindly find the code and help me out.

Thanks in advance,
Pradeep

[Javid Jamae]

This is just a guess, but you don't seem to be closing your session. So, what may have happened was that Hibernate still had the Item associated with the session. Then when you deleted it directly from the DB, Hibernate got confused.

Also, I notice you don't have inverse="true" set for your bi-directional relationship. I'm guessing you got an error before this one when you tried to persist the Item? That error would have occurred because Hibernate would have tried to write the ITEM_ID foreign key twice, once for the many-to-one and once for the one-to-many.