Grouper Users - Open Discussion List

[Chris Hyzer <>]

> I am not having much luck with debugging my problem via p6spy using the
> 1.4.1-SNAPSHOT.

It wasn’t 1.4.1, it was 1.4 branch, right?  (which is newer and fixed in this 
area)

If that isn’t the problem, can you get the latest 1.4 branch and make sure 
the grouper version says 1.4.2 instead of 1.4.1?  And every 
grouper.properties file has the hook listed, right?  (e.g. in the UI, WS, etc)

If that doesn’t work, then please let me know the platform and db version of 
your db, and the platform that you are developing on.  Also let me know how 
you are updating the group (UI?  GSH?  WS?) and I will try to put together an 
end-to-end start-to-finish example for you...

Kind regards,
Chris

> -----Original Message-----
> From: Dr. Loris Bennett 
> [mailto:]
> Sent: Wednesday, February 18, 2009 4:00 AM
> To: Chris Hyzer
> Cc: Grouper Users Mailing List
> Subject: RE: [grouper-users] RE: Grouper 1.4.0: Using hooks
>
> Hi Chris,
>
> I am not having much luck with debugging my problem via p6spy using the
> 1.4.1-SNAPSHOT.
>
> In the attached file contains the log info for the following actions:
>
>         1. Create group with without p6spy -> Hook is fired, group is
>         created but without the data which from the hook
>
>         2. Configure p6spy -> Grouper no longer starts with "Database
>         schema ddl is not up to date"
>
>         3. Unconfigure p6spy -> Same problem as in 2.
>
> Is it possible that p6spy breaking the database? This seems a little
> unlikely to me, but then again I am not familiar with it.
>
> Any ideas?
>
> Thanks
>
> Loris
>
>
>
> On Wed, 2009-02-11 at 09:54 -0500, Chris Hyzer wrote:
> > Hmm, it works for me.  Are you sure the hook code is getting executed
> on a postInsert?  You see log messages?
> >
> > Let me explain the differences first:
> >
> > a. postInsert should go in same transaction, so once the group add is
> committed, the add type and assign attribute is committed
> >
> > b. postInsert with the hibernate callback with transactiontype
> GrouperTransactionType.READ_WRITE_NEW
> >
> > This will run in a different transaction.  I don’t think this would
> work since how can you add a type or attribute to a group which is not
> committed yet in a different transaction?
> >
> > c. postCommitInsert should wait until all group add code is
> committed, then will run... shouldn’t need a new transaction there if
> you have the latest in branch after I added a tx to all postCommit
> hooks.
> >
> > How are you adding your group?  UI?  GSH?
> >
> >
> > Here is what I do to try to troubleshoot this kind of thing:
> >
> > 1. in grouper.hibernate.properties, set the db driver to p6spy (which
> logs db traffic)
> >
> > hibernate.connection.driver_class     =
> com.p6spy.engine.spy.P6SpyDriver
> >
> > 2. in spy.properties, set the realdriver to whatever it was in
> grouper.hibernate.properties:
> >
> > realdriver=com.mysql.jdbc.Driver
> >
> > 3. in spy.properties, set the log file to something where the parent
> dir exist, where you want the logs to go:
> >
> > logfile=f\:\\temp\\grouperSpy.log
> >
> > 4. run the test case, and look in that log.  I debug and step through
> so I can see sql for each java step, though Hibernate might not flush
> it...
> >
> > I am just using a junit test case:
> >
> >     //try an insert
> >     Group group = edu.addChildGroup("myGroup", "myGroup");
> >
> >     assertTrue(group.getTypes().contains(fubGroup));
> >
> >     assertEquals("2", group.getAttribute("gid"));
> >
> > Hook:
> >
> http://viewvc.internet2.edu/viewvc.py/grouper/src/test/edu/internet2/mi
> ddleware/grouper/hooks/GroupHookAddType.java?root=I2MI&view=markup&path
> rev=GROUPER_1_4_BRANCH
> >
> > Test:
> >
> http://viewvc.internet2.edu/viewvc.py/grouper/src/test/edu/internet2/mi
> ddleware/grouper/hooks/GroupHooksAddTypeTest.java?root=I2MI&view=markup
> &pathrev=GROUPER_1_4_BRANCH
> >
> >
> >
> #######################################################################
> ############
> > Group.addType in hook produces this:
> >
> #######################################################################
> ############
> >
> > 2009/02/11 09:32:30:693, 0ms, statement: ByHqlStatic.java.listSet()
> line 293, Hib3GroupTypeDAO.java.findAll() line 132,
> GroupTypeFinder.java._findAll() line 227,
> GroupTypeFinder.java.internal_updateKnownTypes() line 191,
> GroupTypeFinder.java.find() line 74,
> GroupTypeTupleIncludeExcludeHook.java.groupTypeTupleHelper() line 173,
> GroupTypeTupleIncludeExcludeHook.java.groupTypeTuplePostInsert() line
> 143, GrouperUtil.java.invokeMethod() line 3023,
> GrouperHooksUtils.java.executeHook() line 460,
> GrouperHooksUtils.java.callHooksIfRegistered() line 263,
> GrouperHooksUtils.java.callHooksIfRegistered() line 202,
> GrouperHooksUtils.java.callHooksIfRegistered() line 128,
> GroupTypeTuple.java.onPostSave() line 178, Hib3GroupDAO.java.callback()
> line 107, Hib3GroupDAO.java.addType() line 103, Group.java.addType()
> line 711, Group.java.addType() line 659,
> GroupHookAddType.java.groupPostInsert() line 28,
> GrouperUtil.java.invokeMethod() line 3023,
> GrouperHooksUtils.java.executeHook() line 460,
> GrouperHooksUtils.java.callHooksIfRegistered() line 263,
> GrouperHooksUtils.java.callHooksIfRegistered() line 202,
> GrouperHooksUtils.java.callHooksIfRegistered() line 128,
> Group.java.onPostSave() line 3434, Hib3StemDAO.java.callback() line 74,
> Hib3StemDAO.java.createChildGroup() line 68, Stem.java.callback() line
> 1374, Stem.java.internal_addChildGroup() line 1316,
> Stem.java.addChildGroup() line 277,
> GroupHooksAddTypeTest.java.testGroupHooksAddType() line 105,
> GroupHooksAddTypeTest.java.main() line 32
> >    select grouptype0_.id as id4_,
> grouptype0_.hibernate_version_number as hibernate2_4_, grouptype0_.name
> as name4_, grouptype0_.creator_uuid as creator4_4_,
> grouptype0_.create_time as create5_4_, grouptype0_.is_assignable as
> is6_4_, grouptype0_.is_internal as is7_4_ from grouper_types
> grouptype0_ order by grouptype0_.name asc
> > 2009/02/11 09:32:30:771, resultset: ALIASES: 0: id, 1:
> hibernate_version_number, 2: name, 3: creator_uuid, 4: create_time, 5:
> is_assignable, 6: is_internal
> > 2009/02/11 09:32:30:771, resultset: 0: 17ea736c-a0c0-4857-aa51-
> c96cccecafc7, 1: 0, 2: base, 3: 7a81d717-dced-4e56-ad13-4343f3f67321,
> 4: 1234361874926, 5: false, 6: false
> > 2009/02/11 09:32:30:771, resultset: 0: b6402c98-104c-4425-a3eb-
> ed25c489301a, 1: 0, 2: fubGroup, 3: 7a81d717-dced-4e56-ad13-
> 4343f3f67321, 4: 1234362665051, 5: true, 6: false
> > 2009/02/11 09:32:30:771, resultset: 0: d1c845d6-7e25-45f5-ab5b-
> 152ab6c8ac08, 1: 0, 2: naming, 3: 7a81d717-dced-4e56-ad13-4343f3f67321,
> 4: 1234361875129, 5: false, 6: true
> > 2009/02/11 09:32:30:787, 0ms, statement: ByHqlStatic.java.listSet()
> line 293, Hib3GroupTypeDAO.java.findAll() line 132,
> GroupTypeFinder.java._findAll() line 227,
> GroupTypeFinder.java.internal_updateKnownTypes() line 191,
> GroupTypeFinder.java.find() line 74,
> GroupTypeTupleIncludeExcludeHook.java.groupTypeTupleHelper() line 173,
> GroupTypeTupleIncludeExcludeHook.java.groupTypeTuplePostInsert() line
> 143, GrouperUtil.java.invokeMethod() line 3023,
> GrouperHooksUtils.java.executeHook() line 460,
> GrouperHooksUtils.java.callHooksIfRegistered() line 263,
> GrouperHooksUtils.java.callHooksIfRegistered() line 202,
> GrouperHooksUtils.java.callHooksIfRegistered() line 128,
> GroupTypeTuple.java.onPostSave() line 178, Hib3GroupDAO.java.callback()
> line 107, Hib3GroupDAO.java.addType() line 103, Group.java.addType()
> line 711, Group.java.addType() line 659,
> GroupHookAddType.java.groupPostInsert() line 28,
> GrouperUtil.java.invokeMethod() line 3023,
> GrouperHooksUtils.java.executeHook() line 460,
> GrouperHooksUtils.java.callHooksIfRegistered() line 263,
> GrouperHooksUtils.java.callHooksIfRegistered() line 202,
> GrouperHooksUtils.java.callHooksIfRegistered() line 128,
> Group.java.onPostSave() line 3434, Hib3StemDAO.java.callback() line 74,
> Hib3StemDAO.java.createChildGroup() line 68, Stem.java.callback() line
> 1374, Stem.java.internal_addChildGroup() line 1316,
> Stem.java.addChildGroup() line 277,
> GroupHooksAddTypeTest.java.testGroupHooksAddType() line 105,
> GroupHooksAddTypeTest.java.main() line 32
> >    insert into grouper_groups_types (hibernate_version_number,
> group_uuid, type_uuid, id) values (0, 'f872f926-1a24-45c0-955d-
> 66373ad4c5da', 'b6402c98-104c-4425-a3eb-ed25c489301a',
> '02db5bdb1f65bf5b011f65c0d6e5004d')
> > 2009/02/11 09:32:30:849, 0ms, statement: ByHqlStatic.java.listSet()
> line 293, Hib3GroupTypeDAO.java.findAll() line 132,
> GroupTypeFinder.java._findAll() line 227,
> GroupTypeFinder.java.internal_updateKnownTypes() line 191,
> GroupTypeFinder.java.find() line 74,
> GroupTypeTupleIncludeExcludeHook.java.groupTypeTupleHelper() line 178,
> GroupTypeTupleIncludeExcludeHook.java.groupTypeTuplePostInsert() line
> 143, GrouperUtil.java.invokeMethod() line 3023,
> GrouperHooksUtils.java.executeHook() line 460,
> GrouperHooksUtils.java.callHooksIfRegistered() line 263,
> GrouperHooksUtils.java.callHooksIfRegistered() line 202,
> GrouperHooksUtils.java.callHooksIfRegistered() line 128,
> GroupTypeTuple.java.onPostSave() line 178, Hib3GroupDAO.java.callback()
> line 107, Hib3GroupDAO.java.addType() line 103, Group.java.addType()
> line 711, Group.java.addType() line 659,
> GroupHookAddType.java.groupPostInsert() line 28,
> GrouperUtil.java.invokeMethod() line 3023,
> GrouperHooksUtils.java.executeHook() line 460,
> GrouperHooksUtils.java.callHooksIfRegistered() line 263,
> GrouperHooksUtils.java.callHooksIfRegistered() line 202,
> GrouperHooksUtils.java.callHooksIfRegistered() line 128,
> Group.java.onPostSave() line 3434, Hib3StemDAO.java.callback() line 74,
> Hib3StemDAO.java.createChildGroup() line 68, Stem.java.callback() line
> 1374, Stem.java.internal_addChildGroup() line 1316,
> Stem.java.addChildGroup() line 277,
> GroupHooksAddTypeTest.java.testGroupHooksAddType() line 105,
> GroupHooksAddTypeTest.java.main() line 32
> >    select grouptype0_.id as id4_,
> grouptype0_.hibernate_version_number as hibernate2_4_, grouptype0_.name
> as name4_, grouptype0_.creator_uuid as creator4_4_,
> grouptype0_.create_time as create5_4_, grouptype0_.is_assignable as
> is6_4_, grouptype0_.is_internal as is7_4_ from grouper_types
> grouptype0_ order by grouptype0_.name asc
> > 2009/02/11 09:32:30:912, resultset: ALIASES: 0: id, 1:
> hibernate_version_number, 2: name, 3: creator_uuid, 4: create_time, 5:
> is_assignable, 6: is_internal
> > 2009/02/11 09:32:30:912, resultset: 0: 17ea736c-a0c0-4857-aa51-
> c96cccecafc7, 1: 0, 2: base, 3: 7a81d717-dced-4e56-ad13-4343f3f67321,
> 4: 1234361874926, 5: false, 6: false
> > 2009/02/11 09:32:30:927, resultset: 0: b6402c98-104c-4425-a3eb-
> ed25c489301a, 1: 0, 2: fubGroup, 3: 7a81d717-dced-4e56-ad13-
> 4343f3f67321, 4: 1234362665051, 5: true, 6: false
> > 2009/02/11 09:32:30:927, resultset: 0: d1c845d6-7e25-45f5-ab5b-
> 152ab6c8ac08, 1: 0, 2: naming, 3: 7a81d717-dced-4e56-ad13-4343f3f67321,
> 4: 1234361875129, 5: false, 6: true
> > 2009/02/11 09:32:30:943, 16ms, statement: ByHqlStatic.java.listSet()
> line 293, Hib3GroupTypeDAO.java.findAll() line 132,
> GroupTypeFinder.java._findAll() line 227,
> GroupTypeFinder.java.internal_updateKnownTypes() line 191,
> GroupTypeFinder.java.find() line 74,
> GroupTypeTupleIncludeExcludeHook.java.groupTypeTupleHelper() line 196,
> GroupTypeTupleIncludeExcludeHook.java.groupTypeTuplePostInsert() line
> 143, GrouperUtil.java.invokeMethod() line 3023,
> GrouperHooksUtils.java.executeHook() line 460,
> GrouperHooksUtils.java.callHooksIfRegistered() line 263,
> GrouperHooksUtils.java.callHooksIfRegistered() line 202,
> GrouperHooksUtils.java.callHooksIfRegistered() line 128,
> GroupTypeTuple.java.onPostSave() line 178, Hib3GroupDAO.java.callback()
> line 107, Hib3GroupDAO.java.addType() line 103, Group.java.addType()
> line 711, Group.java.addType() line 659,
> GroupHookAddType.java.groupPostInsert() line 28,
> GrouperUtil.java.invokeMethod() line 3023,
> GrouperHooksUtils.java.executeHook() line 460,
> GrouperHooksUtils.java.callHooksIfRegistered() line 263,
> GrouperHooksUtils.java.callHooksIfRegistered() line 202,
> GrouperHooksUtils.java.callHooksIfRegistered() line 128,
> Group.java.onPostSave() line 3434, Hib3StemDAO.java.callback() line 74,
> Hib3StemDAO.java.createChildGroup() line 68, Stem.java.callback() line
> 1374, Stem.java.internal_addChildGroup() line 1316,
> Stem.java.addChildGroup() line 277,
> GroupHooksAddTypeTest.java.testGroupHooksAddType() line 105,
> GroupHooksAddTypeTest.java.main() line 32
> >    select grouptype0_.id as id4_,
> grouptype0_.hibernate_version_number as hibernate2_4_, grouptype0_.name
> as name4_, grouptype0_.creator_uuid as creator4_4_,
> grouptype0_.create_time as create5_4_, grouptype0_.is_assignable as
> is6_4_, grouptype0_.is_internal as is7_4_ from grouper_types
> grouptype0_ order by grouptype0_.name asc
> > 2009/02/11 09:32:31:005, resultset: ALIASES: 0: id, 1:
> hibernate_version_number, 2: name, 3: creator_uuid, 4: create_time, 5:
> is_assignable, 6: is_internal
> > 2009/02/11 09:32:31:005, resultset: 0: 17ea736c-a0c0-4857-aa51-
> c96cccecafc7, 1: 0, 2: base, 3: 7a81d717-dced-4e56-ad13-4343f3f67321,
> 4: 1234361874926, 5: false, 6: false
> > 2009/02/11 09:32:31:005, resultset: 0: b6402c98-104c-4425-a3eb-
> ed25c489301a, 1: 0, 2: fubGroup, 3: 7a81d717-dced-4e56-ad13-
> 4343f3f67321, 4: 1234362665051, 5: true, 6: false
> > 2009/02/11 09:32:31:005, resultset: 0: d1c845d6-7e25-45f5-ab5b-
> 152ab6c8ac08, 1: 0, 2: naming, 3: 7a81d717-dced-4e56-ad13-4343f3f67321,
> 4: 1234361875129, 5: false, 6: true
> > 2009/02/11 09:32:31:021, 0ms, statement:
> ByHqlStatic.java.uniqueResult() line 209,
> Hib3GroupDAO.java.findByUuid() line 826, GroupFinder.java.findByUuid()
> line 292, Hib3GroupDAO.java.callback() line 116,
> Hib3GroupDAO.java.addType() line 103, Group.java.addType() line 711,
> Group.java.addType() line 659, GroupHookAddType.java.groupPostInsert()
> line 28, GrouperUtil.java.invokeMethod() line 3023,
> GrouperHooksUtils.java.executeHook() line 460,
> GrouperHooksUtils.java.callHooksIfRegistered() line 263,
> GrouperHooksUtils.java.callHooksIfRegistered() line 202,
> GrouperHooksUtils.java.callHooksIfRegistered() line 128,
> Group.java.onPostSave() line 3434, Hib3StemDAO.java.callback() line 74,
> Hib3StemDAO.java.createChildGroup() line 68, Stem.java.callback() line
> 1374, Stem.java.internal_addChildGroup() line 1316,
> Stem.java.addChildGroup() line 277,
> GroupHooksAddTypeTest.java.testGroupHooksAddType() line 105,
> GroupHooksAddTypeTest.java.main() line 32
> >    select group0_.id as id3_, group0_.hibernate_version_number as
> hibernate2_3_, group0_.parent_stem as parent3_3_, group0_.creator_id as
> creator4_3_, group0_.create_time as create5_3_, group0_.modifier_id as
> modifier6_3_, group0_.modify_time as modify7_3_ from grouper_groups
> group0_ where group0_.id='f872f926-1a24-45c0-955d-66373ad4c5da'
> > 2009/02/11 09:32:31:068, resultset: ALIASES: 0: id, 1:
> hibernate_version_number, 2: parent_stem, 3: creator_id, 4:
> create_time, 5: modifier_id, 6: modify_time
> > 2009/02/11 09:32:31:068, resultset: 0: f872f926-1a24-45c0-955d-
> 66373ad4c5da, 1: 0, 2: 24e6742a-06d2-4fbe-8dba-13b97d166b34, 3:
> 7a81d717-dced-4e56-ad13-4343f3f67321, 4: 1234362665113, 5: null, 6: 0
> > 2009/02/11 09:32:31:162, 0ms, statement: ByHqlStatic.java.list() line
> 253, Hib3GroupDAO.java.findAllAttributesByGroup() line 258,
> Group.java.getAttributesDb() line 3339, Group.java.getName() line 2095,
> Group.java.hashCode() line 3407, AccessPrivilege.java.hashCode() line
> 96, GrouperSystemAccessResolver.java.getPrivileges() line 92,
> CachingAccessResolver.java.getPrivileges() line 107,
> CachingAccessResolver.java.hasPrivilege() line 176,
> WheelAccessResolver.java.hasPrivilege() line 203,
> ValidatingAccessResolver.java.hasPrivilege() line 117,
> PrivilegeHelper.java.canView() line 171, GroupFinder.java.findByUuid()
> line 293, Hib3GroupDAO.java.callback() line 116,
> Hib3GroupDAO.java.addType() line 103, Group.java.addType() line 711,
> Group.java.addType() line 659, GroupHookAddType.java.groupPostInsert()
> line 28, GrouperUtil.java.invokeMethod() line 3023,
> GrouperHooksUtils.java.executeHook() line 460,
> GrouperHooksUtils.java.callHooksIfRegistered() line 263,
> GrouperHooksUtils.java.callHooksIfRegistered() line 202,
> GrouperHooksUtils.java.callHooksIfRegistered() line 128,
> Group.java.onPostSave() line 3434, Hib3StemDAO.java.callback() line 74,
> Hib3StemDAO.java.createChildGroup() line 68, Stem.java.callback() line
> 1374, Stem.java.internal_addChildGroup() line 1316,
> Stem.java.addChildGroup() line 277,
> GroupHooksAddTypeTest.java.testGroupHooksAddType() line 105,
> GroupHooksAddTypeTest.java.main() line 32
> >    select attribute0_.id as id0_,
> attribute0_.hibernate_version_number as hibernate2_0_,
> attribute0_.group_id as group3_0_, attribute0_.field_id as field4_0_,
> attribute0_.value as value0_ from grouper_attributes attribute0_ where
> attribute0_.group_id='f872f926-1a24-45c0-955d-66373ad4c5da'
> > 2009/02/11 09:32:31:224, resultset: ALIASES: 0: id, 1:
> hibernate_version_number, 2: group_id, 3: field_id, 4: value
> > 2009/02/11 09:32:31:224, resultset: 0:
> 02db5bdb1f65bf5b011f65bf88c80049, 1: 0, 2: f872f926-1a24-45c0-955d-
> 66373ad4c5da, 3: 3cd11b25-69f6-49e2-8034-0d5843459125, 4: myGroup
> > 2009/02/11 09:32:31:224, resultset: 0:
> 02db5bdb1f65bf5b011f65bf88f7004c, 1: 0, 2: f872f926-1a24-45c0-955d-
> 66373ad4c5da, 3: 78d25d0e-16d2-4d6b-b2bb-41faad7a79f5, 4:
> education:myGroup
> > 2009/02/11 09:32:31:224, resultset: 0:
> 02db5bdb1f65bf5b011f65bf88e7004b, 1: 0, 2: f872f926-1a24-45c0-955d-
> 66373ad4c5da, 3: d5909da2-9b84-497c-8aa7-de85ab5ddbc4, 4: edu:myGroup
> > 2009/02/11 09:32:31:224, resultset: 0:
> 02db5bdb1f65bf5b011f65bf88e7004a, 1: 0, 2: f872f926-1a24-45c0-955d-
> 66373ad4c5da, 3: e569a92d-aa51-4798-9f40-fa7e2b519301, 4: myGroup
> > 2009/02/11 09:32:31:240, 0ms, statement: ByHql.java.list() line 253,
> Hib3GroupDAO.java._updateAttributes() line 1034,
> Group.java.onPostUpdate() line 3444, Hib3GroupDAO.java.callback() line
> 122, Hib3GroupDAO.java.addType() line 103, Group.java.addType() line
> 711, Group.java.addType() line 659,
> GroupHookAddType.java.groupPostInsert() line 28,
> GrouperUtil.java.invokeMethod() line 3023,
> GrouperHooksUtils.java.executeHook() line 460,
> GrouperHooksUtils.java.callHooksIfRegistered() line 263,
> GrouperHooksUtils.java.callHooksIfRegistered() line 202,
> GrouperHooksUtils.java.callHooksIfRegistered() line 128,
> Group.java.onPostSave() line 3434, Hib3StemDAO.java.callback() line 74,
> Hib3StemDAO.java.createChildGroup() line 68, Stem.java.callback() line
> 1374, Stem.java.internal_addChildGroup() line 1316,
> Stem.java.addChildGroup() line 277,
> GroupHooksAddTypeTest.java.testGroupHooksAddType() line 105,
> GroupHooksAddTypeTest.java.main() line 32
> >    select attribute0_.id as id0_,
> attribute0_.hibernate_version_number as hibernate2_0_,
> attribute0_.group_id as group3_0_, attribute0_.field_id as field4_0_,
> attribute0_.value as value0_ from grouper_attributes attribute0_ where
> attribute0_.group_id='f872f926-1a24-45c0-955d-66373ad4c5da'
> > 2009/02/11 09:32:31:287, resultset: ALIASES: 0: id, 1:
> hibernate_version_number, 2: group_id, 3: field_id, 4: value
> > 2009/02/11 09:32:31:287, resultset: 0:
> 02db5bdb1f65bf5b011f65bf88c80049, 1: 0, 2: f872f926-1a24-45c0-955d-
> 66373ad4c5da, 3: 3cd11b25-69f6-49e2-8034-0d5843459125, 4: myGroup
> > 2009/02/11 09:32:31:287, resultset: 0:
> 02db5bdb1f65bf5b011f65bf88f7004c, 1: 0, 2: f872f926-1a24-45c0-955d-
> 66373ad4c5da, 3: 78d25d0e-16d2-4d6b-b2bb-41faad7a79f5, 4:
> education:myGroup
> > 2009/02/11 09:32:31:302, resultset: 0:
> 02db5bdb1f65bf5b011f65bf88e7004b, 1: 0, 2: f872f926-1a24-45c0-955d-
> 66373ad4c5da, 3: d5909da2-9b84-497c-8aa7-de85ab5ddbc4, 4: edu:myGroup
> > 2009/02/11 09:32:31:302, resultset: 0:
> 02db5bdb1f65bf5b011f65bf88e7004a, 1: 0, 2: f872f926-1a24-45c0-955d-
> 66373ad4c5da, 3: e569a92d-aa51-4798-9f40-fa7e2b519301, 4: myGroup
> > 2009/02/11 09:32:31:318, 0ms, statement:
> HibernateSession.java.callbackHibernateSession() line 387,
> Hib3GroupDAO.java.addType() line 103, Group.java.addType() line 711,
> Group.java.addType() line 659, GroupHookAddType.java.groupPostInsert()
> line 28, GrouperUtil.java.invokeMethod() line 3023,
> GrouperHooksUtils.java.executeHook() line 460,
> GrouperHooksUtils.java.callHooksIfRegistered() line 263,
> GrouperHooksUtils.java.callHooksIfRegistered() line 202,
> GrouperHooksUtils.java.callHooksIfRegistered() line 128,
> Group.java.onPostSave() line 3434, Hib3StemDAO.java.callback() line 74,
> Hib3StemDAO.java.createChildGroup() line 68, Stem.java.callback() line
> 1374, Stem.java.internal_addChildGroup() line 1316,
> Stem.java.addChildGroup() line 277,
> GroupHooksAddTypeTest.java.testGroupHooksAddType() line 105,
> GroupHooksAddTypeTest.java.main() line 32
> >    update grouper_groups set hibernate_version_number=2,
> creator_id='7a81d717-dced-4e56-ad13-4343f3f67321',
> create_time=1234362665113, modifier_id=null, modify_time=0 where
> id='f872f926-1a24-45c0-955d-66373ad4c5da'
> >
> >
> #######################################################################
> ############
> > group.setAttribute("gid", "2");
> > group.store(); produces this:
> >
> #######################################################################
> ############
> >
> >    select field0_.id as id2_, field0_.hibernate_version_number as
> hibernate2_2_, field0_.grouptype_uuid as grouptype3_2_,
> field0_.is_nullable as is4_2_, field0_.name as name2_,
> field0_.read_privilege as read6_2_, field0_.type as type2_,
> field0_.write_privilege as write8_2_ from grouper_fields field0_ order
> by field0_.name asc
> > 2009/02/11 09:35:07:055, resultset: ALIASES: 0: id, 1:
> hibernate_version_number, 2: grouptype_uuid, 3: is_nullable, 4: name,
> 5: read_privilege, 6: type, 7: write_privilege
> > 2009/02/11 09:35:07:055, resultset: 0: a3bbcf0e-7535-460c-a6b8-
> 3136bc24f994, 1: 0, 2: 17ea736c-a0c0-4857-aa51-c96cccecafc7, 3: true,
> 4: admins, 5: admin, 6: access, 7: admin
> > 2009/02/11 09:35:07:071, resultset: 0: 8bfff1b3-b04f-49dd-b47e-
> cfa1f1a7ad98, 1: 0, 2: d1c845d6-7e25-45f5-ab5b-152ab6c8ac08, 3: true,
> 4: creators, 5: stem, 6: naming, 7: stem
> > 2009/02/11 09:35:07:071, resultset: 0: bac86589-835f-46c0-bd00-
> 9bf8d2fbdfb3, 1: 0, 2: 17ea736c-a0c0-4857-aa51-c96cccecafc7, 3: true,
> 4: description, 5: read, 6: attribute, 7: admin
> > 2009/02/11 09:35:07:071, resultset: 0: e569a92d-aa51-4798-9f40-
> fa7e2b519301, 1: 0, 2: 17ea736c-a0c0-4857-aa51-c96cccecafc7, 3: false,
> 4: displayExtension, 5: view, 6: attribute, 7: admin
> > 2009/02/11 09:35:07:071, resultset: 0: 78d25d0e-16d2-4d6b-b2bb-
> 41faad7a79f5, 1: 0, 2: 17ea736c-a0c0-4857-aa51-c96cccecafc7, 3: false,
> 4: displayName, 5: view, 6: attribute, 7: system
> > 2009/02/11 09:35:07:071, resultset: 0: 3cd11b25-69f6-49e2-8034-
> 0d5843459125, 1: 0, 2: 17ea736c-a0c0-4857-aa51-c96cccecafc7, 3: false,
> 4: extension, 5: view, 6: attribute, 7: admin
> > 2009/02/11 09:35:07:071, resultset: 0: 5c007370-d142-43e6-90b2-
> 91287e001c3c, 1: 0, 2: b6402c98-104c-4425-a3eb-ed25c489301a, 3: true,
> 4: gid, 5: read, 6: attribute, 7: admin
> > 2009/02/11 09:35:07:086, resultset: 0: 08d7b368-028c-4f7b-a989-
> 70ef82f941fe, 1: 0, 2: 17ea736c-a0c0-4857-aa51-c96cccecafc7, 3: true,
> 4: members, 5: read, 6: list, 7: update
> > 2009/02/11 09:35:07:086, resultset: 0: d5909da2-9b84-497c-8aa7-
> de85ab5ddbc4, 1: 0, 2: 17ea736c-a0c0-4857-aa51-c96cccecafc7, 3: false,
> 4: name, 5: view, 6: attribute, 7: system
> > 2009/02/11 09:35:07:086, resultset: 0: 23b40ac0-f896-4aae-8aaf-
> 8c5c5c059f45, 1: 0, 2: 17ea736c-a0c0-4857-aa51-c96cccecafc7, 3: true,
> 4: optins, 5: update, 6: access, 7: update
> > 2009/02/11 09:35:07:086, resultset: 0: 9709b8a3-c529-497b-82a7-
> a2160c9f7d97, 1: 0, 2: 17ea736c-a0c0-4857-aa51-c96cccecafc7, 3: true,
> 4: optouts, 5: update, 6: access, 7: update
> > 2009/02/11 09:35:07:086, resultset: 0: f53747f9-1367-4a99-8f1d-
> c2a3b4b36f5a, 1: 0, 2: 17ea736c-a0c0-4857-aa51-c96cccecafc7, 3: true,
> 4: readers, 5: admin, 6: access, 7: admin
> > 2009/02/11 09:35:07:086, resultset: 0: 969b1e8e-ff21-4160-9b7b-
> 596f8a6f7063, 1: 0, 2: d1c845d6-7e25-45f5-ab5b-152ab6c8ac08, 3: true,
> 4: stemmers, 5: stem, 6: naming, 7: stem
> > 2009/02/11 09:35:07:102, resultset: 0: ad60d39a-0491-4dde-adf6-
> f41cecfe4fca, 1: 0, 2: 17ea736c-a0c0-4857-aa51-c96cccecafc7, 3: true,
> 4: updaters, 5: admin, 6: access, 7: admin
> > 2009/02/11 09:35:07:102, resultset: 0: b118fbd5-e2d8-462f-a0bd-
> 5949805af3cb, 1: 0, 2: 17ea736c-a0c0-4857-aa51-c96cccecafc7, 3: true,
> 4: viewers, 5: admin, 6: access, 7: admin
> > 2009/02/11 09:35:08:071, 0ms, statement: ByHql.java.list() line 253,
> Hib3GroupDAO.java._updateAttributes() line 1034,
> Group.java.onPostUpdate() line 3444, Hib3GroupDAO.java.update() line
> 972, Group.java.store() line 2852,
> GroupHookAddType.java.groupPostInsert() line 30,
> GrouperUtil.java.invokeMethod() line 3023,
> GrouperHooksUtils.java.executeHook() line 460,
> GrouperHooksUtils.java.callHooksIfRegistered() line 263,
> GrouperHooksUtils.java.callHooksIfRegistered() line 202,
> GrouperHooksUtils.java.callHooksIfRegistered() line 128,
> Group.java.onPostSave() line 3434, Hib3StemDAO.java.callback() line 74,
> Hib3StemDAO.java.createChildGroup() line 68, Stem.java.callback() line
> 1374, Stem.java.internal_addChildGroup() line 1316,
> Stem.java.addChildGroup() line 277,
> GroupHooksAddTypeTest.java.testGroupHooksAddType() line 105,
> GroupHooksAddTypeTest.java.main() line 32
> >    select attribute0_.id as id0_,
> attribute0_.hibernate_version_number as hibernate2_0_,
> attribute0_.group_id as group3_0_, attribute0_.field_id as field4_0_,
> attribute0_.value as value0_ from grouper_attributes attribute0_ where
> attribute0_.group_id='f872f926-1a24-45c0-955d-66373ad4c5da'
> > 2009/02/11 09:35:08:118, resultset: ALIASES: 0: id, 1:
> hibernate_version_number, 2: group_id, 3: field_id, 4: value
> > 2009/02/11 09:35:08:118, resultset: 0:
> 02db5bdb1f65bf5b011f65bf88c80049, 1: 0, 2: f872f926-1a24-45c0-955d-
> 66373ad4c5da, 3: 3cd11b25-69f6-49e2-8034-0d5843459125, 4: myGroup
> > 2009/02/11 09:35:08:118, resultset: 0:
> 02db5bdb1f65bf5b011f65bf88f7004c, 1: 0, 2: f872f926-1a24-45c0-955d-
> 66373ad4c5da, 3: 78d25d0e-16d2-4d6b-b2bb-41faad7a79f5, 4:
> education:myGroup
> > 2009/02/11 09:35:08:118, resultset: 0:
> 02db5bdb1f65bf5b011f65bf88e7004b, 1: 0, 2: f872f926-1a24-45c0-955d-
> 66373ad4c5da, 3: d5909da2-9b84-497c-8aa7-de85ab5ddbc4, 4: edu:myGroup
> > 2009/02/11 09:35:08:118, resultset: 0:
> 02db5bdb1f65bf5b011f65bf88e7004a, 1: 0, 2: f872f926-1a24-45c0-955d-
> 66373ad4c5da, 3: e569a92d-aa51-4798-9f40-fa7e2b519301, 4: myGroup
> > 2009/02/11 09:35:08:133, 0ms, statement: ByHqlStatic.java.listSet()
> line 293, Hib3GroupTypeDAO.java.findAll() line 132,
> GroupTypeFinder.java._findAll() line 227,
> GroupTypeFinder.java.internal_updateKnownTypes() line 191,
> GroupTypeFinder.java.find() line 74,
> AttributeIncludeExcludeHook.java.manageIncludesExcludesAndGroups() line
> 87, AttributeIncludeExcludeHook.java.attributePostInsert() line 39,
> GrouperUtil.java.invokeMethod() line 3023,
> GrouperHooksUtils.java.executeHook() line 460,
> GrouperHooksUtils.java.callHooksIfRegistered() line 263,
> GrouperHooksUtils.java.callHooksIfRegistered() line 202,
> GrouperHooksUtils.java.callHooksIfRegistered() line 128,
> Attribute.java.onPostSave() line 259,
> Hib3GroupDAO.java._updateAttributes() line 1060,
> Group.java.onPostUpdate() line 3444, Hib3GroupDAO.java.update() line
> 972, Group.java.store() line 2852,
> GroupHookAddType.java.groupPostInsert() line 30,
> GrouperUtil.java.invokeMethod() line 3023,
> GrouperHooksUtils.java.executeHook() line 460,
> GrouperHooksUtils.java.callHooksIfRegistered() line 263,
> GrouperHooksUtils.java.callHooksIfRegistered() line 202,
> GrouperHooksUtils.java.callHooksIfRegistered() line 128,
> Group.java.onPostSave() line 3434, Hib3StemDAO.java.callback() line 74,
> Hib3StemDAO.java.createChildGroup() line 68, Stem.java.callback() line
> 1374, Stem.java.internal_addChildGroup() line 1316,
> Stem.java.addChildGroup() line 277,
> GroupHooksAddTypeTest.java.testGroupHooksAddType() line 105,
> GroupHooksAddTypeTest.java.main() line 32
> >    select grouptype0_.id as id4_,
> grouptype0_.hibernate_version_number as hibernate2_4_, grouptype0_.name
> as name4_, grouptype0_.creator_uuid as creator4_4_,
> grouptype0_.create_time as create5_4_, grouptype0_.is_assignable as
> is6_4_, grouptype0_.is_internal as is7_4_ from grouper_types
> grouptype0_ order by grouptype0_.name asc
> > 2009/02/11 09:35:08:212, resultset: ALIASES: 0: id, 1:
> hibernate_version_number, 2: name, 3: creator_uuid, 4: create_time, 5:
> is_assignable, 6: is_internal
> > 2009/02/11 09:35:08:212, resultset: 0: 17ea736c-a0c0-4857-aa51-
> c96cccecafc7, 1: 0, 2: base, 3: 7a81d717-dced-4e56-ad13-4343f3f67321,
> 4: 1234361874926, 5: false, 6: false
> > 2009/02/11 09:35:08:212, resultset: 0: b6402c98-104c-4425-a3eb-
> ed25c489301a, 1: 0, 2: fubGroup, 3: 7a81d717-dced-4e56-ad13-
> 4343f3f67321, 4: 1234362665051, 5: true, 6: false
> > 2009/02/11 09:35:08:212, resultset: 0: d1c845d6-7e25-45f5-ab5b-
> 152ab6c8ac08, 1: 0, 2: naming, 3: 7a81d717-dced-4e56-ad13-4343f3f67321,
> 4: 1234361875129, 5: false, 6: true
> > 2009/02/11 09:35:08:227, 0ms, statement: ByHqlStatic.java.listSet()
> line 293, Hib3GroupTypeDAO.java.findAll() line 132,
> GroupTypeFinder.java._findAll() line 227,
> GroupTypeFinder.java.internal_updateKnownTypes() line 191,
> GroupTypeFinder.java.find() line 74,
> AttributeIncludeExcludeHook.java.manageIncludesExcludesAndGroups() line
> 87, AttributeIncludeExcludeHook.java.attributePostInsert() line 39,
> GrouperUtil.java.invokeMethod() line 3023,
> GrouperHooksUtils.java.executeHook() line 460,
> GrouperHooksUtils.java.callHooksIfRegistered() line 263,
> GrouperHooksUtils.java.callHooksIfRegistered() line 202,
> GrouperHooksUtils.java.callHooksIfRegistered() line 128,
> Attribute.java.onPostSave() line 259,
> Hib3GroupDAO.java._updateAttributes() line 1060,
> Group.java.onPostUpdate() line 3444, Hib3GroupDAO.java.update() line
> 972, Group.java.store() line 2852,
> GroupHookAddType.java.groupPostInsert() line 30,
> GrouperUtil.java.invokeMethod() line 3023,
> GrouperHooksUtils.java.executeHook() line 460,
> GrouperHooksUtils.java.callHooksIfRegistered() line 263,
> GrouperHooksUtils.java.callHooksIfRegistered() line 202,
> GrouperHooksUtils.java.callHooksIfRegistered() line 128,
> Group.java.onPostSave() line 3434, Hib3StemDAO.java.callback() line 74,
> Hib3StemDAO.java.createChildGroup() line 68, Stem.java.callback() line
> 1374, Stem.java.internal_addChildGroup() line 1316,
> Stem.java.addChildGroup() line 277,
> GroupHooksAddTypeTest.java.testGroupHooksAddType() line 105,
> GroupHooksAddTypeTest.java.main() line 32
> >    insert into grouper_attributes (hibernate_version_number,
> group_id, field_id, value, id) values (0, 'f872f926-1a24-45c0-955d-
> 66373ad4c5da', '5c007370-d142-43e6-90b2-91287e001c3c', '2',
> '02db5bdb1f65bf5b011f65c33de5004e')
> > 2009/02/11 09:35:08:290, 0ms, statement: ByHqlStatic.java.listSet()
> line 293, Hib3GroupTypeDAO.java.findAll() line 132,
> GroupTypeFinder.java._findAll() line 227,
> GroupTypeFinder.java.internal_updateKnownTypes() line 191,
> GroupTypeFinder.java.find() line 74,
> AttributeIncludeExcludeHook.java.manageIncludesExcludesAndGroups() line
> 87, AttributeIncludeExcludeHook.java.attributePostInsert() line 39,
> GrouperUtil.java.invokeMethod() line 3023,
> GrouperHooksUtils.java.executeHook() line 460,
> GrouperHooksUtils.java.callHooksIfRegistered() line 263,
> GrouperHooksUtils.java.callHooksIfRegistered() line 202,
> GrouperHooksUtils.java.callHooksIfRegistered() line 128,
> Attribute.java.onPostSave() line 259,
> Hib3GroupDAO.java._updateAttributes() line 1060,
> Group.java.onPostUpdate() line 3444, Hib3GroupDAO.java.update() line
> 972, Group.java.store() line 2852,
> GroupHookAddType.java.groupPostInsert() line 30,
> GrouperUtil.java.invokeMethod() line 3023,
> GrouperHooksUtils.java.executeHook() line 460,
> GrouperHooksUtils.java.callHooksIfRegistered() line 263,
> GrouperHooksUtils.java.callHooksIfRegistered() line 202,
> GrouperHooksUtils.java.callHooksIfRegistered() line 128,
> Group.java.onPostSave() line 3434, Hib3StemDAO.java.callback() line 74,
> Hib3StemDAO.java.createChildGroup() line 68, Stem.java.callback() line
> 1374, Stem.java.internal_addChildGroup() line 1316,
> Stem.java.addChildGroup() line 277,
> GroupHooksAddTypeTest.java.testGroupHooksAddType() line 105,
> GroupHooksAddTypeTest.java.main() line 32
> >    update grouper_groups set hibernate_version_number=3,
> creator_id='7a81d717-dced-4e56-ad13-4343f3f67321',
> create_time=1234362665113, modifier_id='7a81d717-dced-4e56-ad13-
> 4343f3f67321', modify_time=1234362907133 where id='f872f926-1a24-45c0-
> 955d-66373ad4c5da'
> >
> >
> >
> #######################################################################
> ############
> > Then once it gets out of Stem.internal_addChildGroup(), there is a
> bunch of more sql, then a commit (before any rollback):
> >
> #######################################################################
> ############
> >
> >    update grouper_groups set hibernate_version_number=3,
> creator_id='7a81d717-dced-4e56-ad13-4343f3f67321',
> create_time=1234362665113, modifier_id='7a81d717-dced-4e56-ad13-
> 4343f3f67321', modify_time=1234362907133 where id='f872f926-1a24-45c0-
> 955d-66373ad4c5da'
> > 2009/02/11 09:37:07:104, 0ms, statement:
> ByHqlStatic.java.uniqueResult() line 209,
> Hib3GroupTypeTupleDAO.java.findByGroupAndType() line 72,
> Hib3StemDAO.java.callback() line 85,
> Hib3StemDAO.java.createChildGroup() line 68, Stem.java.callback() line
> 1374, Stem.java.internal_addChildGroup() line 1316,
> Stem.java.addChildGroup() line 277,
> GroupHooksAddTypeTest.java.testGroupHooksAddType() line 105,
> GroupHooksAddTypeTest.java.main() line 32
> >    select grouptypet0_.id as id5_,
> grouptypet0_.hibernate_version_number as hibernate2_5_,
> grouptypet0_.group_uuid as group3_5_, grouptypet0_.type_uuid as
> type4_5_ from grouper_groups_types grouptypet0_ where
> grouptypet0_.group_uuid='f872f926-1a24-45c0-955d-66373ad4c5da' and
> grouptypet0_.type_uuid='17ea736c-a0c0-4857-aa51-c96cccecafc7'
> > 2009/02/11 09:37:09:636, 0ms, statement: ByHqlStatic.java.listSet()
> line 293, Hib3GroupTypeDAO.java.findAll() line 132,
> GroupTypeFinder.java._findAll() line 227,
> GroupTypeFinder.java.internal_updateKnownTypes() line 191,
> GroupTypeFinder.java.find() line 74,
> GroupTypeTupleIncludeExcludeHook.java.groupTypeTupleHelper() line 173,
> GroupTypeTupleIncludeExcludeHook.java.groupTypeTuplePostInsert() line
> 143, GrouperUtil.java.invokeMethod() line 3023,
> GrouperHooksUtils.java.executeHook() line 460,
> GrouperHooksUtils.java.callHooksIfRegistered() line 263,
> GrouperHooksUtils.java.callHooksIfRegistered() line 202,
> GrouperHooksUtils.java.callHooksIfRegistered() line 128,
> GroupTypeTuple.java.onPostSave() line 178, Hib3StemDAO.java.callback()
> line 88, Hib3StemDAO.java.createChildGroup() line 68,
> Stem.java.callback() line 1374, Stem.java.internal_addChildGroup() line
> 1316, Stem.java.addChildGroup() line 277,
> GroupHooksAddTypeTest.java.testGroupHooksAddType() line 105,
> GroupHooksAddTypeTest.java.main() line 32
> >    select grouptype0_.id as id4_,
> grouptype0_.hibernate_version_number as hibernate2_4_, grouptype0_.name
> as name4_, grouptype0_.creator_uuid as creator4_4_,
> grouptype0_.create_time as create5_4_, grouptype0_.is_assignable as
> is6_4_, grouptype0_.is_internal as is7_4_ from grouper_types
> grouptype0_ order by grouptype0_.name asc
> > 2009/02/11 09:37:09:683, resultset: ALIASES: 0: id, 1:
> hibernate_version_number, 2: name, 3: creator_uuid, 4: create_time, 5:
> is_assignable, 6: is_internal
> > 2009/02/11 09:37:09:683, resultset: 0: 17ea736c-a0c0-4857-aa51-
> c96cccecafc7, 1: 0, 2: base, 3: 7a81d717-dced-4e56-ad13-4343f3f67321,
> 4: 1234361874926, 5: false, 6: false
> > 2009/02/11 09:37:09:683, resultset: 0: b6402c98-104c-4425-a3eb-
> ed25c489301a, 1: 0, 2: fubGroup, 3: 7a81d717-dced-4e56-ad13-
> 4343f3f67321, 4: 1234362665051, 5: true, 6: false
> > 2009/02/11 09:37:09:683, resultset: 0: d1c845d6-7e25-45f5-ab5b-
> 152ab6c8ac08, 1: 0, 2: naming, 3: 7a81d717-dced-4e56-ad13-4343f3f67321,
> 4: 1234361875129, 5: false, 6: true
> > 2009/02/11 09:37:09:714, 0ms, statement: ByHqlStatic.java.listSet()
> line 293, Hib3GroupTypeDAO.java.findAll() line 132,
> GroupTypeFinder.java._findAll() line 227,
> GroupTypeFinder.java.internal_updateKnownTypes() line 191,
> GroupTypeFinder.java.find() line 74,
> GroupTypeTupleIncludeExcludeHook.java.groupTypeTupleHelper() line 173,
> GroupTypeTupleIncludeExcludeHook.java.groupTypeTuplePostInsert() line
> 143, GrouperUtil.java.invokeMethod() line 3023,
> GrouperHooksUtils.java.executeHook() line 460,
> GrouperHooksUtils.java.callHooksIfRegistered() line 263,
> GrouperHooksUtils.java.callHooksIfRegistered() line 202,
> GrouperHooksUtils.java.callHooksIfRegistered() line 128,
> GroupTypeTuple.java.onPostSave() line 178, Hib3StemDAO.java.callback()
> line 88, Hib3StemDAO.java.createChildGroup() line 68,
> Stem.java.callback() line 1374, Stem.java.internal_addChildGroup() line
> 1316, Stem.java.addChildGroup() line 277,
> GroupHooksAddTypeTest.java.testGroupHooksAddType() line 105,
> GroupHooksAddTypeTest.java.main() line 32
> >    insert into grouper_groups_types (hibernate_version_number,
> group_uuid, type_uuid, id) values (0, 'f872f926-1a24-45c0-955d-
> 66373ad4c5da', '17ea736c-a0c0-4857-aa51-c96cccecafc7',
> '02db5bdb1f65bf5b011f65c51884004f')
> > 2009/02/11 09:37:09:761, 0ms, statement: ByHqlStatic.java.listSet()
> line 293, Hib3GroupTypeDAO.java.findAll() line 132,
> GroupTypeFinder.java._findAll() line 227,
> GroupTypeFinder.java.internal_updateKnownTypes() line 191,
> GroupTypeFinder.java.find() line 74,
> GroupTypeTupleIncludeExcludeHook.java.groupTypeTupleHelper() line 178,
> GroupTypeTupleIncludeExcludeHook.java.groupTypeTuplePostInsert() line
> 143, GrouperUtil.java.invokeMethod() line 3023,
> GrouperHooksUtils.java.executeHook() line 460,
> GrouperHooksUtils.java.callHooksIfRegistered() line 263,
> GrouperHooksUtils.java.callHooksIfRegistered() line 202,
> GrouperHooksUtils.java.callHooksIfRegistered() line 128,
> GroupTypeTuple.java.onPostSave() line 178, Hib3StemDAO.java.callback()
> line 88, Hib3StemDAO.java.createChildGroup() line 68,
> Stem.java.callback() line 1374, Stem.java.internal_addChildGroup() line
> 1316, Stem.java.addChildGroup() line 277,
> GroupHooksAddTypeTest.java.testGroupHooksAddType() line 105,
> GroupHooksAddTypeTest.java.main() line 32
> >    select grouptype0_.id as id4_,
> grouptype0_.hibernate_version_number as hibernate2_4_, grouptype0_.name
> as name4_, grouptype0_.creator_uuid as creator4_4_,
> grouptype0_.create_time as create5_4_, grouptype0_.is_assignable as
> is6_4_, grouptype0_.is_internal as is7_4_ from grouper_types
> grouptype0_ order by grouptype0_.name asc
> > 2009/02/11 09:37:09:808, resultset: ALIASES: 0: id, 1:
> hibernate_version_number, 2: name, 3: creator_uuid, 4: create_time, 5:
> is_assignable, 6: is_internal
> > 2009/02/11 09:37:09:808, resultset: 0: 17ea736c-a0c0-4857-aa51-
> c96cccecafc7, 1: 0, 2: base, 3: 7a81d717-dced-4e56-ad13-4343f3f67321,
> 4: 1234361874926, 5: false, 6: false
> > 2009/02/11 09:37:09:808, resultset: 0: b6402c98-104c-4425-a3eb-
> ed25c489301a, 1: 0, 2: fubGroup, 3: 7a81d717-dced-4e56-ad13-
> 4343f3f67321, 4: 1234362665051, 5: true, 6: false
> > 2009/02/11 09:37:09:808, resultset: 0: d1c845d6-7e25-45f5-ab5b-
> 152ab6c8ac08, 1: 0, 2: naming, 3: 7a81d717-dced-4e56-ad13-4343f3f67321,
> 4: 1234361875129, 5: false, 6: true
> > 2009/02/11 09:37:09:823, 0ms, statement: ByHqlStatic.java.listSet()
> line 293, Hib3GroupTypeDAO.java.findAll() line 132,
> GroupTypeFinder.java._findAll() line 227,
> GroupTypeFinder.java.internal_updateKnownTypes() line 191,
> GroupTypeFinder.java.find() line 74,
> GroupTypeTupleIncludeExcludeHook.java.groupTypeTupleHelper() line 196,
> GroupTypeTupleIncludeExcludeHook.java.groupTypeTuplePostInsert() line
> 143, GrouperUtil.java.invokeMethod() line 3023,
> GrouperHooksUtils.java.executeHook() line 460,
> GrouperHooksUtils.java.callHooksIfRegistered() line 263,
> GrouperHooksUtils.java.callHooksIfRegistered() line 202,
> GrouperHooksUtils.java.callHooksIfRegistered() line 128,
> GroupTypeTuple.java.onPostSave() line 178, Hib3StemDAO.java.callback()
> line 88, Hib3StemDAO.java.createChildGroup() line 68,
> Stem.java.callback() line 1374, Stem.java.internal_addChildGroup() line
> 1316, Stem.java.addChildGroup() line 277,
> GroupHooksAddTypeTest.java.testGroupHooksAddType() line 105,
> GroupHooksAddTypeTest.java.main() line 32
> >    select grouptype0_.id as id4_,
> grouptype0_.hibernate_version_number as hibernate2_4_, grouptype0_.name
> as name4_, grouptype0_.creator_uuid as creator4_4_,
> grouptype0_.create_time as create5_4_, grouptype0_.is_assignable as
> is6_4_, grouptype0_.is_internal as is7_4_ from grouper_types
> grouptype0_ order by grouptype0_.name asc
> > 2009/02/11 09:37:09:870, resultset: ALIASES: 0: id, 1:
> hibernate_version_number, 2: name, 3: creator_uuid, 4: create_time, 5:
> is_assignable, 6: is_internal
> > 2009/02/11 09:37:09:886, resultset: 0: 17ea736c-a0c0-4857-aa51-
> c96cccecafc7, 1: 0, 2: base, 3: 7a81d717-dced-4e56-ad13-4343f3f67321,
> 4: 1234361874926, 5: false, 6: false
> > 2009/02/11 09:37:09:886, resultset: 0: b6402c98-104c-4425-a3eb-
> ed25c489301a, 1: 0, 2: fubGroup, 3: 7a81d717-dced-4e56-ad13-
> 4343f3f67321, 4: 1234362665051, 5: true, 6: false
> > 2009/02/11 09:37:09:886, resultset: 0: d1c845d6-7e25-45f5-ab5b-
> 152ab6c8ac08, 1: 0, 2: naming, 3: 7a81d717-dced-4e56-ad13-4343f3f67321,
> 4: 1234361875129, 5: false, 6: true
> > 2009/02/11 09:37:09:901, 0ms, statement:
> ByHqlStatic.java.uniqueResult() line 209,
> Hib3GroupTypeTupleDAO.java.findByGroupAndType() line 72,
> Hib3StemDAO.java.callback() line 85,
> Hib3StemDAO.java.createChildGroup() line 68, Stem.java.callback() line
> 1374, Stem.java.internal_addChildGroup() line 1316,
> Stem.java.addChildGroup() line 277,
> GroupHooksAddTypeTest.java.testGroupHooksAddType() line 105,
> GroupHooksAddTypeTest.java.main() line 32
> >    select grouptypet0_.id as id5_,
> grouptypet0_.hibernate_version_number as hibernate2_5_,
> grouptypet0_.group_uuid as group3_5_, grouptypet0_.type_uuid as
> type4_5_ from grouper_groups_types grouptypet0_ where
> grouptypet0_.group_uuid='f872f926-1a24-45c0-955d-66373ad4c5da' and
> grouptypet0_.type_uuid='b6402c98-104c-4425-a3eb-ed25c489301a'
> > 2009/02/11 09:37:09:933, resultset: ALIASES: 0: id, 1:
> hibernate_version_number, 2: group_uuid, 3: type_uuid
> > 2009/02/11 09:37:09:933, resultset: 0:
> 02db5bdb1f65bf5b011f65c0d6e5004d, 1: 0, 2: f872f926-1a24-45c0-955d-
> 66373ad4c5da, 3: b6402c98-104c-4425-a3eb-ed25c489301a
> > 2009/02/11 09:37:09:948, 0ms, statement: HibernateMisc.java.flush()
> line 23, Hib3StemDAO.java.callback() line 93,
> Hib3StemDAO.java.createChildGroup() line 68, Stem.java.callback() line
> 1374, Stem.java.internal_addChildGroup() line 1316,
> Stem.java.addChildGroup() line 277,
> GroupHooksAddTypeTest.java.testGroupHooksAddType() line 105,
> GroupHooksAddTypeTest.java.main() line 32
> >    update grouper_stems set hibernate_version_number=2, name='edu',
> display_name='education', creator_id='7a81d717-dced-4e56-ad13-
> 4343f3f67321', create_time=1234362664926, modifier_id='7a81d717-dced-
> 4e56-ad13-4343f3f67321', modify_time=1234362665004,
> display_extension='education', extension='edu', description=null where
> id='24e6742a-06d2-4fbe-8dba-13b97d166b34'
> > 2009/02/11 09:37:09:964, 0ms, statement:
> ByHqlStatic.java.uniqueResult() line 209, Hib3MemberDAO.java.exists()
> line 82, Hib3StemDAO.java.callback() line 94,
> Hib3StemDAO.java.createChildGroup() line 68, Stem.java.callback() line
> 1374, Stem.java.internal_addChildGroup() line 1316,
> Stem.java.addChildGroup() line 277,
> GroupHooksAddTypeTest.java.testGroupHooksAddType() line 105,
> GroupHooksAddTypeTest.java.main() line 32
> >    select member0_.id as col_0_0_ from grouper_members member0_ where
> member0_.id='5ac8256a-9de5-4a27-a476-3c3588aa271a'
> > 2009/02/11 09:37:11:870, 0ms, statement:
> HibernateSession.java.callbackHibernateSession() line 387,
> Hib3StemDAO.java.createChildGroup() line 68, Stem.java.callback() line
> 1374, Stem.java.internal_addChildGroup() line 1316,
> Stem.java.addChildGroup() line 277,
> GroupHooksAddTypeTest.java.testGroupHooksAddType() line 105,
> GroupHooksAddTypeTest.java.main() line 32
> >    insert into grouper_members (hibernate_version_number, subject_id,
> subject_source, subject_type, id) values (0, 'f872f926-1a24-45c0-955d-
> 66373ad4c5da', 'g:gsa', 'group', '5ac8256a-9de5-4a27-a476-
> 3c3588aa271a')
> > 2009/02/11 09:37:23:714, 0ms, statement:
> ByHqlStatic.java.uniqueResult() line 209,
> Hib3MemberDAO.java.findBySubject() line 150,
> MemberFinder.java.internal_findOrCreateBySubject() line 202,
> MemberFinder.java.internal_findBySubject() line 175,
> MemberFinder.java.findBySubject() line 105,
> MemberFinder.java.internal_findReadableMemberBySubject() line 248,
> Membership.java.internal_addImmediateMembership() line 560,
> GrouperAccessAdapter.java.callback() line 235,
> GrouperSession.java.callbackGrouperSession() line 626,
> GrouperAccessAdapter.java.grantPriv() line 222,
> AccessWrapper.java.grantPrivilege() line 130,
> GrouperAllAccessResolver.java.grantPrivilege() line 111,
> GrouperSystemAccessResolver.java.grantPrivilege() line 119,
> CachingAccessResolver.java.grantPrivilege() line 153,
> WheelAccessResolver.java.grantPrivilege() line 179,
> ValidatingAccessResolver.java.grantPrivilege() line 103,
> Stem.java._grantDefaultPrivsUponCreate() line 1475,
> Stem.java.access$3() line 1471, Stem.java.callback() line 1378,
> Stem.java.internal_addChildGroup() line 1316, Stem.java.addChildGroup()
> line 277, GroupHooksAddTypeTest.java.testGroupHooksAddType() line 105,
> GroupHooksAddTypeTest.java.main() line 32
> >    select member0_.id as id6_, member0_.hibernate_version_number as
> hibernate2_6_, member0_.subject_id as subject3_6_,
> member0_.subject_source as subject4_6_, member0_.subject_type as
> subject5_6_ from grouper_members member0_ where
> member0_.subject_id='GrouperSystem' and member0_.subject_source='g:isa'
> and member0_.subject_type='application'
> > 2009/02/11 09:37:23:761, resultset: ALIASES: 0: id, 1:
> hibernate_version_number, 2: subject_id, 3: subject_source, 4:
> subject_type
> > 2009/02/11 09:37:23:761, resultset: 0: 7a81d717-dced-4e56-ad13-
> 4343f3f67321, 1: 0, 2: GrouperSystem, 3: g:isa, 4: application
> > 2009/02/11 09:37:23:777, 0ms, statement:
> ByHqlStatic.java.uniqueResult() line 209,
> Hib3MembershipDAO.java.exists() line 96,
> ImmediateMembershipValidator.java.validate() line 77,
> DefaultMemberOf.java.callback() line 758,
> GrouperSession.java.callbackGrouperSession() line 626,
> DefaultMemberOf.java._evaluateAddImmediateMembership() line 746,
> DefaultMemberOf.java.addImmediate() line 182,
> Membership.java.internal_addImmediateMembership() line 562,
> GrouperAccessAdapter.java.callback() line 235,
> GrouperSession.java.callbackGrouperSession() line 626,
> GrouperAccessAdapter.java.grantPriv() line 222,
> AccessWrapper.java.grantPrivilege() line 130,
> GrouperAllAccessResolver.java.grantPrivilege() line 111,
> GrouperSystemAccessResolver.java.grantPrivilege() line 119,
> CachingAccessResolver.java.grantPrivilege() line 153,
> WheelAccessResolver.java.grantPrivilege() line 179,
> ValidatingAccessResolver.java.grantPrivilege() line 103,
> Stem.java._grantDefaultPrivsUponCreate() line 1475,
> Stem.java.access$3() line 1471, Stem.java.callback() line 1378,
> Stem.java.internal_addChildGroup() line 1316, Stem.java.addChildGroup()
> line 277, GroupHooksAddTypeTest.java.testGroupHooksAddType() line 105,
> GroupHooksAddTypeTest.java.main() line 32
> >    select membership0_.id as col_0_0_ from grouper_memberships
> membership0_, grouper_fields field1_ where
> membership0_.owner_id='f872f926-1a24-45c0-955d-66373ad4c5da' and
> membership0_.member_id='7a81d717-dced-4e56-ad13-4343f3f67321' and
> membership0_.field_id=field1_.id and field1_.name='admins' and
> membership0_.mship_type='immediate'
> > 2009/02/11 09:37:23:823, 0ms, statement:
> ByHqlStatic.java.uniqueResult() line 209, Hib3GroupDAO.java.exists()
> line 235, MembershipValidator.java._doesOwnerExist() line 82,
> MembershipValidator.java.validate() line 46,
> ImmediateMembershipValidator.java.validate() line 86,
> DefaultMemberOf.java.callback() line 758,
> GrouperSession.java.callbackGrouperSession() line 626,
> DefaultMemberOf.java._evaluateAddImmediateMembership() line 746,
> DefaultMemberOf.java.addImmediate() line 182,
> Membership.java.internal_addImmediateMembership() line 562,
> GrouperAccessAdapter.java.callback() line 235,
> GrouperSession.java.callbackGrouperSession() line 626,
> GrouperAccessAdapter.java.grantPriv() line 222,
> AccessWrapper.java.grantPrivilege() line 130,
> GrouperAllAccessResolver.java.grantPrivilege() line 111,
> GrouperSystemAccessResolver.java.grantPrivilege() line 119,
> CachingAccessResolver.java.grantPrivilege() line 153,
> WheelAccessResolver.java.grantPrivilege() line 179,
> ValidatingAccessResolver.java.grantPrivilege() line 103,
> Stem.java._grantDefaultPrivsUponCreate() line 1475,
> Stem.java.access$3() line 1471, Stem.java.callback() line 1378,
> Stem.java.internal_addChildGroup() line 1316, Stem.java.addChildGroup()
> line 277, GroupHooksAddTypeTest.java.testGroupHooksAddType() line 105,
> GroupHooksAddTypeTest.java.main() line 32
> >    select group0_.id as col_0_0_ from grouper_groups group0_ where
> group0_.id='f872f926-1a24-45c0-955d-66373ad4c5da'
> > 2009/02/11 09:37:23:886, resultset: ALIASES: 0: id
> > 2009/02/11 09:37:23:886, resultset: 0: f872f926-1a24-45c0-955d-
> 66373ad4c5da
> > 2009/02/11 09:37:23:886, 0ms, statement:
> ByHqlStatic.java.uniqueResult() line 209, Hib3MemberDAO.java.exists()
> line 82, MembershipValidator.java.validate() line 49,
> ImmediateMembershipValidator.java.validate() line 86,
> DefaultMemberOf.java.callback() line 758,
> GrouperSession.java.callbackGrouperSession() line 626,
> DefaultMemberOf.java._evaluateAddImmediateMembership() line 746,
> DefaultMemberOf.java.addImmediate() line 182,
> Membership.java.internal_addImmediateMembership() line 562,
> GrouperAccessAdapter.java.callback() line 235,
> GrouperSession.java.callbackGrouperSession() line 626,
> GrouperAccessAdapter.java.grantPriv() line 222,
> AccessWrapper.java.grantPrivilege() line 130,
> GrouperAllAccessResolver.java.grantPrivilege() line 111,
> GrouperSystemAccessResolver.java.grantPrivilege() line 119,
> CachingAccessResolver.java.grantPrivilege() line 153,
> WheelAccessResolver.java.grantPrivilege() line 179,
> ValidatingAccessResolver.java.grantPrivilege() line 103,
> Stem.java._grantDefaultPrivsUponCreate() line 1475,
> Stem.java.access$3() line 1471, Stem.java.callback() line 1378,
> Stem.java.internal_addChildGroup() line 1316, Stem.java.addChildGroup()
> line 277, GroupHooksAddTypeTest.java.testGroupHooksAddType() line 105,
> GroupHooksAddTypeTest.java.main() line 32
> >    select member0_.id as col_0_0_ from grouper_members member0_ where
> member0_.id='7a81d717-dced-4e56-ad13-4343f3f67321'
> > 2009/02/11 09:37:23:933, resultset: ALIASES: 0: id
> > 2009/02/11 09:37:23:933, resultset: 0: 7a81d717-dced-4e56-ad13-
> 4343f3f67321
> > 2009/02/11 09:37:23:948, 0ms, statement: ByHql.java.list() line 253,
> Hib3GroupDAO.java._updateAttributes() line 1034,
> Group.java.onPostUpdate() line 3444, Hib3MembershipDAO.java.callback()
> line 576, Hib3MembershipDAO.java.update() line 566,
> Membership.java.callback() line 526, Hib3TransactionDAO.java.callback()
> line 46, Hib3TransactionDAO.java.transactionCallback() line 39,
> Membership.java.internal_insertPersistDefaultMemberOf() line 516,
> Membership.java.internal_addImmediateMembership() line 563,
> GrouperAccessAdapter.java.callback() line 235,
> GrouperSession.java.callbackGrouperSession() line 626,
> GrouperAccessAdapter.java.grantPriv() line 222,
> AccessWrapper.java.grantPrivilege() line 130,
> GrouperAllAccessResolver.java.grantPrivilege() line 111,
> GrouperSystemAccessResolver.java.grantPrivilege() line 119,
> CachingAccessResolver.java.grantPrivilege() line 153,
> WheelAccessResolver.java.grantPrivilege() line 179,
> ValidatingAccessResolver.java.grantPrivilege() line 103,
> Stem.java._grantDefaultPrivsUponCreate() line 1475,
> Stem.java.access$3() line 1471, Stem.java.callback() line 1378,
> Stem.java.internal_addChildGroup() line 1316, Stem.java.addChildGroup()
> line 277, GroupHooksAddTypeTest.java.testGroupHooksAddType() line 105,
> GroupHooksAddTypeTest.java.main() line 32
> >
> >    select attribute0_.id as id0_,
> attribute0_.hibernate_version_number as hibernate2_0_,
> attribute0_.group_id as group3_0_, attribute0_.field_id as field4_0_,
> attribute0_.value as value0_ from grouper_attributes attribute0_ where
> attribute0_.group_id='f872f926-1a24-45c0-955d-66373ad4c5da'
> > 2009/02/11 09:37:24:011, resultset: ALIASES: 0: id, 1:
> hibernate_version_number, 2: group_id, 3: field_id, 4: value
> > 2009/02/11 09:37:24:011, resultset: 0:
> 02db5bdb1f65bf5b011f65bf88c80049, 1: 0, 2: f872f926-1a24-45c0-955d-
> 66373ad4c5da, 3: 3cd11b25-69f6-49e2-8034-0d5843459125, 4: myGroup
> > 2009/02/11 09:37:24:011, resultset: 0:
> 02db5bdb1f65bf5b011f65c33de5004e, 1: 0, 2: f872f926-1a24-45c0-955d-
> 66373ad4c5da, 3: 5c007370-d142-43e6-90b2-91287e001c3c, 4: 2
> > 2009/02/11 09:37:24:011, resultset: 0:
> 02db5bdb1f65bf5b011f65bf88f7004c, 1: 0, 2: f872f926-1a24-45c0-955d-
> 66373ad4c5da, 3: 78d25d0e-16d2-4d6b-b2bb-41faad7a79f5, 4:
> education:myGroup
> > 2009/02/11 09:37:24:011, resultset: 0:
> 02db5bdb1f65bf5b011f65bf88e7004b, 1: 0, 2: f872f926-1a24-45c0-955d-
> 66373ad4c5da, 3: d5909da2-9b84-497c-8aa7-de85ab5ddbc4, 4: edu:myGroup
> > 2009/02/11 09:37:24:011, resultset: 0:
> 02db5bdb1f65bf5b011f65bf88e7004a, 1: 0, 2: f872f926-1a24-45c0-955d-
> 66373ad4c5da, 3: e569a92d-aa51-4798-9f40-fa7e2b519301, 4: myGroup
> > 2009/02/11 09:37:24:042, 0ms, statement:
> HibernateSession.java.callbackHibernateSession() line 387,
> Hib3MembershipDAO.java.update() line 566, Membership.java.callback()
> line 526, Hib3TransactionDAO.java.callback() line 46,
> Hib3TransactionDAO.java.transactionCallback() line 39,
> Membership.java.internal_insertPersistDefaultMemberOf() line 516,
> Membership.java.internal_addImmediateMembership() line 563,
> GrouperAccessAdapter.java.callback() line 235,
> GrouperSession.java.callbackGrouperSession() line 626,
> GrouperAccessAdapter.java.grantPriv() line 222,
> AccessWrapper.java.grantPrivilege() line 130,
> GrouperAllAccessResolver.java.grantPrivilege() line 111,
> GrouperSystemAccessResolver.java.grantPrivilege() line 119,
> CachingAccessResolver.java.grantPrivilege() line 153,
> WheelAccessResolver.java.grantPrivilege() line 179,
> ValidatingAccessResolver.java.grantPrivilege() line 103,
> Stem.java._grantDefaultPrivsUponCreate() line 1475,
> Stem.java.access$3() line 1471, Stem.java.callback() line 1378,
> Stem.java.internal_addChildGroup() line 1316, Stem.java.addChildGroup()
> line 277, GroupHooksAddTypeTest.java.testGroupHooksAddType() line 105,
> GroupHooksAddTypeTest.java.main() line 32
> >    insert into grouper_memberships (hibernate_version_number,
> owner_id, member_id, field_id, mship_type, via_id, depth,
> parent_membership, creator_id, create_time, id) values (0, 'f872f926-
> 1a24-45c0-955d-66373ad4c5da', '7a81d717-dced-4e56-ad13-4343f3f67321',
> 'a3bbcf0e-7535-460c-a6b8-3136bc24f994', 'immediate', null, 0, null,
> '7a81d717-dced-4e56-ad13-4343f3f67321', 1234363043777, '13414333-ee5a-
> 446e-90d0-db300835abc3')
> > 2009/02/11 09:37:24:089, 0ms, statement:
> HibernateSession.java.callbackHibernateSession() line 387,
> Hib3MembershipDAO.java.update() line 566, Membership.java.callback()
> line 526, Hib3TransactionDAO.java.callback() line 46,
> Hib3TransactionDAO.java.transactionCallback() line 39,
> Membership.java.internal_insertPersistDefaultMemberOf() line 516,
> Membership.java.internal_addImmediateMembership() line 563,
> GrouperAccessAdapter.java.callback() line 235,
> GrouperSession.java.callbackGrouperSession() line 626,
> GrouperAccessAdapter.java.grantPriv() line 222,
> AccessWrapper.java.grantPrivilege() line 130,
> GrouperAllAccessResolver.java.grantPrivilege() line 111,
> GrouperSystemAccessResolver.java.grantPrivilege() line 119,
> CachingAccessResolver.java.grantPrivilege() line 153,
> WheelAccessResolver.java.grantPrivilege() line 179,
> ValidatingAccessResolver.java.grantPrivilege() line 103,
> Stem.java._grantDefaultPrivsUponCreate() line 1475,
> Stem.java.access$3() line 1471, Stem.java.callback() line 1378,
> Stem.java.internal_addChildGroup() line 1316, Stem.java.addChildGroup()
> line 277, GroupHooksAddTypeTest.java.testGroupHooksAddType() line 105,
> GroupHooksAddTypeTest.java.main() line 32
> >    update grouper_groups set hibernate_version_number=5,
> creator_id='7a81d717-dced-4e56-ad13-4343f3f67321',
> create_time=1234362665113, modifier_id='7a81d717-dced-4e56-ad13-
> 4343f3f67321', modify_time=1234363043948 where id='f872f926-1a24-45c0-
> 955d-66373ad4c5da'
> > 2009/02/11 09:37:24:136, 0ms, statement:
> ByHqlStatic.java.uniqueResult() line 209,
> Hib3MemberDAO.java.findBySubject() line 150,
> MemberFinder.java.internal_findOrCreateBySubject() line 202,
> MemberFinder.java.internal_findBySubject() line 175,
> MemberFinder.java.findBySubject() line 105,
> MemberFinder.java.internal_findReadableMemberBySubject() line 248,
> Membership.java.internal_addImmediateMembership() line 560,
> GrouperAccessAdapter.java.callback() line 235,
> GrouperSession.java.callbackGrouperSession() line 626,
> GrouperAccessAdapter.java.grantPriv() line 222,
> AccessWrapper.java.grantPrivilege() line 130,
> GrouperAllAccessResolver.java.grantPrivilege() line 111,
> GrouperSystemAccessResolver.java.grantPrivilege() line 119,
> CachingAccessResolver.java.grantPrivilege() line 153,
> WheelAccessResolver.java.grantPrivilege() line 179,
> ValidatingAccessResolver.java.grantPrivilege() line 103,
> Stem.java._grantOptionalPrivUponCreate() line 1567,
> Stem.java._grantDefaultPrivsUponCreate() line 1483,
> Stem.java.access$3() line 1471, Stem.java.callback() line 1378,
> Stem.java.internal_addChildGroup() line 1316, Stem.java.addChildGroup()
> line 277, GroupHooksAddTypeTest.java.testGroupHooksAddType() line 105,
> GroupHooksAddTypeTest.java.main() line 32
> >    select member0_.id as id6_, member0_.hibernate_version_number as
> hibernate2_6_, member0_.subject_id as subject3_6_,
> member0_.subject_source as subject4_6_, member0_.subject_type as
> subject5_6_ from grouper_members member0_ where
> member0_.subject_id='GrouperAll' and member0_.subject_source='g:isa'
> and member0_.subject_type='application'
> > 2009/02/11 09:37:24:199, 0ms, statement: ByObjectStatic.java.save()
> line 387, Hib3MemberDAO.java.create() line 64,
> MemberFinder.java.internal_findOrCreateBySubject() line 212,
> MemberFinder.java.internal_findBySubject() line 175,
> MemberFinder.java.findBySubject() line 105,
> MemberFinder.java.internal_findReadableMemberBySubject() line 248,
> Membership.java.internal_addImmediateMembership() line 560,
> GrouperAccessAdapter.java.callback() line 235,
> GrouperSession.java.callbackGrouperSession() line 626,
> GrouperAccessAdapter.java.grantPriv() line 222,
> AccessWrapper.java.grantPrivilege() line 130,
> GrouperAllAccessResolver.java.grantPrivilege() line 111,
> GrouperSystemAccessResolver.java.grantPrivilege() line 119,
> CachingAccessResolver.java.grantPrivilege() line 153,
> WheelAccessResolver.java.grantPrivilege() line 179,
> ValidatingAccessResolver.java.grantPrivilege() line 103,
> Stem.java._grantOptionalPrivUponCreate() line 1567,
> Stem.java._grantDefaultPrivsUponCreate() line 1483,
> Stem.java.access$3() line 1471, Stem.java.callback() line 1378,
> Stem.java.internal_addChildGroup() line 1316, Stem.java.addChildGroup()
> line 277, GroupHooksAddTypeTest.java.testGroupHooksAddType() line 105,
> GroupHooksAddTypeTest.java.main() line 32
> >    insert into grouper_members (hibernate_version_number, subject_id,
> subject_source, subject_type, id) values (0, 'GrouperAll', 'g:isa',
> 'application', '844f0eae-288c-4445-afd4-c88210df2d28')
> > 2009/02/11 09:37:24:261, 16ms, statement:
> ByHqlStatic.java.uniqueResult() line 209,
> Hib3MembershipDAO.java.exists() line 96,
> ImmediateMembershipValidator.java.validate() line 77,
> DefaultMemberOf.java.callback() line 758,
> GrouperSession.java.callbackGrouperSession() line 626,
> DefaultMemberOf.java._evaluateAddImmediateMembership() line 746,
> DefaultMemberOf.java.addImmediate() line 182,
> Membership.java.internal_addImmediateMembership() line 562,
> GrouperAccessAdapter.java.callback() line 235,
> GrouperSession.java.callbackGrouperSession() line 626,
> GrouperAccessAdapter.java.grantPriv() line 222,
> AccessWrapper.java.grantPrivilege() line 130,
> GrouperAllAccessResolver.java.grantPrivilege() line 111,
> GrouperSystemAccessResolver.java.grantPrivilege() line 119,
> CachingAccessResolver.java.grantPrivilege() line 153,
> WheelAccessResolver.java.grantPrivilege() line 179,
> ValidatingAccessResolver.java.grantPrivilege() line 103,
> Stem.java._grantOptionalPrivUponCreate() line 1567,
> Stem.java._grantDefaultPrivsUponCreate() line 1483,
> Stem.java.access$3() line 1471, Stem.java.callback() line 1378,
> Stem.java.internal_addChildGroup() line 1316, Stem.java.addChildGroup()
> line 277, GroupHooksAddTypeTest.java.testGroupHooksAddType() line 105,
> GroupHooksAddTypeTest.java.main() line 32
> >    select membership0_.id as col_0_0_ from grouper_memberships
> membership0_, grouper_fields field1_ where
> membership0_.owner_id='f872f926-1a24-45c0-955d-66373ad4c5da' and
> membership0_.member_id='844f0eae-288c-4445-afd4-c88210df2d28' and
> membership0_.field_id=field1_.id and field1_.name='readers' and
> membership0_.mship_type='immediate'
> > 2009/02/11 09:37:24:324, 0ms, statement: ByHql.java.list() line 253,
> Hib3GroupDAO.java._updateAttributes() line 1034,
> Group.java.onPostUpdate() line 3444, Hib3MembershipDAO.java.callback()
> line 576, Hib3MembershipDAO.java.update() line 566,
> Membership.java.callback() line 526, Hib3TransactionDAO.java.callback()
> line 46, Hib3TransactionDAO.java.transactionCallback() line 39,
> Membership.java.internal_insertPersistDefaultMemberOf() line 516,
> Membership.java.internal_addImmediateMembership() line 563,
> GrouperAccessAdapter.java.callback() line 235,
> GrouperSession.java.callbackGrouperSession() line 626,
> GrouperAccessAdapter.java.grantPriv() line 222,
> AccessWrapper.java.grantPrivilege() line 130,
> GrouperAllAccessResolver.java.grantPrivilege() line 111,
> GrouperSystemAccessResolver.java.grantPrivilege() line 119,
> CachingAccessResolver.java.grantPrivilege() line 153,
> WheelAccessResolver.java.grantPrivilege() line 179,
> ValidatingAccessResolver.java.grantPrivilege() line 103,
> Stem.java._grantOptionalPrivUponCreate() line 1567,
> Stem.java._grantDefaultPrivsUponCreate() line 1483,
> Stem.java.access$3() line 1471, Stem.java.callback() line 1378,
> Stem.java.internal_addChildGroup() line 1316, Stem.java.addChildGroup()
> line 277, GroupHooksAddTypeTest.java.testGroupHooksAddType() line 105,
> GroupHooksAddTypeTest.java.main() line 32
> >    select attribute0_.id as id0_,
> attribute0_.hibernate_version_number as hibernate2_0_,
> attribute0_.group_id as group3_0_, attribute0_.field_id as field4_0_,
> attribute0_.value as value0_ from grouper_attributes attribute0_ where
> attribute0_.group_id='f872f926-1a24-45c0-955d-66373ad4c5da'
> > 2009/02/11 09:37:24:386, resultset: ALIASES: 0: id, 1:
> hibernate_version_number, 2: group_id, 3: field_id, 4: value
> > 2009/02/11 09:37:24:386, resultset: 0:
> 02db5bdb1f65bf5b011f65bf88c80049, 1: 0, 2: f872f926-1a24-45c0-955d-
> 66373ad4c5da, 3: 3cd11b25-69f6-49e2-8034-0d5843459125, 4: myGroup
> > 2009/02/11 09:37:24:386, resultset: 0:
> 02db5bdb1f65bf5b011f65c33de5004e, 1: 0, 2: f872f926-1a24-45c0-955d-
> 66373ad4c5da, 3: 5c007370-d142-43e6-90b2-91287e001c3c, 4: 2
> > 2009/02/11 09:37:24:386, resultset: 0:
> 02db5bdb1f65bf5b011f65bf88f7004c, 1: 0, 2: f872f926-1a24-45c0-955d-
> 66373ad4c5da, 3: 78d25d0e-16d2-4d6b-b2bb-41faad7a79f5, 4:
> education:myGroup
> > 2009/02/11 09:37:24:386, resultset: 0:
> 02db5bdb1f65bf5b011f65bf88e7004b, 1: 0, 2: f872f926-1a24-45c0-955d-
> 66373ad4c5da, 3: d5909da2-9b84-497c-8aa7-de85ab5ddbc4, 4: edu:myGroup
> > 2009/02/11 09:37:24:386, resultset: 0:
> 02db5bdb1f65bf5b011f65bf88e7004a, 1: 0, 2: f872f926-1a24-45c0-955d-
> 66373ad4c5da, 3: e569a92d-aa51-4798-9f40-fa7e2b519301, 4: myGroup
> > 2009/02/11 09:37:24:402, 0ms, statement:
> HibernateSession.java.callbackHibernateSession() line 387,
> Hib3MembershipDAO.java.update() line 566, Membership.java.callback()
> line 526, Hib3TransactionDAO.java.callback() line 46,
> Hib3TransactionDAO.java.transactionCallback() line 39,
> Membership.java.internal_insertPersistDefaultMemberOf() line 516,
> Membership.java.internal_addImmediateMembership() line 563,
> GrouperAccessAdapter.java.callback() line 235,
> GrouperSession.java.callbackGrouperSession() line 626,
> GrouperAccessAdapter.java.grantPriv() line 222,
> AccessWrapper.java.grantPrivilege() line 130,
> GrouperAllAccessResolver.java.grantPrivilege() line 111,
> GrouperSystemAccessResolver.java.grantPrivilege() line 119,
> CachingAccessResolver.java.grantPrivilege() line 153,
> WheelAccessResolver.java.grantPrivilege() line 179,
> ValidatingAccessResolver.java.grantPrivilege() line 103,
> Stem.java._grantOptionalPrivUponCreate() line 1567,
> Stem.java._grantDefaultPrivsUponCreate() line 1483,
> Stem.java.access$3() line 1471, Stem.java.callback() line 1378,
> Stem.java.internal_addChildGroup() line 1316, Stem.java.addChildGroup()
> line 277, GroupHooksAddTypeTest.java.testGroupHooksAddType() line 105,
> GroupHooksAddTypeTest.java.main() line 32
> >    insert into grouper_memberships (hibernate_version_number,
> owner_id, member_id, field_id, mship_type, via_id, depth,
> parent_membership, creator_id, create_time, id) values (0, 'f872f926-
> 1a24-45c0-955d-66373ad4c5da', '844f0eae-288c-4445-afd4-c88210df2d28',
> 'f53747f9-1367-4a99-8f1d-c2a3b4b36f5a', 'immediate', null, 0, null,
> '7a81d717-dced-4e56-ad13-4343f3f67321', 1234363044245, 'ce142a42-fef9-
> 449c-9f1f-fe0ce7c26b24')
> > 2009/02/11 09:37:24:449, 0ms, statement:
> HibernateSession.java.callbackHibernateSession() line 387,
> Hib3MembershipDAO.java.update() line 566, Membership.java.callback()
> line 526, Hib3TransactionDAO.java.callback() line 46,
> Hib3TransactionDAO.java.transactionCallback() line 39,
> Membership.java.internal_insertPersistDefaultMemberOf() line 516,
> Membership.java.internal_addImmediateMembership() line 563,
> GrouperAccessAdapter.java.callback() line 235,
> GrouperSession.java.callbackGrouperSession() line 626,
> GrouperAccessAdapter.java.grantPriv() line 222,
> AccessWrapper.java.grantPrivilege() line 130,
> GrouperAllAccessResolver.java.grantPrivilege() line 111,
> GrouperSystemAccessResolver.java.grantPrivilege() line 119,
> CachingAccessResolver.java.grantPrivilege() line 153,
> WheelAccessResolver.java.grantPrivilege() line 179,
> ValidatingAccessResolver.java.grantPrivilege() line 103,
> Stem.java._grantOptionalPrivUponCreate() line 1567,
> Stem.java._grantDefaultPrivsUponCreate() line 1483,
> Stem.java.access$3() line 1471, Stem.java.callback() line 1378,
> Stem.java.internal_addChildGroup() line 1316, Stem.java.addChildGroup()
> line 277, GroupHooksAddTypeTest.java.testGroupHooksAddType() line 105,
> GroupHooksAddTypeTest.java.main() line 32
> >    update grouper_groups set hibernate_version_number=7,
> creator_id='7a81d717-dced-4e56-ad13-4343f3f67321',
> create_time=1234362665113, modifier_id='7a81d717-dced-4e56-ad13-
> 4343f3f67321', modify_time=1234363044308 where id='f872f926-1a24-45c0-
> 955d-66373ad4c5da'
> > 2009/02/11 09:37:24:511, 0ms, statement:
> ByHqlStatic.java.uniqueResult() line 209,
> Hib3MemberDAO.java.findBySubject() line 150,
> MemberFinder.java.internal_findOrCreateBySubject() line 202,
> MemberFinder.java.internal_findBySubject() line 175,
> MemberFinder.java.findBySubject() line 105,
> MemberFinder.java.internal_findReadableMemberBySubject() line 248,
> Membership.java.internal_addImmediateMembership() line 560,
> GrouperAccessAdapter.java.callback() line 235,
> GrouperSession.java.callbackGrouperSession() line 626,
> GrouperAccessAdapter.java.grantPriv() line 222,
> AccessWrapper.java.grantPrivilege() line 130,
> GrouperAllAccessResolver.java.grantPrivilege() line 111,
> GrouperSystemAccessResolver.java.grantPrivilege() line 119,
> CachingAccessResolver.java.grantPrivilege() line 153,
> WheelAccessResolver.java.grantPrivilege() line 179,
> ValidatingAccessResolver.java.grantPrivilege() line 103,
> Stem.java._grantOptionalPrivUponCreate() line 1567,
> Stem.java._grantDefaultPrivsUponCreate() line 1485,
> Stem.java.access$3() line 1471, Stem.java.callback() line 1378,
> Stem.java.internal_addChildGroup() line 1316, Stem.java.addChildGroup()
> line 277, GroupHooksAddTypeTest.java.testGroupHooksAddType() line 105,
> GroupHooksAddTypeTest.java.main() line 32
> >    select member0_.id as id6_, member0_.hibernate_version_number as
> hibernate2_6_, member0_.subject_id as subject3_6_,
> member0_.subject_source as subject4_6_, member0_.subject_type as
> subject5_6_ from grouper_members member0_ where
> member0_.subject_id='GrouperAll' and member0_.subject_source='g:isa'
> and member0_.subject_type='application'
> > 2009/02/11 09:37:24:558, resultset: ALIASES: 0: id, 1:
> hibernate_version_number, 2: subject_id, 3: subject_source, 4:
> subject_type
> > 2009/02/11 09:37:24:574, resultset: 0: 844f0eae-288c-4445-afd4-
> c88210df2d28, 1: 0, 2: GrouperAll, 3: g:isa, 4: application
> > 2009/02/11 09:37:24:574, 0ms, statement:
> ByHqlStatic.java.uniqueResult() line 209,
> Hib3MembershipDAO.java.exists() line 96,
> ImmediateMembershipValidator.java.validate() line 77,
> DefaultMemberOf.java.callback() line 758,
> GrouperSession.java.callbackGrouperSession() line 626,
> DefaultMemberOf.java._evaluateAddImmediateMembership() line 746,
> DefaultMemberOf.java.addImmediate() line 182,
> Membership.java.internal_addImmediateMembership() line 562,
> GrouperAccessAdapter.java.callback() line 235,
> GrouperSession.java.callbackGrouperSession() line 626,
> GrouperAccessAdapter.java.grantPriv() line 222,
> AccessWrapper.java.grantPrivilege() line 130,
> GrouperAllAccessResolver.java.grantPrivilege() line 111,
> GrouperSystemAccessResolver.java.grantPrivilege() line 119,
> CachingAccessResolver.java.grantPrivilege() line 153,
> WheelAccessResolver.java.grantPrivilege() line 179,
> ValidatingAccessResolver.java.grantPrivilege() line 103,
> Stem.java._grantOptionalPrivUponCreate() line 1567,
> Stem.java._grantDefaultPrivsUponCreate() line 1485,
> Stem.java.access$3() line 1471, Stem.java.callback() line 1378,
> Stem.java.internal_addChildGroup() line 1316, Stem.java.addChildGroup()
> line 277, GroupHooksAddTypeTest.java.testGroupHooksAddType() line 105,
> GroupHooksAddTypeTest.java.main() line 32
> >    select membership0_.id as col_0_0_ from grouper_memberships
> membership0_, grouper_fields field1_ where
> membership0_.owner_id='f872f926-1a24-45c0-955d-66373ad4c5da' and
> membership0_.member_id='844f0eae-288c-4445-afd4-c88210df2d28' and
> membership0_.field_id=field1_.id and field1_.name='viewers' and
> membership0_.mship_type='immediate'
> > 2009/02/11 09:37:24:652, 0ms, statement: ByHql.java.list() line 253,
> Hib3GroupDAO.java._updateAttributes() line 1034,
> Group.java.onPostUpdate() line 3444, Hib3MembershipDAO.java.callback()
> line 576, Hib3MembershipDAO.java.update() line 566,
> Membership.java.callback() line 526, Hib3TransactionDAO.java.callback()
> line 46, Hib3TransactionDAO.java.transactionCallback() line 39,
> Membership.java.internal_insertPersistDefaultMemberOf() line 516,
> Membership.java.internal_addImmediateMembership() line 563,
> GrouperAccessAdapter.java.callback() line 235,
> GrouperSession.java.callbackGrouperSession() line 626,
> GrouperAccessAdapter.java.grantPriv() line 222,
> AccessWrapper.java.grantPrivilege() line 130,
> GrouperAllAccessResolver.java.grantPrivilege() line 111,
> GrouperSystemAccessResolver.java.grantPrivilege() line 119,
> CachingAccessResolver.java.grantPrivilege() line 153,
> WheelAccessResolver.java.grantPrivilege() line 179,
> ValidatingAccessResolver.java.grantPrivilege() line 103,
> Stem.java._grantOptionalPrivUponCreate() line 1567,
> Stem.java._grantDefaultPrivsUponCreate() line 1485,
> Stem.java.access$3() line 1471, Stem.java.callback() line 1378,
> Stem.java.internal_addChildGroup() line 1316, Stem.java.addChildGroup()
> line 277, GroupHooksAddTypeTest.java.testGroupHooksAddType() line 105,
> GroupHooksAddTypeTest.java.main() line 32
> >    select attribute0_.id as id0_,
> attribute0_.hibernate_version_number as hibernate2_0_,
> attribute0_.group_id as group3_0_, attribute0_.field_id as field4_0_,
> attribute0_.value as value0_ from grouper_attributes attribute0_ where
> attribute0_.group_id='f872f926-1a24-45c0-955d-66373ad4c5da'
> > 2009/02/11 09:37:24:699, resultset: ALIASES: 0: id, 1:
> hibernate_version_number, 2: group_id, 3: field_id, 4: value
> > 2009/02/11 09:37:24:699, resultset: 0:
> 02db5bdb1f65bf5b011f65bf88c80049, 1: 0, 2: f872f926-1a24-45c0-955d-
> 66373ad4c5da, 3: 3cd11b25-69f6-49e2-8034-0d5843459125, 4: myGroup
> > 2009/02/11 09:37:24:714, resultset: 0:
> 02db5bdb1f65bf5b011f65c33de5004e, 1: 0, 2: f872f926-1a24-45c0-955d-
> 66373ad4c5da, 3: 5c007370-d142-43e6-90b2-91287e001c3c, 4: 2
> > 2009/02/11 09:37:24:714, resultset: 0:
> 02db5bdb1f65bf5b011f65bf88f7004c, 1: 0, 2: f872f926-1a24-45c0-955d-
> 66373ad4c5da, 3: 78d25d0e-16d2-4d6b-b2bb-41faad7a79f5, 4:
> education:myGroup
> > 2009/02/11 09:37:24:714, resultset: 0:
> 02db5bdb1f65bf5b011f65bf88e7004b, 1: 0, 2: f872f926-1a24-45c0-955d-
> 66373ad4c5da, 3: d5909da2-9b84-497c-8aa7-de85ab5ddbc4, 4: edu:myGroup
> > 2009/02/11 09:37:24:714, resultset: 0:
> 02db5bdb1f65bf5b011f65bf88e7004a, 1: 0, 2: f872f926-1a24-45c0-955d-
> 66373ad4c5da, 3: e569a92d-aa51-4798-9f40-fa7e2b519301, 4: myGroup
> > 2009/02/11 09:37:24:730, 0ms, statement:
> HibernateSession.java.callbackHibernateSession() line 387,
> Hib3MembershipDAO.java.update() line 566, Membership.java.callback()
> line 526, Hib3TransactionDAO.java.callback() line 46,
> Hib3TransactionDAO.java.transactionCallback() line 39,
> Membership.java.internal_insertPersistDefaultMemberOf() line 516,
> Membership.java.internal_addImmediateMembership() line 563,
> GrouperAccessAdapter.java.callback() line 235,
> GrouperSession.java.callbackGrouperSession() line 626,
> GrouperAccessAdapter.java.grantPriv() line 222,
> AccessWrapper.java.grantPrivilege() line 130,
> GrouperAllAccessResolver.java.grantPrivilege() line 111,
> GrouperSystemAccessResolver.java.grantPrivilege() line 119,
> CachingAccessResolver.java.grantPrivilege() line 153,
> WheelAccessResolver.java.grantPrivilege() line 179,
> ValidatingAccessResolver.java.grantPrivilege() line 103,
> Stem.java._grantOptionalPrivUponCreate() line 1567,
> Stem.java._grantDefaultPrivsUponCreate() line 1485,
> Stem.java.access$3() line 1471, Stem.java.callback() line 1378,
> Stem.java.internal_addChildGroup() line 1316, Stem.java.addChildGroup()
> line 277, GroupHooksAddTypeTest.java.testGroupHooksAddType() line 105,
> GroupHooksAddTypeTest.java.main() line 32
> >    insert into grouper_memberships (hibernate_version_number,
> owner_id, member_id, field_id, mship_type, via_id, depth,
> parent_membership, creator_id, create_time, id) values (0, 'f872f926-
> 1a24-45c0-955d-66373ad4c5da', '844f0eae-288c-4445-afd4-c88210df2d28',
> 'b118fbd5-e2d8-462f-a0bd-5949805af3cb', 'immediate', null, 0, null,
> '7a81d717-dced-4e56-ad13-4343f3f67321', 1234363044574, 'cebc27ec-c29c-
> 4eaa-ad83-cb93b5b19820')
> > 2009/02/11 09:37:24:777, 0ms, statement:
> HibernateSession.java.callbackHibernateSession() line 387,
> Hib3MembershipDAO.java.update() line 566, Membership.java.callback()
> line 526, Hib3TransactionDAO.java.callback() line 46,
> Hib3TransactionDAO.java.transactionCallback() line 39,
> Membership.java.internal_insertPersistDefaultMemberOf() line 516,
> Membership.java.internal_addImmediateMembership() line 563,
> GrouperAccessAdapter.java.callback() line 235,
> GrouperSession.java.callbackGrouperSession() line 626,
> GrouperAccessAdapter.java.grantPriv() line 222,
> AccessWrapper.java.grantPrivilege() line 130,
> GrouperAllAccessResolver.java.grantPrivilege() line 111,
> GrouperSystemAccessResolver.java.grantPrivilege() line 119,
> CachingAccessResolver.java.grantPrivilege() line 153,
> WheelAccessResolver.java.grantPrivilege() line 179,
> ValidatingAccessResolver.java.grantPrivilege() line 103,
> Stem.java._grantOptionalPrivUponCreate() line 1567,
> Stem.java._grantDefaultPrivsUponCreate() line 1485,
> Stem.java.access$3() line 1471, Stem.java.callback() line 1378,
> Stem.java.internal_addChildGroup() line 1316, Stem.java.addChildGroup()
> line 277, GroupHooksAddTypeTest.java.testGroupHooksAddType() line 105,
> GroupHooksAddTypeTest.java.main() line 32
> >    update grouper_groups set hibernate_version_number=9,
> creator_id='7a81d717-dced-4e56-ad13-4343f3f67321',
> create_time=1234362665113, modifier_id='7a81d717-dced-4e56-ad13-
> 4343f3f67321', modify_time=1234363044636 where id='f872f926-1a24-45c0-
> 955d-66373ad4c5da'
> > 2009/02/11 09:37:24:839, 0ms, commit
> >
> >
> >
> >
> >
> > > -----Original Message-----
> > > From: Dr. Loris Bennett 
> > > [mailto:]
> > > Sent: Wednesday, February 11, 2009 8:45 AM
> > > To: Chris Hyzer
> > > Cc: Grouper Users Mailing List
> > > Subject: RE: [grouper-users] RE: Grouper 1.4.0: Using hooks
> > >
> > > Hi Chris,
> > >
> > > The upgrade script worked, so I was able to try out the postInsert
> > > hook.
> > > >From the logs, the code is executed and a new group id generated.
> > > However, although the new group is created, the custom type and
> hence
> > > the custom attribute is not added.
> > >
> > > Thus, for the time being I will have to use the
> groupPostCommitInsert
> > > hook as a work around.
> > >
> > > I have attached the code, whereby I also tried out the variant
> which is
> > > commented out, as I wasn't sure what difference it would make if
> the
> > > callback is invoked. Perhaps you could enlighten me here.
> > >
> > > Cheers
> > >
> > > Loris
> > >
> > >
> > >
> > >
> > > On Mon, 2009-02-09 at 10:41 -0500, Chris Hyzer wrote:
> > > > Heres option 3 which would be easier:
> > > >
> > > > Here is the script I use to upgrade postgres to v13:
> > > >
> > > > postgresUpgrade_v13.sql (also attached):
> > > > ##########################
> > > >
> > > > DROP INDEX stem_name_idx;
> > > >
> > > > CREATE UNIQUE INDEX stem_name_idx ON grouper_stems (name);
> > > >
> > > > update grouper_ddl set db_version = 13, last_updated =
> '2009/02/09
> > > > 10:30:06' where object_name = 'Grouper'; commit;
> > > >
> > > > ##########################
> > > >
> > > > C:\mchyzer\isc\dev\grouper_v1_4\grouper\bin>gsh -registry -
> runsqlfile
> > > > ..\postgresUpgrade_v13.sql
> > > >
> > > > ...
> > > >
> > > > Script was executed successfully
> > > >
> > > > I created a bug for this:
> > > > https://bugs.internet2.edu/jira/browse/GRP-223
> > > >
> > > > Chris
> > > >
> > > > > -----Original Message-----
> > > > > From: Dr. Loris Bennett 
> > > > > [mailto:]
> > > > > Sent: Monday, February 09, 2009 10:31 AM
> > > > > To: Chris Hyzer
> > > > > Cc: Grouper Users Mailing List
> > > > > Subject: RE: [grouper-users] RE: Grouper 1.4.0: Using hooks
> > > > >
> > > > > Hi Chris,
> > > > >
> > > > > I am running:
> > > > >
> > > > > Debian 3.1 (Linux 2.6.22.1.dl380 #1 SMP Thu Aug 2 10:44:26 CEST
> > > 2007
> > > > > GNU/Linux)
> > > > > Postgres 8.4.2 (Debian 1:3.3.5-13)
> > > > >
> > > > > I shall try out the workarounds and let you know how I get on.
> > > > >
> > > > > Cheers
> > > > >
> > > > > Loris
> > > > >
> > > > >
> > > > > On Mon, 2009-02-09 at 10:03 -0500, Chris Hyzer wrote:
> > > > > > Well, ddlutils is confused, it is reading jdbc metadata and
> it is
> > > > > saying that there are multiple columns with the same name in
> the
> > > > > table...
> > > > > > I have seen postgres have more issues than oracle/mysql/hsql
> with
> > > > > ddlutils...  anyways, I think you are stuck with one of the
> > > > > workarounds I suggested.
> > > > > > Let me know the platform (linux?) and postgres version, and I
> > > will
> > > > > open a bug and see if I can make progress on a longer term
> > > solution.
> > > > > >
> > > > > > Thanks,
> > > > > > Chris
> > > > > >
> > > > > >
> > > > > >
> > > > > > > -----Original Message-----
> > > > > > > From: Dr. Loris Bennett 
> > > > > > > [mailto:]
> > > > > > > Sent: Monday, February 09, 2009 9:55 AM
> > > > > > > To: Chris Hyzer
> > > > > > > Cc: Grouper Users Mailing List
> > > > > > > Subject: RE: [grouper-users] RE: Grouper 1.4.0: Using hooks
> > > > > > >
> > > > > > > Here is the console output:
> > > > > > >
> > > > > > >         $ ./bin/gsh.sh -registry -check
> > > > > > >         Using
> > > > > > >         GROUPER_HOME:
> > > > > /home/testwww/src/grouper/grouper.binary.1.4.1
> > > > > > >         Using
> > > > > > >         GROUPER_CONF:
> > > > > > > /home/testwww/src/grouper/grouper.binary.1.4.1/conf
> > > > > > >         Using JAVA: /home/testwww/java/jdk/bin/java
> > > > > > >         using MEMORY: 64m-512m
> > > > > > >         Grouper starting up: version: 1.4.1, build date:
> > > 2009/02/02
> > > > > > >         14:43:32, env: testing
> > > > > > >         grouper.properties read
> > > > > > >         from:
> > > > > > >
> > > > >
> > >
> /home/testwww/src/grouper/grouper.binary.1.4.1/conf/grouper.properti
> > > > > es
> > > > > > >         Grouper current directory
> > > > > > >         is: /home/testwww/src/grouper/grouper.binary.1.4.1
> > > > > > >         log4j.properties read
> > > > > > >         from:
> > > > > > >
> > > > >
> > >
> /home/testwww/src/grouper/grouper.binary.1.4.1/conf/log4j.properties
> > > > > > >         Grouper is logging to
> > > > > > >         file:
> > > > > > >
> > > > >
> > >
> /home/testwww/src/grouper/grouper.binary.1.4.1/logs/grouper_error.lo
> > > > > g,
> > > > > > > at min level WARN for package:
> > > edu.internet2.middleware.grouper,
> > > > > based
> > > > > > > on log4j.properties
> > > > > > >         grouper.hibernate.properties:
> > > > > > >
> > > > >
> > >
> /home/testwww/src/grouper/grouper.binary.1.4.1/conf/grouper.hibernat
> > > > > e.p
> > > > > > > roperties
> > > > > > >         grouper.hibernate.properties:
> > > > > > >         
> > > > > > > grouper@jdbc:postgresql://identity-store.zedat.fu-
> > > > > > > berlin.de:5713/testfurzdb
> > > > > > >         sources.xml read
> > > > > > >         from:
> > > > > > >
> /home/testwww/src/grouper/grouper.binary.1.4.1/conf/sources.xml
> > > > > > >         sources.xml groupersource id: g:gsa
> > > > > > >         sources.xml jdbc source id:   jdbc:
> > > > > > >         GrouperJdbcConnectionProvider
> > > > > > >         (note, might need to type in your response multiple
> > > > > > > times
> > > > > (Java
> > > > > > >         stdin is flaky))
> > > > > > >         (note, you can whitelist or blacklist db urls and
> users
> > > > > > > in
> > > > > the
> > > > > > >         grouper.properties)
> > > > > > >         Are you sure you want to schemaexport all tables
> > > > > > >         (dropThenCreate=F,writeAndRunScript=F) in db user
> > > > > 'grouper', db
> > > > > > >         url
> > > > > > >         'jdbc:postgresql://identity-store.zedat.fu-
> > > > > > > berlin.de:5713/testfurzdb'? (y|n):
> > > > > > >         y
> > > > > > >         Continuing...
> > > > > > >         Grouper ddl object type 'Grouper' has dbVersion: 12
> and
> > > > > java
> > > > > > >         version: 13
> > > > > > >         org.apache.ddlutils.model.ModelException: There are
> > > > > multiple
> > > > > > >         column with the name id in the table
> grouper_attributes
> > > > > > >               at
> > > > > > >
> > > > > > >
> > > org.apache.ddlutils.model.Database.initialize(Database.java:295)
> > > > > > >               at
> > > > > > >
> > > > > > >
> > > > >
> > >
> org.apache.ddlutils.platform.JdbcModelReader.getDatabase(JdbcModelRe
> > > > > ade
> > > > > > > r.java:484)
> > > > > > >               at
> > > > > > >
> > > > > > >
> > > > >
> > >
> org.apache.ddlutils.platform.PlatformImplBase.readModelFromDatabase(
> > > > > Pla
> > > > > > > tformImplBase.java:1920)
> > > > > > >               at
> > > > > > >
> > > > > > >
> > > > >
> > >
> edu.internet2.middleware.grouper.ddl.GrouperDdlUtils.bootstrapHelper
> > > > > (Gr
> > > > > > > ouperDdlUtils.java:488)
> > > > > > >               at
> > > > > > >
> > > > > > >
> > > > >
> > >
> edu.internet2.middleware.grouper.registry.RegistryInitializeSchema.m
> > > > > ain
> > > > > > > (RegistryInitializeSchema.java:155)
> > > > > > >               at
> > > > > sun.reflect.NativeMethodAccessorImpl.invoke0(Native
> > > > > > > Method)
> > > > > > >               at
> > > > > > >
> > > > > > >
> > > > >
> > >
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl
> > > > > .ja
> > > > > > > va:39)
> > > > > > >               at
> > > > > > >
> > > > > > >
> > > > >
> > >
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcce
> > > > > sso
> > > > > > > rImpl.java:25)
> > > > > > >               at
> > > java.lang.reflect.Method.invoke(Method.java:597)
> > > > > > >               at
> > > > > > >
> > > > > > >
> > > > >
> > >
> edu.internet2.middleware.grouper.app.gsh.GrouperShell.handleSpecialC
> > > > > ase
> > > > > > > (GrouperShell.java:167)
> > > > > > >               at
> > > > > > >
> > > > > > >
> > > > >
> > >
> edu.internet2.middleware.grouper.app.gsh.GrouperShell.main(GrouperSh
> > > > > ell
> > > > > > > .java:108)
> > > > > > >               at
> > > > > sun.reflect.NativeMethodAccessorImpl.invoke0(Native
> > > > > > > Method)
> > > > > > >               at
> > > > > > >
> > > > > > >
> > > > >
> > >
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl
> > > > > .ja
> > > > > > > va:39)
> > > > > > >               at
> > > > > > >
> > > > > > >
> > > > >
> > >
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcce
> > > > > sso
> > > > > > > rImpl.java:25)
> > > > > > >               at
> > > java.lang.reflect.Method.invoke(Method.java:597)
> > > > > > >               at
> > > > > com.dawidweiss.invoker.Invoker.loader(Invoker.java:167)
> > > > > > >               at
> > > > > com.dawidweiss.invoker.Invoker.main(Invoker.java:303)
> > > > > > >         [com.dawidweiss.invoker.Invoker]
> > > > > > >
> edu.internet2.middleware.grouper.app.gsh.GrouperShell
> > > > > > > has thrown
> > > > > > >         an exception.
> > > > > > >         java.lang.RuntimeException:
> > > > > > >         java.lang.reflect.InvocationTargetException
> > > > > > >               at
> > > > > > >
> > > > > > >
> > > > >
> > >
> edu.internet2.middleware.grouper.app.gsh.GrouperShell.handleSpecialC
> > > > > ase
> > > > > > > (GrouperShell.java:172)
> > > > > > >               at
> > > > > > >
> > > > > > >
> > > > >
> > >
> edu.internet2.middleware.grouper.app.gsh.GrouperShell.main(GrouperSh
> > > > > ell
> > > > > > > .java:108)
> > > > > > >               at
> > > > > sun.reflect.NativeMethodAccessorImpl.invoke0(Native
> > > > > > > Method)
> > > > > > >               at
> > > > > > >
> > > > > > >
> > > > >
> > >
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl
> > > > > .ja
> > > > > > > va:39)
> > > > > > >               at
> > > > > > >
> > > > > > >
> > > > >
> > >
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcce
> > > > > sso
> > > > > > > rImpl.java:25)
> > > > > > >               at
> > > java.lang.reflect.Method.invoke(Method.java:597)
> > > > > > >               at
> > > > > com.dawidweiss.invoker.Invoker.loader(Invoker.java:167)
> > > > > > >               at
> > > > > com.dawidweiss.invoker.Invoker.main(Invoker.java:303)
> > > > > > >         Caused by:
> java.lang.reflect.InvocationTargetException
> > > > > > >               at
> > > > > sun.reflect.NativeMethodAccessorImpl.invoke0(Native
> > > > > > > Method)
> > > > > > >               at
> > > > > > >
> > > > > > >
> > > > >
> > >
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl
> > > > > .ja
> > > > > > > va:39)
> > > > > > >               at
> > > > > > >
> > > > > > >
> > > > >
> > >
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcce
> > > > > sso
> > > > > > > rImpl.java:25)
> > > > > > >               at
> > > java.lang.reflect.Method.invoke(Method.java:597)
> > > > > > >               at
> > > > > > >
> > > > > > >
> > > > >
> > >
> edu.internet2.middleware.grouper.app.gsh.GrouperShell.handleSpecialC
> > > > > ase
> > > > > > > (GrouperShell.java:167)
> > > > > > >               ... 7 more
> > > > > > >         Caused by: java.lang.RuntimeException:
> > > > > > >         org.apache.ddlutils.model.ModelException: There are
> > > > > multiple
> > > > > > >         column with the name id in the table
> grouper_attributes
> > > > > > >               at
> > > > > > >
> > > > > > >
> > > > >
> > >
> edu.internet2.middleware.grouper.registry.RegistryInitializeSchema.m
> > > > > ain
> > > > > > > (RegistryInitializeSchema.java:176)
> > > > > > >               ... 12 more
> > > > > > >         Caused by:
> org.apache.ddlutils.model.ModelException:
> > > > > > > There
> > > > > are
> > > > > > >         multiple column with the name id in the table
> > > > > > > grouper_attributes
> > > > > > >               at
> > > > > > >
> > > > > > >
> > > org.apache.ddlutils.model.Database.initialize(Database.java:295)
> > > > > > >               at
> > > > > > >
> > > > > > >
> > > > >
> > >
> org.apache.ddlutils.platform.JdbcModelReader.getDatabase(JdbcModelRe
> > > > > ade
> > > > > > > r.java:484)
> > > > > > >               at
> > > > > > >
> > > > > > >
> > > > >
> > >
> org.apache.ddlutils.platform.PlatformImplBase.readModelFromDatabase(
> > > > > Pla
> > > > > > > tformImplBase.java:1920)
> > > > > > >               at
> > > > > > >
> > > > > > >
> > > > >
> > >
> edu.internet2.middleware.grouper.ddl.GrouperDdlUtils.bootstrapHelper
> > > > > (Gr
> > > > > > > ouperDdlUtils.java:488)
> > > > > > >               at
> > > > > > >
> > > > > > >
> > > > >
> > >
> edu.internet2.middleware.grouper.registry.RegistryInitializeSchema.m
> > > > > ain
> > > > > > > (RegistryInitializeSchema.java:155)
> > > > > > >               ... 12 more
> > > > > > >
> > > > > > > and here is grouper_error.log:
> > > > > > >
> > > > > > >         2009-02-09 15:50:26,049: [main] WARN
> > > > > > >         ApiConfig.printConfigOnce(186) - Grouper starting
> up:
> > > > > version:
> > > > > > >         1.4.1, build date: 2009/02/02 14:43:32, env:
> testing
> > > > > > >         grouper.properties read
> > > > > > >         from:
> > > > > > >
> > > > >
> > >
> /home/testwww/src/grouper/grouper.binary.1.4.1/conf/grouper.properti
> > > > > es
> > > > > > >         Grouper current directory
> > > > > > >         is: /home/testwww/src/grouper/grouper.binary.1.4.1
> > > > > > >         log4j.properties read
> > > > > > >         from:
> > > > > > >
> > > > >
> > >
> /home/testwww/src/grouper/grouper.binary.1.4.1/conf/log4j.properties
> > > > > > >         Grouper is logging to
> > > > > > >         file:
> > > > > > >
> > > > >
> > >
> /home/testwww/src/grouper/grouper.binary.1.4.1/logs/grouper_error.lo
> > > > > g,
> > > > > > > at min level WARN for package:
> > > edu.internet2.middleware.grouper,
> > > > > based
> > > > > > > on log4j.properties
> > > > > > >         grouper.hibernate.properties:
> > > > > > >
> > > > >
> > >
> /home/testwww/src/grouper/grouper.binary.1.4.1/conf/grouper.hibernat
> > > > > e.p
> > > > > > > roperties
> > > > > > >         grouper.hibernate.properties:
> > > > > > >         
> > > > > > > grouper@jdbc:postgresql://identity-store.zedat.fu-
> > > > > > > berlin.de:5713/testfurzdb
> > > > > > >         sources.xml read
> > > > > > >         from:
> > > > > > >
> /home/testwww/src/grouper/grouper.binary.1.4.1/conf/sources.xml
> > > > > > >         sources.xml groupersource id: g:gsa
> > > > > > >         sources.xml jdbc source id:   jdbc:
> > > > > > >         GrouperJdbcConnectionProvider
> > > > > > >         2009-02-09 15:50:35,664: [main] ERROR
> > > > > > >         GrouperDdlUtils.bootstrapHelper(393) - Grouper ddl
> > > > > > > object
> > > > > type
> > > > > > >         'Grouper' has dbVersion: 12 and java version: 13
> > > > > > >
> > > > > > > HTH
> > > > > > >
> > > > > > > Loris
> > > > > > >
> > > > > > > On Mon, 2009-02-09 at 09:45 -0500, Chris Hyzer wrote:
> > > > > > > > How did you try to upgrade the DB?  With:
> > > > > > > >
> > > > > > > > gsh -registry -check -runscript
> > > > > > > >
> > > > > > > > Can you send me the entire log?
> > > > > > > >
> > > > > > > > As a workaround, you can either:
> > > > > > > >
> > > > > > > > 1. export to xml, recreate the db from scratch (delete
> data)
> > > > > with:
> > > > > > > >
> > > > > > > > gsh -registry -check -drop -runscript
> > > > > > > >
> > > > > > > > Then import the xml
> > > > > > > >
> > > > > > > > -or- 2. Change the grouper_stems stem name index to be
> unique
> > > > > (drop
> > > > > > > and recreate index), and change the grouper_ddl row for
> grouper
> > > > > > > to
> > > > > be
> > > > > > > version 13...
> > > > > > > >
> > > > > > > > Thanks,
> > > > > > > > Chris
> > > > > > > >
> > > > > > > > > -----Original Message-----
> > > > > > > > > From: Dr. Loris Bennett 
> > > > > > > > > [mailto:loris.bennett@fu-
> berlin.de]
> > > > > > > > > Sent: Monday, February 09, 2009 7:55 AM
> > > > > > > > > To: Chris Hyzer
> > > > > > > > > Cc: Grouper Users Mailing List
> > > > > > > > > Subject: RE: [grouper-users] RE: Grouper 1.4.0: Using
> hooks
> > > > > > > > >
> > > > > > > > > Hi Chris,
> > > > > > > > >
> > > > > > > > > Using your code I got everything working for a
> > > > > > > > > groupPostCommit
> > > > > > > hook,
> > > > > > > > > which is great.
> > > > > > > > >
> > > > > > > > > However, I can't try out the groupPostInsert hook with
> the
> > > > > > > > > CVS
> > > > > > > version,
> > > > > > > > > because when I try to update the database from 1.4.0, I
> get
> > > > > > > > > the following error:
> > > > > > > > >
> > > > > > > > > Grouper ddl object type 'Grouper' has dbVersion: 12 and
> > > java
> > > > > > > version:
> > > > > > > > > 13
> > > > > > > > >         org.apache.ddlutils.model.ModelException: There
> are
> > > > > > > multiple
> > > > > > > > > column with the name id in the table grouper_attributes
> > > > > > > > >
> > > > > > > > > The error message is misleading, since the table has in
> > > fact
> > > > > the
> > > > > > > > > regular
> > > > > > > > > 5 attributes - id, group_id, field_id, value,
> > > > > > > hibernate_version_number.
> > > > > > > > >
> > > > > > > > > Any ideas?
> > > > > > > > >
> > > > > > > > > TIA
> > > > > > > > >
> > > > > > > > > Loris
> > > > > > > > >
> > > > > > > > > On Thu, 2009-02-05 at 16:21 -0500, Chris Hyzer wrote:
> > > > > > > > > > Ok, the workaround isn’t working, lets fix the real
> > > issues
> > > > > > > first...
> > > > > > > > > >
> > > > > > > > > > Those two bugs are fixed in the 1.4 branch, can you
> get
> > > > > latest
> > > > > > > from
> > > > > > > > > 1.4 branch?
> > > > > > > > > >
> > > > > > > > > > https://bugs.internet2.edu/jira/browse/GRP-219
> > > > > > > > > > https://bugs.internet2.edu/jira/browse/GRP-220
> > > > > > > > > >
> > > > > > > > > > cvs
> > > > > > > > > > -
> d:pserver::/home/cvs/i2mi
> > > > > login
> > > > > > > > > > cvs
> > > > > > > > > > -
> d:pserver::/home/cvs/i2mi
> > > > > > > export -r
> > > > > > > > > GROUPER_1_4_BRANCH grouper
> > > > > > > > > >
> > > > > > > > > > Now we should be able to do this the original way,
> with a
> > > > > > > postInsert
> > > > > > > > > hook, and group.addType.
> > > > > > > > > >
> > > > > > > > > > Here is my testcase:
> > > > > > > > > >
> > > > > > > > > >   public void groupPostInsert(HooksContext
> hooksContext,
> > > > > > > > > >       HooksGroupBean postInsertBean) {
> > > > > > > > > >
> > > > > > > > > >     super.groupPostInsert(hooksContext,
> postInsertBean);
> > > > > > > > > >     try {
> > > > > > > > > >       Group group = postInsertBean.getGroup();
> > > > > > > > > >       GroupType fubGroup =
> > > GroupTypeFinder.find("fubGroup");
> > > > > > > > > >       group.addType(fubGroup);
> > > > > > > > > >       int sequenceNumber = 2;
> > > > > > > > > >       group.setAttribute("gid", sequenceNumber + "");
> > > > > > > > > >       group.store();
> > > > > > > > > >     } catch (Exception e) {
> > > > > > > > > >       throw new RuntimeException(e.getMessage(), e);
> > > > > > > > > >     }
> > > > > > > > > >   }
> > > > > > > > > >
> > > > > > > > > > Now, to get that "2", you want to use an oracle
> sequence?
> > > > > You
> > > > > > > should
> > > > > > > > > be able to do something like this:
> > > > > > > > > >
> > > > > > > > > >       int sequenceNumber =
> > > > > > > > > HibernateSession.bySqlStatic().select(int.class,
> > > > > > > > > >         "select someSeq.nextval from dual");
> > > > > > > > > >
> > > > > > > > > > If you want to put it in a table, you can use
> hibernate,
> > > > > > > > > > but
> > > > > > > unless
> > > > > > > > > you are doing a lot of sql, might just want to use
> sql...
> > > > > > > > > if
> > > > > you
> > > > > > > want
> > > > > > > > > hibernate, let me know and I can make an example...
> > > > > > > > > >
> > > > > > > > > >       List<Object> params =
> > > > > > > > > GrouperUtil.toList((Object)group.getUuid(),
> > > sequenceNumber);
> > > > > > > > > >
> HibernateSession.bySqlStatic().executeSql("insert
> > > > > > > > > > into
> > > > > > > > > some_table (col1, col2) values (?, ?)",
> > > > > > > > > >           params);
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > > > OK, all that being said, I think you have another
> > > problem...
> > > > > your
> > > > > > > > > type has an extra attribute associated with it right
> > > (should
> > > > > only
> > > > > > > have
> > > > > > > > > gid, but it also has "id")???  You should be able to
> run
> > > > > > > > > this
> > > > > > > query:
> > > > > > > > > >
> > > > > > > > > > select gt.name as type_name, gf.name as field_name,
> > > > > > > > > > gf.is_nullable, gf.type as field_type,
> gf.read_privilege,
> > > > > > > > > > gf.write_privilege, gt.is_assignable, gt.is_internal
> > > > > > > > > >   from grouper_fields gf, grouper_types gt where
> > > > > > > > > > gf.grouptype_uuid = gt.id
> > > > > > > > > >
> > > > > > > > > > You should see that fubGroup has one attribute named
> > > "gid".
> > > > > If
> > > > > > > you
> > > > > > > > > see multiple attributes, you can delete those
> attributes
> > > > > (assuming
> > > > > > > they
> > > > > > > > > aren’t already being used :) ), with gsh...  I usually
> make
> > > > > > > > > my
> > > > > > > group
> > > > > > > > > types with java or gsh, not xml, but Im not sure what
> the
> > > > > > > > > issue
> > > > > > > is...
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > >
> > > > > > >
> > > > >
> > >
> https://wiki.internet2.edu/confluence/display/GrouperWG/GrouperShell
> > > > > +(g
> > > > > > > > > sh)
> > > > > > > > > > typeDelField(type name, field name)
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > > > Let me know the next step.
> > > > > > > > > > Kind regards,
> > > > > > > > > >
> > > > > > > > > > Chris
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > > > > -----Original Message-----
> > > > > > > > > > > From: Dr. Loris Bennett
> > > > > > > > > > > [mailto:]
> > > > > > > > > > > Sent: Thursday, February 05, 2009 6:14 AM
> > > > > > > > > > > To: Chris Hyzer
> > > > > > > > > > > Cc: Grouper Users Mailing List
> > > > > > > > > > > Subject: RE: [grouper-users] RE: Grouper 1.4.0:
> Using
> > > > > > > > > > > hooks
> > > > > > > > > > >
> > > > > > > > > > > On Wed, 2009-02-04 at 11:38 -0500, Chris Hyzer
> wrote:
> > > > > > > > > > > > Ok, this is a problem with grouper.  In
> addChildGroup
> > > > > > > > > > > > in
> > > > > > > Stem, it
> > > > > > > > > > > assume that the types aren’t saved yet right after
> the
> > > > > group
> > > > > > > insert
> > > > > > > > > > > (since hooks didn’t exist back then, it was a safe
> > > > > assumption).
> > > > > > > > > > > >
> > > > > > > > > > > > I added a bug:
> > > > > > > > > > > >
> > > > > > > > > > > > https://bugs.internet2.edu/jira/browse/GRP-219
> > > > > > > > > > > >
> > > > > > > > > > > > We will be able to fix this no problem.
> > > > > > > > > > > >
> > > > > > > > > > > > In the meantime, you have two options:
> > > > > > > > > > > >
> > > > > > > > > > > > 1. Instead of adding a type, add it to the list
> of
> > > > > > > > > > > > types
> > > > > that
> > > > > > > the
> > > > > > > > > > > calling method will add:
> > > > > > > > > > > >
> > > > > > > > > > > > FROM:
> > > > > > > > > > > > g.addType(fubGroup);
> > > > > > > > > > > >
> > > > > > > > > > > > TO:
> > > > > > > > > > > > g.getTypesDb().add(fubGroup);
> > > > > > > > > > > >
> > > > > > > > > > > > This seems like the best temporary workaround
> until
> > > we
> > > > > fix
> > > > > > > the
> > > > > > > > > real
> > > > > > > > > > > issue.  Though this using an internal method, so
> you
> > > > > > > > > > > should
> > > > > > > > > definitely
> > > > > > > > > > > switch it out when you get a fixed group.  I tried
> it
> > > > > > > > > > > and
> > > > > it
> > > > > > > works.
> > > > > > > > > > >
> > > > > > > > > > > This gives me the error:
> > > > > > > > > > >
> > > > > > > > > > >         2009-02-05 09:11:54,097:
> > > > > > > > > > > [http-130.133.2.116-9080-
> > > > > > > > > Processor21]
> > > > > > > > > > >         ERROR GrouperCapableAction.execute(281) -
> > > > > > > > > > >         java.lang.RuntimeException:
> edu.internet2.mid
> > > > > > > > > > >         dleware.grouper.exception.SchemaException:
> > > > > > > > > > > invalid
> > > > > > > group
> > > > > > > > > type:
> > > > > > > > > > >         for group name: test:abc123,
> > > > > > > > > > >         GroupType[creatorUuid=b0bb6118-c6b9-4d37-
> 8257-
> > > > > > > 61dcee19b4c
> > > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > >
> > > > > > >
> > > > >
> > >
> 6,createTime=1231229012373,fields=12,isAssignable=false,isInternal=f
> > > > > als
> > > > > > > > > > > e,name=base,uuid=fc8eff6c-6812-4a10-8891-
> > > > > > > 133df83bfbb5]:extension
> > > > > > > > > > >
> > > > > > > > > > > The UI says that the group was saved successfully,
> but
> > > > > > > > > > > also
> > > > > > > that an
> > > > > > > > > > > error occurred. When I click on the group in the UI
> to
> > > > > > > > > > > get
> > > > > the
> > > > > > > > > group
> > > > > > > > > > > summary, I get the standard error message.
> > > > > > > > > > >
> > > > > > > > > > > So I tried the second method (see below) ...
> > > > > > > > > > >
> > > > > > > > > > > > ################################
> > > > > > > > > > > >
> > > > > > > > > > > > -or- 2.  Do a postCommitInsert hook.  This will
> not
> > > be
> > > > > > > > > > > > in
> > > > > the
> > > > > > > > > same
> > > > > > > > > > > transaction, but all the work of adding the group
> will
> > > > > > > > > > > be
> > > > > done,
> > > > > > > so
> > > > > > > > > you
> > > > > > > > > > > are safe to add a type.
> > > > > > > > > > > >  Again, if you pick this, then you might want to
> > > > > > > > > > > > switch
> > > > > it
> > > > > > > back
> > > > > > > > > when
> > > > > > > > > > > you get a fixed grouper. I tried this and it didn’t
> > > > > > > > > > > commit
> > > > > the
> > > > > > > > > changes
> > > > > > > > > > > (something about post
> > > > > > > > > > > > commit puts it in a transaction that doesn’t get
> > > > > committed).
> > > > > > > I
> > > > > > > > > made
> > > > > > > > > > > another bug:
> > > > > > > > > > > >
> > > > > > > > > > > > https://bugs.internet2.edu/jira/browse/GRP-220
> > > > > > > > > > > >
> > > > > > > > > > > > The workaround here is to just make a new
> transaction
> > > > > that
> > > > > > > will
> > > > > > > > > > > commit when done.  I tested it and it works:
> > > > > > > > > > > >
> > > > > > > > > > > > FROM:
> > > > > > > > > > > >     public void groupPostInsert(HooksContext
> > > > > hooksContext,
> > > > > > > > > > > HooksGroupBean postInsertBean) {
> > > > > > > > > > > >
> > > > > > > > > > > > TO:
> > > > > > > > > > > >     public void
> groupPostCommitInsert(HooksContext
> > > > > > > hooksContext,
> > > > > > > > > > > HooksGroupBean postInsertBean) {
> > > > > > > > > > > >
> > > > > > > > > > > > FROM:
> > > > > > > > > > > >       g.addType(fubGroup);
> > > > > > > > > > > >
> > > > > > > > > > > > TO:
> > > > > > > > > > > >       final Group G = g;
> > > > > > > > > > > >       final GroupType FUB_GROUP = fubGroup;
> > > > > > > > > > > >       HibernateSession.callbackHibernateSession(
> > > > > > > > > > > >           GrouperTransactionType.READ_WRITE_NEW,
> new
> > > > > > > > > > > HibernateHandler() {
> > > > > > > > > > > >
> > > > > > > > > > > >             public Object
> callback(HibernateSession
> > > > > > > > > hibernateSession)
> > > > > > > > > > > >                 throws GrouperDAOException {
> > > > > > > > > > > >               try {
> > > > > > > > > > > >                 G.addType(FUB_GROUP);
> > > > > > > > > > > >               } catch (Exception e) {
> > > > > > > > > > > >                 throw new RuntimeException(e);
> > > > > > > > > > > >               }
> > > > > > > > > > > >               return null;
> > > > > > > > > > > >             }
> > > > > > > > > > > >
> > > > > > > > > > > >           });
> > > > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > > > This works. The group type is added with the
> attributes
> > > > > > > > > > >
> > > > > > > > > > >         gid <empty>
> > > > > > > > > > >         id <same as uuid>
> > > > > > > > > > >
> > > > > > > > > > > However, my definition of the group type looks like
> > > > > > > > > > >
> > > > > > > > > > >         <registry>
> > > > > > > > > > >           <metadata>
> > > > > > > > > > >             <groupTypesMetaData>
> > > > > > > > > > >               <groupTypeDef name='fubGroup'>
> > > > > > > > > > >                 <field name='gid' required='false'
> > > > > > > type='attribute'
> > > > > > > > > > >         readPriv='read' writePriv='admin'/>
> > > > > > > > > > >               </groupTypeDef>
> > > > > > > > > > >             </groupTypesMetaData>
> > > > > > > > > > >           </metadata>
> > > > > > > > > > >         </registry>
> > > > > > > > > > >
> > > > > > > > > > > so where does 'id' come from?
> > > > > > > > > > >
> > > > > > > > > > > > Let me know if you need more help.
> > > > > > > > > > >
> > > > > > > > > > > Another thing I am not sure about is how I would do
> an
> > > > > insert
> > > > > > > into
> > > > > > > > > a
> > > > > > > > > > > table such as "fub_group_ids" to get a gid from a
> > > > > > > > > > > sequence
> > > > > > > which I
> > > > > > > > > can
> > > > > > > > > > > then write into the 'gid' field of my customised
> type.
> > > I
> > > > > > > > > > > am
> > > > > not
> > > > > > > too
> > > > > > > > > > > familiar with hibernate, but assume this would be
> the
> > > > > > > > > > > way
> > > > > to
> > > > > > > go,
> > > > > > > > > right?
> > > > > > > > > > >
> > > > > > > > > > > Thanks for all your help,
> > > > > > > > > > >
> > > > > > > > > > > Loris
> > > > > > > > > > >
> > > > > > > > > > > > Kind regards,
> > > > > > > > > > > > Chris
> > > > > > > > > > > >
> > > > > > > > > > > > > -----Original Message-----
> > > > > > > > > > > > > From: Dr. Loris Bennett
> [mailto:loris.bennett@fu-
> > > > > berlin.de]
> > > > > > > > > > > > > Sent: Wednesday, February 04, 2009 6:08 AM
> > > > > > > > > > > > > To: Chris Hyzer
> > > > > > > > > > > > > Cc: Grouper Users Mailing List
> > > > > > > > > > > > > Subject: RE: [grouper-users] RE: Grouper 1.4.0:
> > > > > > > > > > > > > Using
> > > > > hooks
> > > > > > > > > > > > >
> > > > > > > > > > > > > Hi Chris,
> > > > > > > > > > > > >
> > > > > > > > > > > > > I tried the failsafe call, but got the same
> errors.
> > > > > > > > > > > > > In
> > > > > the
> > > > > > > UI:
> > > > > > > > > > > > >
> > > > > > > > > > > > >         Error: Could not create group. Error is
> > > > > > > > > > > > > 'cannot
> > > > > > > create
> > > > > > > > > > > child
> > > > > > > > > > > > >         group: Problem create child stem:
> > > > > > > > > > > > >
> > > > > > > > > > > > > Stem[displayName=test,name=test,uuid=029bc9c2-
> > > > > 50bd-
> > > > > > > > > 4122-
> > > > > > > > > > > 891c-
> > > > > > > > > > > > > ffdf252744b8,creator=fd703376-4f16-47df-b707-
> > > > > > > > > > > > > 64d8c5953d04,modifier=fd703376-4f16-47df-b707-
> > > > > > > 64d8c5953d04],
> > > > > > > > > child:
> > > > > > > > > > > > > Group[name=test:xxx,uuid=d559eccd-9be2-4555-
> ac1a-
> > > > > > > 40ee72bb106e],
> > > > > > > > > > > > > memberDto: 'd559eccd-9be2-4555-ac1a-
> > > > > > > > > 40ee72bb106e'/'group'/'g:gsa',
> > > > > > > > > > > > > Problem in HibernateSession: HibernateSession:
> > > isNew:
> > > > > > > false,
> > > > > > > > > > > > > isReadonly: false, grouperTransactionType:
> > > > > READ_WRITE_NEW,
> > > > > > > > > > > Exception in
> > > > > > > > > > > > > uniqueResult: (class java.lang.Object),
> > > ByHqlStatic,
> > > > > query:
> > > > > > > > > 'select
> > > > > > > > > > > > > m.id from Member as m where m.uuid = :uuid',
> > > cacheable:
> > > > > > > false,
> > > > > > > > > > > > > cacheRegion:
> > > > > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > >
> > > > > > >
> > > > >
> > >
> edu.internet2.middleware.grouper.internal.dao.hib3.Hib3MemberDAO.Exi
> > > > > sts
> > > > > > > > > > > > > , tx type: nullBind var[0]: 'Param (class
> > > > > > > java.lang.String):
> > > > > > > > > > > 'uuid'-
> > > > > > > > > > > > > >'90e883dd-326e-40f1-9416-805d2770a9d6', ,
> Problem
> > > > > > > > > > > > > >in
> > > > > > > > > > > HibernateSession:
> > > > > > > > > > > > > HibernateSession: isNew: false, isReadonly:
> false,
> > > > > > > > > > > > > grouperTransactionType: READ_WRITE_NEW'.
> > > > > > > > > > > > >
> > > > > > > > > > > > > I have attached an extract from the grouper log
> and
> > > > > > > > > > > > > the
> > > > > > > code.
> > > > > > > > > > > > >
> > > > > > > > > > > > > Thanks for all your help.
> > > > > > > > > > > > >
> > > > > > > > > > > > > Loris
> > > > > > > > > > > > >
> > > > > > > > > > > > >
> > > > > > > > > > > > > On Tue, 2009-02-03 at 23:32 -0500, Chris Hyzer
> > > wrote:
> > > > > > > > > > > > > > Ive been thinking about your issue, and if
> your
> > > > > question
> > > > > > > is,
> > > > > > > > > why
> > > > > > > > > > > > > should you use the failsafe group type call
> since
> > > > > > > > > > > > > the
> > > > > type
> > > > > > > > > hasn’t
> > > > > > > > > > > been
> > > > > > > > > > > > > applied yet, it might be because when you add a
> > > type
> > > > > > > > > > > > > to
> > > > > a
> > > > > > > > > group, it
> > > > > > > > > > > > > might update the group lastUpdated col, and
> invoke
> > > > > > > > > > > > > the
> > > > > > > update
> > > > > > > > > hook
> > > > > > > > > > > > > again.  Then, the second time, it does have
> that
> > > > > > > > > > > > > type,
> > > > > and
> > > > > > > you
> > > > > > > > > cant
> > > > > > > > > > > add
> > > > > > > > > > > > > it again.  This is something we are exploring
> for
> > > > > > > > > > > > > 1.5
> > > > > (not
> > > > > > > > > setting
> > > > > > > > > > > the
> > > > > > > > > > > > > Group lastUpdated for each peripheral operation
> > > like
> > > > > > > > > memberships,
> > > > > > > > > > > > > types, etc).  However, for 1.4, the group
> object
> > > > > > > > > > > > > might
> > > > > be
> > > > > > > saved
> > > > > > > > > for
> > > > > > > > > > > any
> > > > > > > > > > > > > related change, which fires the hooks again...
> so
> > > > > > > > > > > > > if
> > > > > you
> > > > > > > use
> > > > > > > > > the
> > > > > > > > > > > > > failsafe method per one of my previous emails,
> then
> > > > > > > > > > > > > the
> > > > > > > second
> > > > > > > > > time
> > > > > > > > > > > the
> > > > > > > > > > > > > hook is called, it doesn’t fail.
> > > > > > > > > > > > > >
> > > > > > > > > > > > > > Hope this helps, if not, send your code and
> > > > > description
> > > > > > > again
> > > > > > > > > and
> > > > > > > > > > > I
> > > > > > > > > > > > > > will take a look.  :)
> > > > > > > > > > > > > >
> > > > > > > > > > > > > > Kind regards,
> > > > > > > > > > > > > > Chris
> > > > > > > > > > > > > >
> > > > > > > > > > > > > > > -----Original Message-----
> > > > > > > > > > > > > > > From: Dr. Loris Bennett
> > > > > > > > > > > > > > > [mailto:loris.bennett@fu-
> > > > > > > berlin.de]
> > > > > > > > > > > > > > > Sent: Tuesday, February 03, 2009 9:37 AM
> > > > > > > > > > > > > > > To: Chris Hyzer
> > > > > > > > > > > > > > > Cc: Grouper Users Mailing List
> > > > > > > > > > > > > > > Subject: RE: [grouper-users] RE: Grouper
> 1.4.0:
> > > > > Using
> > > > > > > hooks
> > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > Hi Chris,
> > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > I don't understand what is going on here.
> If I
> > > > > create a
> > > > > > > new
> > > > > > > > > > > group
> > > > > > > > > > > > > > > via the UI without selecting any custom
> type,
> > > > > > > > > > > > > > > the
> > > > > code
> > > > > > > > > > > > > > >
> > > > > > > > > > > > > > >         Group g =
> postInsertBean.getGroup();
> > > > > > > > > > > > > > >         Set<GroupType> types =
> g.getTypes();
> > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > tells me that the new group has just one
> type,
> > > > > namely
> > > > > > > > > 'base'. I
> > > > > > > > > > > > > then
> > > > > > > > > > > > > > > get the error
> > > > > > > > > > > > > > >
> > > > > > > > > > > > > > >         ERROR
> > > > > JDBCExceptionReporter.logExceptions(78) -
> > > > > > > > > ERROR:
> > > > > > > > > > > > > > > duplicate
> > > > > > > > > > > > > > >         key violates unique constraint
> > > > > > > > > > > > > "grouptypetyple_grouptype_idx"
> > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > But how can the group already have the type
> at
> > > > > > > > > > > > > > > this
> > > > > > > point?
> > > > > > > > > The
> > > > > > > > > > > > > > > following error appears in the UI:
> > > > > > > > > > > > > > >
> > > > > > > > > > > > > > >         Error: Could not create group.
> Error is
> > > > > 'cannot
> > > > > > > > > create
> > > > > > > > > > > > > child
> > > > > > > > > > > > > > >         group: Problem create child stem:
> > > > > > > > > > > > > > >
> > > > > > > > > > > > > > >
> Stem[displayName=test,name=test,uuid=029bc9c2-
> > > 50
> > > > > > > > > > > > > > > bd-
> > > > > > > 4122-
> > > > > > > > > 891c-
> > > > > > > > > > > > > > > ffdf252744b8,creator=fd703376-4f16-47df-
> b707-
> > > > > > > > > > > > > > > 64d8c5953d04,modifier=fd703376-4f16-47df-
> b707-
> > > > > > > > > 64d8c5953d04],
> > > > > > > > > > > child:
> > > > > > > > > > > > > > > Group[name=test:xyz,uuid=dc2a2fa6-4fad-
> 446e-
> > > bf5c
> > > > > > > > > > > > > > > -
> > > > > > > > > d08dba8d0b33],
> > > > > > > > > > > > > > > memberDto: 'dc2a2fa6-4fad-446e-bf5c-
> > > > > > > > > > > d08dba8d0b33'/'group'/'g:gsa',
> > > > > > > > > > > > > > > Problem in HibernateSession:
> HibernateSession:
> > > > > isNew:
> > > > > > > > > false,
> > > > > > > > > > > > > > > isReadonly: false, grouperTransactionType:
> > > > > > > READ_WRITE_NEW,
> > > > > > > > > > > > > Exception
> > > > > > > > > > > > > > > in
> > > > > > > > > > > > > > > uniqueResult: (class java.lang.Object),
> > > > > ByHqlStatic,
> > > > > > > query:
> > > > > > > > > > > 'select
> > > > > > > > > > > > > > > m.id from Member as m where m.uuid =
> :uuid',
> > > > > cacheable:
> > > > > > > > > false,
> > > > > > > > > > > > > > > cacheRegion:
> > > > > > > > > > > > > > >
> > > > > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > >
> > > > > > >
> > > > >
> > >
> edu.internet2.middleware.grouper.internal.dao.hib3.Hib3MemberDAO.Exi
> > > > > > > > > > > > > > > sts , tx type: nullBind var[0]: 'Param
> (class
> > > > > > > > > > > java.lang.String):
> > > > > > > > > > > > > > > 'uuid'-
> > > > > > > > > > > > > > > >'b412a97d-080a-4b68-a856-5a237a041e06', ,
> > > > > > > > > > > > > > > >Problem
> > > > > in
> > > > > > > > > > > > > HibernateSession:
> > > > > > > > > > > > > > > HibernateSession: isNew: false, isReadonly:
> > > > > > > > > > > > > > > false,
> > > > > > > > > > > > > > > grouperTransactionType: READ_WRITE_NEW'.
> > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > Any ideas what I am doing wrong?
> > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > Cheers
> > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > Loris
> > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > On Fri, 2009-01-30 at 15:36 -0500, Chris
> Hyzer
> > > > > wrote:
> > > > > > > > > > > > > > > > That index "grouptypetyple_grouptype_idx"
> is
> > > a
> > > > > unique
> > > > > > > > > index
> > > > > > > > > > > on
> > > > > > > > > > > > > > > > grouper_group_types cols: group_uuid and
> > > > > type_uuid.
> > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > So that error means that the group
> already
> > > has
> > > > > the
> > > > > > > type.
> > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > I have also found it unnatural that the
> > > > > > > > > > > > > > > > default
> > > > > > > Grouper
> > > > > > > > > API
> > > > > > > > > > > > > > > > behavior is to throw exceptions if the
> task
> > > is
> > > > > > > already
> > > > > > > > > done.
> > > > > > > > > > > > > E.g.
> > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > group.addType(someType);
> > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > Will throw an exception if the type is
> > > already
> > > > > > > there... I
> > > > > > > > > > > have
> > > > > > > > > > > > > > > > been slowly overloading these types of
> > > methods
> > > > > with
> > > > > > > their
> > > > > > > > > > > safe
> > > > > > > > > > > > > > > > equivalents...  so if you change it to:
> > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > //false means don’t throw exception if
> type
> > > is
> > > > > > > already
> > > > > > > > > > > assigned
> > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > group.addType(someType, false);
> > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > It should do the trick.  Let me know if
> not.
> > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > Thanks,
> > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > Chris
> > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > Ps.   Btw, web services do not behave
> that
> > > way...
> > > > > > > e.g. if
> > > > > > > > > you
> > > > > > > > > > > add
> > > > > > > > > > > > > a
> > > > > > > > > > > > > > > > member to a group that already has the
> > > member,
> > > > > > > > > > > > > > > > it
> > > > > > > will be
> > > > > > > > > a
> > > > > > > > > > > no-
> > > > > > > > > > > > > op,
> > > > > > > > > > > > > > > > return SUCCESS, and let you know exactly
> what
> > > > > > > happened
> > > > > > > > > (e.g.
> > > > > > > > > > > > > > > > success, but it already had the
> assignment)
> > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > > -----Original Message-----
> > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > > From: Dr. Loris Bennett
> > > > > [mailto:loris.bennett@fu-
> > > > > > > > > berlin.de]
> > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > > Sent: Friday, January 30, 2009 8:27 AM
> > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > > To: Chris Hyzer
> > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > > Cc: Grouper Users Mailing List
> > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > > Subject: RE: [grouper-users] RE:
> Grouper
> > > 1.4.0:
> > > > > > > Using
> > > > > > > > > hooks
> > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > > However, when I try to add the type in
> > > > > > > groupPostInsert,
> > > > > > > > > I
> > > > > > > > > > > get
> > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > >         ERROR
> > > > > > > JDBCExceptionReporter.logExceptions(78) -
> > > > > > > > > > > ERROR:
> > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > > duplicate
> > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > >         key violates unique constraint
> > > > > > > > > > > > > > > > "grouptypetyple_grouptype_idx"
> > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > > Any ideas?
> > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > > Loris
> > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > > On Fri, 2009-01-30 at 07:34 -0500,
> Chris
> > > > > > > > > > > > > > > > > Hyzer
> > > > > > > wrote:
> > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > > > Good catch!  Thanks!
> > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > > > > -----Original Message-----
> > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > > > > From: Dr. Loris Bennett
> > > > > > > [mailto:loris.bennett@fu-
> > > > > > > > > > > berlin.de]
> > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > > > > Sent: Friday, January 30, 2009 7:31
> AM
> > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > > > > To: Chris Hyzer
> > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > > > > Cc: Grouper Users Mailing List
> > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > > > > Subject: RE: [grouper-users] RE:
> > > Grouper
> > > > > 1.4.0:
> > > > > > > > > Using
> > > > > > > > > > > hooks
> > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > > > > OK, I see what I am doing wrong. I
> have
> > > > > > > > > > > > > > > > > > > the
> > > > > > > addType
> > > > > > > > > in
> > > > > > > > > > > my
> > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > > > > groupPreInsert, whereas the group
> must
> > > > > already
> > > > > > > > > exist
> > > > > > > > > > > before
> > > > > > > > > > > > > > > > > > > I
> > > > > > > > > > > > > > > > can
> > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > > add
> > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > > > > anything to it.
> > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > > > > On Fri, 2009-01-30 at 11:39 +0100,
> Dr.
> > > > > Loris
> > > > > > > > > Bennett
> > > > > > > > > > > wrote:
> > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > > > > > Hi Chris,
> > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > > > > > Using
> > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > > > > >         fubGroup =
> > > > > > > > > > > GroupTypeFinder.find(groupTypeName);
> > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > > > > > I can get my custom group type,
> but
> > > > > > > > > > > > > > > > > > > > when
> > > > > I
> > > > > > > try to
> > > > > > > > > add
> > > > > > > > > > > > > this
> > > > > > > > > > > > > > > > with
> > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > > > > >         g.addType(fubGroup);
> > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > > > > > I get the error:
> > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > > > > >         ERROR
> > > > > > > > > JDBCExceptionReporter.logExceptions(78)
> > > > > > > > > > > -
> > > > > > > > > > > > > > > ERROR:
> > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > > insert
> > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > > > > or
> > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > > > > >         update on table
> > > > > > > "grouper_groups_types"
> > > > > > > > > > > violates
> > > > > > > > > > > > > > > > foreign
> > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > > key
> > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > > > > >         constraint
> > > > > > > "fk_groups_types_group_uuid"
> > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > > > > >           Detail: Key
> > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > > > > > (group_uuid)=(6ea9f650-cdc8-4e69-
> > > 93df-
> > > > > > > > > 5b35a87351fe)
> > > > > > > > > > > > > > > is
> > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > > not
> > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > > > > >         present in table
> > > > > "grouper_groups".
> > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > > > > > Am I doing something wrong here?
> > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > > > > > TIA
> > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > > > > > Loris
> > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > > > > > On Thu, 2009-01-29 at 03:21 -
> 0500,
> > > > > > > > > > > > > > > > > > > > Chris
> > > > > > > Hyzer
> > > > > > > > > wrote:
> > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > > > > > > > So the pre-insert would also
> set
> > > > > > > > > > > > > > > > > > > > > > the
> > > > > > > custom
> > > > > > > > > > > > > attribute,
> > > > > > > > > > > > > > > > right?
> > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > > > > > > OK, didn’t know we were talking
> > > > > > > > > > > > > > > > > > > > > about a
> > > > > > > custom
> > > > > > > > > > > > > attribute.
> > > > > > > > > > > > > > > > It’s
> > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > > a
> > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > > > > little tricky since the set of
> > > > > > > > > > > > > > > > > > > attributes
> > > > > is
> > > > > > > known
> > > > > > > > > when
> > > > > > > > > > > the
> > > > > > > > > > > > > > > > group
> > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > > SQL
> > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > > > > is written, but you are making
> changes
> > > > > > > > > > > > > > > > > > > (I
> > > > > guess
> > > > > > > to
> > > > > > > > > that
> > > > > > > > > > > > > > > > attribute
> > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > > set).
> > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > > > > I would think a post insert is the
> best
> > > > > bet,
> > > > > > > and
> > > > > > > > > you
> > > > > > > > > > > don’t
> > > > > > > > > > > > > > > > > > > need
> > > > > > > > > > > > > > > > the
> > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > > > > pre, but play around and try
> different
> > > > > things,
> > > > > > > and
> > > > > > > > > if
> > > > > > > > > > > you
> > > > > > > > > > > > > > > > > > > cant
> > > > > > > > > > > > > > > > get
> > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > > > > anything to work let me know.
> > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > > > > > > Chris
> > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > > > > --
> > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > > > > Dr. Loris Bennett (Mr.)
> > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > > > > Freie Universität Berlin
> > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > > > > ZEDAT - Zentraleinrichtung für
> > > > > > > Datenverarbeitung /
> > > > > > > > > > > Computer
> > > > > > > > > > > > > > > > Center
> > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > > > > Compute & Media Service
> > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > > > > Fabeckstr. 32, Room 221
> > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > > > > D-14195 Berlin
> > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > > > > Tel ++49 30 838 51024
> > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > > > > Fax ++49 30 838 56721
> > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > > > > Email 
> > > > > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > > > > Web www.zedat.fu-berlin.de
> > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > > --
> > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > > Dr. Loris Bennett (Mr.)
> > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > > Freie Universität Berlin
> > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > > ZEDAT - Zentraleinrichtung für
> > > > > Datenverarbeitung /
> > > > > > > > > Computer
> > > > > > > > > > > > > > > > > Center
> > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > > Compute & Media Service
> > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > > Fabeckstr. 32, Room 221
> > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > > D-14195 Berlin
> > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > > Tel ++49 30 838 51024
> > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > > Fax ++49 30 838 56721
> > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > > Email 
> > > > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > > Web www.zedat.fu-berlin.de
> > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > --
> > > > > > > > > > > > > > > Dr. Loris Bennett (Mr.) Freie Universität
> > > Berlin
> > > > > > > > > > > > > > > ZEDAT - Zentraleinrichtung für
> > > Datenverarbeitung
> > > > > > > > > > > > > > > /
> > > > > > > Computer
> > > > > > > > > > > Center
> > > > > > > > > > > > > > > Compute & Media Service Fabeckstr. 32, Room
> 221
> > > > > > > > > > > > > > > D-14195 Berlin
> > > > > > > > > > > > > > > Tel ++49 30 838 51024 Fax ++49 30 838 56721
> > > > > > > > > > > > > > > Email 
> > > > > > > > > > > > > > > 
> > > > > > > > > > > > > > >  Web
> > > > > > > > > > > > > > > www.zedat.fu-berlin.de
> > > > > > > > > > > > > >
> > > > > > > > > > > > > --
> > > > > > > > > > > > > Dr. Loris Bennett (Mr.) Freie Universität
> Berlin
> > > > > > > > > > > > > ZEDAT - Zentraleinrichtung für
> Datenverarbeitung /
> > > > > Computer
> > > > > > > > > Center
> > > > > > > > > > > > > Compute & Media Service Fabeckstr. 32, Room 221
> > > > > > > > > > > > > D-14195 Berlin
> > > > > > > > > > > > > Tel ++49 30 838 51024
> > > > > > > > > > > > > Fax ++49 30 838 56721
> > > > > > > > > > > > > Email 
> > > > > > > > > > > > > 
> > > > > > > > > > > > > Web www.zedat.fu-berlin.de
> > > > > > > > > > > --
> > > > > > > > > > > Dr. Loris Bennett (Mr.)
> > > > > > > > > > > Freie Universität Berlin
> > > > > > > > > > > ZEDAT - Zentraleinrichtung für Datenverarbeitung /
> > > Computer
> > > > > > > Center
> > > > > > > > > > > Compute & Media Service
> > > > > > > > > > > Fabeckstr. 32, Room 221
> > > > > > > > > > > D-14195 Berlin
> > > > > > > > > > > Tel ++49 30 838 51024
> > > > > > > > > > > Fax ++49 30 838 56721
> > > > > > > > > > > Email 
> > > > > > > > > > > 
> > > > > > > > > > > Web www.zedat.fu-berlin.de
> > > > > > > > > >
> > > > > > > > > --
> > > > > > > > > Dr. Loris Bennett (Mr.)
> > > > > > > > > Freie Universität Berlin
> > > > > > > > > ZEDAT - Zentraleinrichtung für Datenverarbeitung /
> Computer
> > > > > Center
> > > > > > > > > Compute & Media Service
> > > > > > > > > Fabeckstr. 32, Room 221
> > > > > > > > > D-14195 Berlin
> > > > > > > > > Tel ++49 30 838 51024
> > > > > > > > > Fax ++49 30 838 56721
> > > > > > > > > Email 
> > > > > > > > > 
> > > > > > > > > Web www.zedat.fu-berlin.de
> > > > > > > >
> > > > > > > --
> > > > > > > Dr. Loris Bennett (Mr.)
> > > > > > > Freie Universität Berlin
> > > > > > > ZEDAT - Zentraleinrichtung für Datenverarbeitung / Computer
> > > Center
> > > > > > > Compute & Media Service
> > > > > > > Fabeckstr. 32, Room 221
> > > > > > > D-14195 Berlin
> > > > > > > Tel ++49 30 838 51024
> > > > > > > Fax ++49 30 838 56721
> > > > > > > Email 
> > > > > > > 
> > > > > > > Web www.zedat.fu-berlin.de
> > > > > >
> > > > > --
> > > > > Dr. Loris Bennett (Mr.)
> > > > > Freie Universität Berlin
> > > > > ZEDAT - Zentraleinrichtung für Datenverarbeitung / Computer
> Center
> > > > > Compute & Media Service
> > > > > Fabeckstr. 32, Room 221
> > > > > D-14195 Berlin
> > > > > Tel ++49 30 838 51024
> > > > > Fax ++49 30 838 56721
> > > > > Email 
> > > > > 
> > > > > Web www.zedat.fu-berlin.de
> > > >
> > > --
> > > Dr. Loris Bennett (Mr.)
> > > Freie Universität Berlin
> > > ZEDAT - Zentraleinrichtung für Datenverarbeitung / Computer Center
> > > Compute & Media Service
> > > Fabeckstr. 32, Room 221
> > > D-14195 Berlin
> > > Tel ++49 30 838 51024
> > > Fax ++49 30 838 56721
> > > Email 
> > > 
> > > Web www.zedat.fu-berlin.de
> --
> Dr. Loris Bennett (Mr.)
> Freie Universität Berlin
> ZEDAT - Zentraleinrichtung für Datenverarbeitung / Computer Center
> Compute & Media Service
> Fabeckstr. 32, Room 221
> D-14195 Berlin
> Tel ++49 30 838 51024
> Fax ++49 30 838 56721
> Email 
> 
> Web www.zedat.fu-berlin.de