Hey...
Iam using String as my primary id
here is my POJO

public class EmpDetailsVO extends ActionForm {
private String date;
private String consultant_name;
private String consultant_email = "";
private String consultant_phone;
....

Mapping file...
<hibernate-mapping>
<class name="main.java.org.beans.EmpDetailsVO" table="resources_table1">


<id name="consultant_email" column="consultant_email" type="java.lang.String" unsaved-value="">
<generator class="assigned" />
</id>

<property name="date" column="today_date" not-null="false"/>
.......

DAO class

Session session = HibernateUtil.getSessionFactory().openSession();
try{
Transaction tx = session.beginTransaction();
if(session.isOpen()||session.isConnected()){
session.save(empVO); tx.commit();
}
} catch (HibernateException e).......


When I execute I get ..

ERROR 2007-12-10 15:59:42,780 [http-8080-Processor25] (SessionImpl.java:2379) - Could not synchronize database state with session
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:2371)
at net.sf.hibernate.impl.SessionImpl.flush(SessionImpl.java:2240)
at .......


I have been banging my head since 3 weeks...
Please let me know what's worng in the code

What happens if you change the unsaved value to null and set the email address to null at the begining?



Farzad-

I tried with that but ,it gives the same error :(

Hello,


<generator class="assigned" /> means that you need to assigned yourself the email address. Therefore try to use saveOrUpdate instead save.

Do you have any collections mapping and cascading property defined in your mapping ?

No I dont have any collection mapping or cascading properties..
Its just simple (one table).

I generate the id and assign to it..
I tried with saveOrUpdate too it dint work