Pessoal nao acho o erro de maneira alguma...nao abre a tela para exibir os dados

well · Julho 17, 2009, 8:28am

Quando cllico do link para mostrar os quartos cadastrados da esse erro:

HTTP Status 500 -

type Exception report

message

description The server encountered an internal error () that prevented it from fulfilling this request.

exception

javax.servlet.ServletException: /quartos.jsp(22,12) ‘#{QuartoFace.cachedQuartos}’ Error reading ‘cachedQuartos’ on type projetoPousada.faces.QuartoFace
javax.faces.webapp.FacesServlet.service(FacesServlet.java:256)

root cause

org.apache.jasper.el.JspELException: /quartos.jsp(22,12) ‘#{QuartoFace.cachedQuartos}’ Error reading ‘cachedQuartos’ on type projetoPousada.faces.QuartoFace
org.apache.jasper.el.JspValueExpression.getValue(JspValueExpression.java:107)
javax.faces.component.UIData.getValue(UIData.java:582)
javax.faces.component.UIData.getDataModel(UIData.java:1063)
javax.faces.component.UIData.setRowIndex(UIData.java:417)
com.sun.faces.renderkit.html_basic.TableRenderer.encodeBegin(TableRenderer.java:85)
javax.faces.component.UIComponentBase.encodeBegin(UIComponentBase.java:788)
javax.faces.component.UIData.encodeBegin(UIData.java:879)
javax.faces.component.UIComponent.encodeAll(UIComponent.java:884)
javax.faces.render.Renderer.encodeChildren(Renderer.java:137)
javax.faces.component.UIComponentBase.encodeChildren(UIComponentBase.java:812)
javax.faces.component.UIComponent.encodeAll(UIComponent.java:886)
javax.faces.component.UIComponent.encodeAll(UIComponent.java:892)
com.sun.faces.application.ViewHandlerImpl.doRenderView(ViewHandlerImpl.java:245)
com.sun.faces.application.ViewHandlerImpl.renderView(ViewHandlerImpl.java:176)
com.sun.faces.lifecycle.RenderResponsePhase.execute(RenderResponsePhase.java:106)
com.sun.faces.lifecycle.LifecycleImpl.phase(LifecycleImpl.java:251)
com.sun.faces.lifecycle.LifecycleImpl.render(LifecycleImpl.java:144)
javax.faces.webapp.FacesServlet.service(FacesServlet.java:245)

root cause

org.hibernate.hql.ast.QuerySyntaxException: Quarto is not mapped [from Quarto quart]
org.hibernate.hql.ast.util.SessionFactoryHelper.requireClassPersister(SessionFactoryHelper.java:181)
org.hibernate.hql.ast.tree.FromElementFactory.addFromElement(FromElementFactory.java:110)
org.hibernate.hql.ast.tree.FromClause.addFromElement(FromClause.java:93)
org.hibernate.hql.ast.HqlSqlWalker.createFromElement(HqlSqlWalker.java:277)
org.hibernate.hql.antlr.HqlSqlBaseWalker.fromElement(HqlSqlBaseWalker.java:3056)
org.hibernate.hql.antlr.HqlSqlBaseWalker.fromElementList(HqlSqlBaseWalker.java:2945)
org.hibernate.hql.antlr.HqlSqlBaseWalker.fromClause(HqlSqlBaseWalker.java:688)
org.hibernate.hql.antlr.HqlSqlBaseWalker.query(HqlSqlBaseWalker.java:544)
org.hibernate.hql.antlr.HqlSqlBaseWalker.selectStatement(HqlSqlBaseWalker.java:281)
org.hibernate.hql.antlr.HqlSqlBaseWalker.statement(HqlSqlBaseWalker.java:229)
org.hibernate.hql.ast.QueryTranslatorImpl.analyze(QueryTranslatorImpl.java:251)
org.hibernate.hql.ast.QueryTranslatorImpl.doCompile(QueryTranslatorImpl.java:183)
org.hibernate.hql.ast.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:134)
org.hibernate.engine.query.HQLQueryPlan.(HQLQueryPlan.java:101)
org.hibernate.engine.query.HQLQueryPlan.(HQLQueryPlan.java:80)
org.hibernate.engine.query.QueryPlanCache.getHQLQueryPlan(QueryPlanCache.java:94)
org.hibernate.impl.AbstractSessionImpl.getHQLQueryPlan(AbstractSessionImpl.java:156)
org.hibernate.impl.AbstractSessionImpl.createQuery(AbstractSessionImpl.java:135)
org.hibernate.impl.SessionImpl.createQuery(SessionImpl.java:1650)
projetoPousadas.dao.GenericDAO.getPureList(GenericDAO.java:67)
projetoPousadas.dao.QuartoDAO.getQuartos(QuartoDAO.java:40)
projetoPousada.faces.QuartoFace.getCachedQuartos(QuartoFace.java:32)
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
java.lang.reflect.Method.invoke(Method.java:597)
javax.el.BeanELResolver.getValue(BeanELResolver.java:62)
javax.el.CompositeELResolver.getValue(CompositeELResolver.java:53)
com.sun.faces.el.FacesCompositeELResolver.getValue(FacesCompositeELResolver.java:64)
org.apache.el.parser.AstValue.getValue(AstValue.java:118)
org.apache.el.ValueExpressionImpl.getValue(ValueExpressionImpl.java:186)
org.apache.jasper.el.JspValueExpression.getValue(JspValueExpression.java:101)
javax.faces.component.UIData.getValue(UIData.java:582)
javax.faces.component.UIData.getDataModel(UIData.java:1063)
javax.faces.component.UIData.setRowIndex(UIData.java:417)
com.sun.faces.renderkit.html_basic.TableRenderer.encodeBegin(TableRenderer.java:85)
javax.faces.component.UIComponentBase.encodeBegin(UIComponentBase.java:788)
javax.faces.component.UIData.encodeBegin(UIData.java:879)
javax.faces.component.UIComponent.encodeAll(UIComponent.java:884)
javax.faces.render.Renderer.encodeChildren(Renderer.java:137)
javax.faces.component.UIComponentBase.encodeChildren(UIComponentBase.java:812)
javax.faces.component.UIComponent.encodeAll(UIComponent.java:886)
javax.faces.component.UIComponent.encodeAll(UIComponent.java:892)
com.sun.faces.application.ViewHandlerImpl.doRenderView(ViewHandlerImpl.java:245)
com.sun.faces.application.ViewHandlerImpl.renderView(ViewHandlerImpl.java:176)
com.sun.faces.lifecycle.RenderResponsePhase.execute(RenderResponsePhase.java:106)
com.sun.faces.lifecycle.LifecycleImpl.phase(LifecycleImpl.java:251)
com.sun.faces.lifecycle.LifecycleImpl.render(LifecycleImpl.java:144)
javax.faces.webapp.FacesServlet.service(FacesServlet.java:245)

note The full stack trace of the root cause is available in the Apache Tomcat/6.0.18 logs.

Aki esta QuartoDAO

package projetoPousadas.dao;

import java.util.List;
import projetoPousadas.entity.Quarto;

/**
 *
 * @author Rafael
 */
public class QuartoDAO extends GenericDAO {
    
    
    public QuartoDAO(){
    }
    
    public int addQuarto(Quarto quart){
        salvarAlterarPojo(quart);
        return quart.getCodigo();
    }

    public void removerQuarto(Quarto quarto){
        removerPojo(quarto);
    }

    public void alterarQuarto(Quarto quarto){
        salvarAlterarPojo(quarto);
    }

    public Quarto getQuarto(int quartoCodigo){
        Quarto quart = getPojo(Quarto.class, quartoCodigo);
        return  quart;
    }

    public List<Quarto> getQuartos(){
        return getPureList(Quarto.class,"from Quarto quart");
    }
}

Aki esta a GenericDAo

package projetoPousadas.dao;

import java.io.Serializable;
import java.util.List;
import org.hibernate.Query;
import org.hibernate.Session;
import projetoPousadas.entity.HibernateUtil;

/**
 *
 * @author Rafael
 */
public abstract class GenericDAO {
     private static final long serialVesionUID = 1L;



     public GenericDAO(){
     }

     protected Session getSession(){
         return HibernateUtil.getInstance().getSession();
     }

     protected  void salvarAlterarPojo(Serializable Pojo){
         Session ses = getSession();
         ses.saveOrUpdate(Pojo);
         ses.getTransaction().commit();
         ses.close();
     }

     protected <T extends Serializable> T getPojo(Class<T> preocurarClass, Serializable key){
         Session ses = getSession();
         Serializable toReturn = (Serializable) ses.get(preocurarClass, key);
         ses.getTransaction().commit();
         ses.close();
         return (T) toReturn;
     }

     protected void removerPojo(Serializable PojoParaRemover){
         Session ses = getSession();
         ses.delete(PojoParaRemover);
         ses.getTransaction().commit();
         ses.close();

     }

     protected  Serializable getPurePojo(String query, Object... params) {
         Session ses = getSession();
         Query qr = ses.createQuery(query);
         for (int i = 1; i <= params.length; i++) {
            qr.setParameter(1, params [i-1]);
        }
         Object toReturn  = qr.uniqueResult();
         ses.getTransaction().commit();
         ses.close();
         return  (Serializable) toReturn;
     }

     protected  <T extends Serializable> List<T> getPureList(Class<T> classToCast,String query, Object... params) {
         Session ses = getSession();
         Query qr = ses.createQuery(query);
         for (int i = 1; i <= params.length; i++) {
            qr.setParameter(1, params [i-1]);
        }
         List<T> toReturn  = qr.list();
         ses.getTransaction().commit();
         ses.close();
         return toReturn;
     }
}

e aki o QuartoFace

package projetoPousada.faces;

import java.util.List;
import projetoPousadas.dao.QuartoDAO;
import projetoPousadas.entity.Quarto;



/**
 *
 * @author Rafael
 */

public class QuartoFace {
    //********** listando dados da Pousada************
    private List<Quarto> cachedQuartos = null;
    private QuartoDAO quartoDAO = new QuartoDAO();
    private Quarto selectedQuarto;


    /** Creates a new instance of QuartoFace */
    public QuartoFace() {
    }

    public List<Quarto> getCachedQuartos() {
        if (cachedQuartos == null){
            cachedQuartos = quartoDAO.getQuartos();
        }
        return cachedQuartos;
    }

//********** Adicionar Quartos ***************

    public String addQuarto(){
        selectedQuarto = new Quarto();
        return "irParaAddNovoQuarto";
    }

    public String removerQuarto(){
        quartoDAO.removerQuarto(selectedQuarto);
        cachedQuartos = null;
        return "irParaListaQuartos";
    }

    public Quarto getSelectedQuarto(){
        return selectedQuarto;
    }

    public String terminaAddQuarto(){
        quartoDAO.addQuarto(selectedQuarto);
        cachedQuartos = null;
        return "irParaListaPousadas";
    }

    public QuartoDAO getQuartoDAO() {
        return quartoDAO;
    }

    public void setQuartoDAO(QuartoDAO quartoDAO) {
        this.quartoDAO = quartoDAO;
    }


    public void setSelectedQuarto(Quarto selectedQuarto) {
        this.selectedQuarto = selectedQuarto;
    }

}

Obrigado ao que poderem ajudar…

Rafael_Carneiro · Julho 17, 2009, 8:33am

org.hibernate.hql.ast.QuerySyntaxException: Quarto is not mapped [from Quarto quart]

Mostre-nos a sua entidade Quarto.

well · Julho 17, 2009, 9:01am

Bem depois do q vc falou eu mudei umas coisas… s q agora esta dando problema no me relacionamento… por ex: Many quartos pertencem a uma pousada e One pousada tem uma lista de quartos… me da uma força ai…

e agora o erro é o seguinte…

HTTP Status 500 -

type Exception report

message

description The server encountered an internal error () that prevented it from fulfilling this request.

exception

javax.servlet.ServletException: /quartos.jsp(22,12) ‘#{QuartoFace.cachedQuartos}’ Error reading ‘cachedQuartos’ on type projetoPousada.faces.QuartoFace
javax.faces.webapp.FacesServlet.service(FacesServlet.java:256)

root cause

org.apache.jasper.el.JspELException: /quartos.jsp(22,12) ‘#{QuartoFace.cachedQuartos}’ Error reading ‘cachedQuartos’ on type projetoPousada.faces.QuartoFace
org.apache.jasper.el.JspValueExpression.getValue(JspValueExpression.java:107)
javax.faces.component.UIData.getValue(UIData.java:582)
javax.faces.component.UIData.getDataModel(UIData.java:1063)
javax.faces.component.UIData.setRowIndex(UIData.java:417)
com.sun.faces.renderkit.html_basic.TableRenderer.encodeBegin(TableRenderer.java:85)
javax.faces.component.UIComponentBase.encodeBegin(UIComponentBase.java:788)
javax.faces.component.UIData.encodeBegin(UIData.java:879)
javax.faces.component.UIComponent.encodeAll(UIComponent.java:884)
javax.faces.render.Renderer.encodeChildren(Renderer.java:137)
javax.faces.component.UIComponentBase.encodeChildren(UIComponentBase.java:812)
javax.faces.component.UIComponent.encodeAll(UIComponent.java:886)
javax.faces.component.UIComponent.encodeAll(UIComponent.java:892)
com.sun.faces.application.ViewHandlerImpl.doRenderView(ViewHandlerImpl.java:245)
com.sun.faces.application.ViewHandlerImpl.renderView(ViewHandlerImpl.java:176)
com.sun.faces.lifecycle.RenderResponsePhase.execute(RenderResponsePhase.java:106)
com.sun.faces.lifecycle.LifecycleImpl.phase(LifecycleImpl.java:251)
com.sun.faces.lifecycle.LifecycleImpl.render(LifecycleImpl.java:144)
javax.faces.webapp.FacesServlet.service(FacesServlet.java:245)

root cause

org.hibernate.AnnotationException: Use of @OneToMany or @ManyToMany targeting an unmapped class: projetoPousadas.entity.Pousada.quartos[projetoPousadas.entity.Quarto]
org.hibernate.cfg.annotations.CollectionBinder.bindManyToManySecondPass(CollectionBinder.java:1071)
org.hibernate.cfg.annotations.CollectionBinder.bindStarToManySecondPass(CollectionBinder.java:602)
org.hibernate.cfg.annotations.CollectionBinder$1.secondPass(CollectionBinder.java:543)
org.hibernate.cfg.CollectionSecondPass.doSecondPass(CollectionSecondPass.java:66)
org.hibernate.cfg.Configuration.secondPassCompile(Configuration.java:1163)
org.hibernate.cfg.AnnotationConfiguration.secondPassCompile(AnnotationConfiguration.java:329)
org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1319)
org.hibernate.cfg.AnnotationConfiguration.buildSessionFactory(AnnotationConfiguration.java:867)
projetoPousadas.entity.HibernateUtil.(HibernateUtil.java:25)
projetoPousadas.entity.HibernateUtil.getInstance(HibernateUtil.java:57)
projetoPousadas.dao.GenericDAO.getSession(GenericDAO.java:27)
projetoPousadas.dao.GenericDAO.getPureList(GenericDAO.java:66)
projetoPousadas.dao.QuartoDAO.getQuartos(QuartoDAO.java:40)
projetoPousada.faces.QuartoFace.getCachedQuartos(QuartoFace.java:32)
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
java.lang.reflect.Method.invoke(Method.java:597)
javax.el.BeanELResolver.getValue(BeanELResolver.java:62)
javax.el.CompositeELResolver.getValue(CompositeELResolver.java:53)
com.sun.faces.el.FacesCompositeELResolver.getValue(FacesCompositeELResolver.java:64)
org.apache.el.parser.AstValue.getValue(AstValue.java:118)
org.apache.el.ValueExpressionImpl.getValue(ValueExpressionImpl.java:186)
org.apache.jasper.el.JspValueExpression.getValue(JspValueExpression.java:101)
javax.faces.component.UIData.getValue(UIData.java:582)
javax.faces.component.UIData.getDataModel(UIData.java:1063)
javax.faces.component.UIData.setRowIndex(UIData.java:417)
com.sun.faces.renderkit.html_basic.TableRenderer.encodeBegin(TableRenderer.java:85)
javax.faces.component.UIComponentBase.encodeBegin(UIComponentBase.java:788)
javax.faces.component.UIData.encodeBegin(UIData.java:879)
javax.faces.component.UIComponent.encodeAll(UIComponent.java:884)
javax.faces.render.Renderer.encodeChildren(Renderer.java:137)
javax.faces.component.UIComponentBase.encodeChildren(UIComponentBase.java:812)
javax.faces.component.UIComponent.encodeAll(UIComponent.java:886)
javax.faces.component.UIComponent.encodeAll(UIComponent.java:892)
com.sun.faces.application.ViewHandlerImpl.doRenderView(ViewHandlerImpl.java:245)
com.sun.faces.application.ViewHandlerImpl.renderView(ViewHandlerImpl.java:176)
com.sun.faces.lifecycle.RenderResponsePhase.execute(RenderResponsePhase.java:106)
com.sun.faces.lifecycle.LifecycleImpl.phase(LifecycleImpl.java:251)
com.sun.faces.lifecycle.LifecycleImpl.render(LifecycleImpl.java:144)
javax.faces.webapp.FacesServlet.service(FacesServlet.java:245)

Quarto.java

package projetoPousadas.entity;

import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.Id;
import javax.persistence.JoinColumn;
import javax.persistence.ManyToOne;
import javax.persistence.Table;

/**
*

@author Rafael
*/
@Entity
@Table(name=“quartos”)
public class Quarto implements java.io.Serializable{
private static final long serialVersionUID = 1L;

@Id
@Column(name=“codigo”)
private Integer codigo;

@ManyToOne
@JoinColumn(name=“cnpj_pousada”)
private Pousada pousada;

@ManyToOne
@JoinColumn(name=“codSituacao”)
private SituacaoQuarto situacaoQuarto;

@ManyToOne
@JoinColumn(name=“codTipo”)
private TiposQuarto tiposQuarto;

@Column(name=“numero”)
private Integer numero;

public Quarto(){
}

public Integer getCodigo() {
return codigo;
}

public void setCodigo(Integer codigo) {
this.codigo = codigo;
}

public Integer getNumero() {
return numero;
}

public void setNumero(Integer numero) {
this.numero = numero;
}

public Pousada getPousada() {
return pousada;
}

public void setPousada(Pousada pousada) {
this.pousada = pousada;
}

public SituacaoQuarto getSituacaoQuarto() {
return situacaoQuarto;
}

public void setSituacaoQuarto(SituacaoQuarto situacaoQuarto) {
this.situacaoQuarto = situacaoQuarto;
}

public TiposQuarto getTiposQuarto() {
return tiposQuarto;
}

public void setTiposQuarto(TiposQuarto tiposQuarto) {
this.tiposQuarto = tiposQuarto;
}

@Override
public boolean equals(Object obj) {
if (obj == null) {
return false;
}
if (getClass() != obj.getClass()) {
return false;
}
final Quarto other = (Quarto) obj;
if (this.codigo != other.codigo && (this.codigo == null || !this.codigo.equals(other.codigo))) {
return false;
}
return true;
}

@Override
public int hashCode() {
int hash = 3;
hash = 59 * hash + (this.codigo != null ? this.codigo.hashCode() : 0);
return hash;
}

}

Pousada.java

package projetoPousadas.entity;

import java.util.List;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.FetchType;
import javax.persistence.Id;
import javax.persistence.JoinColumn;
import javax.persistence.ManyToOne;
import javax.persistence.OneToMany;
import javax.persistence.Table;

/**
*

@author Rafael
*/
@Entity
@Table(name=“pousadas”)
public class Pousada implements java.io.Serializable {
private static final long serialVersionUID = 1L;

@Id
@Column(name=“cnpj_pousada”,nullable=false)
private Integer cnpj_pousada;

//faltando codFoto…

@ManyToOne()
@JoinColumn(name=“codBairro”)
private Bairro bairro;

@Column(name=“nomeRazao”,nullable=false)
private String nomeRazao;

@Column(name=“nomeFantasia”,nullable=false)
private String nomeFantasia;

@Column(name=“logradouro”,nullable=false)
private String logradouro;

@Column(name=“numero”,nullable=false)
private String numero;

@Column(name=“cep”,nullable=false)
private Integer cep;

@Column(name=“complemento”,nullable=false)
private String complemento;

@Column(name=“telefone”,nullable=false)
private Integer telefone;

@Column(name=“celular”,nullable=false)
private Integer celular;

@Column(name=“site”,nullable=false)
private String site;

@Column(name=“email”,nullable=false)
private String email;

@Column(name=“login”,nullable=false)
private String login;

@Column(name=“senha”,nullable=false)
private String senha;

//************* lista de Quartos ***************
@OneToMany(mappedBy=“pousada”, fetch=FetchType.LAZY)
private List quartos;
//*********************************************

public Pousada(){
}

public Bairro getBairro() {
return bairro;
}

public void setBairro(Bairro bairro) {
this.bairro = bairro;
}

public Integer getCelular() {
return celular;
}

public void setCelular(Integer celular) {
this.celular = celular;
}

public Integer getCep() {
return cep;
}

public void setCep(Integer cep) {
this.cep = cep;
}

public Integer getCnpj_pousada() {
return cnpj_pousada;
}

public void setCnpj_pousada(Integer cnpj_pousada) {
this.cnpj_pousada = cnpj_pousada;
}

public String getComplemento() {
return complemento;
}

public void setComplemento(String complemento) {
this.complemento = complemento;
}

public String getEmail() {
return email;
}

public void setEmail(String email) {
this.email = email;
}

public String getLogin() {
return login;
}

public void setLogin(String login) {
this.login = login;
}

public String getLogradouro() {
return logradouro;
}

public void setLogradouro(String logradouro) {
this.logradouro = logradouro;
}

public String getNomeFantasia() {
return nomeFantasia;
}

public void setNomeFantasia(String nomeFantasia) {
this.nomeFantasia = nomeFantasia;
}

public String getNomeRazao() {
return nomeRazao;
}

public void setNomeRazao(String nomeRazao) {
this.nomeRazao = nomeRazao;
}

public String getNumero() {
return numero;
}

public void setNumero(String numero) {
this.numero = numero;
}

public String getSenha() {
return senha;
}

public void setSenha(String senha) {
this.senha = senha;
}

public String getSite() {
return site;
}

public void setSite(String site) {
this.site = site;
}

public Integer getTelefone() {
return telefone;
}

public void setTelefone(Integer telefone) {
this.telefone = telefone;
}

public boolean validarSenha(String senhaParaTeste){
return senhaParaTeste.equals(senha);
}

public List getQuartos() {
return quartos;
}

public void setQuartos(List quartos) {
this.quartos = quartos;
}
```
@Override
```
public boolean equals(Object obj) {
if (obj == null) {
return false;
}
if (getClass() != obj.getClass()) {
return false;
}
final Pousada other = (Pousada) obj;
if (this.cnpj_pousada != other.cnpj_pousada && (this.cnpj_pousada == null || !this.cnpj_pousada.equals(other.cnpj_pousada))) {
return false;
}
return true;
}

@Override
public int hashCode() {
int hash = 7;
hash = 17 * hash + (this.cnpj_pousada != null ? this.cnpj_pousada.hashCode() : 0);
return hash;
}

}

YvGa · Julho 17, 2009, 9:36am

Quarto continua sem mapeamento. Voce esta informando na configuracao da session factory sobre essa classe?

well · Julho 17, 2009, 9:54am

Muito obrigado era isto q estava faltando…

system · Dezembro 22, 2015, 8:57pm

Pessoal nao acho o erro de maneira alguma...nao abre a tela para exibir os dados

Cursos de Mobile

Cursos de Programação

Cursos de Front-end

Cursos de DevOps

Cursos de Design & UX

Cursos de Business

Cursos de Data & BI