Grouper Developers Forum

[Shilen Patel <>]

So MembershipEntry refers to the grouper_memberships_all_v view in the 
database.  And this view is composed of grouper_group_set and 
grouper_memberships.  When the code was trying to perform a select, 
hibernate discovered that the owner_id field in MembershipEntry (which 
is really the owner_id field in grouper_group_set) was not right so it 
tried to perform an update.  Hibernate doesn't realize that it's a view 
and so it fails.

Thanks!

-- Shilen

On 7/1/10 12:55 PM, Jim Fox wrote:
>    
> > If you look in the SQL file that was generated as part of the upgrade,
> > these statements should be in there.  I'm guessing they didn't get
> > executed because of the other issue you had with the views.
> >
> > Let me know if this works or not.
> >
> >      
> Works like a charm now.  Thanks.
>
> Was the "query: 'select ms, m from MembershipEntry as ms,..." statement
> reported in the error.log a ruse?  And the real failed query was to the
> group_group_set table?
>
> Thanks again.
>
> Jim
>