Olá a todos!
Bem, estou com um pequeno problema… deixa eu ver se eu consigo me explicar… tenho duas entidades, AtividadeDiaria e Empresa, sendo que a primeira tem uma referência ManyToOne com a segunda. Acontece que, quando eu faço uma busca para retornar uma lista da entidade, ela diz que não consgue achar a outra entidade(a qual ela faz referência) com aquele id específico.
Já verifiquei as minhas referências no banco de dados e na aplicação, e estão todas certas. Também verifiquei os próprios dados, e vi que o elemento que ele reclama não existir está no banco. Alguém tem alguma idéia?? Abaixo estou enviando minhas classes e o stacktrace:
Classe AtividadeDiaria:
@IAtividadeDiariaPeriodoValidator(groups = AtividadeDiaria.IPeriodoGroup.class)
@Entity
@Table(name = "rdat", schema = "met_intrametha_rdiario")
@TableGenerator(name = "AtividadeDiariaTG", schema = "met_intrametha_rdiario", table = "chavep5", pkColumnName = "tabela", valueColumnName = "ultimo", allocationSize = 1, pkColumnValue = "rdat")
@NamedQueries({
@NamedQuery(name = AtividadeDiaria.NQ_OBTER_POR_RD, query = "SELECT a FROM AtividadeDiaria a WHERE a.rd = ?1"),
@NamedQuery(name = AtividadeDiaria.NQ_OBTER_QUANTIDADE_DE_ATIVIDADES_DIARIAS_POR_CLIENTE, query = "SELECT COUNT(*) FROM AtividadeDiaria a WHERE a.empresa = ?1"),
@NamedQuery(name = AtividadeDiaria.NQ_OBTER_ATIVIDADE_DIARIA_POR_ATIVIDADE, query = "SELECT COUNT(*) FROM AtividadeDiaria a WHERE a.atividade = ?1"),
@NamedQuery(name = AtividadeDiaria.NQ_OBTER_ATIVIDADES_DIARIAS_POR_COLABORADOR_E_PERIODO_ORDENADA_GRUPO, query = "SELECT a FROM AtividadeDiaria a WHERE a.colaborador = ?1 AND CONCAT(a.data.ano, a.data.mes) BETWEEN ?2 AND ?3 ORDER BY a.empresa.grupo, a.atividade.descricao" ),
@NamedQuery(name = AtividadeDiaria.NQ_OBTER_ATIVIDADES_DIARIAS_POR_COLABORADOR_E_PERIODO_ORDENADA_TIPO_DE_ATIVIDADE, query = "SELECT a FROM AtividadeDiaria a WHERE a.colaborador = ?1 AND CONCAT(a.data.ano, a.data.mes) BETWEEN ?2 AND ?3 ORDER BY a.atividade.descricao" ),
@NamedQuery(name = AtividadeDiaria.NQ_OBTER_ATIVIDADES_DIARIAS_POR_COLABORADOR_E_PERIODO, query = "SELECT a FROM AtividadeDiaria a WHERE a.colaborador = ?1 AND CONCAT(a.data.ano, a.data.mes) BETWEEN ?2 AND ?3 ORDER BY a.empresa.fantasia, a.atividade.descricao" )})
public class AtividadeDiaria implements Serializable {
/**
*
*/
private static final long serialVersionUID = 1L;
public static final String NQ_OBTER_POR_RD = "AtividadeDiaria.obterPorRd";
public static final String NQ_OBTER_QUANTIDADE_DE_ATIVIDADES_DIARIAS_POR_CLIENTE = "AtividadeDiaria.obterQuantidadeDeAtividadesDiariasPorCliente";
public static final String NQ_OBTER_ATIVIDADE_DIARIA_POR_ATIVIDADE = "AtividadeDiaria.obterAtividadeDiariaPorAtividade";
public static final String NQ_OBTER_ATIVIDADES_DIARIAS_POR_COLABORADOR_E_PERIODO = "AtividadeDiaria.obterAtividadesDiariasPorColaboradorEPeriodo";
public static final String NQ_OBTER_ATIVIDADES_DIARIAS_POR_COLABORADOR_E_PERIODO_ORDENADA_TIPO_DE_ATIVIDADE = "AtividadeDiaria.obterAtividadesDiariasPorColaboradorEPeriodoOrdenadaTipoDeAtividade";
public static final String NQ_OBTER_ATIVIDADES_DIARIAS_POR_COLABORADOR_E_PERIODO_ORDENADA_GRUPO = "AtividadeDiaria.obterAtividadesDiariasPorColaboradorEPeriodoOrdenadaGrupo";
public interface IPeriodoGroup {
}
@GroupSequence({ Default.class, AtividadeDiaria.IPeriodoGroup.class })
public interface IAtividadeDiariaGroupSequence {
}
@Id
@GeneratedValue(strategy = GenerationType.TABLE, generator = "AtividadeDiariaTG")
@Column(name = "codseq", unique = true, nullable = false)
private Integer id;
@NotNull
@ManyToOne
@JoinColumn(name = "cod_rd", nullable = false)
private TempoDiario rd;
@NotNull
@ManyToOne
@JoinColumn(name = "codcol", nullable = false)
private Colaborador colaborador;
@Embedded
@Valid
@NotNull
@AttributeOverrides({
@AttributeOverride(name = "dia", column = @Column(name = "dia", nullable = false)),
@AttributeOverride(name = "mes", column = @Column(name = "mes", nullable = false)),
@AttributeOverride(name = "ano", column = @Column(name = "ano", nullable = false)) })
private DiaMesEAno data;
@NotNull
@ManyToOne
@JoinColumn(name = "cod_cli", nullable = false)
private Empresa empresa;
//@NotNull
//@ManyToOne
//@JoinColumn(name = "cod_sis", nullable = false)
//private Sistema sistema;
@NotNull
@ManyToOne
@JoinColumn(name = "cod_ati", nullable = false)
private Atividade atividade;
@Embedded
@IHora
@AttributeOverride(name = "horaEMinuto", column = @Column(name = "tempog", nullable = false))
private Hora horasAlocadas = new Hora("");
@Temporal(TemporalType.TIMESTAMP)
@Column(name = "ultatu", nullable = false)
private Date ultimaAtualizacao;
@NotNull
@ManyToOne
@JoinColumn(name = "respatu", nullable = false)
private Responsavel responsavelAtualizacao;
@NotNull
@ManyToOne
@JoinColumn(name = "respinc", nullable = false)
private Responsavel responsavelInclusao;
@Temporal(TemporalType.TIMESTAMP)
@Column(name = "dtinc", nullable = false)
private Date dataInclusao;
@Embedded
@NotNull
@IHora
@AttributeOverride(name = "horaEMinuto", column = @Column(name = "ini_ativ", nullable = false))
private Hora inicio = new Hora("");
@Embedded
@IHora
@AttributeOverride(name = "horaEMinuto", column = @Column(name = "fim_ativ", nullable = false))
private Hora fim = new Hora("");Classe Empresa:
@Entity
//@Cache(usage = CacheConcurrencyStrategy.NONSTRICT_READ_WRITE)
@Table(name = "empresa", schema = "met_intrametha_rdiario")
@TableGenerator(name = "EmpresaTG", schema = "met_intrametha_rdiario", table = "chavep5", pkColumnName = "tabela", valueColumnName = "ultimo", allocationSize = 1, pkColumnValue="EMPRESA")
@NamedQueries( {
@NamedQuery(name = Empresa.NQ_OBTER_TODOS, query = "SELECT e FROM Empresa e ORDER BY e.codigo"),
@NamedQuery(name = Empresa.NQ_OBTER_MONITORADOS, query = "SELECT e FROM Empresa e WHERE e.tempoGastoMonitorado = true"),
@NamedQuery(name = Empresa.NQ_OBTER_GRUPOS, query = "SELECT grupo FROM Empresa e ORDER BY e.codigo"),
@NamedQuery(name = Empresa.NQ_PROCURAR_POR_FANTASIA_LIKE, query = "SELECT e FROM Empresa e WHERE UPPER(e.fantasia) LIKE UPPER(?1) ORDER BY e.fantasia"),
@NamedQuery(name = Empresa.NQ_PROCURAR_POR_EMPRESA, query = "SELECT e FROM Empresa e WHERE e.id = ?1"),
@NamedQuery(name = Empresa.NQ_PROCURAR_POR_CODIGO_E_ID_DIFERENTE, query = "SELECT e FROM Empresa e WHERE e.codigo = ?1 AND e.id <> ?2"),
@NamedQuery(name = Empresa.NQ_PROCURAR_POR_CODIGO, query = "SELECT e FROM Empresa e WHERE e.codigo = ?1") })
public class Empresa implements Serializable{
/**
*
*/
private static final long serialVersionUID = 1L;
public static final String NQ_OBTER_TODOS = "Empresa.obterTodos";
public static final String NQ_OBTER_MONITORADOS = "Empresa.obterMonitorados";
public static final String NQ_OBTER_GRUPOS = "Empresa.obterGrupos";
public static final String NQ_PROCURAR_POR_FANTASIA_LIKE = "Empresa.procurarPorFantasiaLike";
public static final String NQ_PROCURAR_POR_EMPRESA = "Empresa.procurarPorEmpresa";
public static final String NQ_PROCURAR_POR_CODIGO = "Empresa.procurarPorCodigo";
public static final String NQ_PROCURAR_POR_CODIGO_E_ID_DIFERENTE = "Empresa.procurarPorCodigoEIdDiferente";
@Id
@GeneratedValue(strategy = GenerationType.TABLE, generator = "EmpresaTG")
@Column(name = "codseq", unique = true, nullable = false)
private Integer id;
@OneToMany(mappedBy = "empresa")
private List<EmpresaPessoa> empresasPessoas;
@OneToMany(mappedBy = "empresa")
private List<EmpresaColaborador> empresasColaboradores;
@OneToMany(mappedBy = "empresa")
@OrderBy(value = "dataInclusao DESC, codigo")
private List<Correspondencia> correspondencias;
@OneToMany(mappedBy = "empresa")
@OrderBy(value = "dataInclusao DESC, codigo")
private List<OrdemDeServico> ordems;
@NotNull
@Pattern(regexp = ".*[^\\s].*", message = "Codigo não pode estar em branco")
@Column(name = "codigo", nullable = false)
private String codigo;
@NotNull
@Pattern(regexp = ".*[^\\s].*", message = "Fanstasia não pode estar em branco")
@Column(name = "fantasia", nullable = false)
private String fantasia;
@NotNull
@Pattern(regexp = ".*[^\\s].*", message = "Grupo não pode estar em branco")
@Column(name = "grupo", nullable = true)
private String grupo;
@Temporal(TemporalType.TIMESTAMP)
@Column(name = "ultatu", nullable = false)
private Date ultimaAtualizacao;
@ManyToOne
@JoinColumn(name = "respatu", nullable = false)
private Responsavel responsavelAtualizacao;
@Column(name = "razao", nullable = true)
private String razao;
@Column(name = "endereco", nullable = true)
private String endereco;
@Column(name = "numero", nullable = true)
private String numero;
@Column(name = "complemento", nullable = true)
private String complemento;
@Column(name = "bairro", nullable = true)
private String bairro;
@Column(name = "cidade", nullable = true)
private String cidade;
@Column(name = "estado", nullable = true)
private String estado;
@Column(name = "cep", nullable = true)
private String cep;
@OneToMany(mappedBy = "cliente", cascade = CascadeType.ALL)
private List<TelefoneEmpresa> telefones;
@Embedded
@AttributeOverride(name = "numero", column = @Column(name = "cnpj"))
private CNPJ cnpj;
@Column(name = "pagweb", nullable = true)
private String paginaWeb;
@Column(name = "email", nullable = true)
private String email;
@Column(name = "tempo_gasto_monitorado", nullable = true)
private Boolean tempoGastoMonitorado;
@Temporal(TemporalType.TIMESTAMP)
@Column(name = "dtinc", nullable = false)
private Date dataInclusao;
@ManyToOne
@JoinColumn(name = "respinc", nullable = false)
private Responsavel responsavelInclusao;StackTrace:
17/03/2011 10:12:58 com.sun.faces.application.ActionListenerImpl processAction
GRAVE: javax.persistence.EntityNotFoundException: Unable to find net.metha.registroDiarioJSF.model.entity.Empresa with id 5
javax.faces.el.EvaluationException: javax.persistence.EntityNotFoundException: Unable to find net.metha.registroDiarioJSF.model.entity.Empresa with id 5
at javax.faces.component.MethodBindingMethodExpressionAdapter.invoke(MethodBindingMethodExpressionAdapter.java:102)
at com.sun.faces.application.ActionListenerImpl.processAction(ActionListenerImpl.java:102)
at javax.faces.component.UICommand.broadcast(UICommand.java:387)
at org.ajax4jsf.component.AjaxViewRoot.processEvents(AjaxViewRoot.java:329)
at org.ajax4jsf.component.AjaxViewRoot.broadcastEventsForPhase(AjaxViewRoot.java:304)
at org.ajax4jsf.component.AjaxViewRoot.processPhase(AjaxViewRoot.java:261)
at org.ajax4jsf.component.AjaxViewRoot.processApplication(AjaxViewRoot.java:474)
at com.sun.faces.lifecycle.InvokeApplicationPhase.execute(InvokeApplicationPhase.java:82)
at com.sun.faces.lifecycle.Phase.doPhase(Phase.java:100)
at com.sun.faces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:118)
at javax.faces.webapp.FacesServlet.service(FacesServlet.java:265)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.ajax4jsf.webapp.BaseXMLFilter.doXmlFilter(BaseXMLFilter.java:206)
at org.ajax4jsf.webapp.BaseFilter.handleRequest(BaseFilter.java:290)
at org.ajax4jsf.webapp.BaseFilter.processUploadsAndHandleRequest(BaseFilter.java:388)
at org.ajax4jsf.webapp.BaseFilter.doFilter(BaseFilter.java:515)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at net.metha.registroDiarioJSF.servlet.filter.JPASessionFilter.doFilter(JPASessionFilter.java:28)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:563)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:857)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
at java.lang.Thread.run(Unknown Source)
Caused by: javax.persistence.EntityNotFoundException: Unable to find net.metha.registroDiarioJSF.model.entity.Empresa with id 5
at org.hibernate.ejb.Ejb3Configuration$Ejb3EntityNotFoundDelegate.handleEntityNotFound(Ejb3Configuration.java:132)
at org.hibernate.event.def.DefaultLoadEventListener.load(DefaultLoadEventListener.java:233)
at org.hibernate.event.def.DefaultLoadEventListener.proxyOrLoad(DefaultLoadEventListener.java:285)
at org.hibernate.event.def.DefaultLoadEventListener.onLoad(DefaultLoadEventListener.java:152)
at org.hibernate.impl.SessionImpl.fireLoad(SessionImpl.java:1080)
at org.hibernate.impl.SessionImpl.internalLoad(SessionImpl.java:1028)
at org.hibernate.type.EntityType.resolveIdentifier(EntityType.java:623)
at org.hibernate.type.EntityType.resolve(EntityType.java:431)
at org.hibernate.engine.TwoPhaseLoad.initializeEntity(TwoPhaseLoad.java:140)
at org.hibernate.loader.Loader.initializeEntitiesAndCollections(Loader.java:898)
at org.hibernate.loader.Loader.doQuery(Loader.java:773)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:270)
at org.hibernate.loader.Loader.doList(Loader.java:2449)
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2192)
at org.hibernate.loader.Loader.list(Loader.java:2187)
at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:452)
at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:363)
at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:196)
at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1258)
at org.hibernate.impl.QueryImpl.list(QueryImpl.java:102)
at org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:241)
at net.metha.registroDiarioJSF.repositorio.TempoDiarioRepositorio.obterAtividadesDiariasPorColaboradorEPeriodo(TempoDiarioRepositorio.java:379)
at net.metha.registroDiarioJSF.controller.TempoPorClienteController.obterListaPorCliente(TempoPorClienteController.java:261)
at net.metha.registroDiarioJSF.controller.TempoPorClienteController.listaPorCliente(TempoPorClienteController.java:247)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.apache.el.parser.AstValue.invoke(AstValue.java:191)
at org.apache.el.MethodExpressionImpl.invoke(MethodExpressionImpl.java:276)
at com.sun.facelets.el.TagMethodExpression.invoke(TagMethodExpression.java:68)
at javax.faces.component.MethodBindingMethodExpressionAdapter.invoke(MethodBindingMethodExpressionAdapter.java:88)
... 32 more
17/03/2011 10:12:58 com.sun.faces.lifecycle.InvokeApplicationPhase execute
AVISO: #{tempoPorClienteController.listaPorCliente}: javax.persistence.EntityNotFoundException: Unable to find net.metha.registroDiarioJSF.model.entity.Empresa with id 5
javax.faces.FacesException: #{tempoPorClienteController.listaPorCliente}: javax.persistence.EntityNotFoundException: Unable to find net.metha.registroDiarioJSF.model.entity.Empresa with id 5
at com.sun.faces.application.ActionListenerImpl.processAction(ActionListenerImpl.java:118)
at javax.faces.component.UICommand.broadcast(UICommand.java:387)
at org.ajax4jsf.component.AjaxViewRoot.processEvents(AjaxViewRoot.java:329)
at org.ajax4jsf.component.AjaxViewRoot.broadcastEventsForPhase(AjaxViewRoot.java:304)
at org.ajax4jsf.component.AjaxViewRoot.processPhase(AjaxViewRoot.java:261)
at org.ajax4jsf.component.AjaxViewRoot.processApplication(AjaxViewRoot.java:474)
at com.sun.faces.lifecycle.InvokeApplicationPhase.execute(InvokeApplicationPhase.java:82)
at com.sun.faces.lifecycle.Phase.doPhase(Phase.java:100)
at com.sun.faces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:118)
at javax.faces.webapp.FacesServlet.service(FacesServlet.java:265)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.ajax4jsf.webapp.BaseXMLFilter.doXmlFilter(BaseXMLFilter.java:206)
at org.ajax4jsf.webapp.BaseFilter.handleRequest(BaseFilter.java:290)
at org.ajax4jsf.webapp.BaseFilter.processUploadsAndHandleRequest(BaseFilter.java:388)
at org.ajax4jsf.webapp.BaseFilter.doFilter(BaseFilter.java:515)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at net.metha.registroDiarioJSF.servlet.filter.JPASessionFilter.doFilter(JPASessionFilter.java:28)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:563)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:857)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
at java.lang.Thread.run(Unknown Source)
Caused by: javax.faces.el.EvaluationException: javax.persistence.EntityNotFoundException: Unable to find net.metha.registroDiarioJSF.model.entity.Empresa with id 5
at javax.faces.component.MethodBindingMethodExpressionAdapter.invoke(MethodBindingMethodExpressionAdapter.java:102)
at com.sun.faces.application.ActionListenerImpl.processAction(ActionListenerImpl.java:102)
... 31 more
Caused by: javax.persistence.EntityNotFoundException: Unable to find net.metha.registroDiarioJSF.model.entity.Empresa with id 5
at org.hibernate.ejb.Ejb3Configuration$Ejb3EntityNotFoundDelegate.handleEntityNotFound(Ejb3Configuration.java:132)
at org.hibernate.event.def.DefaultLoadEventListener.load(DefaultLoadEventListener.java:233)
at org.hibernate.event.def.DefaultLoadEventListener.proxyOrLoad(DefaultLoadEventListener.java:285)
at org.hibernate.event.def.DefaultLoadEventListener.onLoad(DefaultLoadEventListener.java:152)
at org.hibernate.impl.SessionImpl.fireLoad(SessionImpl.java:1080)
at org.hibernate.impl.SessionImpl.internalLoad(SessionImpl.java:1028)
at org.hibernate.type.EntityType.resolveIdentifier(EntityType.java:623)
at org.hibernate.type.EntityType.resolve(EntityType.java:431)
at org.hibernate.engine.TwoPhaseLoad.initializeEntity(TwoPhaseLoad.java:140)
at org.hibernate.loader.Loader.initializeEntitiesAndCollections(Loader.java:898)
at org.hibernate.loader.Loader.doQuery(Loader.java:773)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:270)
at org.hibernate.loader.Loader.doList(Loader.java:2449)
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2192)
at org.hibernate.loader.Loader.list(Loader.java:2187)
at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:452)
at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:363)
at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:196)
at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1258)
at org.hibernate.impl.QueryImpl.list(QueryImpl.java:102)
at org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:241)
at net.metha.registroDiarioJSF.repositorio.TempoDiarioRepositorio.obterAtividadesDiariasPorColaboradorEPeriodo(TempoDiarioRepositorio.java:379)
at net.metha.registroDiarioJSF.controller.TempoPorClienteController.obterListaPorCliente(TempoPorClienteController.java:261)
at net.metha.registroDiarioJSF.controller.TempoPorClienteController.listaPorCliente(TempoPorClienteController.java:247)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.apache.el.parser.AstValue.invoke(AstValue.java:191)
at org.apache.el.MethodExpressionImpl.invoke(MethodExpressionImpl.java:276)
at com.sun.facelets.el.TagMethodExpression.invoke(TagMethodExpression.java:68)
at javax.faces.component.MethodBindingMethodExpressionAdapter.invoke(MethodBindingMethodExpressionAdapter.java:88)
... 32 more
10:12:58,987 ERROR BaseXMLFilter:227 - Exception in the filter chain
javax.servlet.ServletException: #{tempoPorClienteController.listaPorCliente}: javax.persistence.EntityNotFoundException: Unable to find net.metha.registroDiarioJSF.model.entity.Empresa with id 5
at javax.faces.webapp.FacesServlet.service(FacesServlet.java:277)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.ajax4jsf.webapp.BaseXMLFilter.doXmlFilter(BaseXMLFilter.java:206)
at org.ajax4jsf.webapp.BaseFilter.handleRequest(BaseFilter.java:290)
at org.ajax4jsf.webapp.BaseFilter.processUploadsAndHandleRequest(BaseFilter.java:388)
at org.ajax4jsf.webapp.BaseFilter.doFilter(BaseFilter.java:515)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at net.metha.registroDiarioJSF.servlet.filter.JPASessionFilter.doFilter(JPASessionFilter.java:28)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:563)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:857)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
at java.lang.Thread.run(Unknown Source)
Caused by: javax.faces.FacesException: #{tempoPorClienteController.listaPorCliente}: javax.persistence.EntityNotFoundException: Unable to find net.metha.registroDiarioJSF.model.entity.Empresa with id 5
at com.sun.faces.application.ActionListenerImpl.processAction(ActionListenerImpl.java:118)
at javax.faces.component.UICommand.broadcast(UICommand.java:387)
at org.ajax4jsf.component.AjaxViewRoot.processEvents(AjaxViewRoot.java:329)
at org.ajax4jsf.component.AjaxViewRoot.broadcastEventsForPhase(AjaxViewRoot.java:304)
at org.ajax4jsf.component.AjaxViewRoot.processPhase(AjaxViewRoot.java:261)
at org.ajax4jsf.component.AjaxViewRoot.processApplication(AjaxViewRoot.java:474)
at com.sun.faces.lifecycle.InvokeApplicationPhase.execute(InvokeApplicationPhase.java:82)
at com.sun.faces.lifecycle.Phase.doPhase(Phase.java:100)
at com.sun.faces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:118)
at javax.faces.webapp.FacesServlet.service(FacesServlet.java:265)
... 22 more
Caused by: javax.faces.el.EvaluationException: javax.persistence.EntityNotFoundException: Unable to find net.metha.registroDiarioJSF.model.entity.Empresa with id 5
at javax.faces.component.MethodBindingMethodExpressionAdapter.invoke(MethodBindingMethodExpressionAdapter.java:102)
at com.sun.faces.application.ActionListenerImpl.processAction(ActionListenerImpl.java:102)
... 31 more
Caused by: javax.persistence.EntityNotFoundException: Unable to find net.metha.registroDiarioJSF.model.entity.Empresa with id 5
at org.hibernate.ejb.Ejb3Configuration$Ejb3EntityNotFoundDelegate.handleEntityNotFound(Ejb3Configuration.java:132)
at org.hibernate.event.def.DefaultLoadEventListener.load(DefaultLoadEventListener.java:233)
at org.hibernate.event.def.DefaultLoadEventListener.proxyOrLoad(DefaultLoadEventListener.java:285)
at org.hibernate.event.def.DefaultLoadEventListener.onLoad(DefaultLoadEventListener.java:152)
at org.hibernate.impl.SessionImpl.fireLoad(SessionImpl.java:1080)
at org.hibernate.impl.SessionImpl.internalLoad(SessionImpl.java:1028)
at org.hibernate.type.EntityType.resolveIdentifier(EntityType.java:623)
at org.hibernate.type.EntityType.resolve(EntityType.java:431)
at org.hibernate.engine.TwoPhaseLoad.initializeEntity(TwoPhaseLoad.java:140)
at org.hibernate.loader.Loader.initializeEntitiesAndCollections(Loader.java:898)
at org.hibernate.loader.Loader.doQuery(Loader.java:773)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:270)
at org.hibernate.loader.Loader.doList(Loader.java:2449)
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2192)
at org.hibernate.loader.Loader.list(Loader.java:2187)
at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:452)
at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:363)
at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:196)
at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1258)
at org.hibernate.impl.QueryImpl.list(QueryImpl.java:102)
at org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:241)
at net.metha.registroDiarioJSF.repositorio.TempoDiarioRepositorio.obterAtividadesDiariasPorColaboradorEPeriodo(TempoDiarioRepositorio.java:379)
at net.metha.registroDiarioJSF.controller.TempoPorClienteController.obterListaPorCliente(TempoPorClienteController.java:261)
at net.metha.registroDiarioJSF.controller.TempoPorClienteController.listaPorCliente(TempoPorClienteController.java:247)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.apache.el.parser.AstValue.invoke(AstValue.java:191)
at org.apache.el.MethodExpressionImpl.invoke(MethodExpressionImpl.java:276)
at com.sun.facelets.el.TagMethodExpression.invoke(TagMethodExpression.java:68)
at javax.faces.component.MethodBindingMethodExpressionAdapter.invoke(MethodBindingMethodExpressionAdapter.java:88)
... 32 more
17/03/2011 10:12:58 com.sun.faces.lifecycle.Phase doPhase
GRAVE: JSF1054: (Phase ID: INVOKE_APPLICATION 5, View ID: /restrito/tempoporcliente.xhtml) Exception thrown during phase execution: javax.faces.event.PhaseEvent[source=com.sun.faces.lifecycle.LifecycleImpl@374ed5]
17/03/2011 10:12:58 org.apache.catalina.core.StandardWrapperValve invoke
GRAVE: Servlet.service() for servlet Faces Servlet threw exception
javax.persistence.EntityNotFoundException: Unable to find net.metha.registroDiarioJSF.model.entity.Empresa with id 5
at org.hibernate.ejb.Ejb3Configuration$Ejb3EntityNotFoundDelegate.handleEntityNotFound(Ejb3Configuration.java:132)
at org.hibernate.event.def.DefaultLoadEventListener.load(DefaultLoadEventListener.java:233)
at org.hibernate.event.def.DefaultLoadEventListener.proxyOrLoad(DefaultLoadEventListener.java:285)
at org.hibernate.event.def.DefaultLoadEventListener.onLoad(DefaultLoadEventListener.java:152)
at org.hibernate.impl.SessionImpl.fireLoad(SessionImpl.java:1080)
at org.hibernate.impl.SessionImpl.internalLoad(SessionImpl.java:1028)
at org.hibernate.type.EntityType.resolveIdentifier(EntityType.java:623)
at org.hibernate.type.EntityType.resolve(EntityType.java:431)
at org.hibernate.engine.TwoPhaseLoad.initializeEntity(TwoPhaseLoad.java:140)
at org.hibernate.loader.Loader.initializeEntitiesAndCollections(Loader.java:898)
at org.hibernate.loader.Loader.doQuery(Loader.java:773)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:270)
at org.hibernate.loader.Loader.doList(Loader.java:2449)
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2192)
at org.hibernate.loader.Loader.list(Loader.java:2187)
at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:452)
at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:363)
at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:196)
at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1258)
at org.hibernate.impl.QueryImpl.list(QueryImpl.java:102)
at org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:241)
at net.metha.registroDiarioJSF.repositorio.TempoDiarioRepositorio.obterAtividadesDiariasPorColaboradorEPeriodo(TempoDiarioRepositorio.java:379)
at net.metha.registroDiarioJSF.controller.TempoPorClienteController.obterListaPorCliente(TempoPorClienteController.java:261)
at net.metha.registroDiarioJSF.controller.TempoPorClienteController.listaPorCliente(TempoPorClienteController.java:247)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.apache.el.parser.AstValue.invoke(AstValue.java:191)
at org.apache.el.MethodExpressionImpl.invoke(MethodExpressionImpl.java:276)
at com.sun.facelets.el.TagMethodExpression.invoke(TagMethodExpression.java:68)
at javax.faces.component.MethodBindingMethodExpressionAdapter.invoke(MethodBindingMethodExpressionAdapter.java:88)
at com.sun.faces.application.ActionListenerImpl.processAction(ActionListenerImpl.java:102)
at javax.faces.component.UICommand.broadcast(UICommand.java:387)
at org.ajax4jsf.component.AjaxViewRoot.processEvents(AjaxViewRoot.java:329)
at org.ajax4jsf.component.AjaxViewRoot.broadcastEventsForPhase(AjaxViewRoot.java:304)
at org.ajax4jsf.component.AjaxViewRoot.processPhase(AjaxViewRoot.java:261)
at org.ajax4jsf.component.AjaxViewRoot.processApplication(AjaxViewRoot.java:474)
at com.sun.faces.lifecycle.InvokeApplicationPhase.execute(InvokeApplicationPhase.java:82)
at com.sun.faces.lifecycle.Phase.doPhase(Phase.java:100)
at com.sun.faces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:118)
at javax.faces.webapp.FacesServlet.service(FacesServlet.java:265)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.ajax4jsf.webapp.BaseXMLFilter.doXmlFilter(BaseXMLFilter.java:206)
at org.ajax4jsf.webapp.BaseFilter.handleRequest(BaseFilter.java:290)
at org.ajax4jsf.webapp.BaseFilter.processUploadsAndHandleRequest(BaseFilter.java:388)
at org.ajax4jsf.webapp.BaseFilter.doFilter(BaseFilter.java:515)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at net.metha.registroDiarioJSF.servlet.filter.JPASessionFilter.doFilter(JPASessionFilter.java:28)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:563)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:857)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
at java.lang.Thread.run(Unknown Source)Alguém saberia qual é o problema??? Já tentei várias coisas, mas até agora nada…