Hibernate Community • View topic - Set Element Collection Mapping

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

Set Element Collection Mapping - Set retrieved is empty

Page 1 of 1

[ 2 posts ]

Previous topic | Next topic

Author

Message

owenrh

Post subject: Set Element Collection Mapping - Set retrieved is empty

Posted: Wed Nov 03, 2004 2:14 pm

Newbie

Joined: Tue Sep 21, 2004 8:11 am
Posts: 6

Hibernate version: 2.1
Informix IDS 9.4
Spring 1.1.1 - should make any difference, in theory

Hi,

I've got a problem with the mapping shown below. Basically, I'm trying to map the following user_permission table from a core user table, which has a primary key of user_id:

Code:

create table user_permission (
user_id char(8) not null,
permission varchar(50) not null)

The sql appears to be generated correctly, and retrieves results from the user_permissions table. But when the setPermission(Set permissions) method is called the set passed in has zero elements. Despite the fact that there is data in the table, and the db logging suggests that a row was returned by the query.

Thanks, Owen

The mapping looks like this:

Code:

<hibernate-mapping>
    <class name="adaptation.user.User" table="user" dynamic-update="true" optimistic-lock="version">
      <cache usage="read-write"/>

        <id name="username" column="user_id">
            <generator class="assigned"/>
        </id>
        
        <version name="version" unsaved-value="negative"/>
        
        <property name="password" column="password" not-null="true"/>
        <set name="permissions" table="user_permission">
           <cache usage="read-write"/>
      <key column="user_id"/>
      <element column="permission" type="string"/>
   </set>
        ...
   </class>
</hibernate-mapping>

The logging on the database shows that the queries generated retrieve results from the user_permission table, inline with the following sql logged.

The generated SQL (show_sql=true):

Code:

[03/11/04 17:55:08:984 GMT] 7cab480e SystemOut     O Hibernate: select user0_.user_id as user_id0_, user0_.version as version0_, user0_.password as password0_, user0_.enabled_flag as enabled_4_0_, user0_.passwd_expire_date as passwd_e5_0_, user0_.start_dtime as start_dt6_0_, user0_.end_dtime as end_dtime0_, user0_.login_failures as login_fa8_0_ from user user0_ where user0_.user_id=?
[03/11/04 17:55:09:172 GMT] 7cab480e SystemOut     O Hibernate: select permission0_.permission as permission__, permission0_.user_id as user_id__ from user_permission permission0_ where permission0_.user_id=?

Top

owenrh

Post subject: Additional Info - 2 collections in resultset?

Posted: Thu Nov 04, 2004 5:42 am

Newbie

Joined: Tue Sep 21, 2004 8:11 am
Posts: 6

The debug below (see the end) shows that the query for user_permissions returns 2 collections, for some reason. Presumably the correct one is overwritten by the erroneous collection.

Code:

36:54,500 DEBUG SQL:237 - select user0_.user_id as user_id0_, user0_.version as version0_, user0_.password as password0_, user0_.enabled_flag as enabled_4_0_, user0_.passwd_expire_date as passwd_e5_0_, user0_.start_dtime as start_dt6_0_, user0_.end_dtime as end_dtime0_, user0_.login_failures as login_fa8_0_ from user user0_ where user0_.user_id=?
Hibernate: select user0_.user_id as user_id0_, user0_.version as version0_, user0_.password as password0_, user0_.enabled_flag as enabled_4_0_, user0_.passwd_expire_date as passwd_e5_0_, user0_.start_dtime as start_dt6_0_, user0_.end_dtime as end_dtime0_, user0_.login_failures as login_fa8_0_ from user user0_ where user0_.user_id=?
36:54,500 DEBUG BatcherImpl:241 - preparing statement
36:54,546 DEBUG StringType:46 - binding 'owenrh' to parameter: 1
36:54,609 DEBUG Loader:197 - processing result set
36:54,609 DEBUG Loader:405 - result row: owenrh
36:54,609 DEBUG Loader:536 - Initializing object from ResultSet: owenrh
36:54,609 DEBUG Loader:605 - Hydrating entity: adaptation.user.User#owenrh
36:54,609 DEBUG IntegerType:68 - returning '24' as column: version0_
36:54,609 DEBUG StringType:68 - returning 'owen' as column: password0_
36:54,625 DEBUG YesNoType:68 - returning 'true' as column: enabled_4_0_
36:54,625 DEBUG TimestampType:64 - returning null as column: passwd_e5_0_
36:54,625 DEBUG TimestampType:64 - returning null as column: start_dt6_0_
36:54,625 DEBUG TimestampType:64 - returning null as column: end_dtime0_
36:54,625 DEBUG IntegerType:68 - returning '0' as column: login_fa8_0_
36:54,625 DEBUG SessionImpl:1874 - Version: 24
36:54,640 DEBUG Loader:226 - done processing result set (1 rows)
36:54,656 DEBUG BatcherImpl:203 - done closing: 0 open PreparedStatements, 0 open ResultSets
36:54,671 DEBUG BatcherImpl:261 - closing statement
36:54,687 DEBUG Loader:239 - total objects hydrated: 1
36:54,687 DEBUG SessionImpl:2166 - resolving associations for [adaptation.user.User#owenrh]
36:54,687 DEBUG SessionImpl:3891 - creating collection wrapper:[adaptation.user.User.permissions#owenrh]
36:54,687 DEBUG SessionImpl:3218 - initializing collection [adaptation.user.User.permissions#owenrh]
36:54,687 DEBUG SessionImpl:3219 - checking second-level cache
36:54,687 DEBUG ReadWriteCache:68 - Cache lookup: owenrh
36:54,687 DEBUG ReadWriteCache:84 - Cache miss: owenrh
36:54,687 DEBUG SessionImpl:3225 - collection not cached
36:54,703 DEBUG BatcherImpl:196 - about to open: 0 open PreparedStatements, 0 open ResultSets
36:54,703 DEBUG SQL:237 - select permission0_.permission as permission__, permission0_.user_id as user_id__ from user_permission permission0_ where permission0_.user_id=?
Hibernate: select permission0_.permission as permission__, permission0_.user_id as user_id__ from user_permission permission0_ where permission0_.user_id=?
36:54,703 DEBUG BatcherImpl:241 - preparing statement
36:54,718 DEBUG StringType:46 - binding 'owenrh' to parameter: 1
36:54,765 DEBUG Loader:327 - result set contains (possibly empty) collection: [adaptation.user.User.permissions#owenrh]
36:54,765 DEBUG SessionImpl:2984 - uninitialized collection: initializing
36:54,765 DEBUG Loader:197 - processing result set
36:54,765 DEBUG Loader:405 - result row: 
36:54,765 DEBUG StringType:68 - returning 'owenrh  ' as column: user_id__
36:54,765 DEBUG Loader:292 - found row of collection: [adaptation.user.User.permissions#owenrh  ]
36:54,765 DEBUG SessionImpl:2996 - new collection: instantiating
36:54,765 DEBUG StringType:68 - returning 'ROLE_SUPERVISOR' as column: permission__
36:54,796 DEBUG Loader:226 - done processing result set (1 rows)
36:54,812 DEBUG BatcherImpl:203 - done closing: 0 open PreparedStatements, 0 open ResultSets
36:54,812 DEBUG BatcherImpl:261 - closing statement
36:54,828 DEBUG SessionImpl:3043 - 2 collections were found in result set
36:54,828 DEBUG SessionImpl:3057 - Caching collection: [adaptation.user.User.permissions#owenrh]
36:54,828 DEBUG ReadWriteCache:132 - Caching: owenrh
36:54,843 DEBUG ReadWriteCache:143 - Cached: owenrh
36:54,843 DEBUG SessionImpl:3061 - collection fully initialized: [adaptation.user.User.permissions#owenrh]
36:54,843 DEBUG SessionImpl:3057 - Caching collection: [adaptation.user.User.permissions#owenrh  ]
36:54,843 DEBUG ReadWriteCache:132 - Caching: owenrh  
36:54,843 DEBUG ReadWriteCache:143 - Cached: owenrh  
36:54,843 DEBUG SessionImpl:3061 - collection fully initialized: [adaptation.user.User.permissions#owenrh  ]
36:54,843 DEBUG SessionImpl:3064 - 2 collections initialized
36:54,843 DEBUG SessionImpl:3227 - collection initialized
Permission size on setPermissions call is --->0

Top

Page 1 of 1

[ 2 posts ]

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