About getResultList

manual

Running JPA Queries

Explains how to use JPA to run Java Persistence Query Language (JPQL) queries.... one result object is expected. Query.getResultList getResultList() Query's method Execute a SELECT query and return ...

 
api-jpa

getResultList()

Execute a SELECT query and return the query results as a typed List.(Method of javax.persistence.TypedQuery)

 
api-jpa

getResultList()

Execute a SELECT query and return the query results as an untyped List.(Method of javax.persistence.Query)

 
manual

SELECT clause (JPQL / Criteria API)

Explains how to use the SELECT clause and projections in a JPA/JPQL query.... ) ; List<Country> results = query. getResultList getResultList() TypedQuery's method Execute a SELECT query and ... ) ; List<String> results = query. getResultList getResultList() TypedQuery's method Execute a ...

 
issue

NPE on em.createQuery(query).getResultList()

(JPA2 support getting better but still not quite there, excellent progress regardless). Difficult to see what's going on because of obfuscation, but it didn't look like this exact issue was reported yet (seemed to differ from the other reported and fixed NPEs): ... at com.objectdb.jpa.JpaQuery.getResultList(JpaQuery.java:627) at ... query. setParameter ( "p" , e ) . getResultList ( ) ; em. getTransaction ( ...

 
issue

Another NPE on em.createQuery(query).getResultList()

Related to #51 that was tested against 2.2.7 and marked as fixed in 2.2.8. Running the same test case against 2.2.8 now results in: ... at com.objectdb.jpa.JpaQuery.getResultList(JpaQuery.java:627) at ...

 
manual

Setting and Tuning of JPA Queries

Explains various JPA query settings - result range, flush and lock.... query execution if invoked before a query is run using getResultList getResultList() TypedQuery's method Execute a SELECT query and ...

 
manual

CRUD Database Operations with JPA

Shows how to use Java/JPA to store, retrieve, update & delete.... ) ; List<Point> results = query. getResultList getResultList() TypedQuery's method Execute a SELECT query and ...

 
manual

JPA Criteria API Queries

Explains how to use the JPA Criteria API (CriteriaBuilder, CriteriaQuery, etc.) to build JPQL like queries.... ) ; List<Country> results = query. getResultList getResultList() Query's method Execute a SELECT query and return ... ) ; List<Country> results = query. getResultList getResultList() Query's method Execute a SELECT ...

 
forum_thread

Missing Data on Retrieval (0, null values)

I try  to export all Objects in an Flatfile-Hiearchy (.csv). But only the first exported Table contains all necessary Data. Most of the others  contains all  Object-Rows', but most Values of the Columns are missing. With a  em.clear() inside the Loop, all tables are exported correctly but the Enity-Keys do not match. I can't get the point - what am i doing wrong?   emf = Persistence.createEntityManagerFactory(dbFile); em = emf.createEntityManager(); ... = em.createQuery("SELECT q  FROM "+tableName+" "+n).getResultList();   exportToCSV(resultList); }   ... = em.createQuery("SELECT p  FROM Person p").getResultList();     -> resultlist1   OK ... = em.createQuery("SELECT d  FROM Document d" ).getResultList(); -> resultlist2  Bad - many null and 0 Values. ...