[hibernate-issues] [Hibernate-JIRA] Created: (HHH-2914) Hibernate cannot save properties that arae collections of elements of union-subclasses.
Hibernate cannot save properties that arae collections of elements of union-subclasses.
---------------------------------------------------------------------------------------
Key: HHH-2914
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2914
Project: Hibernate3
Issue Type: Bug
Components: core, query-sql
Affects Versions: 3.2.5
Reporter: Frederico Guimarães
Priority: Critical
I have a class Departament that have a collection of class AbstractPerson:
<bag lazy="true" name="person"
cascade="save-update">
<key column="idPerson" />
<one-to-many class="AbstractPerson" />
</bag>
AbstractPerson is abstract an have a lot os subclasses all of then mapped using
union-subclass (none of the abstract classes has a table, all of them are mapped with
abstract="true")
When I do a code like:
AbstractPerson student = new Student();
Departament departament = new Departament();
departament.getPersons().add( student );
...
session.saveOrUpdate( student )
...
I receive the exception:
org.hibernate.exception.SQLGrammarException: could not insert collection:
[br.com.project.model.Departament.persons#29164]
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:67)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at
org.hibernate.persister.collection.AbstractCollectionPersister.recreate(AbstractCollectionPersister.java:1183)
at
org.hibernate.action.CollectionRecreateAction.execute(CollectionRecreateAction.java:26)
at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:250)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:234)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:145)
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 br.com.utilities.db.hibernate.AppDBHibernate.execute(AppDBHibernate.java:785)
at br.com.utilities.db.hibernate.AppDBHibernate.execute(AppDBHibernate.java:754)
at br.com.mindsatwork.mopi.importer.Importer.importInspections(Importer.java:733)
at br.com.mindsatwork.mopi.importer.AppMain.main(AppMain.java:120)
Caused by: java.sql.BatchUpdateException: Base table or view not found message from
server: "Table 'project.AbstractPerson' doesn't exist"
at com.mysql.jdbc.PreparedStatement.executeBatch(PreparedStatement.java:1492)
at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:48)
at org.hibernate.jdbc.BatchingBatcher.addToBatch(BatchingBatcher.java:34)
at
org.hibernate.persister.collection.AbstractCollectionPersister.recreate(AbstractCollectionPersister.java:1146)
... 13 more
...
if show_sql is active hibernate prints the sql:
update AbstractPerson set idDepartament =? where id=?
Why is Hibernate trying to access a table that wat NOT declared and does not exist (as the
AbstractPerson is mapped with abstract "true") instead of look for the type of
the object (in this case Student) and create a sql with the right table (update user set
idDepartament =? where id=?)?
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://opensource.atlassian.com/projects/hibernate/secure/Administrators....
-
For more information on JIRA, see: http://www.atlassian.com/software/jira