Grouper Developers Forum

[Chris Hyzer <>]

We don't have a one-to-one on tables/views to java objects, so you need to 
look for an entity-name in the hbms to see where it goes.  A little 
confusing...

In Hib3MembershipDAO.hbm.xml, you see:

  <class name="Membership" table="grouper_memberships_all_v" batch-size="5" 
optimistic-lock="version" entity-name="MembershipEntry">

So this is the grouper_memberships_all_v, you should see a column: owner_id

In the GrouperDdl table you should see: Object_name: Grouper -> db_version: 
23.  In the upgrade DDL script it should have changed the view to have the 
right columns...  in Grouper 1.5 there was not that column in that view.

Thanks,
Chris



-----Original Message-----
From: 

 
[mailto:]
 On Behalf Of Jim Fox
Sent: Wednesday, June 30, 2010 1:12 PM
To: 

Subject: [grouper-dev] after 1.6.0 getting db error


After upgrading my database to 1.6.0 I'm getting this on a 
GroupFinder.findByName API call:

-------------------------
   ERROR ByHqlStatic.list(366) - Exception in list: (class 
[Ljava.lang.Object;), ByHqlStatic,
   query: 'select ms, m from MembershipEntry as ms, Member as m where       
ms.ownerGroupId   = :owner            and  ms.memberUuid  = :member           
and ms.memberUuid = m.uuid  and ms.enabledDb = 'T'', cacheable: false, 
cacheRegion: 
edu.internet2.middleware.grouper.internal.dao.hib3.Hib3MembershipDAO.FindAllByGroupOwnerAndMemberAndField,
 tx type: null, tx type: nullBind var[0]: 'Param (class java.lang.String): 
'owner'->'b1b359c35174b82ec9d00b2b08d31a98'Bind var[1]: 'Param (class 
java.lang.String): 'member'->'b9d5a6f95baa42c690c887d5ba158b55', 
edu.internet2.middleware.grouper.internal.dao.GrouperDAOException: Problem in 
HibernateSession: HibernateSession: isNew: true, isReadonly: true, 
grouperTransactionType: READONLY_NEW
         at 
edu.internet2.middleware.grouper.hibernate.HibernateSession._internal_hibernateSessionCatch(HibernateSession.java:420)
         at 
edu.internet2.middleware.grouper.hibernate.HibernateSession.callbackHibernateSession(HibernateSession.java:506)
         at 
edu.internet2.middleware.grouper.hibernate.ByHqlStatic.list(ByHqlStatic.java:346)
         at 
edu.internet2.middleware.grouper.hibernate.ByHqlStatic.listSet(ByHqlStatic.java:392)
         at 
edu.internet2.middleware.grouper.internal.dao.hib3.Hib3MembershipDAO.findAllByGroupOwnerAndMember(Hib3MembershipDAO.java:1190)
         at 
edu.internet2.middleware.grouper.privs.GrouperNonDbAccessAdapter.getPrivs(GrouperNonDbAccessAdapter.java:180)
         at 
edu.internet2.middleware.grouper.privs.AccessWrapper.getPrivileges(AccessWrapper.java:98)
         at 
edu.internet2.middleware.grouper.privs.GrouperAllAccessResolver.getPrivileges(GrouperAllAccessResolver.java:78)
         at 
edu.internet2.middleware.grouper.privs.GrouperSystemAccessResolver.getPrivileges(GrouperSystemAccessResolver.java:83)
         at 
edu.internet2.middleware.grouper.privs.CachingAccessResolver.getPrivileges(CachingAccessResolver.java:90)
         at 
edu.internet2.middleware.grouper.privs.CachingAccessResolver.hasPrivilege(CachingAccessResolver.java:149)
         at 
edu.internet2.middleware.grouper.privs.WheelAccessResolver.hasPrivilege(WheelAccessResolver.java:179)
         at 
edu.internet2.middleware.grouper.privs.ValidatingAccessResolver.hasPrivilege(ValidatingAccessResolver.java:100)
         at 
edu.internet2.middleware.grouper.privs.PrivilegeHelper.canView(PrivilegeHelper.java:317)
         at 
edu.internet2.middleware.grouper.GroupFinder.findByName(GroupFinder.java:238)
         at 
edu.internet2.middleware.grouper.GroupFinder.findByName(GroupFinder.java:198)
         at 
edu.washington.gws.group.grouper.GrouperGroupManager.getGwsGroupOrStemByStem(GrouperGroupManager.java:369)


and below it reports:

Caused by: org.postgresql.util.PSQLException: ERROR: column 
membership0_.owner_id does not exist
         at 
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1592)
         at 
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1327)
         ...
--------------------------------

I don't see any table or view named MembershipEntry.  Is that created 
dynamically?
Any ideas where I might look to see if the DB schema is complete?

Thansk

Jim