Skip to main content

skip to main content

developerWorks  >  Open source | Java technology  >

Build a secure enterprise infrastructure with Geronimo

A real-world demonstration of Geronimo's robust security features

developerWorks

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.