Hibernate version: 3

I want to limit the Query with the user name imposed with JDBCRealm.

public List getUserRoleList(String in_usernm)
{
Session session = null;
try
{
session = HibernateUtil.currentSession();
Query query =
session.createQuery(
"select UserRole from com.erp.hibernate.user.UserRole where
UserRole.usernm = :usernm UserRole order by
UserRole.messageKey");
query.setString("usernm", in_usernm);

How to get the login username within Hibernate?

Should it be passed from JSP?

<%
List userRoleList = UserRoleService.getInstance().getUserRoleList(request.getRemoteUser());
request.setAttribute("userRole", userRoleList);
%>

However, request.getRemoteUser() gives nothing.

The output from Query is blank.

Thanks

From : http://java.sun.com/j2ee/sdk_1.3/techdo ... Principal()

getRemoteUser()
Returns the login of the user making this request, if the user has been authenticated, or null if the user has not been authenticated.

Are you positive the user has been authenticated?