Hello, when I change an object and save it, I'm experiencing problems with slowness and at times it even completely blocks my application. By persisting I am returning only this information, but I could not identify what it could be.
stmt.GooGooStatementCache - Multiply prepared statement! select itemgrupo0_.id as id1_92_0_, itemgrupo0_.name as name2_92_0_, itemgrupo0_.observacao as observac3_92_0_, itemgrupo0_.parent_id as parent_i6_92_0_, itemgrupo0_.situacao the situation4_92_0_, itemgrupo0_.last_update as last_upd5_92_0_ from item_grupo itemgrupo0_ where itemgrupo0_.id =?
Can this information indicate something I'm doing and it's wrong? Could this be causing the slowness in my process to save?
Code that causes the error:
@Transactional
@RequiredPermission(resource = Resources.NOTA_ENTRADA, operation = Operations.UPDATE)
public String updateCreditos() {
try {
if (this.getBean().getItens() == null) {
return null;
}
for (NotaFiscalItem it : this.getBean().getItens()) {
if (it.getId() != null && it.getId() < 0) {
it.setId(null);
}
if (!this.getItemH().zeraValores(it)) {
return "./entrada_itens.jsf";
}
if (it.getId() == null) {
this.notaItemBC.insert(it);
} else {
this.notaItemBC.update(it);
}
}
} catch (Exception e) {
CriareLog.log(e);
this.getMessageContext().add(e.getMessage(), SeverityType.ERROR);
this.notaItemBC.rollback();
return null;
}
this.endConversation();
return this.getPreviousView();
}
@Override
@Transactional
public T update(T entity) {
return getEntityManager().merge(entity);
}