Hi Charles, The existing JdbcRealm is not too flexible for this type of customization. Your best bet is to probably look at the existing source code [1], and override doGetAuthenticationInfo to work with your particular query.
HTH, Les [1] http://svn.apache.org/repos/asf/shiro/trunk/core/src/main/java/org/apache/shiro/realm/jdbc/JdbcRealm.java On Thu, Mar 8, 2012 at 9:34 AM, Charles Syperski <csyper...@dupage88.net> wrote: > I have a table that I am trying to authenticate against using a JdbcRealm > that has multiple fields that the user can use for their username can anyone > tell me if this is possible? > > I basically want the user to be able to login using their username, alias or > email address. > > jdbcRealm.authenticationQuery = SELECT password FROM users WHERE (username = > ? or userAlias = ? or emailAddress = ?) and accountStatus = '1' > > Thanks in advance
