Hibernate Community • View topic - error in query.getResultList()

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

error in query.getResultList()

Page 1 of 1

[ 3 posts ]

Previous topic | Next topic

Author

Message

kleberdamasco

Post subject: error in query.getResultList()

Posted: Fri Feb 01, 2013 1:17 pm

Newbie

Joined: Fri Feb 01, 2013 1:00 pm
Posts: 2

Hi,

I've two projects with the same implementation, however,
a project I can use the query successfully, the other throws this exception.
In both projects the table contains 10 records.
I use this for lazy dataTable of primefaces.

Code:

public List<Entity> findAllLimit(String namedQuery, Map parameters,Integer startResults, Integer maxPerPage) throws Exception{
      Query query = replaceParameters(namedQuery, parameters);
      query.setFirstResult(startResults);
      query.setMaxResults(maxPerPage);
      List resultList = query.getResultList();
      return resultList;
}

Please i need help!!

thanks.

Top

DavideD

Post subject: Re: error in query.getResultList()

Posted: Mon Feb 04, 2013 7:20 am

Hibernate Team

Joined: Fri Sep 09, 2011 3:18 am
Posts: 295

Hi,
Where is the exception? I can't see it

Top

kleberdamasco

Post subject: Re: error in query.getResultList()

Posted: Mon Feb 04, 2013 7:44 am

Newbie

Joined: Fri Feb 01, 2013 1:00 pm
Posts: 2

davided80 wrote:

Hi,
Where is the exception? I can't see it

Code:

39:50,062 ERROR [stderr] (http-localhost-127.0.0.1-8080-2)    at org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:252)

39:50,063 ERROR [stderr] (http-localhost-127.0.0.1-8080-2)    ... 117 more

39:50,063 ERROR [stderr] (http-localhost-127.0.0.1-8080-2) Caused by: java.sql.SQLException: ResultSet may only be accessed in a forward direction.

I solved with this line into persistence.xml

Code:

<property name="hibernate.jdbc.use_scrollable_resultset"
            value="false" />

Thank you!

Top

Page 1 of 1

[ 3 posts ]

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum