@Override
public UserProfile checkAuthenticationDB(String username, String password) throws Exception {
SqlSession session = SqlMapConfig.getSqlSession(false);
try {
// Run command ----------------------------------------------------
Map<String, Object> map = new HashMap<String, Object>();
map.put("username", username);
map.put("password", password);
UserProfile userProfile = session.selectOne("UserProfile.getUserProfile", map);
session.commit();
return userProfile;
} catch (Exception e) {
session.rollback();
throw e;
} finally {
session.clearCache();
session.close();
session = null;
}
}
public void clearCache() {
session.clearCache();
}
