Joined: Fri Aug 03, 2007 12:14 pm Posts: 1
|
I using version 3 of Hibernate to access my database. The generated code is working great except for a view that joins some tables. Calls to this view return a List with the correct size but each element is null. Here is copy of the map file for the view:
<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<!-- Generated Aug 2, 2007 10:55:08 AM by Hibernate Tools 3.2.0.b9 -->
<hibernate-mapping>
<class name="com.ngit.its.iwodb.domain.VactiveUserPriv" table="IWOW.VACTIVE_USER_PRIV">
<composite-id name="id" class="com.ngit.its.iwodb.domain.VactiveUserPrivId">
<key-property name="userId" type="string">
<column name="USER_ID" length="10" />
</key-property>
<key-property name="userFullNm" type="string">
<column name="USER_FULL_NM" length="100" />
</key-property>
<key-property name="homeEntityCd" type="string">
<column name="HOME_ENTITY_CD" length="5" />
</key-property>
<key-property name="addById" type="string">
<column name="ADD_BY_ID" length="10" />
</key-property>
<key-property name="lastUpdateId" type="string">
<column name="LAST_UPDATE_ID" length="10" />
</key-property>
<key-property name="lastUpdateDa" type="date">
<column name="LAST_UPDATE_DA" length="7" />
</key-property>
<key-property name="passwordTx" type="string">
<column name="PASSWORD_TX" length="40" />
</key-property>
<key-property name="privEntityCd" type="string">
<column name="PRIV_ENTITY_CD" length="5" />
</key-property>
<key-property name="privFromDa" type="date">
<column name="PRIV_FROM_DA" length="7" />
</key-property>
<key-property name="privContactRoleNm" type="string">
<column name="PRIV_CONTACT_ROLE_NM" length="100" />
</key-property>
<key-property name="privThruDa" type="date">
<column name="PRIV_THRU_DA" length="7" />
</key-property>
<key-property name="privAddById" type="string">
<column name="PRIV_ADD_BY_ID" length="10" />
</key-property>
<key-property name="privLastUpdateId" type="string">
<column name="PRIV_LAST_UPDATE_ID" length="10" />
</key-property>
<key-property name="privLastUpdateDa" type="date">
<column name="PRIV_LAST_UPDATE_DA" length="7" />
</key-property>
<key-property name="homeSectorNm" type="string">
<column name="HOME_SECTOR_NM" length="100" />
</key-property>
<key-property name="homeEntityArchiveDa" type="date">
<column name="HOME_ENTITY_ARCHIVE_DA" length="7" />
</key-property>
<key-property name="homeEntityNm" type="string">
<column name="HOME_ENTITY_NM" length="100" />
</key-property>
<key-property name="homeSubsysIn" type="string">
<column name="HOME_SUBSYS_IN" length="1" />
</key-property>
<key-property name="homeDispTx" type="string">
<column name="HOME_DISP_TX" length="100" />
</key-property>
<key-property name="privSectorNm" type="string">
<column name="PRIV_SECTOR_NM" length="100" />
</key-property>
<key-property name="privEntityArchiveDa" type="date">
<column name="PRIV_ENTITY_ARCHIVE_DA" length="7" />
</key-property>
<key-property name="privEntityNm" type="string">
<column name="PRIV_ENTITY_NM" length="100" />
</key-property>
<key-property name="privSubsysIn" type="string">
<column name="PRIV_SUBSYS_IN" length="1" />
</key-property>
<key-property name="privDispTx" type="string">
<column name="PRIV_DISP_TX" length="100" />
</key-property>
</composite-id>
</class>
</hibernate-mapping>
Can someone please show me the error of my ways? Thanks
|
|