 |
Return to article.
Listing 2. Configuring an SQL login module
<gbean name="workdev-sql-login" class="org.apache.geronimo.security.jaas.LoginModuleGBean">
<attribute name="loginModuleClass">org.apache.geronimo.security.realm.providers.SQLLoginModule</attribute>
<attribute name="serverSide">true</attribute>
<attribute name="options" type="java.util.Properties">
jdbcUser=
jdbcPassword=
jdbcDriver=org.apache.derby.jdbc.EmbeddedDriver
userSelect=SELECT USER_NAME, PASSWORD FROM USERS
groupSelect=SELECT g.GROUP_NAME AS groupname, u.USER_NAME AS username FROM USERS u, GROUPS g WHERE u.GROUP_ID = g.GROUP_ID
jdbcURL=jdbc:derby:WorkingDevelopersDB
</attribute>
<attribute name="loginDomainName">WorkdevRealm</attribute>
</gbean>
|
Return to article.
|  |
|