Im using the jbosssx serurity modul for my web login. And have teste it with some basic database and sql. But when I'm trying to move it to a prodution database and use a slidy more "advance" SQL it will not work.
The basic sql(from login-config.xml):<module-option name = "principalsQuery">select password from users where username=?</module-option> The slidely more "advance": <module-option name = "principalsQuery">select pri.password from m_bruger bru, m_primed pri where pri.uid = bru.uid and bru.wdk=?</module-option> I know my sql is working and returning just the password. But still I get this error, when trying to looking in to me webmodul:11:26:26,433 INFO [STDOUT] javax.security.auth.login.FailedLoginException: No matching username found in Principals What im I missing or can't I use a query like the one I use in the principals query View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3876109#3876109 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3876109 ------------------------------------------------------- This SF.Net email is sponsored by: NEC IT Guy Games. Get your fingers limbered up and give it your best shot. 4 great events, 4 opportunities to win big! Highest score wins.NEC IT Guy Games. Play to win an NEC 61 plasma display. Visit http://www.necitguy.com/?r=20 _______________________________________________ JBoss-user mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/jboss-user
