JBoss

Authenticate against a database

<login-module code="org.jboss.security.auth.spi.DatabaseServerLoginModule" flag="required">
  <module-option name="unauthenticatedIdentity">guest</module-option>
  <module-option name="dsJndiName">java:jdbc/dataSource</module-option>
  <module-option name="principalsQuery">
    SELECT password FROM users WHERE username = ?</module-option>
  <module-option name="rolesQuery">
    SELECT 'role-name', 'Roles' FROM users WHERE username = ?</module-option>
  <module-option name="hashAlgorithm">MD5</module-option>
  <module-option name="hashEncoding">hex</module-option>
  <module-option name="ignorePasswordCase">true</module-option>
</login-module>

[Source: https://community.jboss.org/wiki/DatabaseServerLoginModule ]