Horible tiney issue in Hibernate.

[Awais Bajwa]

I have a simple table .. Student.

colums.
student_id and student_name

here is my code.

Student student=new Student();
student.setId("1");
student.setName("asif");

StudentDAO dao=new StudentDAO(); //Hibernate DAO
dao.saveOrUpdate(student);

I am getting the exception ..............
" Batch update row count wrong: 0"

Anybody know wht the is this ?
regards
A.B

[Jaikiran Pai]

Post your hbm file. My wild guess is that you might have specified an unsaved value as 0 or -1 for the id, and in your code you are setting the id as 1 and as a result Hibernate is issuing an update instead of insert statement.

[pascal betz]

check your id generator part. is unsaved value correct ? is it set to assigned ? if not, then you do not need to set an id.

[Awais Bajwa]

hi guys !
THanks for your replies..
well, I used Student entity as an example. actually i m a Node business objects.. and folliwing is its HBM and java code that causing this exception... hope it will help you Hibernate gurus to find an answer

HMB

  
<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC
"-//Hibernate/Hibernate Mapping DTD//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd" >
 
<hibernate-mapping package="com.otengo.bl.vo">
<class
name="Node"
table="node"
>
<id
name="Id"
type="string"
column="node_id"
>
<generator class="identity"/>
</id>
 
<property
name="MiddleInitial"
column="middle_initial"
type="string"
not-null="false"
length="1"
/>
<property
name="UserDetail"
column="user_detail"
type="string"
not-null="false"
/>
<property
name="HashedPassword"
column="hashed_password"
type="string"
not-null="false"
length="100"
/>
<property
name="Email"
column="email"
type="string"
not-null="true"
length="100"
/>
<property
name="LastName"
column="last_name"
type="string"
not-null="false"
length="100"
/>
<property
name="FirstName"
column="first_name"
type="string"
not-null="false"
length="100"
/>
 
<set
inverse="true"
lazy="true"
name="OnlineNodeSet"
>
<key column="node_id" />
<one-to-many class="OnlineNode" />
</set>
 
<set
inverse="true"
lazy="true"
name="NodeQFactorDataSet"
>
<key column="node_id" />
<one-to-many class="NodeQFactorData" />
</set>
 
<set
inverse="true"
lazy="true"
name="SecondaryEmailSet"
>
<key column="node_id" />
<one-to-many class="SecondaryEmail" />
</set>
 
<set
inverse="true"
lazy="true"
name="CdmLocationSet"
>
<key column="node_id" />
<one-to-many class="CdmLocation" />
</set>
 
<set
inverse="true"
lazy="true"
name="ManifestTrackSet"
>
<key column="recipient_node_id" />
<one-to-many class="ManifestTrack" />
</set>
 

 
</class>
</hibernate-mapping>
  

Java CODE

 
Node node = new Node();
node.setId("2666");
node.setEmail("asfdas");
nodeDAO.saveOrUpdate(node);
  

THanks
A.B

[Sebastian Hennebrueder]

When you want to assign an id you must select id generator="assigned".

Please read the Hibernate Reference.

Best Regards

Sebastian

[Awais Bajwa]

You are rite ... and I was wrong. I changed it to "assigned"

still same exception.. and i guess it had nothing to do with, wht u said.

Now here is my exception for your consideration .

Excepiton
net.sf.hibernate.HibernateException: Batch update row count wrong: 0
at net.sf.hibernate.impl.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:65)
at net.sf.hibernate.impl.BatcherImpl.executeBatch(BatcherImpl.java:126)
at net.sf.hibernate.impl.SessionImpl.executeAll(SessionImpl.java:2421)
at net.sf.hibernate.impl.SessionImpl.execute(SessionImpl.java:2372)
at net.sf.hibernate.impl.SessionImpl.flush(SessionImpl.java:2240)
at net.sf.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:61)
at com.otengo.bl.dao.base._BaseRootDAO.commitTransaction(_BaseRootDAO.java:151)
at com.otengo.bl.dao.base._BaseRootDAO.saveOrUpdate(_BaseRootDAO.java:574)
at com.otengo.bl.dao.base.BaseNodeDAO.saveOrUpdate(BaseNodeDAO.java:84)
at com.otengo.web.action.SaveUserRegistrationAction.executeAction(SaveUserRegistrationAction.java:81)
at com.otengo.web.action.base.BaseAction.execute(BaseAction.java:38)
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)
at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:525)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:256)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:553)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2416)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:171)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:172)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:223)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:601)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:392)
at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:565)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:619)
at java.lang.Thread.run(Thread.java:595)

[Praful Thakare]

 Node node = new Node();
node.setId("2666");
node.setEmail("asfdas");
nodeDAO.saveOrUpdate(node);   

Is this new row your trying to insert? what database are you using?
I would suggest use <generator class="org.hibernate.id.IdentityGenerator" />
if your database supports autoincrement (like mysql) and class="sequence" if your databas supports sequence (like oracle) and class="native" if you dont know what your database supports.

and for new rows to be inserted do not set id,let hibernate take care of it.

-Praful
[ May 18, 2006: Message edited by: Praful Thakare ]

[Awais Bajwa]

Thanks for your post.
But my requirement is not to use Hibernate generated id, and to assign my own application generated id. How can I accomplish this ?

I am using Mysql, and in one other object i m using class="identity" and it is working fine.


Regards
Awais Bajwa

[Sebastian Hennebrueder]

Hello,
I just saw something in your mapping.
In your mapping you are using uppercase names. They should be lowercase.

Best Regards

Sebastian

[Awais Bajwa]

Thanks again .. i have tried it using the lower case properties..
but again following is the result.

   net.sf.hibernate.HibernateException: Batch update row count wrong: 0
at net.sf.hibernate.impl.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:65)
at net.sf.hibernate.impl.BatcherImpl.executeBatch(BatcherImpl.java:126)
at net.sf.hibernate.impl.SessionImpl.executeAll(SessionImpl.java:2421)
at net.sf.hibernate.impl.SessionImpl.execute(SessionImpl.java:2372)
 

[Sebastian Hennebrueder]

Hello,
the following did work on my system. You might add your columns step by step.

package de.test;
 
import org.hibernate.Session;
import org.hibernate.Transaction;
import org.hibernate.cfg.Configuration;
 
public class Test {
 
/**
 * @param args
 */
public static void main(String[] args) {
Session session = new Configuration().configure().buildSessionFactory().openSession();
Transaction transaction = session.beginTransaction();
Node  node = new Node();
node.setId("4711");
node.setMiddleInitial("t");
session.save((node));
transaction.commit();
session.close();
}
}

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-mapping PUBLIC
    "-//Hibernate/Hibernate Mapping DTD 3.0//EN" 
    "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<hibernate-mapping package="de.test">
<class name="Node" table="node">
<id name="id" type="string" column="node_id">
<generator class="assigned" />
</id>
<property name="middleInitial" column="middle_initial" type="string" not-null="false"  />
</class>
</hibernate-mapping>

package de.test;
 
public class Node {
 
public Node() {
 
}
 
public String toString() {
return "Node: " + id + " " + middleInitial;
}
 
private String id;
 
private String middleInitial;
 
public String getId() {
return id;
}
 
public void setId(String id) {
this.id = id;
}
 
public String getMiddleInitial() {
return middleInitial;
}
 
public void setMiddleInitial(String middleInitial) {
this.middleInitial = middleInitial;
}
 
}

[Awais Bajwa]

Sebasistian,
Thanks a lot for your coding example, and that coding example points to a fairly simple mistake I made. I corrected it and my problem has been resolved.

I want to write the soloution of my issue , so that all readers get this information.


I used <generator class="assigned" /> for my identity.

and then I used node.saveOrUpdate(node);
So hibernate tried to update that node, (in saveOrUpdate() hibernate always tries to update that record if the id exists.)

when Hibernate tries to update the recorde there is no record already exists in the database, so it throws exception

 net.sf.hibernate.HibernateException: Batch update row count wrong: 0
at net.sf.hibernate.impl.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:65)
at net.sf.hibernate.impl.BatcherImpl.executeBatch(BatcherImpl.java:126)
at net.sf.hibernate.impl.SessionImpl.executeAll(SessionImpl.java:2421)
at net.sf.hibernate.impl.SessionImpl.execute(SessionImpl.java:2372)
 
 

saveOrUpdate() function wud hav worked if i wud use

 
<generator class="assigned" /> for my identity.

for verification you may use saveOrUpdate() in your and you will get the same exception above.

Regards
Awais Bajwa
[ May 24, 2006: Message edited by: Awais Bajwa ]

[Praful Thakare]

it good your code is working but just for my info

When Sebastian suggested

When you want to assign an id you must select id generator="assigned"

you replied

You are rite ... and I was wrong. I changed it to "assigned"
still same exception.. and i guess it had nothing to do with, wht u said.

are we missing something here?

-Praful

[Awais Bajwa]

Yeah, when I changed to generator="assigned", I should have used
node.save();

I used node.saveOrUpdate(), instead

that was the think that we were missing.

A.B

[Praful Thakare]

waoo very useful info,Thanks

-Praful