java - MySQL query in spring-security.xml for authorization -

q1. > how check whether following 2 queries executed or not in spring-security.xml ?

 <jdbc-user-service data-source-ref="datasource"           users-by-username-query=             "select user_login_name username,user_password password,user_type_id,role_id sox_audit.sox_users user_login_name=? , user_password=?"             authorities-by-username-query=             "select user_login_name username,role_id authority sox_audit.sox_users user_login_name ='sriram@gmail.com' , user_password='12345' "/> 

i can able login hardcoded values , give authorities per user type. cannot selecting records db.

can me out in this.

enable logs jdbcdaoimpl implements userdetailsservice. like:

log4j.logger.org.springframework.security.core.userdetails.jdbc.jdbcdaoimpl=debug 

if doesn't work, add breakpoints on class , debug on runtime.