Using ScrollableResults and hibernate

Question

It's my first time trying this, but I'm getting the following error:

The result set is closed

while trying to use ScrollableResults.

@Override
public void associarTodosConteudos(LoteTransferenciaTO lotetransferencia, UsuarioDepartamentoTO udLogado, Long idDepartamento, Long idUsuario) {
    // Lista os objetos controlados fluxo
    ScrollableResults objetos = this.persistencia.listarConteudosSR(idDepartamento, idUsuario);

    while (objetos.next()) {
        ContentTO content = (ContentTO) objetos.get(0);

        this.negocioVinculoLote.adicionarNoLoteTransferencia(lotetransferencia, content, udLogado);
    }
}

Hi, what's the type of this persistencia object? I think the problem is there... — Eldius, May 28 '15 at 19:49

score 1 · Answer 1 · edited Jul 02 '15 at 06:45

1

ScrollableResults is closed once this method this.persistencia.listarConteudosSR(idDepartamento, idUsuario); is exited.

Try to iterate over the ScrollableResults inside this.persistencia.listarConteudosSR(idDepartamento, idUsuario); method. it should work.

for more details refer https://docs.jboss.org/hibernate/orm/3.3/reference/en/html/batch.html

edited Jul 02 '15 at 06:45

riccardo.cardin

7,971
5
57
106

answered Jul 02 '15 at 06:00

user3435860

59
1
5

Using ScrollableResults and hibernate

1 Answers1