Batch Update Failure

[subhashchandra medhiassam]

Hi all,
I have a table named Contact in MYSQL. This table looks like the following:

Column Type
------------- -------------
ID decimal
FIRSTNAME varchar
LASTNAME varchar
EMAIL varchar

There is only a single row of data in the table.

This row contains the following data:

ID = 6,FIRSTNAME=Subhash,LASTNAME=Medhi,[email protected]

Corresponding to this table i have a class Contact.java. It looks like the following:

 
package roseindia.tutorial.hibernate;
 
public class Contact {
private String firstName;
private String lastName;
private String email;
private long id;
 
/**
 * @return Email
 */
public String getEmail() {
return email;
}
 
/**
 * @return First Name
 */
public String getFirstName() {
return firstName;
}
 
/** 
 * @return Last name
 */
public String getLastName() {
return lastName;
}
 
/**
 * @param string Sets the Email
 */
public void setEmail(String string) {
email = string;
}
 
/**
 * @param string Sets the First Name
 */
public void setFirstName(String string) {
firstName = string;
}
 
/**
 * @param string sets the Last Name
 */
public void setLastName(String string) {
lastName = string;
}
 
/**
 * @return ID Returns ID
 */
public long getId() {
return id;
}
 
/**
 * @param l Sets the ID
 */
public void setId(long l) {
id = l;
}
 
}
   

My hbm.xml file looks like this:

<?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.hibernate.Contact" table="CONTACT">
   <id name="id" type="long" column="ID" >
   <generator class="assigned"/>
  </id>
 
  <property name="firstName">
     <column name="FIRSTNAME" />
  </property>
  <property name="lastName">
    <column name="LASTNAME"/>
  </property>
  <property name="email">
    <column name="EMAIL"/>
  </property>
 </class>
 
 
</hibernate-mapping>

I have a third class in which i am trying to update table Contact. This class named as UpdateExample.java looks like the following:

 public class UpdateExample {
 
    /**
     * @param args
     */
    private transient static Logger logger = Logger.getLogger(UpdateExample.class);
    
    public static void main(String[] args) {
 Session session = null;
 
 try {
      long initialTime = System.currentTimeMillis();
      SessionFactory factory = new Configuration().configure().buildSessionFactory();
      session = factory.openSession();
      Transaction tx = session.beginTransaction();
     
      Contact contact = (Contact)session.load(Contact.class, new Long(6));
      contact.setEmail("[e-mail]");
      contact.setFirstName("Subhash");
      contact.setLastName("Medhi");
      session.update(contact);
      tx.commit();
      long elapsedTime = System.currentTimeMillis() - initialTime;
      logger.info("Time to execute update: " + elapsedTime);
      session.close();
      
 }
 catch(Exception e){
    System.out.println(e.getMessage());
 }
 

    }
 
}
   

When i run this class, however, i am getting the following message:

 Hibernate: select contact0_.ID as ID0_, contact0_.FIRSTNAME as FIRSTNAME0_0_, contact0_.LASTNAME as LASTNAME0_0_, contact0_.EMAIL as EMAIL0_0_ from CONTACT contact0_ where contact0_.ID=?
Hibernate: update CONTACT set FIRSTNAME=?, LASTNAME=?, EMAIL=? where ID=?
Could not execute JDBC batch update
   

The table is not getting updated.

Could anybody kindly tell me what exactly could the problem be?

Thanks,
Subhash

[subhashchandra medhiassam]

Hi,
Could anybody kindly help me out. Please kindly help me out. It's urgent.

Thanks,
Subhash
[ September 29, 2008: Message edited by: subhashchandra medhiassam ]

[Paul Sturrock]

There should be more information in the error message. What else does it tell you?

This may be nothing to do with the issue, but you have modelled your contact entity with an ID attribute with the type decimal, and mapped it with the type long. You possibly want to fix that.

And please, EaseUp.

[subhashchandra medhiassam]

There's nothing more in the message.

what should be the type of column id of Contact table? Kindly help.

Thanks,
Subhash

[Paul Sturrock]

Originally posted by subhashchandra medhiassam:
There's nothing more in the message.

This would be because you log the message the exception returns and not the stack trace. Print the stack trace and you will get more information. Hibernate always logs the underlying SQLException, which in turn always reports the database error message.

what should be the type of column id of Contact table

Decimal is usually used to store flaoting point numbers and floating point numbers are poor choices for surrogate keys. MySQL provides a variety of integer data types, I'd use one of them.

[subhashchandra medhiassam]

i have used various types like mediumint and bigint for the column ID of table Contact. But nothing works.

[subhashchandra medhiassam]

Hi,
when i changed the program to print the stacktrace it printed the following message:

  org.hibernate.exception.GenericJDBCException: Could not execute JDBC batch update
at org.hibernate.exception.ErrorCodeConverter.handledNonSpecificException(ErrorCodeConverter.java:92)
at org.hibernate.exception.ErrorCodeConverter.convert(ErrorCodeConverter.java:80)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:161)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:226)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:137)
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 org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:293)
at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:86)
at roseindia.tutorial.hibernate.UpdateExample.main(UpdateExample.java:37)
Caused by: java.sql.BatchUpdateException: Data too long for column 'EMAIL' at row 1
at com.mysql.jdbc.PreparedStatement.executeBatch(PreparedStatement.java:1492)
at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:57)
at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:154)
... 8 more  

I got it. thanks.
[ September 29, 2008: Message edited by: subhashchandra medhiassam ]

[Paul Sturrock]

Good. Worth remembering to check what is logged by Hibernate. SQLExceptions always tell you the issue - or at least as much information as the database is willing to give you.

[peter tong]

the tutorial in roseIndia about hibernate has many bugs, their hibernate3.zip is old and would cause more error when you go to delete query example!!