@Transactional
	public int createSession(int userId, Date date) {

		Query q = em.createQuery("update CoreSession t "
				+ "set t.sessionCloseTime = :sessionCloseTime, "
				+ "    t.isActive = 0 " + "where t.isActive = 1 "
				+ "  and t.userId = :userId");
		q.setParameter("sessionCloseTime", date);
		q.setParameter("userId", userId);
		q.executeUpdate();

		CoreSession coreSession = new CoreSession();
		try {
			coreSession.setUserId(userId);
			coreSession.setIsActive(1);
			coreSession.setSessionStartTime(date);
			coreSession.setLastRequestTime(date);
			em.persist(coreSession);
			//em.flush();
			//em.refresh(coreSession);

		} catch (Exception e) {
			System.out.println(e.getMessage());
		}

		return coreSession.getId();
	}