grouper-users - RE: [grouper-users] RE: Grouper 1.4.0: Using hooks
Subject: Grouper Users - Open Discussion List
List archive
- From: "Dr. Loris Bennett" <>
- To: Chris Hyzer <>
- Cc: Grouper Users Mailing List <>
- Subject: RE: [grouper-users] RE: Grouper 1.4.0: Using hooks
- Date: Wed, 18 Feb 2009 08:59:52 +0000
- Organization: Freie Universität Berlin
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/middleware/grouper/hooks/GroupHookAddType.java?root=I2MI&view=markup&pathrev=GROUPER_1_4_BRANCH
>
> Test:
> http://viewvc.internet2.edu/viewvc.py/grouper/src/test/edu/internet2/middleware/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:]
> > > > > > > > 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
> > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > > > 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
> > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > 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
> > > > > > > > > > > > > >
> > > > > > > > > > > > > > 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
> > > > > > > > > > > >
> > > > > > > > > > > > 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
> > > > > > > > > >
> > > > > > > > > > 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
> > > > > > > >
> > > > > > > > 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
> > > > > >
> > > > > > 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
> > > >
> > > > 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
> >
> > 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
Web www.zedat.fu-berlin.de
2009-02-18 09:20:43,101: [main] WARN C3p0JdbcConnectionProvider.init(127) - maxIdle is not available for c3p0 (in subject API: fub) 2009-02-18 09:20:43,119: [main] WARN ApiConfig.printConfigOnce(186) - Grouper starting up: version: 1.4.1, build date: 2009/02/09 12:00:11, env: dev grouper.properties read from: /home/xxxxxxxx/src/grouper/grouper-api-1.4.1-SNAPSHOT/conf/grouper.properties Grouper current directory is: /home/xxxxxxxx/src/grouper/grouper-api-1.4.1-SNAPSHOT log4j.properties read from: /home/xxxxxxxx/src/grouper/grouper-api-1.4.1-SNAPSHOT/conf/log4j.properties Grouper is logging to file: /home/xxxxxxxx/src/grouper/grouper-api-1.4.1-SNAPSHOT/logs/grouper_error.log, at min level WARN for package: edu.internet2.middleware.grouper, based on log4j.properties grouper.hibernate.properties: /home/xxxxxxxx/src/grouper/grouper-api-1.4.1-SNAPSHOT/conf/grouper.hibernate.properties grouper.hibernate.properties: grouper@jdbc:postgresql://xxxxxxxx.xxxxxxxx.fu-berlin.de:xxxx/xxxxxxxxdb sources.xml read from: /home/xxxxxxxx/src/grouper/grouper-api-1.4.1-SNAPSHOT/conf/sources.xml sources.xml groupersource id: g:gsa sources.xml jdbc source id: fub: grouper@jdbc:postgresql://xxxxxxxx.xxxxxxxx.fu-berlin.de:xxxx/xxxxxxxxdb 2009-02-18 09:20:49,763: [main] WARN GrouperCheckConfig.checkConfigProperties(1254) - missing from file: grouper.properties, the following properties (which are in the example file: grouper.example.properties): subject.internal.grouperall.name, subject.internal.groupersystem.name 2009-02-18 09:30:03,971: [main] WARN C3p0JdbcConnectionProvider.init(127) - maxIdle is not available for c3p0 (in subject API: fub) 2009-02-18 09:30:04,079: [main] WARN ApiConfig.printConfigOnce(186) - Grouper starting up: version: 1.4.1, build date: 2009/02/09 12:00:11, env: dev grouper.properties read from: /home/xxxxxxxx/src/grouper/grouper-api-1.4.1-SNAPSHOT/conf/grouper.properties Grouper current directory is: /home/xxxxxxxx/src/grouper/grouper-api-1.4.1-SNAPSHOT log4j.properties read from: /home/xxxxxxxx/src/grouper/grouper-api-1.4.1-SNAPSHOT/conf/log4j.properties Grouper is logging to file: /home/xxxxxxxx/src/grouper/grouper-api-1.4.1-SNAPSHOT/logs/grouper_error.log, at min level WARN for package: edu.internet2.middleware.grouper, based on log4j.properties grouper.hibernate.properties: /home/xxxxxxxx/src/grouper/grouper-api-1.4.1-SNAPSHOT/conf/grouper.hibernate.properties grouper.hibernate.properties: grouper@jdbc:postgresql://xxxxxxxx.xxxxxxxx.fu-berlin.de:xxxx/xxxxxxxxdb sources.xml read from: /home/xxxxxxxx/src/grouper/grouper-api-1.4.1-SNAPSHOT/conf/sources.xml sources.xml groupersource id: g:gsa sources.xml jdbc source id: fub: grouper@jdbc:postgresql://xxxxxxxx.xxxxxxxx.fu-berlin.de:xxxx/xxxxxxxxdb 2009-02-18 09:30:08,545: [main] WARN GrouperCheckConfig.checkConfigProperties(1254) - missing from file: grouper.properties, the following properties (which are in the example file: grouper.example.properties): subject.internal.grouperall.name, subject.internal.groupersystem.name 2009-02-18 09:30:28,353: [http-130.133.2.116-9080-Processor18] ERROR ErrorFilter.doFilter(145) - javax.servlet.ServletException: getAttribute: Session already invalidated at org.apache.struts.action.RequestProcessor.processException(RequestProcessor.java:516) at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:423) at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:226) at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1164) at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:397) at javax.servlet.http.HttpServlet.service(HttpServlet.java:627) at javax.servlet.http.HttpServlet.service(HttpServlet.java:729) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at edu.internet2.middleware.grouper.ui.LoginCheckFilter$1.callback(LoginCheckFilter.java:159) at edu.internet2.middleware.grouper.GrouperSession.callbackGrouperSession(GrouperSession.java:626) at edu.internet2.middleware.grouper.ui.LoginCheckFilter.doFilter(LoginCheckFilter.java:154) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at edu.internet2.middleware.grouper.ui.ErrorFilter.doFilter(ErrorFilter.java:134) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:204) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:172) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:433) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117) at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:548) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:174) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:875) at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665) at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528) at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689) at java.lang.Thread.run(Thread.java:619) 2009-02-18 09:30:28,355: [http-xxx.xxx.xxx.xxx-xxxx-Processor18] ERROR StandardWrapperValve.invoke(260) - Servlet.service() for servlet action threw exception java.lang.IllegalStateException: getAttribute: Session already invalidated at org.apache.catalina.session.StandardSession.getAttribute(StandardSession.java:1021) at org.apache.catalina.session.StandardSessionFacade.getAttribute(StandardSessionFacade.java:110) at edu.internet2.middleware.grouper.ui.actions.LowLevelGrouperCapableAction.getExceptionHelper(LowLevelGrouperCapableAction.java:573) at edu.internet2.middleware.grouper.ui.ErrorFilter.doFilter(ErrorFilter.java:148) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:204) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:172) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:433) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117) at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:548) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:174) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:875) at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665) at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528) at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689) at java.lang.Thread.run(Thread.java:619) 2009-02-18 09:30:28,358: [http-xxx.xxx.xxx.xxx-xxxx-Processor18] ERROR PopulateErrorAction.execute(69) - Caught '500' for /grouper-dev/logout.do 2009-02-18 09:31:00,483: [http-xxx.xxx.xxx.xxx-xxxx-Processor21] ERROR GroupHooks.groupPostInsert(115) - HOOKTEST: Got new FUB GID = 1 2009-02-18 09:31:00,572: [http-xxx.xxx.xxx.xxx-xxxx-Processor21] ERROR GroupHooks.groupPostInsert(119) - HOOKTEST: Stored new group with FUB GID 2009-02-18 09:34:37,191: [http-xxx.xxx.xxx.xxx-xxxx-Processor20] ERROR ErrorFilter.doFilter(145) - javax.servlet.ServletException: getAttribute: Session already invalidated at org.apache.struts.action.RequestProcessor.processException(RequestProcessor.java:516) at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:423) at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:226) at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1164) at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:397) at javax.servlet.http.HttpServlet.service(HttpServlet.java:627) at javax.servlet.http.HttpServlet.service(HttpServlet.java:729) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at edu.internet2.middleware.grouper.ui.LoginCheckFilter$1.callback(LoginCheckFilter.java:159) at edu.internet2.middleware.grouper.GrouperSession.callbackGrouperSession(GrouperSession.java:626) at edu.internet2.middleware.grouper.ui.LoginCheckFilter.doFilter(LoginCheckFilter.java:154) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at edu.internet2.middleware.grouper.ui.ErrorFilter.doFilter(ErrorFilter.java:134) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:204) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:172) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:433) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117) at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:548) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:174) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:875) at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665) at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528) at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689) at java.lang.Thread.run(Thread.java:619) 2009-02-18 09:34:37,197: [http-xxx.xxx.xxx.xxx-xxxx-Processor20] ERROR StandardWrapperValve.invoke(260) - Servlet.service() for servlet action threw exception java.lang.IllegalStateException: getAttribute: Session already invalidated at org.apache.catalina.session.StandardSession.getAttribute(StandardSession.java:1021) at org.apache.catalina.session.StandardSessionFacade.getAttribute(StandardSessionFacade.java:110) at edu.internet2.middleware.grouper.ui.actions.LowLevelGrouperCapableAction.getExceptionHelper(LowLevelGrouperCapableAction.java:573) at edu.internet2.middleware.grouper.ui.ErrorFilter.doFilter(ErrorFilter.java:148) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:204) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:172) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:433) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117) at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:548) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:174) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:875) at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665) at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528) at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689) at java.lang.Thread.run(Thread.java:619) 2009-02-18 09:34:37,212: [http-xxx.xxx.xxx.xxx-xxxx-Processor20] ERROR PopulateErrorAction.execute(69) - Caught '500' for /grouper-dev/logout.do 2009-02-18 09:35:59,630: [http-xxx.xxx.xxx.xxx-xxxx-Processor22] WARN C3p0JdbcConnectionProvider.init(127) - maxIdle is not available for c3p0 (in subject API: fub) 2009-02-18 09:35:59,635: [http-xxx.xxx.xxx.xxx-xxxx-Processor22] WARN ApiConfig.printConfigOnce(186) - Grouper starting up: version: 1.4.1, build date: null, env: dev grouper.properties read from: /home/xxxxxxxx/tomcat/identity/webapps/grouper-dev/WEB-INF/classes/grouper.properties Grouper current directory is: /home/xxxxxxxx/src/grouper/grouper-ui-1.4.1 log4j.properties read from: /home/xxxxxxxx/tomcat/identity/webapps/grouper-dev/WEB-INF/classes/log4j.properties Grouper is logging to file: /home/xxxxxxxx/src/grouper/grouper-ui-1.4.1/../grouper-api-1.4.1-SNAPSHOT/logs/grouper_error.log, at min level WARN for package: edu.internet2.middleware.grouper, based on log4j.properties grouper.hibernate.properties: /home/xxxxxxxx/tomcat/identity/webapps/grouper-dev/WEB-INF/classes/grouper.hibernate.properties grouper.hibernate.properties: grouper@jdbc:postgresql://xxxxxxxx.xxxxxxxx.fu-berlin.de:xxxx/xxxxxxxxdb sources.xml read from: /home/xxxxxxxx/tomcat/identity/webapps/grouper-dev/WEB-INF/classes/sources.xml sources.xml groupersource id: g:gsa sources.xml jdbc source id: fub: grouper@jdbc:postgresql://xxxxxxxx.xxxxxxxx.fu-berlin.de:xxxx/xxxxxxxxdb 2009-02-18 09:36:01,270: [http-xxx.xxx.xxx.xxx-xxxx-Processor22] ERROR GrouperDdlUtils.retrieveDdlsFromCache(1239) - maybe the grouper_ddl table isnt there... if that is the reason its ok. Problem in HibernateSession: HibernateSession: isNew: true, isReadonly: true, grouperTransactionType: READONLY_NEW, Exception in list: (class edu.internet2.middleware.grouper.app.loader.db.Hib3GrouperDdl), ByCriteriaStatic, persistentClass: 'class edu.internet2.middleware.grouper.app.loader.db.Hib3GrouperDdl', criterions: null', cacheable: null, cacheRegion: null, tx type: null 2009-02-18 09:36:01,295: [http-xxx.xxx.xxx.xxx-xxxx-Processor22] ERROR GrouperDdlUtils.bootstrapHelper(393) - Grouper ddl object type 'Grouper' has dbVersion: 0 and java version: 13 2009-02-18 09:36:17,901: [http-xxx.xxx.xxx.xxx-xxxx-Processor22] ERROR GrouperDdlUtils.bootstrapHelper(393) - Grouper ddl object type 'Subject' has dbVersion: 0 and java version: 1 2009-02-18 09:36:18,356: [http-xxx.xxx.xxx.xxx-xxxx-Processor22] ERROR GrouperDdlUtils.bootstrapHelper(643) - Grouper database schema DDL requires updates (should run script manually and carefully, in sections, verify data before drop statements, backup/export important data before starting, follow change log on confluence, dont run exact same script in multiple envs - generate a new one for each env), script file is: /home/xxxxxxxx/grouper/ddlScripts/grouperDdl_20090218_09_36_18_355.sql 2009-02-18 09:36:18,602: [http-xxx.xxx.xxx.xxx-xxxx-Processor22] ERROR GrouperCheckConfig.checkGrouperVersion(992) - grouper versions do not match, GrouperVersion.class: 1.4.1, grouper.version.properties: 1.4.1, manifest: null 2009-02-18 09:36:18,605: [http-xxx.xxx.xxx.xxx-xxxx-Processor22] WARN GrouperCheckConfig.checkConfigProperties(1254) - missing from file: grouper.properties, the following properties (which are in the example file: grouper.example.properties): subject.internal.grouperall.name, subject.internal.groupersystem.name 2009-02-18 09:36:18,649: [http-xxx.xxx.xxx.xxx-xxxx-Processor22] ERROR GrouperStartup.startup(107) - Couldnt startup grouper: Database schema ddl is not up to date, or has issues, check logs and config ddl in grouper.properties and run: gsh -registry -check, Problem in HibernateSession: null, Exception in uniqueResult: (class edu.internet2.middleware.grouper.Member), ByHqlStatic, query: 'from Member as m where m.subjectIdDb = :sid and m.subjectSourceIdDb = :source and m.subjectTypeId = :type', cacheable: true, cacheRegion: edu.internet2.middleware.grouper.internal.dao.hib3.Hib3MemberDAO.FindBySubject, tx type: nullBind var[0]: 'Param (class java.lang.String): 'sid'->'GrouperSystem', Bind var[1]: 'Param (class java.lang.String): 'type'->'application'Bind var[2]: 'Param (class java.lang.String): 'source'->'g:isa', java.lang.RuntimeException: Database schema ddl is not up to date, or has issues, check logs and config ddl in grouper.properties and run: gsh -registry -check, Problem in HibernateSession: null, Exception in uniqueResult: (class edu.internet2.middleware.grouper.Member), ByHqlStatic, query: 'from Member as m where m.subjectIdDb = :sid and m.subjectSourceIdDb = :source and m.subjectTypeId = :type', cacheable: true, cacheRegion: edu.internet2.middleware.grouper.internal.dao.hib3.Hib3MemberDAO.FindBySubject, tx type: nullBind var[0]: 'Param (class java.lang.String): 'sid'->'GrouperSystem', Bind var[1]: 'Param (class java.lang.String): 'type'->'application'Bind var[2]: 'Param (class java.lang.String): 'source'->'g:isa', at edu.internet2.middleware.grouper.hibernate.HibernateSession.<init>(HibernateSession.java:67) at edu.internet2.middleware.grouper.hibernate.HibernateSession._internal_hibernateSession(HibernateSession.java:254) at edu.internet2.middleware.grouper.hibernate.HibernateSession.callbackHibernateSession(HibernateSession.java:383) at edu.internet2.middleware.grouper.hibernate.ByHqlStatic.uniqueResult(ByHqlStatic.java:209) at edu.internet2.middleware.grouper.internal.dao.hib3.Hib3MemberDAO.findBySubject(Hib3MemberDAO.java:140) at edu.internet2.middleware.grouper.MemberFinder.internal_findOrCreateBySubject(MemberFinder.java:202) at edu.internet2.middleware.grouper.MemberFinder.internal_findBySubject(MemberFinder.java:175) at edu.internet2.middleware.grouper.GrouperSession.start(GrouperSession.java:250) at edu.internet2.middleware.grouper.GrouperSession.startRootSession(GrouperSession.java:201) at edu.internet2.middleware.grouper.GrouperSession.startRootSession(GrouperSession.java:219) at edu.internet2.middleware.grouper.misc.GrouperCheckConfig.checkGroups(GrouperCheckConfig.java:439) at edu.internet2.middleware.grouper.misc.GrouperCheckConfig.checkConfig(GrouperCheckConfig.java:410) at edu.internet2.middleware.grouper.misc.GrouperStartup.startup(GrouperStartup.java:82) at edu.internet2.middleware.grouper.internal.dao.hib3.Hib3DAO.<clinit>(Hib3DAO.java:64) at edu.internet2.middleware.grouper.internal.dao.hib3.Hib3DAOFactory.getField(Hib3DAOFactory.java:51) at edu.internet2.middleware.grouper.FieldFinder.findAll(FieldFinder.java:146) at edu.internet2.middleware.grouper.GrouperHelper.getFieldsAsMap(GrouperHelper.java:2820) at edu.internet2.middleware.grouper.ui.SessionInitialiser.init(SessionInitialiser.java:192) at edu.internet2.middleware.grouper.ui.SessionInitialiser.init(SessionInitialiser.java:84) at edu.internet2.middleware.grouper.ui.ErrorFilter.doFilter(ErrorFilter.java:97) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:204) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:172) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:433) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117) at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:548) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:174) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:875) at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665) at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528) at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689) at java.lang.Thread.run(Thread.java:619) 2009-02-18 09:36:18,651: [http-xxx.xxx.xxx.xxx-xxxx-Processor22] FATAL Hib3DAO.<clinit>(68) - unable to initialize hibernate: Database schema ddl is not up to date, or has issues, check logs and config ddl in grouper.properties and run: gsh -registry -check, Problem in HibernateSession: null, Exception in uniqueResult: (class edu.internet2.middleware.grouper.Member), ByHqlStatic, query: 'from Member as m where m.subjectIdDb = :sid and m.subjectSourceIdDb = :source and m.subjectTypeId = :type', cacheable: true, cacheRegion: edu.internet2.middleware.grouper.internal.dao.hib3.Hib3MemberDAO.FindBySubject, tx type: nullBind var[0]: 'Param (class java.lang.String): 'sid'->'GrouperSystem', Bind var[1]: 'Param (class java.lang.String): 'type'->'application'Bind var[2]: 'Param (class java.lang.String): 'source'->'g:isa', java.lang.RuntimeException: Database schema ddl is not up to date, or has issues, check logs and config ddl in grouper.properties and run: gsh -registry -check, Problem in HibernateSession: null, Exception in uniqueResult: (class edu.internet2.middleware.grouper.Member), ByHqlStatic, query: 'from Member as m where m.subjectIdDb = :sid and m.subjectSourceIdDb = :source and m.subjectTypeId = :type', cacheable: true, cacheRegion: edu.internet2.middleware.grouper.internal.dao.hib3.Hib3MemberDAO.FindBySubject, tx type: nullBind var[0]: 'Param (class java.lang.String): 'sid'->'GrouperSystem', Bind var[1]: 'Param (class java.lang.String): 'type'->'application'Bind var[2]: 'Param (class java.lang.String): 'source'->'g:isa', at edu.internet2.middleware.grouper.hibernate.HibernateSession.<init>(HibernateSession.java:67) at edu.internet2.middleware.grouper.hibernate.HibernateSession._internal_hibernateSession(HibernateSession.java:254) at edu.internet2.middleware.grouper.hibernate.HibernateSession.callbackHibernateSession(HibernateSession.java:383) at edu.internet2.middleware.grouper.hibernate.ByHqlStatic.uniqueResult(ByHqlStatic.java:209) at edu.internet2.middleware.grouper.internal.dao.hib3.Hib3MemberDAO.findBySubject(Hib3MemberDAO.java:140) at edu.internet2.middleware.grouper.MemberFinder.internal_findOrCreateBySubject(MemberFinder.java:202) at edu.internet2.middleware.grouper.MemberFinder.internal_findBySubject(MemberFinder.java:175) at edu.internet2.middleware.grouper.GrouperSession.start(GrouperSession.java:250) at edu.internet2.middleware.grouper.GrouperSession.startRootSession(GrouperSession.java:201) at edu.internet2.middleware.grouper.GrouperSession.startRootSession(GrouperSession.java:219) at edu.internet2.middleware.grouper.misc.GrouperCheckConfig.checkGroups(GrouperCheckConfig.java:439) at edu.internet2.middleware.grouper.misc.GrouperCheckConfig.checkConfig(GrouperCheckConfig.java:410) at edu.internet2.middleware.grouper.misc.GrouperStartup.startup(GrouperStartup.java:82) at edu.internet2.middleware.grouper.internal.dao.hib3.Hib3DAO.<clinit>(Hib3DAO.java:64) at edu.internet2.middleware.grouper.internal.dao.hib3.Hib3DAOFactory.getField(Hib3DAOFactory.java:51) at edu.internet2.middleware.grouper.FieldFinder.findAll(FieldFinder.java:146) at edu.internet2.middleware.grouper.GrouperHelper.getFieldsAsMap(GrouperHelper.java:2820) at edu.internet2.middleware.grouper.ui.SessionInitialiser.init(SessionInitialiser.java:192) at edu.internet2.middleware.grouper.ui.SessionInitialiser.init(SessionInitialiser.java:84) at edu.internet2.middleware.grouper.ui.ErrorFilter.doFilter(ErrorFilter.java:97) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:204) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:172) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:433) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117) at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:548) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:174) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:875) at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665) at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528) at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689) at java.lang.Thread.run(Thread.java:619) 2009-02-18 09:36:18,652: [http-xxx.xxx.xxx.xxx-xxxx-Processor22] ERROR StandardWrapperValve.invoke(253) - Servlet.service() for servlet action threw exception java.lang.RuntimeException: Database schema ddl is not up to date, or has issues, check logs and config ddl in grouper.properties and run: gsh -registry -check, Problem in HibernateSession: null, Exception in uniqueResult: (class edu.internet2.middleware.grouper.Member), ByHqlStatic, query: 'from Member as m where m.subjectIdDb = :sid and m.subjectSourceIdDb = :source and m.subjectTypeId = :type', cacheable: true, cacheRegion: edu.internet2.middleware.grouper.internal.dao.hib3.Hib3MemberDAO.FindBySubject, tx type: nullBind var[0]: 'Param (class java.lang.String): 'sid'->'GrouperSystem', Bind var[1]: 'Param (class java.lang.String): 'type'->'application'Bind var[2]: 'Param (class java.lang.String): 'source'->'g:isa', at edu.internet2.middleware.grouper.hibernate.HibernateSession.<init>(HibernateSession.java:67) at edu.internet2.middleware.grouper.hibernate.HibernateSession._internal_hibernateSession(HibernateSession.java:254) at edu.internet2.middleware.grouper.hibernate.HibernateSession.callbackHibernateSession(HibernateSession.java:383) at edu.internet2.middleware.grouper.hibernate.ByHqlStatic.uniqueResult(ByHqlStatic.java:209) at edu.internet2.middleware.grouper.internal.dao.hib3.Hib3MemberDAO.findBySubject(Hib3MemberDAO.java:140) at edu.internet2.middleware.grouper.MemberFinder.internal_findOrCreateBySubject(MemberFinder.java:202) at edu.internet2.middleware.grouper.MemberFinder.internal_findBySubject(MemberFinder.java:175) at edu.internet2.middleware.grouper.GrouperSession.start(GrouperSession.java:250) at edu.internet2.middleware.grouper.GrouperSession.startRootSession(GrouperSession.java:201) at edu.internet2.middleware.grouper.GrouperSession.startRootSession(GrouperSession.java:219) at edu.internet2.middleware.grouper.misc.GrouperCheckConfig.checkGroups(GrouperCheckConfig.java:439) at edu.internet2.middleware.grouper.misc.GrouperCheckConfig.checkConfig(GrouperCheckConfig.java:410) at edu.internet2.middleware.grouper.misc.GrouperStartup.startup(GrouperStartup.java:82) at edu.internet2.middleware.grouper.internal.dao.hib3.Hib3DAO.<clinit>(Hib3DAO.java:64) at edu.internet2.middleware.grouper.internal.dao.hib3.Hib3DAOFactory.getField(Hib3DAOFactory.java:51) at edu.internet2.middleware.grouper.FieldFinder.findAll(FieldFinder.java:146) at edu.internet2.middleware.grouper.GrouperHelper.getFieldsAsMap(GrouperHelper.java:2820) at edu.internet2.middleware.grouper.ui.SessionInitialiser.init(SessionInitialiser.java:192) at edu.internet2.middleware.grouper.ui.SessionInitialiser.init(SessionInitialiser.java:84) at edu.internet2.middleware.grouper.ui.ErrorFilter.doFilter(ErrorFilter.java:97) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:204) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:172) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:433) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117) at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:548) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:174) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:875) at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665) at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528) at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689) at java.lang.Thread.run(Thread.java:619) 2009-02-18 09:36:18,683: [http-xxx.xxx.xxx.xxx-xxxx-Processor22] ERROR PopulateErrorAction.execute(69) - Caught '500' for /grouper-dev/populateIndex.do 2009-02-18 09:39:00,039: [http-xxx.xxx.xxx.xxx-xxxx-Processor18] WARN C3p0JdbcConnectionProvider.init(127) - maxIdle is not available for c3p0 (in subject API: fub) 2009-02-18 09:39:00,043: [http-xxx.xxx.xxx.xxx-xxxx-Processor18] WARN ApiConfig.printConfigOnce(186) - Grouper starting up: version: 1.4.1, build date: null, env: dev grouper.properties read from: /xxxxxxxx/tomcat/identity/webapps/grouper-dev/WEB-INF/classes/grouper.properties Grouper current directory is: /xxxxxxxx/src/grouper/grouper-ui-1.4.1 log4j.properties read from: /xxxxxxxx/tomcat/identity/webapps/grouper-dev/WEB-INF/classes/log4j.properties Grouper is logging to file: /xxxxxxxx/src/grouper/grouper-ui-1.4.1/../grouper-api-1.4.1-SNAPSHOT/logs/grouper_error.log, at min level WARN for package: edu.internet2.middleware.grouper, based on log4j.properties grouper.hibernate.properties: /xxxxxxxx/tomcat/identity/webapps/grouper-dev/WEB-INF/classes/grouper.hibernate.properties grouper.hibernate.properties: grouper@jdbc:postgresql://xxxxxxxx.xxxxxxxx.fu-berlin.de:xxxx/xxxxxxxxdb sources.xml read from: /xxxxxxxx/tomcat/identity/webapps/grouper-dev/WEB-INF/classes/sources.xml sources.xml groupersource id: g:gsa sources.xml jdbc source id: fub: grouper@jdbc:postgresql://xxxxxxxx.xxxxxxxx.fu-berlin.de:xxxx/xxxxxxxxdb 2009-02-18 09:39:01,654: [http-xxx.xxx.xxx.xxx-xxxx-Processor18] ERROR GrouperDdlUtils.retrieveDdlsFromCache(1239) - maybe the grouper_ddl table isnt there... if that is the reason its ok. Problem in HibernateSession: HibernateSession: isNew: true, isReadonly: true, grouperTransactionType: READONLY_NEW, Exception in list: (class edu.internet2.middleware.grouper.app.loader.db.Hib3GrouperDdl), ByCriteriaStatic, persistentClass: 'class edu.internet2.middleware.grouper.app.loader.db.Hib3GrouperDdl', criterions: null', cacheable: null, cacheRegion: null, tx type: null 2009-02-18 09:39:01,683: [http-xxx.xxx.xxx.xxx-xxxx-Processor18] ERROR GrouperDdlUtils.bootstrapHelper(393) - Grouper ddl object type 'Grouper' has dbVersion: 0 and java version: 13 2009-02-18 09:39:17,795: [http-xxx.xxx.xxx.xxx-xxxx-Processor18] ERROR GrouperDdlUtils.bootstrapHelper(393) - Grouper ddl object type 'Subject' has dbVersion: 0 and java version: 1 2009-02-18 09:39:18,269: [http-xxx.xxx.xxx.xxx-xxxx-Processor18] ERROR GrouperDdlUtils.bootstrapHelper(643) - Grouper database schema DDL requires updates (should run script manually and carefully, in sections, verify data before drop statements, backup/export important data before starting, follow change log on confluence, dont run exact same script in multiple envs - generate a new one for each env), script file is: /xxxxxxxx/grouper/ddlScripts/grouperDdl_20090218_09_39_18_268.sql 2009-02-18 09:39:18,519: [http-xxx.xxx.xxx.xxx-xxxx-Processor18] ERROR GrouperCheckConfig.checkGrouperVersion(992) - grouper versions do not match, GrouperVersion.class: 1.4.1, grouper.version.properties: 1.4.1, manifest: null 2009-02-18 09:39:18,522: [http-xxx.xxx.xxx.xxx-xxxx-Processor18] WARN GrouperCheckConfig.checkConfigProperties(1254) - missing from file: grouper.properties, the following properties (which are in the example file: grouper.example.properties): subject.internal.grouperall.name, subject.internal.groupersystem.name 2009-02-18 09:39:18,570: [http-xxx.xxx.xxx.xxx-xxxx-Processor18] ERROR GrouperStartup.startup(107) - Couldnt startup grouper: Database schema ddl is not up to date, or has issues, check logs and config ddl in grouper.properties and run: gsh -registry -check, Problem in HibernateSession: null, Exception in uniqueResult: (class edu.internet2.middleware.grouper.Member), ByHqlStatic, query: 'from Member as m where m.subjectIdDb = :sid and m.subjectSourceIdDb = :source and m.subjectTypeId = :type', cacheable: true, cacheRegion: edu.internet2.middleware.grouper.internal.dao.hib3.Hib3MemberDAO.FindBySubject, tx type: nullBind var[0]: 'Param (class java.lang.String): 'sid'->'GrouperSystem', Bind var[1]: 'Param (class java.lang.String): 'type'->'application'Bind var[2]: 'Param (class java.lang.String): 'source'->'g:isa', java.lang.RuntimeException: Database schema ddl is not up to date, or has issues, check logs and config ddl in grouper.properties and run: gsh -registry -check, Problem in HibernateSession: null, Exception in uniqueResult: (class edu.internet2.middleware.grouper.Member), ByHqlStatic, query: 'from Member as m where m.subjectIdDb = :sid and m.subjectSourceIdDb = :source and m.subjectTypeId = :type', cacheable: true, cacheRegion: edu.internet2.middleware.grouper.internal.dao.hib3.Hib3MemberDAO.FindBySubject, tx type: nullBind var[0]: 'Param (class java.lang.String): 'sid'->'GrouperSystem', Bind var[1]: 'Param (class java.lang.String): 'type'->'application'Bind var[2]: 'Param (class java.lang.String): 'source'->'g:isa', at edu.internet2.middleware.grouper.hibernate.HibernateSession.<init>(HibernateSession.java:67) at edu.internet2.middleware.grouper.hibernate.HibernateSession._internal_hibernateSession(HibernateSession.java:254) at edu.internet2.middleware.grouper.hibernate.HibernateSession.callbackHibernateSession(HibernateSession.java:383) at edu.internet2.middleware.grouper.hibernate.ByHqlStatic.uniqueResult(ByHqlStatic.java:209) at edu.internet2.middleware.grouper.internal.dao.hib3.Hib3MemberDAO.findBySubject(Hib3MemberDAO.java:140) at edu.internet2.middleware.grouper.MemberFinder.internal_findOrCreateBySubject(MemberFinder.java:202) at edu.internet2.middleware.grouper.MemberFinder.internal_findBySubject(MemberFinder.java:175) at edu.internet2.middleware.grouper.GrouperSession.start(GrouperSession.java:250) at edu.internet2.middleware.grouper.GrouperSession.startRootSession(GrouperSession.java:201) at edu.internet2.middleware.grouper.GrouperSession.startRootSession(GrouperSession.java:219) at edu.internet2.middleware.grouper.misc.GrouperCheckConfig.checkGroups(GrouperCheckConfig.java:439) at edu.internet2.middleware.grouper.misc.GrouperCheckConfig.checkConfig(GrouperCheckConfig.java:410) at edu.internet2.middleware.grouper.misc.GrouperStartup.startup(GrouperStartup.java:82) at edu.internet2.middleware.grouper.internal.dao.hib3.Hib3DAO.<clinit>(Hib3DAO.java:64) at edu.internet2.middleware.grouper.internal.dao.hib3.Hib3DAOFactory.getField(Hib3DAOFactory.java:51) at edu.internet2.middleware.grouper.FieldFinder.findAll(FieldFinder.java:146) at edu.internet2.middleware.grouper.GrouperHelper.getFieldsAsMap(GrouperHelper.java:2820) at edu.internet2.middleware.grouper.ui.SessionInitialiser.init(SessionInitialiser.java:192) at edu.internet2.middleware.grouper.ui.SessionInitialiser.init(SessionInitialiser.java:84) at edu.internet2.middleware.grouper.ui.ErrorFilter.doFilter(ErrorFilter.java:97) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:204) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:172) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:433) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117) at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:548) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:174) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:875) at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665) at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528) at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689) at java.lang.Thread.run(Thread.java:619) 2009-02-18 09:39:18,572: [http-xxx.xxx.xxx.xxx-xxxx-Processor18] FATAL Hib3DAO.<clinit>(68) - unable to initialize hibernate: Database schema ddl is not up to date, or has issues, check logs and config ddl in grouper.properties and run: gsh -registry -check, Problem in HibernateSession: null, Exception in uniqueResult: (class edu.internet2.middleware.grouper.Member), ByHqlStatic, query: 'from Member as m where m.subjectIdDb = :sid and m.subjectSourceIdDb = :source and m.subjectTypeId = :type', cacheable: true, cacheRegion: edu.internet2.middleware.grouper.internal.dao.hib3.Hib3MemberDAO.FindBySubject, tx type: nullBind var[0]: 'Param (class java.lang.String): 'sid'->'GrouperSystem', Bind var[1]: 'Param (class java.lang.String): 'type'->'application'Bind var[2]: 'Param (class java.lang.String): 'source'->'g:isa', java.lang.RuntimeException: Database schema ddl is not up to date, or has issues, check logs and config ddl in grouper.properties and run: gsh -registry -check, Problem in HibernateSession: null, Exception in uniqueResult: (class edu.internet2.middleware.grouper.Member), ByHqlStatic, query: 'from Member as m where m.subjectIdDb = :sid and m.subjectSourceIdDb = :source and m.subjectTypeId = :type', cacheable: true, cacheRegion: edu.internet2.middleware.grouper.internal.dao.hib3.Hib3MemberDAO.FindBySubject, tx type: nullBind var[0]: 'Param (class java.lang.String): 'sid'->'GrouperSystem', Bind var[1]: 'Param (class java.lang.String): 'type'->'application'Bind var[2]: 'Param (class java.lang.String): 'source'->'g:isa', at edu.internet2.middleware.grouper.hibernate.HibernateSession.<init>(HibernateSession.java:67) at edu.internet2.middleware.grouper.hibernate.HibernateSession._internal_hibernateSession(HibernateSession.java:254) at edu.internet2.middleware.grouper.hibernate.HibernateSession.callbackHibernateSession(HibernateSession.java:383) at edu.internet2.middleware.grouper.hibernate.ByHqlStatic.uniqueResult(ByHqlStatic.java:209) at edu.internet2.middleware.grouper.internal.dao.hib3.Hib3MemberDAO.findBySubject(Hib3MemberDAO.java:140) at edu.internet2.middleware.grouper.MemberFinder.internal_findOrCreateBySubject(MemberFinder.java:202) at edu.internet2.middleware.grouper.MemberFinder.internal_findBySubject(MemberFinder.java:175) at edu.internet2.middleware.grouper.GrouperSession.start(GrouperSession.java:250) at edu.internet2.middleware.grouper.GrouperSession.startRootSession(GrouperSession.java:201) at edu.internet2.middleware.grouper.GrouperSession.startRootSession(GrouperSession.java:219) at edu.internet2.middleware.grouper.misc.GrouperCheckConfig.checkGroups(GrouperCheckConfig.java:439) at edu.internet2.middleware.grouper.misc.GrouperCheckConfig.checkConfig(GrouperCheckConfig.java:410) at edu.internet2.middleware.grouper.misc.GrouperStartup.startup(GrouperStartup.java:82) at edu.internet2.middleware.grouper.internal.dao.hib3.Hib3DAO.<clinit>(Hib3DAO.java:64) at edu.internet2.middleware.grouper.internal.dao.hib3.Hib3DAOFactory.getField(Hib3DAOFactory.java:51) at edu.internet2.middleware.grouper.FieldFinder.findAll(FieldFinder.java:146) at edu.internet2.middleware.grouper.GrouperHelper.getFieldsAsMap(GrouperHelper.java:2820) at edu.internet2.middleware.grouper.ui.SessionInitialiser.init(SessionInitialiser.java:192) at edu.internet2.middleware.grouper.ui.SessionInitialiser.init(SessionInitialiser.java:84) at edu.internet2.middleware.grouper.ui.ErrorFilter.doFilter(ErrorFilter.java:97) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:204) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:172) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:433) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117) at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:548) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:174) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:875) at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665) at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528) at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689) at java.lang.Thread.run(Thread.java:619) 2009-02-18 09:39:18,573: [http-xxx.xxx.xxx.xxx-xxxx-Processor18] ERROR StandardWrapperValve.invoke(253) - Servlet.service() for servlet action threw exception java.lang.RuntimeException: Database schema ddl is not up to date, or has issues, check logs and config ddl in grouper.properties and run: gsh -registry -check, Problem in HibernateSession: null, Exception in uniqueResult: (class edu.internet2.middleware.grouper.Member), ByHqlStatic, query: 'from Member as m where m.subjectIdDb = :sid and m.subjectSourceIdDb = :source and m.subjectTypeId = :type', cacheable: true, cacheRegion: edu.internet2.middleware.grouper.internal.dao.hib3.Hib3MemberDAO.FindBySubject, tx type: nullBind var[0]: 'Param (class java.lang.String): 'sid'->'GrouperSystem', Bind var[1]: 'Param (class java.lang.String): 'type'->'application'Bind var[2]: 'Param (class java.lang.String): 'source'->'g:isa', at edu.internet2.middleware.grouper.hibernate.HibernateSession.<init>(HibernateSession.java:67) at edu.internet2.middleware.grouper.hibernate.HibernateSession._internal_hibernateSession(HibernateSession.java:254) at edu.internet2.middleware.grouper.hibernate.HibernateSession.callbackHibernateSession(HibernateSession.java:383) at edu.internet2.middleware.grouper.hibernate.ByHqlStatic.uniqueResult(ByHqlStatic.java:209) at edu.internet2.middleware.grouper.internal.dao.hib3.Hib3MemberDAO.findBySubject(Hib3MemberDAO.java:140) at edu.internet2.middleware.grouper.MemberFinder.internal_findOrCreateBySubject(MemberFinder.java:202) at edu.internet2.middleware.grouper.MemberFinder.internal_findBySubject(MemberFinder.java:175) at edu.internet2.middleware.grouper.GrouperSession.start(GrouperSession.java:250) at edu.internet2.middleware.grouper.GrouperSession.startRootSession(GrouperSession.java:201) at edu.internet2.middleware.grouper.GrouperSession.startRootSession(GrouperSession.java:219) at edu.internet2.middleware.grouper.misc.GrouperCheckConfig.checkGroups(GrouperCheckConfig.java:439) at edu.internet2.middleware.grouper.misc.GrouperCheckConfig.checkConfig(GrouperCheckConfig.java:410) at edu.internet2.middleware.grouper.misc.GrouperStartup.startup(GrouperStartup.java:82) at edu.internet2.middleware.grouper.internal.dao.hib3.Hib3DAO.<clinit>(Hib3DAO.java:64) at edu.internet2.middleware.grouper.internal.dao.hib3.Hib3DAOFactory.getField(Hib3DAOFactory.java:51) at edu.internet2.middleware.grouper.FieldFinder.findAll(FieldFinder.java:146) at edu.internet2.middleware.grouper.GrouperHelper.getFieldsAsMap(GrouperHelper.java:2820) at edu.internet2.middleware.grouper.ui.SessionInitialiser.init(SessionInitialiser.java:192) at edu.internet2.middleware.grouper.ui.SessionInitialiser.init(SessionInitialiser.java:84) at edu.internet2.middleware.grouper.ui.ErrorFilter.doFilter(ErrorFilter.java:97) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:204) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:172) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:433) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117) at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:548) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:174) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:875) at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665) at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528) at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689) at java.lang.Thread.run(Thread.java:619) 2009-02-18 09:39:18,600: [http-xxx.xxx.xxx.xxx-xxxx-Processor18] ERROR PopulateErrorAction.execute(69) - Caught '500' for /grouper-dev/populateIndex.do
- RE: [grouper-users] RE: Grouper 1.4.0: Using hooks, (continued)
- RE: [grouper-users] RE: Grouper 1.4.0: Using hooks, Dr. Loris Bennett, 02/05/2009
- RE: [grouper-users] RE: Grouper 1.4.0: Using hooks, Chris Hyzer, 02/05/2009
- RE: [grouper-users] RE: Grouper 1.4.0: Using hooks, Dr. Loris Bennett, 02/09/2009
- RE: [grouper-users] RE: Grouper 1.4.0: Using hooks, Chris Hyzer, 02/09/2009
- RE: [grouper-users] RE: Grouper 1.4.0: Using hooks, Dr. Loris Bennett, 02/09/2009
- RE: [grouper-users] RE: Grouper 1.4.0: Using hooks, Chris Hyzer, 02/09/2009
- RE: [grouper-users] RE: Grouper 1.4.0: Using hooks, Dr. Loris Bennett, 02/09/2009
- RE: [grouper-users] RE: Grouper 1.4.0: Using hooks, Chris Hyzer, 02/09/2009
- RE: [grouper-users] RE: Grouper 1.4.0: Using hooks, Dr. Loris Bennett, 02/11/2009
- RE: [grouper-users] RE: Grouper 1.4.0: Using hooks, Chris Hyzer, 02/11/2009
- RE: [grouper-users] RE: Grouper 1.4.0: Using hooks, Dr. Loris Bennett, 02/18/2009
- RE: [grouper-users] RE: Grouper 1.4.0: Using hooks, Chris Hyzer, 02/18/2009
- RE: [grouper-users] RE: Grouper 1.4.0: Using hooks, Dr. Loris Bennett, 02/23/2009
- RE: [grouper-users] RE: Grouper 1.4.0: Using hooks, Dr. Loris Bennett, 02/23/2009
- RE: [grouper-users] RE: Grouper 1.4.0: Using hooks, Chris Hyzer, 02/23/2009
- RE: [grouper-users] RE: Grouper 1.4.0: Using hooks, Dr. Loris Bennett, 02/23/2009
- RE: [grouper-users] RE: Grouper 1.4.0: Using hooks, Chris Hyzer, 02/24/2009
- RE: [grouper-users] RE: Grouper 1.4.0: Using hooks, Dr. Loris Bennett, 02/26/2009
- RE: [grouper-users] RE: Grouper 1.4.0: Using hooks, Dr. Loris Bennett, 02/09/2009
- RE: [grouper-users] RE: Grouper 1.4.0: Using hooks, Chris Hyzer, 02/05/2009
- RE: [grouper-users] RE: Grouper 1.4.0: Using hooks, Dr. Loris Bennett, 02/05/2009
Archive powered by MHonArc 2.6.16.