求助： 用list配置双向一对多的关系， list-index 在数据库里是Null

 

OtmsStaple表，为一方。

<?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 package="com.xycentre.otms.model">
 <class name="OtmsStaple">
  <id name="id">
   <generator class="native"/>
  </id>
  <many-to-one name="parent" class="OtmsStaple" />
  <property name="name"/>
  <property name="description"/>
  
  <list name="clazzs" inverse="false" cascade="all" >
   <key column="staple"></key>
   <list-index column="clazzIndex" base="0"/>
   <one-to-many class="OtmsClazz"/>
  </list>
   </class>
</hibernate-mapping>

 

 

OtmsClazz表，为多方。

<?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 package="com.xycentre.otms.model">
 <class name="OtmsClazz">
  <id name="id">
   <generator class="native"/>
  </id>
  <many-to-one name="staple" column="staple"/>
  <property name="name"/>
  <property name="description"/>
  <property name="startDate"/>
  <property name="endDate"/>
 </class>
</hibernate-mapping>

 

 

 

删除OtmsStaple属性的时候，出现异常：

Exception in thread "main" org.springframework.orm.hibernate3.HibernateSystemException: null index column for collection: com.xycentre.otms.model.OtmsStaple.clazzs; nested exception is org.hibernate.HibernateException: null index column for collection: com.xycentre.otms.model.OtmsStaple.clazzs
 at org.springframework.orm.hibernate3.SessionFactoryUtils.convertHibernateAccessException(SessionFactoryUtils.java:674)
 at org.springframework.orm.hibernate3.HibernateAccessor.convertHibernateAccessException(HibernateAccessor.java:412)
 at org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:411)
 at org.springframework.orm.hibernate3.HibernateTemplate.executeWithNativeSession(HibernateTemplate.java:374)
 at org.springframework.orm.hibernate3.HibernateTemplate.delete(HibernateTemplate.java:837)
 at org.springframework.orm.hibernate3.HibernateTemplate.delete(HibernateTemplate.java:833)
 at com.xycentre.otms.dao.HibDaoImpl.deleteStaple(HibDaoImpl.java:33)
 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
 at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
 at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
 at java.lang.reflect.Method.invoke(Unknown Source)
 at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307)
 at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
 at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
 at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106)
 at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
 at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
 at $Proxy5.deleteStaple(Unknown Source)
 at com.xycentre.otms.dao.test.ClazzTest.main(ClazzTest.java:45)
Caused by: org.hibernate.HibernateException: null index column for collection: com.xycentre.otms.model.OtmsStaple.clazzs
 at org.hibernate.persister.collection.AbstractCollectionPersister.readIndex(AbstractCollectionPersister.java:732)
 at org.hibernate.collection.PersistentList.readFrom(PersistentList.java:402)
 at org.hibernate.loader.Loader.readCollectionElement(Loader.java:1031)
 at org.hibernate.loader.Loader.readCollectionElements(Loader.java:669)
 at org.hibernate.loader.Loader.getRowFromResultSet(Loader.java:614)
 at org.hibernate.loader.Loader.doQuery(Loader.java:724)
 at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:259)
 at org.hibernate.loader.Loader.loadCollection(Loader.java:2015)
 at org.hibernate.loader.collection.CollectionLoader.initialize(CollectionLoader.java:59)
 at org.hibernate.persister.collection.AbstractCollectionPersister.initialize(AbstractCollectionPersister.java:587)
 at org.hibernate.event.def.DefaultInitializeCollectionEventListener.onInitializeCollection(DefaultInitializeCollectionEventListener.java:83)
 at org.hibernate.impl.SessionImpl.initializeCollection(SessionImpl.java:1743)
 at org.hibernate.collection.AbstractPersistentCollection.initialize(AbstractPersistentCollection.java:366)
 at org.hibernate.collection.AbstractPersistentCollection.read(AbstractPersistentCollection.java:108)
 at org.hibernate.collection.PersistentList.iterator(PersistentList.java:138)
 at org.hibernate.type.CollectionType.getElementsIterator(CollectionType.java:236)
 at org.hibernate.type.CollectionType.getElementsIterator(CollectionType.java:225)
 at org.hibernate.engine.CascadingAction.getAllElementsIterator(CascadingAction.java:438)
 at org.hibernate.engine.CascadingAction.access$100(CascadingAction.java:50)
 at org.hibernate.engine.CascadingAction$1.getCascadableChildrenIterator(CascadingAction.java:148)
 at org.hibernate.engine.Cascade.cascadeCollectionElements(Cascade.java:317)
 at org.hibernate.engine.Cascade.cascadeCollection(Cascade.java:265)
 at org.hibernate.engine.Cascade.cascadeAssociation(Cascade.java:242)
 at org.hibernate.engine.Cascade.cascadeProperty(Cascade.java:192)
 at org.hibernate.engine.Cascade.cascade(Cascade.java:153)
 at org.hibernate.event.def.DefaultDeleteEventListener.cascadeBeforeDelete(DefaultDeleteEventListener.java:329)
 at org.hibernate.event.def.DefaultDeleteEventListener.deleteEntity(DefaultDeleteEventListener.java:268)
 at org.hibernate.event.def.DefaultDeleteEventListener.onDelete(DefaultDeleteEventListener.java:163)
 at org.hibernate.event.def.DefaultDeleteEventListener.onDelete(DefaultDeleteEventListener.java:74)
 at org.hibernate.impl.SessionImpl.fireDelete(SessionImpl.java:793)
 at org.hibernate.impl.SessionImpl.delete(SessionImpl.java:771)
 at org.springframework.orm.hibernate3.HibernateTemplate$25.doInHibernate(HibernateTemplate.java:843)
 at org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:406)
 ... 16 more