TransientObjectException while fetching data.

[Ayyappan Selvaraj]

pals Im getting an exeption while querying the DB with hibernate. Im provding the code snippet where I get the exception, the related mapping (hbm file) and the exception trace. Please suggest me what shud be done.

When I googled, I got the info that this exception arises while leaving an unsaved child object to the database when a parent object is saved. But in my case Im trying to query the database.

the code::

public List getEntityHirearchies(final EntityHierarchy entityHierarchy)
{
 
return getHibernateTemplate().executeFind(getEHList(entityHierarchy));
 
}
 
private HibernateCallback getEHList(final EntityHierarchy entityHierarchy)
{
return new HibernateCallback()
{
public Object doInHibernate(Session session)
throws HibernateException, SQLException
{
 
Criteria criteria = session.createCriteria(EntityHierarchy.class);
 
if (entityHierarchy != null)
{
if (entityHierarchy.getCoreEntity() != null)
{
criteria.add(Expression.eq("coreEntity",entityHierarchy.getCoreEntity()));
}
 
}
return criteria.list();
}
};
}  

the mapping::

   <many-to-one name="coreEntity" class="CoreEntity" cascade="all"
outer-join="auto" update="false" insert="false" 
fetch="select" access="property" not-null="false">
<column name="ENT_ID" />
</many-to-one> 

the excpetion trace::

 
org.springframework.dao.InvalidDataAccessApiUsageException: object references an unsaved transient instance - save the transient instance before flushing: com.bofa.crme.gps.model.som.CoreEntity; nested exception is org.hibernate.TransientObjectException: object references an unsaved transient instance - save the transient instance before flushing: com.bofa.crme.gps.model.som.CoreEntity
Caused by: org.hibernate.TransientObjectException: object references an unsaved transient instance - save the transient instance before flushing: com.bofa.crme.gps.model.som.CoreEntity
at org.hibernate.engine.ForeignKeys.getEntityIdentifierIfNotUnsaved(ForeignKeys.java:219)
at org.hibernate.type.EntityType.getIdentifier(EntityType.java:397)
at org.hibernate.type.ManyToOneType.nullSafeSet(ManyToOneType.java:87)
at org.hibernate.loader.Loader.bindPositionalParameters(Loader.java:1698)
at org.hibernate.loader.Loader.bindParameterValues(Loader.java:1669)
at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1554)
at org.hibernate.loader.Loader.doQuery(Loader.java:661)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:224)
at org.hibernate.loader.Loader.doList(Loader.java:2211)
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2095)
at org.hibernate.loader.Loader.list(Loader.java:2090)
at org.hibernate.loader.criteria.CriteriaLoader.list(CriteriaLoader.java:95)
at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1569)
at org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:283)
at com.bofa.crme.gps.dao.hibernate.HibernatePartyDao$3.doInHibernate(HibernatePartyDao.java:205)
at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:362)
at org.springframework.orm.hibernate3.HibernateTemplate.executeFind(HibernateTemplate.java:332)
at com.bofa.crme.gps.dao.hibernate.HibernatePartyDao.getEntityHirearchies(HibernatePartyDao.java:170)
at com.bofa.crme.gps.dao.hibernate.HibernatePartyDaoTestListEH.testGetEntityHirearchies(HibernatePartyDaoTestListEH.java:31)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at junit.framework.TestCase.runTest(TestCase.java:154)
at junit.framework.TestCase.runBare(TestCase.java:127)
at org.springframework.test.ConditionalTestCase.runBare(ConditionalTestCase.java:69)
at junit.framework.TestResult$1.protect(TestResult.java:106)
at junit.framework.TestResult.runProtected(TestResult.java:124)
at junit.framework.TestResult.run(TestResult.java:109)
at junit.framework.TestCase.run(TestCase.java:118)
at junit.framework.TestSuite.runTest(TestSuite.java:208)
at junit.framework.TestSuite.run(TestSuite.java:203)
at org.junit.internal.runners.OldTestClassRunner.run(OldTestClassRunner.java:35)
at org.eclipse.jdt.internal.junit4.runner.JUnit4TestReference.run(JUnit4TestReference.java:38)
at org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:38)
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:460)
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:673)
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:386)
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:196)

[sathish kumar]

Can you throw in tour entire hbm file.This exception might be occurring when you try to select an object that has a array list/collection object associated.

[Paul Sturrock]

"skumar"

Thanks for updating your dispaly name. Unfortunately it is still invalid; we need both a first and last name. Can you please update it again.


Thanks!

[Lance Gleason]

I am having the same problem as well and have been banging my head against a wall trying to find a solution to it.

Lance

[Ayyappan Selvaraj]

Thanks for replying. The following is the hbm file entries..

  
<hibernate-mapping package="com.bofa.crme.gps.model.som">
<class name="EntityHierarchy" table="ENTITY_HIERARCHY" schema="CED"
dynamic-update="false" dynamic-insert="false"
select-before-update="false" optimistic-lock="version">
<cache usage="read-write" />
<composite-id name="id" class="EntityHierarchyId">
<key-property name="entityId" type="java.lang.Long"
column="ENT_ID" />
<key-property name="entityLinkTypeCode"
type="java.lang.String" column="ENTLINKTY_CODE" />
<key-property name="parentEntityId" type="java.lang.Long"
column="ENT_ID_PAR" />
</composite-id>
<many-to-one name="coreEntity" class="CoreEntity" cascade="all"
outer-join="auto" update="false" insert="false" 
fetch="select" access="property" not-null="false">
<column name="ENT_ID" />
</many-to-one>
<many-to-one name="coreEntityParent" class="CoreEntity"
cascade="all" outer-join="auto" update="false" insert="false"
fetch="select" access="property" not-null="false">
<column name="ENT_ID_PAR" />
</many-to-one>
</hibernate-mapping>
 

[Mark Spritzler]

Well, does the session have other objects in it, because it appears to be a parameter to your method, and therefore we don't know what was done before that method call to that session object.

Mark