Grouper Users - Open Discussion List

[Chris Hyzer <>]

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:]

> 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:]

> > > Sent: Friday, January 30, 2009 7:31 AM

> > > To: Chris Hyzer

> > > Cc: Grouper Users Mailing List

> > > Subject: RE: [grouper-users] RE: Grouper 1.4.0: Using hooks

> > >

> > > OK, I see what I am doing wrong. I have the addType in my

> > > groupPreInsert, whereas the group must already exist before I can

> add

> > > anything to it.

> > >

> > > On Fri, 2009-01-30 at 11:39 +0100, Dr. Loris Bennett wrote:

> > > > Hi Chris,

> > > >

> > > > Using

> > > >

> > > >         fubGroup = GroupTypeFinder.find(groupTypeName);

> > > >

> > > > I can get my custom group type, but when I try to add this with

> > > >

> > > >         g.addType(fubGroup);

> > > >

> > > > I get the error:

> > > >

> > > >         ERROR JDBCExceptionReporter.logExceptions(78) - ERROR:

> insert

> > > or

> > > >         update on table "grouper_groups_types" violates foreign

> key

> > > >         constraint "fk_groups_types_group_uuid"

> > > >           Detail: Key

> > > >         (group_uuid)=(6ea9f650-cdc8-4e69-93df-5b35a87351fe) is

> not

> > > >         present in table "grouper_groups".

> > > >

> > > > Am I doing something wrong here?

> > > >

> > > > TIA

> > > >

> > > > Loris

> > > >

> > > >

> > > > On Thu, 2009-01-29 at 03:21 -0500, Chris Hyzer wrote:

> > > > > >

> > > > > > So the pre-insert would also set the custom attribute, right?

> > > > >

> > > > > OK, didn’t know we were talking about a custom attribute.  It’s

> a

> > > little tricky since the set of attributes is known when the group

> SQL

> > > is written, but you are making changes (I guess to that attribute

> set).

> > > I would think a post insert is the best bet, and you don’t need the

> > > pre, but play around and try different things, and if you cant get

> > > anything to work let me know.

> > > > >

> > > > > Chris

> > > > >

> > > > >

> > > --

> > > Dr. Loris Bennett (Mr.)

> > > Freie Universität Berlin

> > > ZEDAT - Zentraleinrichtung für Datenverarbeitung / Computer Center

> > > Compute & Media Service

> > > Fabeckstr. 32, Room 221

> > > D-14195 Berlin

> > > Tel ++49 30 838 51024

> > > Fax ++49 30 838 56721

> > > Email

> > > Web www.zedat.fu-berlin.de

> >

> --

> Dr. Loris Bennett (Mr.)

> Freie Universität Berlin

> ZEDAT - Zentraleinrichtung für Datenverarbeitung / Computer Center

> Compute & Media Service

> Fabeckstr. 32, Room 221

> D-14195 Berlin

> Tel ++49 30 838 51024

> Fax ++49 30 838 56721

> Email

> Web www.zedat.fu-berlin.de