rich:dataTable executing too much queries and opening more than 1 Hibernate Session

[rimolive]

Hello all,

I found a problem using <rich:dataTable>. When I use these attributes:

<rich:dataTable id="enderecoList" var="endereco" value="#{enderecoBean.resultList}" rendered="#{not empty enderecoBean.resultList}">
...
</rich:dataTable>

it is opening 8 Hibernate sessions and executing the same query 8 times. However, if I remove rendered attribute it will open 1 Session and execute the query only once. Is it a known bug?

I tested with Richfaces 4.1.

Regards,

Ricardo

[iabughosh]

could you post your getResultList java code ?

[rimolive]

Here is my code:

public List<T> getResultList()  {
        CriteriaQuery<T> cq = entityManager.getCriteriaBuilder().createQuery(Endereco.class);
        cq.select(cq.from(type));
        return entityManager.createQuery(cq).getResultList();
}

[iabughosh]

accessing the database through getters considered as a bad approach, because the getter will be called more than you think, so i suggest filling your result list somewhere else, like bean construct method, ex:

for JSF beans :

@PostConstruct

public void init() {

     CriteriaQuery<T> cq = entityManager.getCriteriaBuilder().createQuery(Endereco.class);

     cq.select(cq.from(type));

     setResultList(entityManager.createQuery(cq).getResultList());

}

for CDI beans :

@Inject

public void init() {

     CriteriaQuery<T> cq = entityManager.getCriteriaBuilder().createQuery(Endereco.class);

     cq.select(cq.from(type));

     setResultList(entityManager.createQuery(cq).getResultList());

}

regards.