Effective Way to Pull Large Dataset (over 500,000) in JPA JAXRS

Please I need help with knowing the effective way to pull from DB over 500,000 datasets using JPA. My DB keeps crashing anytime I use the normal SELECT * FROM TABLE_NAME.

NB: I need to pull all data so I use it for computation.

Is this possible with JPA?

I keep getting the below error on Wildfly when I try:

Caused by: javax.transaction.RollbackException: WFLYEJB0447: Transaction 'Local transaction (delegate=TransactionImple < ac, BasicAction: 0:ffff7f000001:-5282a2ce:63184a60:c4 status: ActionStatus.ABORTED >, owner=Local transaction context for provider JBoss JTA transaction provider)' was already rolled back

CODE:

@NamedQuery(name = TitleBasics.FIND_ALL, query = "SELECT t FROM TitleBasics t"),

// EntityManager
public List<TitleBasics> getAllMovies() {
    return em.createNamedQuery(TitleBasics.FIND_ALL, TitleBasics.class)ing
            .getResultList();
}