Update the database correctly

Question

Updated: Link with a video that better exemplifies the situation.

---

I have a big problem, I’m having difficulties to update the database and display the updated data in 2 DataTables different.

I have two pages, one is only visible to office worker Liberacao and the other pro cargo Auditor

Page of the Liberation:

Page of the Auditor

I have a button grabs the selected object in each row. It opens a Dialog which is carried by Bean. On this page that opens I have the button Enviar auditoria and Concluir Auditoria When I Send the Audit it is edited in the database with the cargo who sent it and the status awaiting.

On the Release page in the table Auditorias Recebidas is listed only what was sent by Auditor and has the status Aguardando. And on the Auditor’s page in "Received Audits is only listed what was sent by Liberação and the status for Aguardando.

The problem is as follows, when I have just performed a sending operation and return to the table even after pressing F5 several times the table does not update every time, sometimes it updates and sometimes not. I would like help to be able to update the database correctly:

Here is my method that does the research and fills my List on the Auditor screen:

ManagedBean(name = "controleAuditoriaBean")
@ViewScoped
public class ControleAuditoriaAuditorBean {
private List<SolicitacoesBD> list;
private List<SolicitacoesBD> listEnviados;
@PostConstruct
    public void carregarPesquisa() {

        try {
            SolicitacoesDAO solicitacaoDAO = new SolicitacoesDAO();
            //Se o cargo for "Liberacao" e o Status for "Aguardando" faz a pesquisa.
            list = solicitacaoDAO.listarPorUsuario("Liberacao", "Aguardando");


            System.out.println("Caminho: "+solicitacoesBD.getCaminhoArquivo());
        } catch (RuntimeException ex) {

        }
    }
}

} And here’s the Liberation screen:

@ManagedBean(name = "controleAuditoriaLibBean")
@ViewScoped
public class ControleAuditoriaLiberacaoBean {
    private List<SolicitacoesBD> list;
    private List<SolicitacoesBD> listFiltrada;
    @PostConstruct
    public void carregarPesquisa(){
        try{
            SolicitacoesDAO solicitacaoDAO = new SolicitacoesDAO();
            list = solicitacaoDAO.listarPorUsuario("Auditor", "Aguardando");
            carregarEnviados();
        }catch(RuntimeException ex){
            FacesUtil.adicionarMsgErro("Erro ao tentar listar as Auditorias");
        }
    }
}

Method carrying the Auditor’s Mailed List, the Release is similar:

// mostra na tabela de baixo todos os dados enviados
    public void carregarEnviados() {
        try {
            SolicitacoesDAO solicitacaoDAO = new SolicitacoesDAO();
            listEnviados = solicitacaoDAO.listarEnviados("Auditor");

        } catch (RuntimeException ex) {
            FacesUtil.adicionarMsgErro("Erro ao tentar listar as Auditorias");
        }
    }

---

Updated

Doing some tests I realized that the list is not loaded "immediately" with the database data, it takes around 15 seconds until the list is filled with the current data, even the @postConstruct and the <f:event> with preRenderView does not update the table immediately. And yet I still can’t find where the problem is.

Answer 1

I tried several things and nothing went right, the only solution I found that worked was to take the dataTable Audits Sent from the same page as received and created a Bean separate to manage these pages. I don’t know why but it worked.

UPDATED The problem was solved with only one commit in the method that does the research, before I did not commit the bank queries.