Grouper Users - Open Discussion List

[Scott Koranda <>]

> 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