0

In Eclipselink, when I use @SqlResultSetMappings and I use Query Hint eclipselink.cursor, the console shows me the following exception:

Caused By: java.lang.IllegalArgumentException: Query null, query hint eclipselink.cursor is not valid for this type of query.
at org.eclipse.persistence.internal.jpa.QueryHintsHandler$CursorHint.applyToDatabaseQuery(QueryHintsHandler.java:1640)
at org.eclipse.persistence.internal.jpa.QueryHintsHandler$Hint.apply(QueryHintsHandler.java:367)
at org.eclipse.persistence.internal.jpa.QueryHintsHandler$Hint.apply(QueryHintsHandler.java:345)
at org.eclipse.persistence.internal.jpa.QueryHintsHandler.apply(QueryHintsHandler.java:172)
at org.eclipse.persistence.internal.jpa.QueryImpl.setHintInternal(QueryImpl.java:763)
Truncated. see log file for complete stacktrace

The code is:

@SqlResultSetMapping(
    name = "resultSetMapping",
    entities = @EntityResult(entityClass = Entity.class))

Query q = em.createNativeQuery(sql, "resultSetMapping";
q.setHint(QueryHints.CURSOR, HintValues.TRUE);
q.getSingleResult();

Why cannot I use SqlResultSetMappings with eclipselink.cursor?

Improve this question
6
  • Cursors aren't supported on the ResultSetMappingQuery that lies underneath native SQL queries. Commented Jun 22, 2017 at 16:07
  • If I use em.createQuery with JPQL the error is the same. why? Commented Jun 23, 2017 at 13:36
  • The query must return an entity type (select e from Employee e), not raw data like "select e.id from Employee e". Commented Jun 23, 2017 at 17:59
  • But I can do a query like select a, b.date from EntityA a, (select a.date, a.id.key from EntityB a) b where a.key = 1234 and b.key = a.key, that will return a List with a Entity and a date. This query can be used with cursor hint. Commented Jun 26, 2017 at 11:42
  • I think I found the why. eclipse.org/forums/… Commented Jun 30, 2017 at 12:44
Related questions
3
Java EE SqlResultSetMapping Syntax
6
JPA @SqlResultSetMapping not able to handle empty sql result to be mapped to empty POJO - instead an exception is thrown
0
@SqlResultSetMapping thows strange exception with Spring JPA
Load 7 more related questions Show fewer related questions

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.