JdbcRealm authenticationQuery with mutliple user fields

[Charles Syperski]

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