[hibernate-issues] [Hibernate-JIRA] Created: (HHH-3347) Property Injection dos not work for unwanted properties and throw Invalid Coulumn Name Exception
Property Injection dos not work for unwanted properties and throw Invalid Coulumn Name
Exception
------------------------------------------------------------------------------------------------
Key: HHH-3347
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-3347
Project: Hibernate3
Issue Type: Bug
Components: query-sql
Affects Versions: 3.2.5
Reporter: mahdi asgari
To speed up my query i dosn't return unwanted properties from my database function,
but hibernate property binder try to set all properties.
I have got the following Exception when running named query
"TblBisYeganChildsByYeganId"
I search in the forum and read the hibernate references but i cant find the correct
solution,
would you please help me, is it a bug?
I am using Oracle10G,Hibernate 3.2.5.ga
The exception:
Hibernate:
{ ? = call pkg_bis_yegan.func_sel_childsbyyeganid(?) }
[INFO ] - could not read column value from result set: IS6_32_0_; Invalid column name
[WARN ] - SQL Error: 17006, SQLState: null
[ERROR] - Invalid column name
my Hibernate-Mapping xml
<hibernate-mapping>
<class lazy="true" name="com.test.TblBisYegan"
table="TBL_BIS_YEGAN" schema="AMAD">
<id name="pkYeganId" type="java.lang.Long">
<column name="PK_YEGAN_ID" precision="22"
scale="0" />
<generator class="assigned" />
</id>
<many-to-one name="tblBisInfoBaseDetail"
class="com.test.TblBisInfoBaseDetail" fetch="join"
lazy="false">
<column name="FK_INFO_BASE_DETAIL_ID" precision="22"
scale="0" />
</many-to-one>
<many-to-one name="tblBisYegan"
class="com.test.TblBisYegan" fetch="join" lazy="false">
<column name="FK_YEGAN_ID" precision="10"
scale="0" />
</many-to-one>
<property name="unitNum" type="java.lang.Long">
<column name="UNIT_NUM" precision="22"
scale="0" />
</property>
<property name="yeganName" type="java.lang.String">
<column name="YEGAN_NAME" length="100"
not-null="true" />
</property>
<property name="isActive" type="java.lang.Long">
<column name="IS_ACTIVE" precision="1"
scale="0" />
</property>
<property name="isCreateAmval" type="java.lang.Long">
<column name="IS_CREATE_AMVAL" precision="22"
scale="0" />
</property>
</class>
<sql-query name="TblBisYeganChildsByYeganId"
callable="true">
<return class="com.test.TblBisYegan">
<return-property name="pkYeganId" column="PK_YEGAN_ID"/>
<return-property name="yeganName" column="YEGAN_NAME"/>
<return-property name="unitNum" column="UNIT_NUM"/>
<return-property name="tblBisInfoBaseDetail">
<return-column name="PK_INFO_BASE_DETAIL_ID"/>
</return-property>
<return-property name="tblBisYegan">
<return-column name="PARENT_YEGAN_ID"/>
</return-property>
</return>
{ ? = call pkg_bis_yegan.func_sel_childsbyyeganid(:pkyeganid) }
</sql-query>
</hibernate-mapping>
My Function is:
create or replace package body pkg_bis_yegan is
function func_sel_childsbyyeganid(p_fk_yegan_id number)
return sys_refcursor is
func_result SYS_REFCURSOR;
begin
open func_result for
select tbl_bis_yegan.pk_yegan_id,
tbl_bis_yegan.yegan_name,
tbl_bis_yegan.unit_num,
null parent_yegan_id, -- if dos not exist hibernate throw exception
null pk_info_base_detail_id -- if dos not exist hibernate throw exception
from tbl_bis_yegan
where tbl_bis_yegan.fk_yegan_id = p_fk_yegan_id
order by tbl_bis_yegan.yegan_name;
return func_result;
end;
end pkg_bis_yegan;
--
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