Sometimes query returns only one record

a.pinheiro.s · **Joined:** Tue Mar 15, 2011 2:38 pm **Posts:** 2

Hi, All,

Almost always returns ok, but sometimes the same query returns only one record.
Somebody can help me?

Thanks,
Alexandre Pinheiro

pjw · **Joined:** Sat Dec 26, 2009 12:58 pm **Posts:** 2

a.pinheiro.s wrote:

Almost always returns ok, but sometimes the same query returns only one record.
Somebody can help me?

Could you extend your problem? Does it return different results at the same state of database?

Geissivan · **Joined:** Wed Aug 12, 2009 12:34 pm **Posts:** 2

The query (HQL/Criteria), which surely should return more than one record, is returning only the first. Note that it is being inserted into LIMIT clause in some queries.

The problem occurs more frequently in production, hardly able to simulate in the laboratory.

We use Hibernate 3.2.6 and postgres 8.3.

a.pinheiro.s · **Joined:** Tue Mar 15, 2011 2:38 pm **Posts:** 2

pjw wrote:

a.pinheiro.s wrote:

Almost always returns ok, but sometimes the same query returns only one record.
Somebody can help me?

Could you extend your problem? Does it return different results at the same state of database?

Exactly, different results at the same state of database. Sometimes returns ok (list with many records), sometimes returns only one record (rarely).
Will be a problem in this version of hibernate (Please, see Geissivan's post)?

mmerder · **Posted:** Thu Mar 17, 2011 5:00 am

have you enabled second level cache, especially query cache?