-
A query for paging is constructed as below
String jpql = "SELECT e FROM Employee e WHERE SUBSTRING(e.name,3,1) != '-' ORDER BY e.name DESC"; TypedQuery<Employee> query = entityManager.createQuery(jpql, Employee.class); query.setFirstResult(1); query.
SQLCODE=-199, SQLSTATE=42601 error from DB2 12 for paging query in Hibernate
Solution verified - Updated on
Request a new translation or translation update
A translation for your language preference does not exist. Click below to request a translation for your selected language.
Issue
Subscriber Exclusive Content
A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.