I'm new in this forum , and also in hibernate.
i have this probleme whish i can't find a solution for it , i've seen several post in this forum about the same error but no one has given a right answer,
when i work without a resultSet it it looks fine ,i returned a List of Object . but when i use ResultSet to return a list of my Object , it doesn't work.
List<Category> itemList = findByNamedQuery("category.item.sql.querybyName", new Object[] { });
<?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>
<class name="com.bnpp.jdf.oco.dao.beo.Category" table="TB022_CATEGORY" schema="HR1">
<id name="technicalIdentifier" type="big_decimal">
<column name="TECHNICALIDENTIFIER" precision="22" scale="0" />
<generator class="assigned" />
</id>
<property name="categoryLevel" type="integer">
<column name="CATEGORYLEVEL" />
</property>
<many-to-one name="classification" class="com.bnpp.jdf.oco.dao.beo.Classification" fetch="select" cascade="all">
<column name="CLASSIFICATIONTECHID" precision="22" scale="0" />
</many-to-one>
<many-to-one name="category" class="com.bnpp.jdf.oco.dao.beo.Category" fetch="select" cascade="save-update">
<column name="PARENTCATEGORYTECHID" precision="22" scale="0" />
</many-to-one>
<component name="validityPeriod" class="com.bnpp.jdf.oco.dao.beo.Period">
<property name="endDate" type="date">
<column name="VALIDITY_ENDDATE" length="7" />
</property>
<property name="startDate" type="date">
<column name="VALIDITY_STARTDATE" length="7" />
</property>
</component>
<component name="labelsAndDescription" class="com.bnpp.jdf.oco.dao.beo.LabelsAndDescription">
<property name="description" type="string">
<column name="LAD_DESCRIPTION" length="4000" />
</property>
<property name="shortLabelCode" type="string">
<column name="LAD_SHORTLABELCODE" length="5" />
</property>
<property name="longLabelCode" type="string">
<column name="LAD_LONGLABELCODE" length="5" />
</property>
</component>
<set name="childCategories" cascade="all" inverse="false">
<key column="PARENTCATEGORYTECHID"/>
<one-to-many class="com.bnpp.jdf.oco.dao.beo.Category"/>
</set>
<set name="items" inverse="false" lazy="true" table="TB023_CATEGORY_ITEM" fetch="select" cascade="all" >
<key>
<column name="CATEGORYTECHID" precision="22" scale="0" not-null="true" />
</key>
<many-to-many entity-name="com.bnpp.jdf.oco.dao.beo.Item">
<column name="ITEMTECHID" precision="22" scale="0" not-null="true" />
</many-to-many>
</set>
</class>
<resultset name="CategoryItem">
<return alias="categoryItem" class="com.bnpp.jdf.oco.dao.beo.Category">
</return>
</resultset>
<sql-query name="category.item.sql.querybyName" resultset-ref="CategoryItem" >
<![CDATA[select TECHNICALIDENTIFIER ,CATEGORYLEVEL
from TB022_CATEGORY
]]>
</sql-query>
</hibernate-mapping>
Login
FAQ
Search