users@glassfish.java.net

Getting JDBC authentication to work

From: <glassfish_at_javadesktop.org>
Date: Thu, 03 May 2007 13:02:09 PDT

I'm using build 44 and I'm struggling to get JDBC authentication working.

The administrative website has fields for "User Table", "Username Column", "Password Column", "Group Table", "Group Name Column", and "Assign Group".

My database has:
a UserAccount table with UserID(PK) and Username columns,
a Role table with RoleID(PK) and RoleName columns,
and a RoleMembership table with UserID(FK) and RoleID(FK) columns.

I don't understand how glassfish can lookup the group a user belongs to without knowing about the junction table and I don't see how I can tell glassfish about this junction table given the form fields available.

Any ideas?
[Message sent by forum member 'atappert' (atappert)]

http://forums.java.net/jive/thread.jspa?messageID=215437