spring+struts+hibernate 项目debug总结

spring+struts+hibernate 项目debug总结

WARN] JDBCExceptionReporter - SQL Error 904, SQLState 42000
[ERROR] JDBCExceptionReporter - ORA-00904 无效列名

[INFO] DefaultLoadEventListener - Error performing load command org.hibernate.exception.SQLGrammarException could not load an entity [com.xxx.yyy.Sellinfo#1]

org.hibernate.exception.SQLGrammarException could not load an entity [com.xxx.yyy.Sellinfo#1]

.hbm.xml文件中的某个列名和数据库中的不同。

=======================================================
ConnectionManager - unclosed connection, forgot to call close() on your session

原因：没有关闭hibernate的session的transaction。或者没有关闭session

=======================================================
[WARN] SellCommentDAO - org.hibernate.ObjectDeletedException deleted object would be re-saved by cascade (remove deleted object from associations) [com.xxx.yyy.SellComment#7]

原因：父亲对象（one方）设置cascade=save-update 时，直接删除子对象时，会报错，
处理方法：save信息需要级联操作，delete时候也要用相同的原理。
SellComment sellComment=new SellComment();
sellComment = (SellComment)session.load(SellComment.class,sellCommentId);获取儿子对象
Long sellInfoId=sellComment.getSellInfo().getSellId();获取父亲id
SellInfo sellinfo=(SellInfo)session.load(SellInfo.class,sellInfoId);获取父亲对象
sellInfo.getSellComments().remove(sellComment);断绝父子关系
sellComment.setSellInfo(null);断绝子父关系