Hello,

I have the following Dao Implementation for user login,

@Override
public Users validateUser(Users user) {
            return entityManager.createQuery( "from Users where username = '" + user.getUsername() + "' and password = '"+user.getPassword()+"'", Users.class )
                .getSingleResult();
        
    }

This results in NoResultException exception when no match is found in database.

My question is, Shouldn't this return a null? Why is it throwing an exception?

Note: This is happening only when a match is not found in the database. Otherwise if a match is found, it returns a User object, and everything works fine.

Can someone please help?

cysun wrote:

It's just how JPA API is designed.

So, does that mean that I should always use try/catch when I use entityManager to query database and manually return a null from the catch block?

The reason for asking this is that, I have not seen try/catch in the example code, so I got confused whether is there any work around to try/catch?