TypedQuery<Account> query = em.createNamedQuery("select * from account").setFirstResult(start);

if(length > 0)

{

query.setMaxResult(lenght);

}

Caused by: org.hibernate.exception.GenericJDBCException: could not execute query

	at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:47)

	at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:109)

	at org.hibernate.loader.Loader.doList(Loader.java:2614)

	at org.hibernate.loader.Loader.doList(Loader.java:2594)

	at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2423)

	at org.hibernate.loader.Loader.list(Loader.java:2418)

	at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:501)

	at org.hibernate.hql.internal.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:371)

	at org.hibernate.engine.query.spi.HQLQueryPlan.performList(HQLQueryPlan.java:216)

	at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1326)

	at org.hibernate.internal.QueryImpl.list(QueryImpl.java:87)

	at org.hibernate.jpa.internal.QueryImpl.list(QueryImpl.java:606)

	at org.hibernate.jpa.internal.QueryImpl.getResultList(QueryImpl.java:483)

	... 132 more

Caused by: java.sql.SQLException: Invalid operation for result set type TYPE_FORWARD_ONLY

	at org.mariadb.jdbc.internal.queryresults.resultset.MariaSelectResultSet.absolute(MariaSelectResultSet.java:680)

	at org.jboss.jca.adapters.jdbc.WrappedResultSet.absolute(WrappedResultSet.java:163)

	at org.hibernate.loader.Loader.advance(Loader.java:1825)

	at org.hibernate.loader.Loader.getResultSet(Loader.java:2120)

	at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1899)

	at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1875)

	at org.hibernate.loader.Loader.doQuery(Loader.java:919)

	at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:336)

	at org.hibernate.loader.Loader.doList(Loader.java:2611)

	... 142 more