Major Description
In JDBCBackingEngineFactory is in line 49 the following code:
String selectUsersQuery = (String) options.get(JDBCLoginModule.PASSWORD_QUERY);
PASSWORD_QUERY is ""SELECT PASSWORD FROM USERS WHERE USERNAME=?
but selectUserQuery should be "SELECT USERNAME FROM USERS"
looks like a mismatch.
The correct code should be:
String selectUsersQuery = (String) options.get(JDBCLoginModule.USER_QUERY);
in JDBCLoginModule.java:
public static final String USER_QUERY = "query.user"
and you need a separate selectPasswordQuery attribute.