In SJSAS 9.0 I used net.java.glassfish.security.auth.realm.jdbc.JDBCRealm for
authentication as it supports the following use properties:
It's useful because my databases use many-to-many relationships for users and
SELECT id FROM user WHERE email = ? AND password = ?
SELECT usergroup.name FROM user, usergroup, user_usergroup WHERE user.email = ?
_id = user.id AND user_usergroup.usergroup_id = usergroup.id
Those properties allowed me to use the above queries to define how user
names/passwords and user group names should be checked.
Can these properties be added to
com.sun.enterprise.security.auth.login.JDBCLoginModule ? Looking at the source
for JDBCLoginModule it would be a fairly simple extension.
In 9.1 using net.java.glassfish.security.auth.realm.jdbc.JDBCRealm has become
more difficult as com.sun.gjc.spi.DataSource for which it needs to function are
no longer packaged in $