dev@glassfish.java.net

Re: JDBCRealm allows only one column name to be specified for group memberships table

From: Andreas Loew <Andreas.Loew_at_Sun.COM>
Date: Fri, 07 May 2010 16:19:55 +0200

Anissa Lam schrieb:
> Kumar Jayanti wrote:
>> We also have a parameter :
>>
>> PARAM_GROUP_TABLE_USER_NAME_COLUMN = "group-table-user-name-column";
>>
>> But i guess we maynot have it in V2.X. We have it in V3.
>>
> Admin Console really need your help for usability. If this is a common
> parameter for JDBCRealm, please inform the GUI team about the change so
> this can be presented to user like an attribute, instead of having them
> memorizing the long property name.
> Please file an issue againist admingui if thats the case.

I am wondering why it wouldn't be possible to "rename" the group table
columns to match JDBC realm's expectations by simply creating a view (to
the best of my knowledge, this is a standard SQL feature).

The only drawback is that in standard SQL-92, the view won't be updatable...

BR,

Andreas

-- 
Andreas Loew
Senior Java Architect
Sun Microsystems (Germany)