-->
These old forums are deprecated now and set to read-only. We are waiting for you on our new forums!
More modern, Discourse-based and with GitHub/Google/Twitter authentication built-in.

All times are UTC - 5 hours [ DST ]



Forum locked This topic is locked, you cannot edit posts or make further replies.  [ 2 posts ] 
Author Message
 Post subject: DB View returns null populated List
PostPosted: Fri Aug 03, 2007 12:27 pm 
Newbie

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


Top
 Profile  
 
 Post subject:
PostPosted: Wed Aug 15, 2007 10:15 am 
Newbie

Joined: Wed Aug 15, 2007 9:20 am
Posts: 5
Please edit your post, add code tags around your config and indent it properly.


Top
 Profile  
 
Display posts from previous:  Sort by  
Forum locked This topic is locked, you cannot edit posts or make further replies.  [ 2 posts ] 

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

Search for:
© Copyright 2014, Red Hat Inc. All rights reserved. JBoss and Hibernate are registered trademarks and servicemarks of Red Hat, Inc.