Getting large number of records from database without having primary cache + Separate entity manager

ExportTableSnapshotsServiceImpl.java

public List<Employee> findAllEmployee(int offset, int limit) {
		String employeeQuery = String.format("select distinct r from %s r left join r.owner as u", Employee.class);
		employeeQuery += " WHERE r.status =  :status ORDER BY r.lastModification DESC";
		EntityManagerFactory factory = Persistence.createEntityManagerFactory("employee_ds");
		EntityManager shortLiveEntityManager = factory.createEntityManager();
		TypedQuery<RISIndex> query = shortLiveEntityManager.createQuery(employeeQuery, Employee.class).setFlushMode(FlushModeType.COMMIT);;
		query.setParameter("status", Status.APPROVED);
		query.setHint(QueryHints.QUERY_RESULTS_CACHE, false);
		query.setHint(QueryHints.CACHE_USAGE, CacheUsage.CheckCacheThenDatabase);
		List<RISIndex> resultList = query
				.setFirstResult(offset) // offset
				.setMaxResults(limit + offset) // limit
				.getResultList();
		shortLiveEntityManager.close();
		return resultList;
	}

Annotate with TransactionManagementType.BEAN , so that the container (Weblogic, etc) timeout will not be occurred (default timeout of 30 seconds)

@Stateless
@Slf4j
@TransactionManagement(TransactionManagementType.BEAN)
public class ExportTableSnapshotsServiceImpl implements ExportTableSnapshotsService {