Stored proc calling exception: org hibernate MappingException: Unknown entity:

[prasad kulkarni]

I am trying to call the stored proc through hibernate (& spring), but getting the following exception. Surprisingly , if I use another class present in the same package , it is working.(There are exceptions as the mappings are not related to the another class, but the class is recognized by the hibernate.) Can anybody help me to get out of this? Why the class is not recognized by hibernate?(I am using hibernate 3). I have tried with fully qualified name as well as only class name, but no luck.

org.hibernate.impl.SessionFactoryImpl.<init>(SessionFactoryImpl.java:363) - Error in named query: my_query
org.hibernate.MappingException: Unknown entity: com.domain.SrUserReportResultData
at org.hibernate.impl.SessionFactoryImpl.getEntityPersister(SessionFactoryImpl.java:550)
at org.hibernate.loader.custom.sql.SQLQueryReturnProcessor.getSQLLoadable(SQLQueryReturnProcessor.java:312)
at org.hibernate.loader.custom.sql.SQLQueryReturnProcessor.processRootReturn(SQLQueryReturnProcessor.java:353)
at org.hibernate.loader.custom.sql.SQLQueryReturnProcessor.processReturn(SQLQueryReturnProcessor.java:332)
at org.hibernate.loader.custom.sql.SQLQueryReturnProcessor.process(SQLQueryReturnProcessor.java:148)
at org.hibernate.loader.custom.sql.SQLCustomQuery.<init>(SQLCustomQuery.java:64)
at org.hibernate.engine.query.NativeSQLQueryPlan.<init>(NativeSQLQueryPlan.java:43)
at org.hibernate.engine.query.QueryPlanCache.getNativeSQLQueryPlan(QueryPlanCache.java:114)
at org.hibernate.impl.SessionFactoryImpl.checkNamedQueries(SessionFactoryImpl.java:446)
at org.hibernate.impl.SessionFactoryImpl.<init>(SessionFactoryImpl.java:352)
at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1300)
at org.springframework.orm.hibernate3.LocalSessionFactoryBean.newSessionFactory(LocalSessionFactoryBean.java:816)
at org.springframework.orm.hibernate3.LocalSessionFactoryBean.buildSessionFactory(LocalSessionFactoryBean.java:734)
at org.springframework.orm.hibernate3.AbstractSessionFactoryBean.afterPropertiesSet(AbstractSessionFactoryBean.java:211)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1333)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1299)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:463)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory$1.run(AbstractAutowireCapableBeanFactory.java:404)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:375)
at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:263)
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:170)
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:260)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:184)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:163)
at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:269)
at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:104)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1210)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:978)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:462)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory$1.run(AbstractAutowireCapableBeanFactory.java:404)
org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.destroySingletons(DefaultSingletonBeanRegistry.java:341) 

Here is my xml file code:

<sql-query name="my_query" >
 <return class="com.domain.SrUserReportResultData" > 
<return-property name="longMkSettle" column="mvsettlelong" />
<return-property name="longMkTrade" column="mvtradelong" />
<return-property name="longPosTrade" column="longpostradesum" />
<return-property name="longPosSettle" column="longpossettlesum" />
<return-property name="price" column="pricetype" />
<return-property name="securityCount" column="securitycount" />
<return-property name="securityType" column="security_type" />
<return-property name="shortPosTrade" column="shortpostradesum" />
<return-property name="shortPosSettle" column="shortpossettlesum" />
<return-property name="shortMkTrade" column="mvtradeshort" />
<return-property name="shortMkSettle" column="mvsettleshort" />
</return> 
{ call sr_ui.Stock_borrowfgdfgdg( ?, :in_request_group_id , ? , :in_finra_coa_code , ? , in_long_short_ind  ) }
</sql-query>

My java class is as :
[code]
package com.domain;

import java.util.Date;


public class SrUserReportResultData {

......java class with the attributes & getters-setters
}
[/class]

[Cameron Wallace McKenzie]

So, it seems that the SrUserReportResultData class is used in a query, or is part of the result, and is mapped to a table, but the class itself either isn't part of the configuration, so it is never treated as a Hibernate entity. Make sure it's in the mapping file!

-Cameron McKenzie

[prasad kulkarni]

yeah thanks, I did that & it worked. I have added following in the mapping file. Note that <id ...> tag is IMP otherwise , it will not work.(I faced same exception w/o this tag.)

 
<class name="com.domain.SrUserReportResultData" >
  <id name="securityCount" >
  <generator class="assigned" />
  </id>
  <property name="securityCount" column="securitycount" />
-------- other properties ----

  <loader query-ref="stock_borrow" />
</class>