title: java.sql.SQLException: Data truncated for column
body: <p>I'm new in Java programming. I have an enum data type in my class:</p>
  
  <pre class="lang-java prettyprint-override"><code>public class Persons {
      private String name;
      private String family;
      private Date birthDate;
      public enum degree {Bsd, Msd, prof};
      private degree degree;
      ...
  }
  </code></pre>
  
  <p>In my MySQL database, I have a field for degree as: <code>ENUM('Bsd','Mds','prof')</code> and my hibernate mapping is like this:</p>
  
  <pre class="lang-xml prettyprint-override"><code>&lt;class name="Entity.Professor" table="tbl_professor"&gt;
       &lt;id column="ProfessorId" name="ProfessorId"/&gt;
       &lt;property column="name" name="name"/&gt;
       &lt;property column="family" name="family"/&gt;
       &lt;property column="birthDate" name="birthDate"/&gt;
       &lt;property column="degree" name="degree"/&gt;
  &lt;/class&gt;
  </code></pre>
  
  <p>When I want to insert a new record in my table, I get this error:</p>
  
  <pre><code>Hibernate: insert into tbl_professor (name, family, birthDate, degree, ProfessorId) values (?, ?, ?, ?, ?)
  Apr 26, 2013 6:15:24 PM org.hibernate.util.JDBCExceptionReporter logExceptions
  WARNING: SQL Error: 1265, SQLState: 01000
  Apr 26, 2013 6:15:24 PM org.hibernate.util.JDBCExceptionReporter logExceptions
  SEVERE: Data truncated for column 'degree' at row 1
  Apr 26, 2013 6:15:24 PM org.hibernate.event.def.AbstractFlushingEventListener performExecutions
  SEVERE: Could not synchronize database state with session
  org.hibernate.exception.GenericJDBCException: Could not execute JDBC batch update
      at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:103)
      at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:91)
      at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
      at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:253)
      at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:237)
      at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:141)
      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 org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:338)
      at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:106)
      at DAO.ProfessorDAO.createProfessor(ProfessorDAO.java:21)
      at Entity.Test.main(Test.java:39)
  Caused by: java.sql.BatchUpdateException: Data truncated for column 'degree' at row 1
      at com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:2028)
      at com.mysql.jdbc.PreparedStatement.executeBatch(PreparedStatement.java:1451)
      at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:48)
      at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:246)
      ... 9 more
  Caused by: java.sql.SQLException: Data truncated for column 'degree' at row 1
      at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1073)
      at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3609)
      at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3541)
      at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2002)
      at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2163)
      at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2624)
      at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2127)
      at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2427)
      at com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:1980)
      ... 12 more
  
  Exception in thread "main" org.hibernate.exception.GenericJDBCException: Could not execute JDBC batch update
      at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:103)
      at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:91)
      at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
      at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:253)
      at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:237)
      at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:141)
  </code></pre>
  
  <p>Can anyone help me? I'm really confused with <code>enum</code> datatype.</p>