hibernate one-many example issue

[Mathew Lee]

Hi,

I am trying hibernate one-many mapping example on mysql database server from link
http://www.vaannila.com/hibernate/hibernate-example/hibernate-mapping-one-to-many-1.html

when i execute the main.java class getting following error.

   

log4j:WARN No appenders could be found for logger (org.hibernate.cfg.Environment).
log4j:WARN Please initialize the log4j system properly.
Hibernate: insert into STUDENT (STUDENT_NAME) values (?)
Hibernate: insert into PHONE (PHONE_TYPE, PHONE_NUMBER) values (?, ?)
org.hibernate.exception.GenericJDBCException: could not insert: [com.vaannila.student.Phone]
	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.persister.entity.BasicEntityPersister.insert(BasicEntityPersister.java:1747)
	at org.hibernate.persister.entity.BasicEntityPersister.insert(BasicEntityPersister.java:2149)
	at org.hibernate.action.EntityIdentityInsertAction.execute(EntityIdentityInsertAction.java:34)
	at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:239)
	at org.hibernate.event.def.AbstractSaveEventListener.performSaveOrReplicate(AbstractSaveEventListener.java:238)
	at org.hibernate.event.def.AbstractSaveEventListener.performSave(AbstractSaveEventListener.java:158)
	at org.hibernate.event.def.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:104)
	at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.saveWithGeneratedOrRequestedId(DefaultSaveOrUpdateEventListener.java:184)
	at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.entityIsTransient(DefaultSaveOrUpdateEventListener.java:173)
	at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.performSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:96)
	at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.onSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:69)
	at org.hibernate.impl.SessionImpl.saveOrUpdate(SessionImpl.java:416)
	at org.hibernate.engine.Cascades$5.cascade(Cascades.java:153)
	at org.hibernate.engine.Cascades.cascade(Cascades.java:721)
	at org.hibernate.engine.Cascades.cascadeCollection(Cascades.java:860)
	at org.hibernate.engine.Cascades.cascade(Cascades.java:739)
	at org.hibernate.engine.Cascades.cascade(Cascades.java:817)
	at org.hibernate.event.def.AbstractSaveEventListener.cascadeAfterSave(AbstractSaveEventListener.java:361)
	at org.hibernate.event.def.AbstractSaveEventListener.performSaveOrReplicate(AbstractSaveEventListener.java:263)
	at org.hibernate.event.def.AbstractSaveEventListener.performSave(AbstractSaveEventListener.java:158)
	at org.hibernate.event.def.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:104)
	at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.saveWithGeneratedOrRequestedId(DefaultSaveOrUpdateEventListener.java:184)
	at org.hibernate.event.def.DefaultSaveEventListener.saveWithGeneratedOrRequestedId(DefaultSaveEventListener.java:33)
	at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.entityIsTransient(DefaultSaveOrUpdateEventListener.java:173)
	at org.hibernate.event.def.DefaultSaveEventListener.performSaveOrUpdate(DefaultSaveEventListener.java:27)
	at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.onSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:69)
	at org.hibernate.impl.SessionImpl.save(SessionImpl.java:429)
	at org.hibernate.impl.SessionImpl.save(SessionImpl.java:424)
	at com.vaannila.student.Main.main(Main.java:25)
Caused by: java.sql.SQLException: General error message from server: "Field 'phone_id' doesn't have a default value"
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1997)
	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1167)
	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1278)
	at com.mysql.jdbc.Connection.execSQL(Connection.java:2251)
	at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1772)
	at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1619)
	at org.hibernate.persister.entity.BasicEntityPersister.insert(BasicEntityPersister.java:1729)
	... 28 more


 

Please advise on how to resolve it. Any ideas, suggestions, resources, sample code highly appreciated. Thanks in advance.

[Mathew Lee]

Hi,

I made phone_id column as auto-increment in phone table and again executed main.java. this time the error message changed to

   

log4j:WARN No appenders could be found for logger (org.hibernate.cfg.Environment).
log4j:WARN Please initialize the log4j system properly.
Hibernate: insert into STUDENT (STUDENT_NAME) values (?)
Hibernate: insert into PHONE (PHONE_TYPE, PHONE_NUMBER) values (?, ?)
Hibernate: insert into PHONE (PHONE_TYPE, PHONE_NUMBER) values (?, ?)
Hibernate: insert into STUDENT_PHONE (STUDENT_ID, PHONE_ID) values (?, ?)
Hibernate: insert into STUDENT_PHONE (STUDENT_ID, PHONE_ID) values (?, ?)
org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update
	at org.hibernate.exception.ErrorCodeConverter.convert(ErrorCodeConverter.java:74)
	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:140)
	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 com.vaannila.student.Main.main(Main.java:27)
Caused by: java.sql.BatchUpdateException: Duplicate key or integrity constraint violation message from server: "Duplicate entry '4' for key 'PRIMARY'"
	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
 

Please advise

[Ram Para]

It seems to be as if the you already have some records in Student table.

[Mathew Lee]

Hi Ram,

I forgot to make phone_id column within student_phone table as primary key. After changing that everything working fine. Thank you.