Grouper Users - Open Discussion List

[Chris Hyzer <>]

Yes, sorry, ldappc is not compatible with grouper 1.4.0.
I did change ldappc to use grouper1.4 in branch: 
ldappc_branch_grouper_1_4_20081204
Though Im not setup with maven to build it yet...

As to when there will be a distribution of ldappc, I think the answer is 
hopefully soon...  Tom B and Tom Z, can you comment?

Chris

> -----Original Message-----
> From: Scott Koranda 
> [mailto:]
> Sent: Tuesday, January 13, 2009 1:03 PM
> To: 
> 
> Subject: Re: [grouper-users] error using ldappc 1.1.1 with Grouper
> 1.4.0
>
> > Hi,
> >
> > I am using version 1.1.1 of ldappc with Grouper API 1.4.0 and
> > I am seeing this error:
> >
> > Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException:
> Unknown column 'hib3groupd0_.uuid' in 'field list'
> >
> > I am using a copy of grouper.hibernate.properties that appears
> > to work fine with the API when driven via gsh, the UI, or via
> > web services.
> >
> > I am using mysql-connector-java-5.1.7-bin.jar.
> >
> > Any ideas?
> >
>
> I edited the grouper.hibernate.properties file being used by
> ldappc and set
>
> hibernate.show_sql                    = true
>
> So this is the SQL that ldappc is calling and which is
> failing:
>
> select hib3groupd0_.id as id3_, hib3groupd0_.uuid as uuid3_,
> hib3groupd0_.parent_stem as parent3_3_,
> hib3groupd0_.creator_id as creator4_3_,
> hib3groupd0_.create_time as create5_3_,
> hib3groupd0_.modifier_id as modifier6_3_,
> hib3groupd0_.modify_time as modify7_3_,
> hib3groupd0_.create_source as create8_3_,
> hib3groupd0_.modify_source as modify9_3_ from grouper_groups
> hib3groupd0_ where hib3groupd0_.uuid=?
>
> Looking at the grouper_groups table in MySQL I see this:
>
> mysql> describe grouper_groups;
> +--------------------------+--------------+------+-----+---------+-----
> --+
> | Field                    | Type         | Null | Key | Default |
> Extra |
> +--------------------------+--------------+------+-----+---------+-----
> --+
> | id                       | varchar(128) | NO   | PRI | |       |
> | parent_stem              | varchar(128) | NO   | MUL | |       |
> | creator_id               | varchar(128) | NO   | MUL | |       |
> | create_time              | bigint(20)   | NO   | MUL | |       |
> | modifier_id              | varchar(128) | YES  | MUL | NULL |       |
> | modify_time              | bigint(20)   | YES  | MUL | NULL |       |
> | hibernate_version_number | bigint(20)   | YES  |     | NULL |       |
> +--------------------------+--------------+------+-----+---------+-----
> --+
> 7 rows in set (0.03 sec)
>
> Obviously there are columns in the SQL query that do not
> appear in the table definition.
>
> Is ldappc 1.1.1 not compatible with Grouper 1.4.0?
>
> If not, when is a version of ldappc expected that will be
> compatible?
>
> Thanks,
>
> Scott