Hibernate Community • View topic - can return-property be used to partially load a class?

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

can return-property be used to partially load a class?

Page 1 of 1

[ 1 post ]

Previous topic | Next topic

Author

Message

arnieOag

Post subject: can return-property be used to partially load a class?

Posted: Mon Jul 09, 2007 1:54 pm

Beginner

Joined: Tue Jul 25, 2006 12:34 pm
Posts: 25

Is it possible (as shown in the mapping file below) to have a SP as the source for a list() call but only populate part of the class? The SP is already in production and I'd rather not modify it. I thought the return-property would allow me to do that by specifying what was coming back from the SP. But the error message is no help (I didn't assign a column name of 'owner1_2_0_'). Do I have the name/column values transposed?

Hibernate version: 3.2.3

Mapping documents:

Code:

<?xml version="1.0" encoding="utf-8"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<!-- 
    Mapping file autogenerated by MyEclipse - Hibernate Tools
-->
<hibernate-mapping package="us.tx.state.oag.ApplicationSecurity.db">

    <class name="InfoPublicAddress" table="info_public_address" schema="dbo" catalog="application_security">
    
        <composite-id name="id" class="us.tx.state.oag.ApplicationSecurity.db.InfoPublicAddressId">
            <key-property name="ownerTypeId" type="java.math.BigDecimal">
                <column name="owner_type_id" precision="18" scale="0" />
            </key-property>
            <key-property name="addressId" type="java.math.BigDecimal">
                <column name="address_id" precision="18" scale="0" />
            </key-property>
            <key-property name="parentId" type="java.math.BigDecimal">
                <column name="parent_id" precision="18" scale="0" />
            </key-property>
            <key-property name="addressTypeId" type="java.math.BigDecimal">
                <column name="address_type_id" precision="18" scale="0" />
            </key-property>
            <key-property name="dtEffective" type="java.sql.Timestamp">
                <column name="dt_effective" length="23" />
            </key-property>
        </composite-id>
        
        <property name="city" type="java.lang.String">
            <column name="city" length="30" not-null="true" />
        </property>
        <property name="inactive" type="java.lang.Integer">
            <column name="inactive" not-null="true" />
        </property>
        <property name="isPrimary" type="java.lang.Integer">
            <column name="is_primary" not-null="true" />
        </property>
        <property name="line1" type="java.lang.String">
            <column name="line_1" length="30" not-null="true" />
        </property>
        <property name="line2" type="java.lang.String">
            <column name="line_2" length="30" />
        </property>
        <property name="line3" type="java.lang.String">
            <column name="line_3" length="30" />
        </property>
        <property name="addressName" type="java.lang.String">
            <column name="address_name" length="60" not-null="true" />
        </property>
        <property name="stateCode" type="java.lang.String">
            <column name="state_code" length="6" not-null="true" />
        </property>
        <property name="postalCode" type="java.lang.String">
            <column name="postal_code" length="15" not-null="true" />
        </property>
        <property name="countyCode" type="java.lang.String">
            <column name="county_code" length="13" />
        </property>
        <property name="countryCode" type="java.lang.String">
            <column name="country_code" length="3" />
        </property>
        <property name="crUser" type="java.lang.String">
            <column name="cr_user" length="20" not-null="true" />
        </property>
        <property name="crDate" type="java.sql.Timestamp">
            <column name="cr_date" length="23" not-null="true" />
        </property>
        <property name="upUser" type="java.lang.String">
            <column name="up_user" length="20" not-null="true" />
        </property>
        <property name="upDate" type="java.sql.Timestamp">
            <column name="up_date" length="23" not-null="true" />
        </property>
    </class>

   <!-- NOTE: the first parameter, owner-type = 1 for users -->    
    <sql-query name="userAddresses" callable="true">
       <return alias="userAddress" class="InfoPublicAddress">
          <return-property name="addressName" column="address_name"/>
          <return-property name="line1" column="line_1"/>
          <return-property name="city" column="city"/>
          <return-property name="stateCode" column="state_code"/>
          <return-property name="postalCode" column="postal_code"/>
          <return-property name="countyCode" column="county_code"/>
          <return-property name="countryCode" column="country_code"/>
          <return-property name="isPrimary" column="is_primary"/>
          <return-property name="dtEffective" column="dt_effective"/>
          <return-property name="inactive" column="inactive"/>
          <return-property name="ownerTypeId" column="owner_type_id"/>
          <return-property name="addessId" column="address_id"/>
          <return-property name="parentId" column="parent_id"/>
          <return-property name="addressTypeId" column="address_type_id"/>
       </return>
      <![CDATA[
          { call info_public_addr_on_file_spr(1,?) }
       ]]>       
    </sql-query>

   <!-- NOTE: the first parameter, owner-type = 2 for companies -->    
    <sql-query name="companyAddresses" callable="true">
       <return alias="companyAddress" class="InfoPublicAddress"/>
      <![CDATA[
          { call info_public_addr_on_file_spr(2,?) }
       ]]>       
    </sql-query>

   <!-- NOTE: requires the entire key be supplied -->    
    <sql-query name="getPublicAddress" callable="true">
       <return alias="infoPublicAddress" class="InfoPublicAddress"/>
      <![CDATA[
          { call info_public_address_spr(?,?,?,?,?) }
       ]]>       
    </sql-query>
    
</hibernate-mapping>

Code between sessionFactory.openSession() and session.close():

Code:

            lo_query = lo_sess.getNamedQuery(APPSEC_NQ_USER_ADDRESSES);
            lo_query.setBigDecimal(0, pl_userId);
            lo_numbers = (ArrayList)lo_query.list();

Full stack trace of any exception that occurs:

Name and version of the database you are using: Sybase 12.5

The generated SQL (show_sql=true): (none shown)

Extract From Stored Procedure

Code:

SELECT A.address_name,
   B.description AS address_type,
   A.line_1,
   A.city,
   A.state_code,
   A.postal_code,
   A.county_code,
   A.country_code,
   A.is_primary,
   A.dt_effective,
   A.inactive,
   A.owner_type_id,
   A.address_id,
   A.parent_id,
   A.address_type_id
. . .

Top

Page 1 of 1

[ 1 post ]

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum