[Resolvido] Dúvida FOREACH usando Hibernate e V-Raptor

6 de novembro de 2010 28 respostas

cristianogro 6 de novembro de 2010

Olá à todos, estou tendo dificuldades com uma listagem usando a tag e usando Hibernate, na parte do Hibernate executo um SELECT com JOIN entre duas tabelas, não estou usando Criteria porque não sei fazer JOIN's usando Criteria, estou usando createSQLQuery para a consulta. Quando executo a action ocorre esse erro:

br.com.caelum.vraptor.view.ResultException: org.apache.jasper.JasperException: An exception occurred processing JSP page /WEB-INF/jsp/consultor/Orcamentos.jsp at line 68

65:                 
66:                 <c:forEach items="${orcamentosList}" var="orcamento">
67:                     <tr>    
68:                     <input name="a" type="text" id="cod_orcamento" value="${orcamento.cod_orcamento} " />
69:                     <input name="o" type="text" id="nome" value="${orcamento.nome} " />
70:                     </tr>
71:                 </c:forEach>


Stacktrace:
	br.com.caelum.vraptor.view.DefaultPageResult.forward(DefaultPageResult.java:69)
	br.com.caelum.vraptor.extra.ForwardToDefaultViewInterceptor.intercept(ForwardToDefaultViewInterceptor.java:59)
	br.com.caelum.vraptor.core.ToInstantiateInterceptorHandler.execute(ToInstantiateInterceptorHandler.java:54)
	br.com.caelum.vraptor.core.DefaultInterceptorStack.next(DefaultInterceptorStack.java:65)
	br.com.caelum.vraptor.core.ToInstantiateInterceptorHandler.execute(ToInstantiateInterceptorHandler.java:56)
	br.com.caelum.vraptor.core.DefaultInterceptorStack.next(DefaultInterceptorStack.java:65)
	br.com.caelum.vraptor.interceptor.OutjectResult.intercept(OutjectResult.java:65)
	br.com.caelum.vraptor.core.ToInstantiateInterceptorHandler.execute(ToInstantiateInterceptorHandler.java:54)
	br.com.caelum.vraptor.core.DefaultInterceptorStack.next(DefaultInterceptorStack.java:65)
	br.com.caelum.vraptor.interceptor.ExecuteMethodInterceptor.intercept(ExecuteMethodInterceptor.java:75)
	br.com.caelum.vraptor.core.ToInstantiateInterceptorHandler.execute(ToInstantiateInterceptorHandler.java:54)
	br.com.caelum.vraptor.core.DefaultInterceptorStack.next(DefaultInterceptorStack.java:65)
	br.com.caelum.vraptor.core.ToInstantiateInterceptorHandler.execute(ToInstantiateInterceptorHandler.java:56)
	br.com.caelum.vraptor.core.DefaultInterceptorStack.next(DefaultInterceptorStack.java:65)
	br.com.caelum.vraptor.interceptor.ParametersInstantiatorInterceptor.intercept(ParametersInstantiatorInterceptor.java:77)
	br.com.caelum.vraptor.core.ToInstantiateInterceptorHandler.execute(ToInstantiateInterceptorHandler.java:54)
	br.com.caelum.vraptor.core.DefaultInterceptorStack.next(DefaultInterceptorStack.java:65)
	br.com.caelum.vraptor.interceptor.InstantiateInterceptor.intercept(InstantiateInterceptor.java:42)
	br.com.caelum.vraptor.core.InstantiatedInterceptorHandler.execute(InstantiatedInterceptorHandler.java:47)
	br.com.caelum.vraptor.core.DefaultInterceptorStack.next(DefaultInterceptorStack.java:65)
	br.com.caelum.vraptor.interceptor.InterceptorListPriorToExecutionExtractor.intercept(InterceptorListPriorToExecutionExtractor.java:46)
	br.com.caelum.vraptor.core.ToInstantiateInterceptorHandler.execute(ToInstantiateInterceptorHandler.java:54)
	br.com.caelum.vraptor.core.DefaultInterceptorStack.next(DefaultInterceptorStack.java:65)
	br.com.caelum.vraptor.interceptor.FlashInterceptor.intercept(FlashInterceptor.java:80)
	br.com.caelum.vraptor.core.ToInstantiateInterceptorHandler.execute(ToInstantiateInterceptorHandler.java:54)
	br.com.caelum.vraptor.core.DefaultInterceptorStack.next(DefaultInterceptorStack.java:65)
	br.com.caelum.vraptor.interceptor.ResourceLookupInterceptor.intercept(ResourceLookupInterceptor.java:67)
	br.com.caelum.vraptor.core.ToInstantiateInterceptorHandler.execute(ToInstantiateInterceptorHandler.java:54)
	br.com.caelum.vraptor.core.DefaultInterceptorStack.next(DefaultInterceptorStack.java:65)
	br.com.caelum.vraptor.core.ToInstantiateInterceptorHandler.execute(ToInstantiateInterceptorHandler.java:56)
	br.com.caelum.vraptor.core.DefaultInterceptorStack.next(DefaultInterceptorStack.java:65)
	br.com.caelum.vraptor.core.DefaultRequestExecution.execute(DefaultRequestExecution.java:70)
	br.com.caelum.vraptor.VRaptor$1.insideRequest(VRaptor.java:92)
	br.com.caelum.vraptor.ioc.spring.SpringProvider.provideForRequest(SpringProvider.java:56)
	br.com.caelum.vraptor.VRaptor.doFilter(VRaptor.java:89)
root cause

org.apache.jasper.JasperException: An exception occurred processing JSP page /WEB-INF/jsp/consultor/Orcamentos.jsp at line 68

65:                 
66:                 <c:forEach items="${orcamentosList}" var="orcamento">
67:                     <tr>    
68:                     <input name="a" type="text" id="cod_orcamento" value="${orcamento.cod_orcamento} " />
69:                     <input name="o" type="text" id="nome" value="${orcamento.nome} " />
70:                     </tr>
71:                 </c:forEach>


Stacktrace:
	org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:510)
	org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:419)
	org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313)
	org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
	br.com.caelum.vraptor.core.DefaultStaticContentHandler.deferProcessingToContainer(DefaultStaticContentHandler.java:64)
	br.com.caelum.vraptor.VRaptor.doFilter(VRaptor.java:80)
	br.com.caelum.vraptor.view.DefaultPageResult.forward(DefaultPageResult.java:67)
	br.com.caelum.vraptor.extra.ForwardToDefaultViewInterceptor.intercept(ForwardToDefaultViewInterceptor.java:59)
	br.com.caelum.vraptor.core.ToInstantiateInterceptorHandler.execute(ToInstantiateInterceptorHandler.java:54)
	br.com.caelum.vraptor.core.DefaultInterceptorStack.next(DefaultInterceptorStack.java:65)
	br.com.caelum.vraptor.core.ToInstantiateInterceptorHandler.execute(ToInstantiateInterceptorHandler.java:56)
	br.com.caelum.vraptor.core.DefaultInterceptorStack.next(DefaultInterceptorStack.java:65)
	br.com.caelum.vraptor.interceptor.OutjectResult.intercept(OutjectResult.java:65)
	br.com.caelum.vraptor.core.ToInstantiateInterceptorHandler.execute(ToInstantiateInterceptorHandler.java:54)
	br.com.caelum.vraptor.core.DefaultInterceptorStack.next(DefaultInterceptorStack.java:65)
	br.com.caelum.vraptor.interceptor.ExecuteMethodInterceptor.intercept(ExecuteMethodInterceptor.java:75)
	br.com.caelum.vraptor.core.ToInstantiateInterceptorHandler.execute(ToInstantiateInterceptorHandler.java:54)
	br.com.caelum.vraptor.core.DefaultInterceptorStack.next(DefaultInterceptorStack.java:65)
	br.com.caelum.vraptor.core.ToInstantiateInterceptorHandler.execute(ToInstantiateInterceptorHandler.java:56)
	br.com.caelum.vraptor.core.DefaultInterceptorStack.next(DefaultInterceptorStack.java:65)
	br.com.caelum.vraptor.interceptor.ParametersInstantiatorInterceptor.intercept(ParametersInstantiatorInterceptor.java:77)
	br.com.caelum.vraptor.core.ToInstantiateInterceptorHandler.execute(ToInstantiateInterceptorHandler.java:54)
	br.com.caelum.vraptor.core.DefaultInterceptorStack.next(DefaultInterceptorStack.java:65)
	br.com.caelum.vraptor.interceptor.InstantiateInterceptor.intercept(InstantiateInterceptor.java:42)
	br.com.caelum.vraptor.core.InstantiatedInterceptorHandler.execute(InstantiatedInterceptorHandler.java:47)
	br.com.caelum.vraptor.core.DefaultInterceptorStack.next(DefaultInterceptorStack.java:65)
	br.com.caelum.vraptor.interceptor.InterceptorListPriorToExecutionExtractor.intercept(InterceptorListPriorToExecutionExtractor.java:46)
	br.com.caelum.vraptor.core.ToInstantiateInterceptorHandler.execute(ToInstantiateInterceptorHandler.java:54)
	br.com.caelum.vraptor.core.DefaultInterceptorStack.next(DefaultInterceptorStack.java:65)
	br.com.caelum.vraptor.interceptor.FlashInterceptor.intercept(FlashInterceptor.java:80)
	br.com.caelum.vraptor.core.ToInstantiateInterceptorHandler.execute(ToInstantiateInterceptorHandler.java:54)
	br.com.caelum.vraptor.core.DefaultInterceptorStack.next(DefaultInterceptorStack.java:65)
	br.com.caelum.vraptor.interceptor.ResourceLookupInterceptor.intercept(ResourceLookupInterceptor.java:67)
	br.com.caelum.vraptor.core.ToInstantiateInterceptorHandler.execute(ToInstantiateInterceptorHandler.java:54)
	br.com.caelum.vraptor.core.DefaultInterceptorStack.next(DefaultInterceptorStack.java:65)
	br.com.caelum.vraptor.core.ToInstantiateInterceptorHandler.execute(ToInstantiateInterceptorHandler.java:56)
	br.com.caelum.vraptor.core.DefaultInterceptorStack.next(DefaultInterceptorStack.java:65)
	br.com.caelum.vraptor.core.DefaultRequestExecution.execute(DefaultRequestExecution.java:70)
	br.com.caelum.vraptor.VRaptor$1.insideRequest(VRaptor.java:92)
	br.com.caelum.vraptor.ioc.spring.SpringProvider.provideForRequest(SpringProvider.java:56)
	br.com.caelum.vraptor.VRaptor.doFilter(VRaptor.java:89)
root cause

java.lang.NumberFormatException: For input string: "cod_orcamento"
	java.lang.NumberFormatException.forInputString(NumberFormatException.java:48)
	java.lang.Integer.parseInt(Integer.java:449)
	java.lang.Integer.parseInt(Integer.java:499)
	javax.el.ArrayELResolver.coerce(ArrayELResolver.java:161)
	javax.el.ArrayELResolver.getValue(ArrayELResolver.java:45)
	javax.el.CompositeELResolver.getValue(CompositeELResolver.java:54)
	org.apache.el.parser.AstValue.getValue(AstValue.java:123)
	org.apache.el.ValueExpressionImpl.getValue(ValueExpressionImpl.java:186)
	org.apache.jasper.runtime.PageContextImpl.proprietaryEvaluate(PageContextImpl.java:935)
	org.apache.jsp.WEB_002dINF.jsp.consultor.Orcamentos_jsp._jspx_meth_c_005fforEach_005f0(Orcamentos_jsp.java:161)
	org.apache.jsp.WEB_002dINF.jsp.consultor.Orcamentos_jsp._jspService(Orcamentos_jsp.java:122)
	org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
	org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:377)
	org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313)
	org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
	br.com.caelum.vraptor.core.DefaultStaticContentHandler.deferProcessingToContainer(DefaultStaticContentHandler.java:64)
	br.com.caelum.vraptor.VRaptor.doFilter(VRaptor.java:80)
	br.com.caelum.vraptor.view.DefaultPageResult.forward(DefaultPageResult.java:67)
	br.com.caelum.vraptor.extra.ForwardToDefaultViewInterceptor.intercept(ForwardToDefaultViewInterceptor.java:59)
	br.com.caelum.vraptor.core.ToInstantiateInterceptorHandler.execute(ToInstantiateInterceptorHandler.java:54)
	br.com.caelum.vraptor.core.DefaultInterceptorStack.next(DefaultInterceptorStack.java:65)
	br.com.caelum.vraptor.core.ToInstantiateInterceptorHandler.execute(ToInstantiateInterceptorHandler.java:56)
	br.com.caelum.vraptor.core.DefaultInterceptorStack.next(DefaultInterceptorStack.java:65)
	br.com.caelum.vraptor.interceptor.OutjectResult.intercept(OutjectResult.java:65)
	br.com.caelum.vraptor.core.ToInstantiateInterceptorHandler.execute(ToInstantiateInterceptorHandler.java:54)
	br.com.caelum.vraptor.core.DefaultInterceptorStack.next(DefaultInterceptorStack.java:65)
	br.com.caelum.vraptor.interceptor.ExecuteMethodInterceptor.intercept(ExecuteMethodInterceptor.java:75)
	br.com.caelum.vraptor.core.ToInstantiateInterceptorHandler.execute(ToInstantiateInterceptorHandler.java:54)
	br.com.caelum.vraptor.core.DefaultInterceptorStack.next(DefaultInterceptorStack.java:65)
	br.com.caelum.vraptor.core.ToInstantiateInterceptorHandler.execute(ToInstantiateInterceptorHandler.java:56)
	br.com.caelum.vraptor.core.DefaultInterceptorStack.next(DefaultInterceptorStack.java:65)
	br.com.caelum.vraptor.interceptor.ParametersInstantiatorInterceptor.intercept(ParametersInstantiatorInterceptor.java:77)
	br.com.caelum.vraptor.core.ToInstantiateInterceptorHandler.execute(ToInstantiateInterceptorHandler.java:54)
	br.com.caelum.vraptor.core.DefaultInterceptorStack.next(DefaultInterceptorStack.java:65)
	br.com.caelum.vraptor.interceptor.InstantiateInterceptor.intercept(InstantiateInterceptor.java:42)
	br.com.caelum.vraptor.core.InstantiatedInterceptorHandler.execute(InstantiatedInterceptorHandler.java:47)
	br.com.caelum.vraptor.core.DefaultInterceptorStack.next(DefaultInterceptorStack.java:65)
	br.com.caelum.vraptor.interceptor.InterceptorListPriorToExecutionExtractor.intercept(InterceptorListPriorToExecutionExtractor.java:46)
	br.com.caelum.vraptor.core.ToInstantiateInterceptorHandler.execute(ToInstantiateInterceptorHandler.java:54)
	br.com.caelum.vraptor.core.DefaultInterceptorStack.next(DefaultInterceptorStack.java:65)
	br.com.caelum.vraptor.interceptor.FlashInterceptor.intercept(FlashInterceptor.java:80)
	br.com.caelum.vraptor.core.ToInstantiateInterceptorHandler.execute(ToInstantiateInterceptorHandler.java:54)
	br.com.caelum.vraptor.core.DefaultInterceptorStack.next(DefaultInterceptorStack.java:65)
	br.com.caelum.vraptor.interceptor.ResourceLookupInterceptor.intercept(ResourceLookupInterceptor.java:67)
	br.com.caelum.vraptor.core.ToInstantiateInterceptorHandler.execute(ToInstantiateInterceptorHandler.java:54)
	br.com.caelum.vraptor.core.DefaultInterceptorStack.next(DefaultInterceptorStack.java:65)
	br.com.caelum.vraptor.core.ToInstantiateInterceptorHandler.execute(ToInstantiateInterceptorHandler.java:56)
	br.com.caelum.vraptor.core.DefaultInterceptorStack.next(DefaultInterceptorStack.java:65)
	br.com.caelum.vraptor.core.DefaultRequestExecution.execute(DefaultRequestExecution.java:70)
	br.com.caelum.vraptor.VRaptor$1.insideRequest(VRaptor.java:92)
	br.com.caelum.vraptor.ioc.spring.SpringProvider.provideForRequest(SpringProvider.java:56)
	br.com.caelum.vraptor.VRaptor.doFilter(VRaptor.java:89)

Orcamentos.jsp:

<body bgcolor="#FFFFFF">
        <div id="apDiv3">
            <table width="763">
                
                <c:forEach items="${orcamentosList}" var="orcamento">
                    <tr>    
                    <input name="a" type="text" id="cod_orcamento" value="${orcamento.cod_orcamento} " />
                    <input name="o" type="text" id="nome" value="${orcamento.nome} " />
                    </tr>
                </c:forEach>
            </table>
        </div>
    </body>

Classe Orcamentos:

package br.bmweb.bean;

public class Orcamentos {
    private int cod_orcamento;
    private String nome;

    public int getCod_orcamento() {
        return cod_orcamento;
    }

    public void setCod_orcamento(int cod_orcamento) {
        this.cod_orcamento = cod_orcamento;
    }

    public String getNome() {
        return nome;
    }

    public void setNome(String nome) {
        this.nome = nome;       
    }
    
}

OrcamentoDao:

public List<Orcamentos> listaOrcamentos()
        {
        List ls = null;
        Session session = new AbreSession().getSession();
        Transaction tx = session.beginTransaction();
        ls = session.createSQLQuery("SELECT o.or_cod_orcamento, c.cl_nome FROM tb_orcamento o, tb_cliente c WHERE o.or_cod_cliente = c.cl_cod_cliente and o.or_cod_orcamento = 11").list();
        tx.commit();
        session.close();
        return ls;
	}

ConsultorController:

public List<Orcamentos> Orcamentos() {
        return orcamentodao.listaOrcamentos();
    }

Meus questinamentos: 1) A estrutura da minha consulta da DAO tá certa? 2) O modo de exibir no JSP tá correto? 3) Quando meu método de consulta na DAO executar não preciso setar os valores retornados na classe Orcamentos?

28 Respostas

Guevara 6 de nov. de 2010

Eu faria umas mudanças ai, primeiro colocaria os atributos com notação Java:

public class Orcamento { 
@Column(name="cod_orcamento")
private Integer codOrcamento;
private String nome;
}

Depois colocaria a query em Criteria, algo deste tipo:

public List<Orcamento> lista(Orcamento orcamento) {
		Criteria crit = session.createCriteria(Orcamento.class);
                Criteria clienteCrit = crit.createCriteria("cliente");
		clienteCrit.add(Restrictions.eq("codCliente", orcamento.getCodCliente()));
		crit.add(Restrictions.eq("codOrcamento", new Integer(11)));
		return crit.list();	
	}

Mesma coisa com o código do cliente, deixar em notação Java “codCliente” e a classe Orcamento como Orcamento e não Orcamentos, pq senão vc vai ter que mandar no result.include com outro nome, tipo orcamentosList, pra não ficar o mesmo nome da classe.
Depois no OrcamentoController ou OrcamentosController, depende do que vc tiver ai:

public void listaOrcamentos(Orcamento orcamento) {
		result.include("orcamentos", orcamentoDAO.lista(orcamento));	
		result.use(Results.logic()).redirectTo(OrcamentosController.class).lista();
	}

E na JSP:

<c:forEach items="${orcamentos}" var="orcamento">
                    <tr>    
                    <input name="a" type="text" id="cod_orcamento" value="${orcamento.codOrcamento} " />
                    <input name="o" type="text" id="nome" value="${orcamento.nome} " />
                    </tr>
</c:forEach>

Acho que é por ai, fiz td de cabeça, mas é só adaptar pro que vc têm ai…

cristianogro 6 de nov. de 2010

Guevara:

Eu faria umas mudanças ai, primeiro colocaria os atributos com notação Java:

public class Orcamento { 
@Column(name="cod_orcamento")
private Integer codOrcamento;
private String nome;
}

Depois colocaria a query em Criteria, algo deste tipo:

public List<Orcamento> lista(Orcamento orcamento) {
		Criteria crit = session.createCriteria(Orcamento.class);
                Criteria clienteCrit = crit.createCriteria("cliente");
		clienteCrit.add(Restrictions.eq("codCliente", orcamento.getCodCliente()));
		crit.add(Restrictions.eq("codOrcamento", new Integer(11)));
		return crit.list();	
	}

public void listaOrcamentos(Orcamento orcamento) {
		result.include("orcamentos", orcamentoDAO.lista(orcamento));	
		result.use(Results.logic()).redirectTo(OrcamentosController.class).lista();
	}

E na JSP:

<c:forEach items="${orcamentos}" var="orcamento">
                    <tr>    
                    <input name="a" type="text" id="cod_orcamento" value="${orcamento.codOrcamento} " />
                    <input name="o" type="text" id="nome" value="${orcamento.nome} " />
                    </tr>
</c:forEach>

Acho que é por ai, fiz td de cabeça, mas é só adaptar pro que vc têm ai…

Guevara me tira uma dúvida desse exemplo seu, na DAO vc criou uma Criteria que usa parâmetros, mas e se minha consulta não usar nenhum parâmetro que venha de outra classe ou formulário? No meu caso eu estou tentando achar uma forma para fazer o seguinte no sistema:

O Consultor que vai usar o sistema acessará um link no qual carrega uma tela que executa uma consulta que irá retornar todos os orçamentos que estejam com o status “Aberto” trazendo o código do Orçamento (tabela Orçamento) e o nome do cliente (tabela Cliente), ou seja, quando o Consultor clicar no link ela não vai receber parâmetro nenhum e vai executar esta consulta no banco de dados, seria um SELECT parecido com o logo acima que coloquei mas com mais filtros é claro, o select acima é apenas para testes. A FK da tabela Orçamento é o código do cliente (cod_cliente). Aquele SELECT que postei mais acima funciona perfeitamente no Hibernate mas não estou sabendo/conseguindo jogar o resultado na tela.
Usando Criteria consigo fazer um SELECT parecido com o que postei no primeiro tópico sem necessidade de passar parâmetros?

Guevara 6 de nov. de 2010

Guevara me tira uma dúvida desse exemplo seu, na DAO vc criou uma Criteria que usa parâmetros, mas e se minha consulta não usar nenhum parâmetro que venha de outra classe ou formulário? No meu caso eu estou tentando achar uma forma para fazer o seguinte no sistema:

O Consultor que vai usar o sistema acessará um link no qual carrega uma tela que executa uma consulta que irá retornar todos os orçamentos que estejam com o status “Aberto” trazendo o código do Orçamento (tabela Orçamento) e o nome do cliente (tabela Cliente), ou seja, quando o Consultor clicar no link ela não vai receber parâmetro nenhum e vai executar esta consulta no banco de dados, seria um SELECT parecido com o logo acima que coloquei mas com mais filtros é claro, o select acima é apenas para testes. A FK da tabela Orçamento é o código do cliente (cod_cliente). Aquele SELECT que postei mais acima funciona perfeitamente no Hibernate mas não estou sabendo/conseguindo jogar o resultado na tela.
Usando Criteria consigo fazer um SELECT parecido com o que postei no primeiro tópico sem necessidade de passar parâmetros?

Veja bem, na sua classe Orcamento não existe um atributo cliente do tipo Cliente para poder pegar codCliente na tabela Cliente, se vc quiser usar Hibernate pra ele trazer o objeto principal e seus filhos o ideal seria fazer isso, vc precisa revisar o projeto pra colocar as annotations certas nos atributos certos, ai da pra aproveitar melhor o Hibernate. Ficar fazendo select tendo um Hibernate rodando não faz sentido… =/

Supondo que vc queira pegar os orçamentos de todos os clientes em “aberto”, seguindo o meu raciocinio vc faria:
Digamos tb que o atributo “aberto” seja um Boolean na classe Cliente:

public List<Orcamento> listaOrcamentosEmAberto() {			
		Criteria crit = session.createCriteria(Orcamento.class, "o");
		Criteria clienteCrit = crit.createCriteria("cliente");
		clienteCrit.add(Restrictions.eq("aberto", true));	
		return crit.list();
	}

Mas vc precisa resolver como fica o relacionamento de Orcamento com Cliente, e ai vc consegue usar o Hibernate pra fazer suas Criterias.
Veja se funciona.

cristianogro 6 de nov. de 2010

Desculpa Guevara minha falta de clareza, mas esta classe não é a classe principal, eu criei essa classe com o objetivo de usar somente com os Lists mas já vi que eu estava viajando :shock: a classe Orcamento é esta:

package br.bmweb.bean;

import java.util.Date;

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

@Entity
@Table(name="TB_ORCAMENTO", schema="bmweb") 
public class Orcamento {
	private int cod_orcamento, cod_cliente, cod_funcionario;
	private Date data_orcamento, data_alteracao, data_fechamento, data_validade;
	private double valor_total, valor_unitario;
	private String tipo_orcamento, status_orcamento;
	
	@Id
	@GeneratedValue
	@Column(name="OR_COD_ORCAMENTO")
	public int getCod_orcamento() {
		return cod_orcamento;
	}
	public void setCod_orcamento(int codOrcamento) {
		cod_orcamento = codOrcamento;
	}

	@ManyToOne(cascade = {CascadeType.PERSIST, CascadeType.MERGE} )
	@JoinColumn(name="CL_COD_CLIENTE")	
	@Column(name = "OR_COD_CLIENTE", nullable = false)
	public int getCod_cliente() {
		return cod_cliente;
	}
	public void setCod_cliente(int codCliente) {
		cod_cliente = codCliente;
	}
	
	@Column(name = "OR_COD_FUNCIONARIO", nullable = false)
	public int getCod_funcionario() {
		return cod_funcionario;
	}
	public void setCod_funcionario(int codFuncionario) {
		cod_funcionario = codFuncionario;
	}
	
	@Column(name = "OR_DATA_ORCAMENTO", nullable = false)
	public Date getData_orcamento() {
		return data_orcamento;
	}
	public void setData_orcamento(Date dataOrcamento) {
		data_orcamento = dataOrcamento;
	}
	
	@Column(name = "OR_DATA_ALTERACAO")
	public Date getData_alteracao() {
		return data_alteracao;
	}
	public void setData_alteracao(Date dataAlteracao) {
		data_alteracao = dataAlteracao;
	}
	
	@Column(name = "OR_DATA_FECHAMENTO")
	public Date getData_fechamento() {
		return data_fechamento;
	}
	public void setData_fechamento(Date dataFechamento) {
		data_fechamento = dataFechamento;
	}
	
	@Column(name = "OR_DATA_VALIDADE")
	public Date getData_validade() {
		return data_validade;
	}
	public void setData_validade(Date dataValidade) {
		data_validade = dataValidade;
	}
	
	@Column(name = "OR_VALOR_TOTAL", nullable = false)
	public double getValor_total() {
		return valor_total;
	}
	public void setValor_total(double valorTotal) {
		valor_total = valorTotal;
	}
	
	@Column(name = "OR_VALOR_UNIT", nullable = false)
	public double getValor_unitario() {
		return valor_unitario;
	}
	public void setValor_unitario(double valorUnitario) {
		valor_unitario = valorUnitario;
	}
	
	@Column(name = "OR_TIPO_ORCAMENTO", nullable = false)
	public String getTipo_orcamento() {
		return tipo_orcamento;
	}
	public void setTipo_orcamento(String tipoOrcamento) {
		tipo_orcamento = tipoOrcamento;
	}
	
	@Column(name = "OR_STATUS_ORCAMENTO", nullable = false)
	public String getStatus_orcamento() {
		return status_orcamento;
	}
	public void setStatus_orcamento(String statusOrcamento) {
		status_orcamento = statusOrcamento;
	}
}

Vou fazer uns testes aqui e qualquer coisa aviso.

cristianogro 6 de nov. de 2010

Guevara:
Guevara me tira uma dúvida desse exemplo seu, na DAO vc criou uma Criteria que usa parâmetros, mas e se minha consulta não usar nenhum parâmetro que venha de outra classe ou formulário? No meu caso eu estou tentando achar uma forma para fazer o seguinte no sistema: - O Consultor que vai usar o sistema acessará um link no qual carrega uma tela que executa uma consulta que irá retornar todos os orçamentos que estejam com o status "Aberto" trazendo o código do Orçamento (tabela Orçamento) e o nome do cliente (tabela Cliente), ou seja, quando o Consultor clicar no link ela não vai receber parâmetro nenhum e vai executar esta consulta no banco de dados, seria um SELECT parecido com o logo acima que coloquei mas com mais filtros é claro, o select acima é apenas para testes. A FK da tabela Orçamento é o código do cliente (cod_cliente). Aquele SELECT que postei mais acima funciona perfeitamente no Hibernate mas não estou sabendo/conseguindo jogar o resultado na tela. Usando Criteria consigo fazer um SELECT parecido com o que postei no primeiro tópico sem necessidade de passar parâmetros?
Veja bem, na sua classe Orcamento não existe um atributo cliente do tipo Cliente para poder pegar codCliente na tabela Cliente, se vc quiser usar Hibernate pra ele trazer o objeto principal e seus filhos o ideal seria fazer isso, vc precisa revisar o projeto pra colocar as annotations certas nos atributos certos, ai da pra aproveitar melhor o Hibernate. Ficar fazendo select tendo um Hibernate rodando não faz sentido... =/ Supondo que vc queira pegar os orçamentos de todos os clientes em "aberto", seguindo o meu raciocinio vc faria: Digamos tb que o atributo "aberto" seja um Boolean na classe Cliente:
public List<Orcamento> listaOrcamentosEmAberto() {			
		Criteria crit = session.createCriteria(Orcamento.class, "o");
		Criteria clienteCrit = crit.createCriteria("cliente");
		clienteCrit.add(Restrictions.eq("aberto", true));	
		return crit.list();
	}
Mas vc precisa resolver como fica o relacionamento de Orcamento com Cliente, e ai vc consegue usar o Hibernate pra fazer suas Criterias. Veja se funciona.

Guevara já dei uma travada, sou marinheiro de primeira viagem no Hibernate, alterei as classes e deixei assim os relacionamentos, estou usando Hibernete annotations: Classe Orcamento:

@ManyToOne(cascade = {CascadeType.PERSIST, CascadeType.MERGE})
	@JoinColumn(name="CL_COD_CLIENTE")	
	@Column(name = "OR_COD_CLIENTE", nullable = false)
	public int getCod_cliente() {
		return cod_cliente;
	}
	public void setCod_cliente(int codCliente) {
		cod_cliente = codCliente;
	}

Classe Cliente:

@Id
    @GeneratedValue
    @OneToMany(mappedBy="cliente", fetch = FetchType.LAZY)
    @JoinColumn(name="CL_COD_CLIENTE")
    @Cascade(CascadeType.ALL)
    @Column(name = "CL_COD_CLIENTE", nullable = false)
    public int getCod_cliente() {
        return cod_cliente;
    }

    public void setCod_cliente(int codCliente) {
        cod_cliente = codCliente;
    }

Acho que está errado aqui em cima :( Minha ConsultorConbtroller deixei assim:

public void Orcamentos(){
        result.include("orcamentos", orcamentodao.lista());
        result.use(Results.logic()).redirectTo(ConsultorController.class).Orcamentos();
    }

Minha OrcamentoDao deixei assim:

public List<Orcamento> lista() {
        Criteria crit = session.createCriteria(Orcamento.class);
        Criteria clienteCrit = crit.createCriteria("cliente");
        crit.add(Restrictions.eq("cod_orcamento", new Integer(11)));
        return crit.list();
    }

O jsp tá assim:

<body bgcolor="#FFFFFF">
        <div id="apDiv3">
            <table width="763">
                
                <c:forEach items="${orcamentos}" var="orcamento">
                    <tr>    
                    <input name="a" type="text" id="cod_orcamento" value="${orcamento.cod_orcamento} " />
                    <input name="o" type="text" id="nome" value="${orcamento.nome} " />
                    </tr>
                </c:forEach>
            </table>
        </div>
    </body>

O erro que ocorre é esse:

org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'consultorController' defined in file [D:\TCC\vraptor-blank-project-3.1.1\build\web\WEB-INF\classes\br\bmweb\controller\ConsultorController.class]: Unsatisfied dependency expressed through constructor argument with index 3 of type [br.bmweb.dao.ProdutoDao]: : Error creating bean with name 'produtoDao' defined in file [D:\TCC\vraptor-blank-project-3.1.1\build\web\WEB-INF\classes\br\bmweb\dao\ProdutoDao.class]: Instantiation of bean failed; nested exception is org.springframework.beans.BeanInstantiationException: Could not instantiate bean class [br.bmweb.dao.ProdutoDao]: Constructor threw exception; nested exception is org.hibernate.AnnotationException: @Column(s) not allowed on a @ManyToOne property: br.bmweb.bean.Orcamento.cod_cliente; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'produtoDao' defined in file [D:\TCC\vraptor-blank-project-3.1.1\build\web\WEB-INF\classes\br\bmweb\dao\ProdutoDao.class]: Instantiation of bean failed; nested exception is org.springframework.beans.BeanInstantiationException: Could not instantiate bean class [br.bmweb.dao.ProdutoDao]: Constructor threw exception; nested exception is org.hibernate.AnnotationException: @Column(s) not allowed on a @ManyToOne property: br.bmweb.bean.Orcamento.cod_cliente
	org.springframework.beans.factory.support.ConstructorResolver.createArgumentArray(ConstructorResolver.java:698)
	org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:192)
	org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:984)
	org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:886)
	org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:479)
	org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:450)
	org.springframework.beans.factory.support.AbstractBeanFactory$2.getObject(AbstractBeanFactory.java:328)
	org.springframework.web.context.request.AbstractRequestAttributesScope.get(AbstractRequestAttributesScope.java:43)
	org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:324)
	org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:193)
	org.springframework.beans.factory.support.DefaultListableBeanFactory.getBeansOfType(DefaultListableBeanFactory.java:385)
	org.springframework.beans.factory.support.DefaultListableBeanFactory.getBeansOfType(DefaultListableBeanFactory.java:375)
	org.springframework.context.support.AbstractApplicationContext.getBeansOfType(AbstractApplicationContext.java:1069)
	org.springframework.beans.factory.BeanFactoryUtils.beansOfTypeIncludingAncestors(BeanFactoryUtils.java:221)
	br.com.caelum.vraptor.ioc.spring.VRaptorApplicationContext.getBean(VRaptorApplicationContext.java:244)
	br.com.caelum.vraptor.ioc.spring.SpringBasedContainer.instanceFor(SpringBasedContainer.java:59)
	br.com.caelum.vraptor.interceptor.InstantiateInterceptor.intercept(InstantiateInterceptor.java:41)
	br.com.caelum.vraptor.core.InstantiatedInterceptorHandler.execute(InstantiatedInterceptorHandler.java:47)
	br.com.caelum.vraptor.core.DefaultInterceptorStack.next(DefaultInterceptorStack.java:65)
	br.com.caelum.vraptor.interceptor.InterceptorListPriorToExecutionExtractor.intercept(InterceptorListPriorToExecutionExtractor.java:46)
	br.com.caelum.vraptor.core.ToInstantiateInterceptorHandler.execute(ToInstantiateInterceptorHandler.java:54)
	br.com.caelum.vraptor.core.DefaultInterceptorStack.next(DefaultInterceptorStack.java:65)
	br.com.caelum.vraptor.interceptor.FlashInterceptor.intercept(FlashInterceptor.java:80)
	br.com.caelum.vraptor.core.ToInstantiateInterceptorHandler.execute(ToInstantiateInterceptorHandler.java:54)
	br.com.caelum.vraptor.core.DefaultInterceptorStack.next(DefaultInterceptorStack.java:65)
	br.com.caelum.vraptor.interceptor.ResourceLookupInterceptor.intercept(ResourceLookupInterceptor.java:67)
	br.com.caelum.vraptor.core.ToInstantiateInterceptorHandler.execute(ToInstantiateInterceptorHandler.java:54)
	br.com.caelum.vraptor.core.DefaultInterceptorStack.next(DefaultInterceptorStack.java:65)
	br.com.caelum.vraptor.core.ToInstantiateInterceptorHandler.execute(ToInstantiateInterceptorHandler.java:56)
	br.com.caelum.vraptor.core.DefaultInterceptorStack.next(DefaultInterceptorStack.java:65)
	br.com.caelum.vraptor.core.DefaultRequestExecution.execute(DefaultRequestExecution.java:70)
	br.com.caelum.vraptor.VRaptor$1.insideRequest(VRaptor.java:92)
	br.com.caelum.vraptor.ioc.spring.SpringProvider.provideForRequest(SpringProvider.java:56)
	br.com.caelum.vraptor.VRaptor.doFilter(VRaptor.java:89)
root cause

org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'produtoDao' defined in file [D:\TCC\vraptor-blank-project-3.1.1\build\web\WEB-INF\classes\br\bmweb\dao\ProdutoDao.class]: Instantiation of bean failed; nested exception is org.springframework.beans.BeanInstantiationException: Could not instantiate bean class [br.bmweb.dao.ProdutoDao]: Constructor threw exception; nested exception is org.hibernate.AnnotationException: @Column(s) not allowed on a @ManyToOne property: br.bmweb.bean.Orcamento.cod_cliente
	org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.instantiateBean(AbstractAutowireCapableBeanFactory.java:946)
	org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:890)
	org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:479)
	org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:450)
	org.springframework.beans.factory.support.AbstractBeanFactory$2.getObject(AbstractBeanFactory.java:328)
	org.springframework.web.context.request.AbstractRequestAttributesScope.get(AbstractRequestAttributesScope.java:43)
	org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:324)
	org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:189)
	org.springframework.beans.factory.support.DefaultListableBeanFactory.findAutowireCandidates(DefaultListableBeanFactory.java:820)
	org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:762)
	org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:680)
	org.springframework.beans.factory.support.ConstructorResolver.resolveAutowiredArgument(ConstructorResolver.java:771)
	org.springframework.beans.factory.support.ConstructorResolver.createArgumentArray(ConstructorResolver.java:691)
	org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:192)
	org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:984)
	org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:886)
	org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:479)
	org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:450)
	org.springframework.beans.factory.support.AbstractBeanFactory$2.getObject(AbstractBeanFactory.java:328)
	org.springframework.web.context.request.AbstractRequestAttributesScope.get(AbstractRequestAttributesScope.java:43)
	org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:324)
	org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:193)
	org.springframework.beans.factory.support.DefaultListableBeanFactory.getBeansOfType(DefaultListableBeanFactory.java:385)
	org.springframework.beans.factory.support.DefaultListableBeanFactory.getBeansOfType(DefaultListableBeanFactory.java:375)
	org.springframework.context.support.AbstractApplicationContext.getBeansOfType(AbstractApplicationContext.java:1069)
	org.springframework.beans.factory.BeanFactoryUtils.beansOfTypeIncludingAncestors(BeanFactoryUtils.java:221)
	br.com.caelum.vraptor.ioc.spring.VRaptorApplicationContext.getBean(VRaptorApplicationContext.java:244)
	br.com.caelum.vraptor.ioc.spring.SpringBasedContainer.instanceFor(SpringBasedContainer.java:59)
	br.com.caelum.vraptor.interceptor.InstantiateInterceptor.intercept(InstantiateInterceptor.java:41)
	br.com.caelum.vraptor.core.InstantiatedInterceptorHandler.execute(InstantiatedInterceptorHandler.java:47)
	br.com.caelum.vraptor.core.DefaultInterceptorStack.next(DefaultInterceptorStack.java:65)
	br.com.caelum.vraptor.interceptor.InterceptorListPriorToExecutionExtractor.intercept(InterceptorListPriorToExecutionExtractor.java:46)
	br.com.caelum.vraptor.core.ToInstantiateInterceptorHandler.execute(ToInstantiateInterceptorHandler.java:54)
	br.com.caelum.vraptor.core.DefaultInterceptorStack.next(DefaultInterceptorStack.java:65)
	br.com.caelum.vraptor.interceptor.FlashInterceptor.intercept(FlashInterceptor.java:80)
	br.com.caelum.vraptor.core.ToInstantiateInterceptorHandler.execute(ToInstantiateInterceptorHandler.java:54)
	br.com.caelum.vraptor.core.DefaultInterceptorStack.next(DefaultInterceptorStack.java:65)
	br.com.caelum.vraptor.interceptor.ResourceLookupInterceptor.intercept(ResourceLookupInterceptor.java:67)
	br.com.caelum.vraptor.core.ToInstantiateInterceptorHandler.execute(ToInstantiateInterceptorHandler.java:54)
	br.com.caelum.vraptor.core.DefaultInterceptorStack.next(DefaultInterceptorStack.java:65)
	br.com.caelum.vraptor.core.ToInstantiateInterceptorHandler.execute(ToInstantiateInterceptorHandler.java:56)
	br.com.caelum.vraptor.core.DefaultInterceptorStack.next(DefaultInterceptorStack.java:65)
	br.com.caelum.vraptor.core.DefaultRequestExecution.execute(DefaultRequestExecution.java:70)
	br.com.caelum.vraptor.VRaptor$1.insideRequest(VRaptor.java:92)
	br.com.caelum.vraptor.ioc.spring.SpringProvider.provideForRequest(SpringProvider.java:56)
	br.com.caelum.vraptor.VRaptor.doFilter(VRaptor.java:89)
root cause

org.springframework.beans.BeanInstantiationException: Could not instantiate bean class [br.bmweb.dao.ProdutoDao]: Constructor threw exception; nested exception is org.hibernate.AnnotationException: @Column(s) not allowed on a @ManyToOne property: br.bmweb.bean.Orcamento.cod_cliente
	org.springframework.beans.BeanUtils.instantiateClass(BeanUtils.java:141)
	org.springframework.beans.factory.support.SimpleInstantiationStrategy.instantiate(SimpleInstantiationStrategy.java:72)
	org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.instantiateBean(AbstractAutowireCapableBeanFactory.java:938)
	org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:890)
	org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:479)
	org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:450)
	org.springframework.beans.factory.support.AbstractBeanFactory$2.getObject(AbstractBeanFactory.java:328)
	org.springframework.web.context.request.AbstractRequestAttributesScope.get(AbstractRequestAttributesScope.java:43)
	org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:324)
	org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:189)
	org.springframework.beans.factory.support.DefaultListableBeanFactory.findAutowireCandidates(DefaultListableBeanFactory.java:820)
	org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:762)
	org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:680)
	org.springframework.beans.factory.support.ConstructorResolver.resolveAutowiredArgument(ConstructorResolver.java:771)
	org.springframework.beans.factory.support.ConstructorResolver.createArgumentArray(ConstructorResolver.java:691)
	org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:192)
	org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:984)
	org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:886)
	org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:479)
	org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:450)
	org.springframework.beans.factory.support.AbstractBeanFactory$2.getObject(AbstractBeanFactory.java:328)
	org.springframework.web.context.request.AbstractRequestAttributesScope.get(AbstractRequestAttributesScope.java:43)
	org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:324)
	org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:193)
	org.springframework.beans.factory.support.DefaultListableBeanFactory.getBeansOfType(DefaultListableBeanFactory.java:385)
	org.springframework.beans.factory.support.DefaultListableBeanFactory.getBeansOfType(DefaultListableBeanFactory.java:375)
	org.springframework.context.support.AbstractApplicationContext.getBeansOfType(AbstractApplicationContext.java:1069)
	org.springframework.beans.factory.BeanFactoryUtils.beansOfTypeIncludingAncestors(BeanFactoryUtils.java:221)
	br.com.caelum.vraptor.ioc.spring.VRaptorApplicationContext.getBean(VRaptorApplicationContext.java:244)
	br.com.caelum.vraptor.ioc.spring.SpringBasedContainer.instanceFor(SpringBasedContainer.java:59)
	br.com.caelum.vraptor.interceptor.InstantiateInterceptor.intercept(InstantiateInterceptor.java:41)
	br.com.caelum.vraptor.core.InstantiatedInterceptorHandler.execute(InstantiatedInterceptorHandler.java:47)
	br.com.caelum.vraptor.core.DefaultInterceptorStack.next(DefaultInterceptorStack.java:65)
	br.com.caelum.vraptor.interceptor.InterceptorListPriorToExecutionExtractor.intercept(InterceptorListPriorToExecutionExtractor.java:46)
	br.com.caelum.vraptor.core.ToInstantiateInterceptorHandler.execute(ToInstantiateInterceptorHandler.java:54)
	br.com.caelum.vraptor.core.DefaultInterceptorStack.next(DefaultInterceptorStack.java:65)
	br.com.caelum.vraptor.interceptor.FlashInterceptor.intercept(FlashInterceptor.java:80)
	br.com.caelum.vraptor.core.ToInstantiateInterceptorHandler.execute(ToInstantiateInterceptorHandler.java:54)
	br.com.caelum.vraptor.core.DefaultInterceptorStack.next(DefaultInterceptorStack.java:65)
	br.com.caelum.vraptor.interceptor.ResourceLookupInterceptor.intercept(ResourceLookupInterceptor.java:67)
	br.com.caelum.vraptor.core.ToInstantiateInterceptorHandler.execute(ToInstantiateInterceptorHandler.java:54)
	br.com.caelum.vraptor.core.DefaultInterceptorStack.next(DefaultInterceptorStack.java:65)
	br.com.caelum.vraptor.core.ToInstantiateInterceptorHandler.execute(ToInstantiateInterceptorHandler.java:56)
	br.com.caelum.vraptor.core.DefaultInterceptorStack.next(DefaultInterceptorStack.java:65)
	br.com.caelum.vraptor.core.DefaultRequestExecution.execute(DefaultRequestExecution.java:70)
	br.com.caelum.vraptor.VRaptor$1.insideRequest(VRaptor.java:92)
	br.com.caelum.vraptor.ioc.spring.SpringProvider.provideForRequest(SpringProvider.java:56)
	br.com.caelum.vraptor.VRaptor.doFilter(VRaptor.java:89)
root cause

org.hibernate.AnnotationException: @Column(s) not allowed on a @ManyToOne property: br.bmweb.bean.Orcamento.cod_cliente
	org.hibernate.cfg.AnnotationBinder.processElementAnnotations(AnnotationBinder.java:1345)
	org.hibernate.cfg.AnnotationBinder.bindClass(AnnotationBinder.java:754)
	org.hibernate.cfg.AnnotationConfiguration.processArtifactsOfType(AnnotationConfiguration.java:546)
	org.hibernate.cfg.AnnotationConfiguration.secondPassCompile(AnnotationConfiguration.java:291)
	org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1319)
	org.hibernate.cfg.AnnotationConfiguration.buildSessionFactory(AnnotationConfiguration.java:867)
	br.bmweb.util.AbreSession.getSession(AbreSession.java:11)
	br.bmweb.dao.ProdutoDao.<init>(ProdutoDao.java:19)
	sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
	sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
	sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
	java.lang.reflect.Constructor.newInstance(Constructor.java:513)
	org.springframework.beans.BeanUtils.instantiateClass(BeanUtils.java:126)
	org.springframework.beans.factory.support.SimpleInstantiationStrategy.instantiate(SimpleInstantiationStrategy.java:72)
	org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.instantiateBean(AbstractAutowireCapableBeanFactory.java:938)
	org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:890)
	org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:479)
	org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:450)
	org.springframework.beans.factory.support.AbstractBeanFactory$2.getObject(AbstractBeanFactory.java:328)
	org.springframework.web.context.request.AbstractRequestAttributesScope.get(AbstractRequestAttributesScope.java:43)
	org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:324)
	org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:189)
	org.springframework.beans.factory.support.DefaultListableBeanFactory.findAutowireCandidates(DefaultListableBeanFactory.java:820)
	org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:762)
	org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:680)
	org.springframework.beans.factory.support.ConstructorResolver.resolveAutowiredArgument(ConstructorResolver.java:771)
	org.springframework.beans.factory.support.ConstructorResolver.createArgumentArray(ConstructorResolver.java:691)
	org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:192)
	org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:984)
	org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:886)
	org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:479)
	org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:450)
	org.springframework.beans.factory.support.AbstractBeanFactory$2.getObject(AbstractBeanFactory.java:328)
	org.springframework.web.context.request.AbstractRequestAttributesScope.get(AbstractRequestAttributesScope.java:43)
	org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:324)
	org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:193)
	org.springframework.beans.factory.support.DefaultListableBeanFactory.getBeansOfType(DefaultListableBeanFactory.java:385)
	org.springframework.beans.factory.support.DefaultListableBeanFactory.getBeansOfType(DefaultListableBeanFactory.java:375)
	org.springframework.context.support.AbstractApplicationContext.getBeansOfType(AbstractApplicationContext.java:1069)
	org.springframework.beans.factory.BeanFactoryUtils.beansOfTypeIncludingAncestors(BeanFactoryUtils.java:221)
	br.com.caelum.vraptor.ioc.spring.VRaptorApplicationContext.getBean(VRaptorApplicationContext.java:244)
	br.com.caelum.vraptor.ioc.spring.SpringBasedContainer.instanceFor(SpringBasedContainer.java:59)
	br.com.caelum.vraptor.interceptor.InstantiateInterceptor.intercept(InstantiateInterceptor.java:41)
	br.com.caelum.vraptor.core.InstantiatedInterceptorHandler.execute(InstantiatedInterceptorHandler.java:47)
	br.com.caelum.vraptor.core.DefaultInterceptorStack.next(DefaultInterceptorStack.java:65)
	br.com.caelum.vraptor.interceptor.InterceptorListPriorToExecutionExtractor.intercept(InterceptorListPriorToExecutionExtractor.java:46)
	br.com.caelum.vraptor.core.ToInstantiateInterceptorHandler.execute(ToInstantiateInterceptorHandler.java:54)
	br.com.caelum.vraptor.core.DefaultInterceptorStack.next(DefaultInterceptorStack.java:65)
	br.com.caelum.vraptor.interceptor.FlashInterceptor.intercept(FlashInterceptor.java:80)
	br.com.caelum.vraptor.core.ToInstantiateInterceptorHandler.execute(ToInstantiateInterceptorHandler.java:54)
	br.com.caelum.vraptor.core.DefaultInterceptorStack.next(DefaultInterceptorStack.java:65)
	br.com.caelum.vraptor.interceptor.ResourceLookupInterceptor.intercept(ResourceLookupInterceptor.java:67)
	br.com.caelum.vraptor.core.ToInstantiateInterceptorHandler.execute(ToInstantiateInterceptorHandler.java:54)
	br.com.caelum.vraptor.core.DefaultInterceptorStack.next(DefaultInterceptorStack.java:65)
	br.com.caelum.vraptor.core.ToInstantiateInterceptorHandler.execute(ToInstantiateInterceptorHandler.java:56)
	br.com.caelum.vraptor.core.DefaultInterceptorStack.next(DefaultInterceptorStack.java:65)
	br.com.caelum.vraptor.core.DefaultRequestExecution.execute(DefaultRequestExecution.java:70)
	br.com.caelum.vraptor.VRaptor$1.insideRequest(VRaptor.java:92)
	br.com.caelum.vraptor.ioc.spring.SpringProvider.provideForRequest(SpringProvider.java:56)
	br.com.caelum.vraptor.VRaptor.doFilter(VRaptor.java:89)

Lendo o erro ele diz que a anotação pra FK cod_cliente na tabela Orçamento não é permitida mas não entendi porque? :shock:

Lucas_Cavalcanti 6 de nov. de 2010

@Column(s) not allowed on a @ManyToOne property: br.bmweb.bean.Orcamento.cod_cliente

tire o @Column dessa propriedade… só a @JoinColumn é suficiente…

cristianogro 7 de nov. de 2010

Bom deixei assim agora:

Orcamento:

@Id
	@GeneratedValue
	@Column(name="OR_COD_ORCAMENTO")
	public int getCod_orcamento() {
		return cod_orcamento;
	}
	public void setCod_orcamento(int codOrcamento) {
		cod_orcamento = codOrcamento;
	}

	@ManyToOne(cascade = {CascadeType.PERSIST, CascadeType.MERGE})
	@JoinColumn(name="CL_COD_CLIENTE")	
	public int getCod_cliente() {
		return cod_cliente;
	}
	public void setCod_cliente(int codCliente) {
		cod_cliente = codCliente;
	}

Cliente:

@Id
    @GeneratedValue
    @OneToMany(mappedBy="cliente", fetch = FetchType.LAZY)
    @JoinColumn(name="CL_COD_CLIENTE")
    @Cascade(CascadeType.ALL)
    @Column(name = "CL_COD_CLIENTE", nullable = false)
    public int getCod_cliente() {
        return cod_cliente;
    }

    public void setCod_cliente(int codCliente) {
        cod_cliente = codCliente;
    }

Mas ocorre esse erro que parece não estar encontrando a coluna cod_cliente da classe Orcamento:

org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'consultorController' defined in file [D:\TCC\vraptor-blank-project-3.1.1\build\web\WEB-INF\classes\br\bmweb\controller\ConsultorController.class]: Unsatisfied dependency expressed through constructor argument with index 3 of type [br.bmweb.dao.ProdutoDao]: : Error creating bean with name 'produtoDao' defined in file [D:\TCC\vraptor-blank-project-3.1.1\build\web\WEB-INF\classes\br\bmweb\dao\ProdutoDao.class]: Instantiation of bean failed; nested exception is org.springframework.beans.BeanInstantiationException: Could not instantiate bean class [br.bmweb.dao.ProdutoDao]: Constructor threw exception; nested exception is org.hibernate.AnnotationException: @OneToOne or @ManyToOne on br.bmweb.bean.Orcamento.cod_cliente references an unknown entity: int; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'produtoDao' defined in file [D:\TCC\vraptor-blank-project-3.1.1\build\web\WEB-INF\classes\br\bmweb\dao\ProdutoDao.class]: Instantiation of bean failed; nested exception is org.springframework.beans.BeanInstantiationException: Could not instantiate bean class [br.bmweb.dao.ProdutoDao]: Constructor threw exception; nested exception is org.hibernate.AnnotationException: @OneToOne or @ManyToOne on br.bmweb.bean.Orcamento.cod_cliente references an unknown entity: int
	org.springframework.beans.factory.support.ConstructorResolver.createArgumentArray(ConstructorResolver.java:698)
	org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:192)
	org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:984)
	org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:886)
	org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:479)
	org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:450)
	org.springframework.beans.factory.support.AbstractBeanFactory$2.getObject(AbstractBeanFactory.java:328)
	org.springframework.web.context.request.AbstractRequestAttributesScope.get(AbstractRequestAttributesScope.java:43)
	org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:324)
	org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:193)
	org.springframework.beans.factory.support.DefaultListableBeanFactory.getBeansOfType(DefaultListableBeanFactory.java:385)
	org.springframework.beans.factory.support.DefaultListableBeanFactory.getBeansOfType(DefaultListableBeanFactory.java:375)
	org.springframework.context.support.AbstractApplicationContext.getBeansOfType(AbstractApplicationContext.java:1069)
	org.springframework.beans.factory.BeanFactoryUtils.beansOfTypeIncludingAncestors(BeanFactoryUtils.java:221)
	br.com.caelum.vraptor.ioc.spring.VRaptorApplicationContext.getBean(VRaptorApplicationContext.java:244)
	br.com.caelum.vraptor.ioc.spring.SpringBasedContainer.instanceFor(SpringBasedContainer.java:59)
	br.com.caelum.vraptor.interceptor.InstantiateInterceptor.intercept(InstantiateInterceptor.java:41)
	br.com.caelum.vraptor.core.InstantiatedInterceptorHandler.execute(InstantiatedInterceptorHandler.java:47)
	br.com.caelum.vraptor.core.DefaultInterceptorStack.next(DefaultInterceptorStack.java:65)
	br.com.caelum.vraptor.interceptor.InterceptorListPriorToExecutionExtractor.intercept(InterceptorListPriorToExecutionExtractor.java:46)
	br.com.caelum.vraptor.core.ToInstantiateInterceptorHandler.execute(ToInstantiateInterceptorHandler.java:54)
	br.com.caelum.vraptor.core.DefaultInterceptorStack.next(DefaultInterceptorStack.java:65)
	br.com.caelum.vraptor.interceptor.FlashInterceptor.intercept(FlashInterceptor.java:80)
	br.com.caelum.vraptor.core.ToInstantiateInterceptorHandler.execute(ToInstantiateInterceptorHandler.java:54)
	br.com.caelum.vraptor.core.DefaultInterceptorStack.next(DefaultInterceptorStack.java:65)
	br.com.caelum.vraptor.interceptor.ResourceLookupInterceptor.intercept(ResourceLookupInterceptor.java:67)
	br.com.caelum.vraptor.core.ToInstantiateInterceptorHandler.execute(ToInstantiateInterceptorHandler.java:54)
	br.com.caelum.vraptor.core.DefaultInterceptorStack.next(DefaultInterceptorStack.java:65)
	br.com.caelum.vraptor.core.ToInstantiateInterceptorHandler.execute(ToInstantiateInterceptorHandler.java:56)
	br.com.caelum.vraptor.core.DefaultInterceptorStack.next(DefaultInterceptorStack.java:65)
	br.com.caelum.vraptor.core.DefaultRequestExecution.execute(DefaultRequestExecution.java:70)
	br.com.caelum.vraptor.VRaptor$1.insideRequest(VRaptor.java:92)
	br.com.caelum.vraptor.ioc.spring.SpringProvider.provideForRequest(SpringProvider.java:56)
	br.com.caelum.vraptor.VRaptor.doFilter(VRaptor.java:89)
root cause

org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'produtoDao' defined in file [D:\TCC\vraptor-blank-project-3.1.1\build\web\WEB-INF\classes\br\bmweb\dao\ProdutoDao.class]: Instantiation of bean failed; nested exception is org.springframework.beans.BeanInstantiationException: Could not instantiate bean class [br.bmweb.dao.ProdutoDao]: Constructor threw exception; nested exception is org.hibernate.AnnotationException: @OneToOne or @ManyToOne on br.bmweb.bean.Orcamento.cod_cliente references an unknown entity: int
	org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.instantiateBean(AbstractAutowireCapableBeanFactory.java:946)
	org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:890)
	org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:479)
	org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:450)
	org.springframework.beans.factory.support.AbstractBeanFactory$2.getObject(AbstractBeanFactory.java:328)
	org.springframework.web.context.request.AbstractRequestAttributesScope.get(AbstractRequestAttributesScope.java:43)
	org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:324)
	org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:189)
	org.springframework.beans.factory.support.DefaultListableBeanFactory.findAutowireCandidates(DefaultListableBeanFactory.java:820)
	org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:762)
	org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:680)
	org.springframework.beans.factory.support.ConstructorResolver.resolveAutowiredArgument(ConstructorResolver.java:771)
	org.springframework.beans.factory.support.ConstructorResolver.createArgumentArray(ConstructorResolver.java:691)
	org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:192)
	org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:984)
	org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:886)
	org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:479)
	org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:450)
	org.springframework.beans.factory.support.AbstractBeanFactory$2.getObject(AbstractBeanFactory.java:328)
	org.springframework.web.context.request.AbstractRequestAttributesScope.get(AbstractRequestAttributesScope.java:43)
	org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:324)
	org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:193)
	org.springframework.beans.factory.support.DefaultListableBeanFactory.getBeansOfType(DefaultListableBeanFactory.java:385)
	org.springframework.beans.factory.support.DefaultListableBeanFactory.getBeansOfType(DefaultListableBeanFactory.java:375)
	org.springframework.context.support.AbstractApplicationContext.getBeansOfType(AbstractApplicationContext.java:1069)
	org.springframework.beans.factory.BeanFactoryUtils.beansOfTypeIncludingAncestors(BeanFactoryUtils.java:221)
	br.com.caelum.vraptor.ioc.spring.VRaptorApplicationContext.getBean(VRaptorApplicationContext.java:244)
	br.com.caelum.vraptor.ioc.spring.SpringBasedContainer.instanceFor(SpringBasedContainer.java:59)
	br.com.caelum.vraptor.interceptor.InstantiateInterceptor.intercept(InstantiateInterceptor.java:41)
	br.com.caelum.vraptor.core.InstantiatedInterceptorHandler.execute(InstantiatedInterceptorHandler.java:47)
	br.com.caelum.vraptor.core.DefaultInterceptorStack.next(DefaultInterceptorStack.java:65)
	br.com.caelum.vraptor.interceptor.InterceptorListPriorToExecutionExtractor.intercept(InterceptorListPriorToExecutionExtractor.java:46)
	br.com.caelum.vraptor.core.ToInstantiateInterceptorHandler.execute(ToInstantiateInterceptorHandler.java:54)
	br.com.caelum.vraptor.core.DefaultInterceptorStack.next(DefaultInterceptorStack.java:65)
	br.com.caelum.vraptor.interceptor.FlashInterceptor.intercept(FlashInterceptor.java:80)
	br.com.caelum.vraptor.core.ToInstantiateInterceptorHandler.execute(ToInstantiateInterceptorHandler.java:54)
	br.com.caelum.vraptor.core.DefaultInterceptorStack.next(DefaultInterceptorStack.java:65)
	br.com.caelum.vraptor.interceptor.ResourceLookupInterceptor.intercept(ResourceLookupInterceptor.java:67)
	br.com.caelum.vraptor.core.ToInstantiateInterceptorHandler.execute(ToInstantiateInterceptorHandler.java:54)
	br.com.caelum.vraptor.core.DefaultInterceptorStack.next(DefaultInterceptorStack.java:65)
	br.com.caelum.vraptor.core.ToInstantiateInterceptorHandler.execute(ToInstantiateInterceptorHandler.java:56)
	br.com.caelum.vraptor.core.DefaultInterceptorStack.next(DefaultInterceptorStack.java:65)
	br.com.caelum.vraptor.core.DefaultRequestExecution.execute(DefaultRequestExecution.java:70)
	br.com.caelum.vraptor.VRaptor$1.insideRequest(VRaptor.java:92)
	br.com.caelum.vraptor.ioc.spring.SpringProvider.provideForRequest(SpringProvider.java:56)
	br.com.caelum.vraptor.VRaptor.doFilter(VRaptor.java:89)
root cause

org.springframework.beans.BeanInstantiationException: Could not instantiate bean class [br.bmweb.dao.ProdutoDao]: Constructor threw exception; nested exception is org.hibernate.AnnotationException: @OneToOne or @ManyToOne on br.bmweb.bean.Orcamento.cod_cliente references an unknown entity: int
	org.springframework.beans.BeanUtils.instantiateClass(BeanUtils.java:141)
	org.springframework.beans.factory.support.SimpleInstantiationStrategy.instantiate(SimpleInstantiationStrategy.java:72)
	org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.instantiateBean(AbstractAutowireCapableBeanFactory.java:938)
	org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:890)
	org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:479)
	org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:450)
	org.springframework.beans.factory.support.AbstractBeanFactory$2.getObject(AbstractBeanFactory.java:328)
	org.springframework.web.context.request.AbstractRequestAttributesScope.get(AbstractRequestAttributesScope.java:43)
	org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:324)
	org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:189)
	org.springframework.beans.factory.support.DefaultListableBeanFactory.findAutowireCandidates(DefaultListableBeanFactory.java:820)
	org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:762)
	org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:680)
	org.springframework.beans.factory.support.ConstructorResolver.resolveAutowiredArgument(ConstructorResolver.java:771)
	org.springframework.beans.factory.support.ConstructorResolver.createArgumentArray(ConstructorResolver.java:691)
	org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:192)
	org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:984)
	org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:886)
	org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:479)
	org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:450)
	org.springframework.beans.factory.support.AbstractBeanFactory$2.getObject(AbstractBeanFactory.java:328)
	org.springframework.web.context.request.AbstractRequestAttributesScope.get(AbstractRequestAttributesScope.java:43)
	org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:324)
	org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:193)
	org.springframework.beans.factory.support.DefaultListableBeanFactory.getBeansOfType(DefaultListableBeanFactory.java:385)
	org.springframework.beans.factory.support.DefaultListableBeanFactory.getBeansOfType(DefaultListableBeanFactory.java:375)
	org.springframework.context.support.AbstractApplicationContext.getBeansOfType(AbstractApplicationContext.java:1069)
	org.springframework.beans.factory.BeanFactoryUtils.beansOfTypeIncludingAncestors(BeanFactoryUtils.java:221)
	br.com.caelum.vraptor.ioc.spring.VRaptorApplicationContext.getBean(VRaptorApplicationContext.java:244)
	br.com.caelum.vraptor.ioc.spring.SpringBasedContainer.instanceFor(SpringBasedContainer.java:59)
	br.com.caelum.vraptor.interceptor.InstantiateInterceptor.intercept(InstantiateInterceptor.java:41)
	br.com.caelum.vraptor.core.InstantiatedInterceptorHandler.execute(InstantiatedInterceptorHandler.java:47)
	br.com.caelum.vraptor.core.DefaultInterceptorStack.next(DefaultInterceptorStack.java:65)
	br.com.caelum.vraptor.interceptor.InterceptorListPriorToExecutionExtractor.intercept(InterceptorListPriorToExecutionExtractor.java:46)
	br.com.caelum.vraptor.core.ToInstantiateInterceptorHandler.execute(ToInstantiateInterceptorHandler.java:54)
	br.com.caelum.vraptor.core.DefaultInterceptorStack.next(DefaultInterceptorStack.java:65)
	br.com.caelum.vraptor.interceptor.FlashInterceptor.intercept(FlashInterceptor.java:80)
	br.com.caelum.vraptor.core.ToInstantiateInterceptorHandler.execute(ToInstantiateInterceptorHandler.java:54)
	br.com.caelum.vraptor.core.DefaultInterceptorStack.next(DefaultInterceptorStack.java:65)
	br.com.caelum.vraptor.interceptor.ResourceLookupInterceptor.intercept(ResourceLookupInterceptor.java:67)
	br.com.caelum.vraptor.core.ToInstantiateInterceptorHandler.execute(ToInstantiateInterceptorHandler.java:54)
	br.com.caelum.vraptor.core.DefaultInterceptorStack.next(DefaultInterceptorStack.java:65)
	br.com.caelum.vraptor.core.ToInstantiateInterceptorHandler.execute(ToInstantiateInterceptorHandler.java:56)
	br.com.caelum.vraptor.core.DefaultInterceptorStack.next(DefaultInterceptorStack.java:65)
	br.com.caelum.vraptor.core.DefaultRequestExecution.execute(DefaultRequestExecution.java:70)
	br.com.caelum.vraptor.VRaptor$1.insideRequest(VRaptor.java:92)
	br.com.caelum.vraptor.ioc.spring.SpringProvider.provideForRequest(SpringProvider.java:56)
	br.com.caelum.vraptor.VRaptor.doFilter(VRaptor.java:89)
root cause

org.hibernate.AnnotationException: @OneToOne or @ManyToOne on br.bmweb.bean.Orcamento.cod_cliente references an unknown entity: int
	org.hibernate.cfg.ToOneFkSecondPass.doSecondPass(ToOneFkSecondPass.java:81)
	org.hibernate.cfg.AnnotationConfiguration.processEndOfQueue(AnnotationConfiguration.java:456)
	org.hibernate.cfg.AnnotationConfiguration.processFkSecondPassInOrder(AnnotationConfiguration.java:438)
	org.hibernate.cfg.AnnotationConfiguration.secondPassCompile(AnnotationConfiguration.java:309)
	org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1319)
	org.hibernate.cfg.AnnotationConfiguration.buildSessionFactory(AnnotationConfiguration.java:867)
	br.bmweb.util.AbreSession.getSession(AbreSession.java:11)
	br.bmweb.dao.ProdutoDao.<init>(ProdutoDao.java:19)
	sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
	sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
	sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
	java.lang.reflect.Constructor.newInstance(Constructor.java:513)
	org.springframework.beans.BeanUtils.instantiateClass(BeanUtils.java:126)
	org.springframework.beans.factory.support.SimpleInstantiationStrategy.instantiate(SimpleInstantiationStrategy.java:72)
	org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.instantiateBean(AbstractAutowireCapableBeanFactory.java:938)
	org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:890)
	org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:479)
	org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:450)
	org.springframework.beans.factory.support.AbstractBeanFactory$2.getObject(AbstractBeanFactory.java:328)
	org.springframework.web.context.request.AbstractRequestAttributesScope.get(AbstractRequestAttributesScope.java:43)
	org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:324)
	org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:189)
	org.springframework.beans.factory.support.DefaultListableBeanFactory.findAutowireCandidates(DefaultListableBeanFactory.java:820)
	org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:762)
	org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:680)
	org.springframework.beans.factory.support.ConstructorResolver.resolveAutowiredArgument(ConstructorResolver.java:771)
	org.springframework.beans.factory.support.ConstructorResolver.createArgumentArray(ConstructorResolver.java:691)
	org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:192)
	org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:984)
	org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:886)
	org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:479)
	org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:450)
	org.springframework.beans.factory.support.AbstractBeanFactory$2.getObject(AbstractBeanFactory.java:328)
	org.springframework.web.context.request.AbstractRequestAttributesScope.get(AbstractRequestAttributesScope.java:43)
	org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:324)
	org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:193)
	org.springframework.beans.factory.support.DefaultListableBeanFactory.getBeansOfType(DefaultListableBeanFactory.java:385)
	org.springframework.beans.factory.support.DefaultListableBeanFactory.getBeansOfType(DefaultListableBeanFactory.java:375)
	org.springframework.context.support.AbstractApplicationContext.getBeansOfType(AbstractApplicationContext.java:1069)
	org.springframework.beans.factory.BeanFactoryUtils.beansOfTypeIncludingAncestors(BeanFactoryUtils.java:221)
	br.com.caelum.vraptor.ioc.spring.VRaptorApplicationContext.getBean(VRaptorApplicationContext.java:244)
	br.com.caelum.vraptor.ioc.spring.SpringBasedContainer.instanceFor(SpringBasedContainer.java:59)
	br.com.caelum.vraptor.interceptor.InstantiateInterceptor.intercept(InstantiateInterceptor.java:41)
	br.com.caelum.vraptor.core.InstantiatedInterceptorHandler.execute(InstantiatedInterceptorHandler.java:47)
	br.com.caelum.vraptor.core.DefaultInterceptorStack.next(DefaultInterceptorStack.java:65)
	br.com.caelum.vraptor.interceptor.InterceptorListPriorToExecutionExtractor.intercept(InterceptorListPriorToExecutionExtractor.java:46)
	br.com.caelum.vraptor.core.ToInstantiateInterceptorHandler.execute(ToInstantiateInterceptorHandler.java:54)
	br.com.caelum.vraptor.core.DefaultInterceptorStack.next(DefaultInterceptorStack.java:65)
	br.com.caelum.vraptor.interceptor.FlashInterceptor.intercept(FlashInterceptor.java:80)
	br.com.caelum.vraptor.core.ToInstantiateInterceptorHandler.execute(ToInstantiateInterceptorHandler.java:54)
	br.com.caelum.vraptor.core.DefaultInterceptorStack.next(DefaultInterceptorStack.java:65)
	br.com.caelum.vraptor.interceptor.ResourceLookupInterceptor.intercept(ResourceLookupInterceptor.java:67)
	br.com.caelum.vraptor.core.ToInstantiateInterceptorHandler.execute(ToInstantiateInterceptorHandler.java:54)
	br.com.caelum.vraptor.core.DefaultInterceptorStack.next(DefaultInterceptorStack.java:65)
	br.com.caelum.vraptor.core.ToInstantiateInterceptorHandler.execute(ToInstantiateInterceptorHandler.java:56)
	br.com.caelum.vraptor.core.DefaultInterceptorStack.next(DefaultInterceptorStack.java:65)
	br.com.caelum.vraptor.core.DefaultRequestExecution.execute(DefaultRequestExecution.java:70)
	br.com.caelum.vraptor.VRaptor$1.insideRequest(VRaptor.java:92)
	br.com.caelum.vraptor.ioc.spring.SpringProvider.provideForRequest(SpringProvider.java:56)
	br.com.caelum.vraptor.VRaptor.doFilter(VRaptor.java:89)

Guevara 7 de nov. de 2010

Não entendi suas classes não, ai vai uma sugestão…

Classe Orcamento:

@Entity
public class Orcamento {
@Id
	@Column(name="cod_orcamento")
        private Long codOrcamento;
      // outros atributos se precisar

	@ManyToOne
	private Cliente cliente;
	
   // Não crie os gets, sets e construtor na mão, use o Eclipse para criá-los pra vc, vá em:
   // source>>generate constructor using fields
   // Depois crie os gets e sets:
   // source>>generate getters and setters

}

Classe Cliente:

@Entity
public class Cliente {
@Id
@Column(name="cod_cliente")
private Long codCliente;
// outros atributos;

    @OneToMany(targetEntity=Orcamento.class ,cascade = CascadeType.ALL, mappedBy = "cliente",orphanRemoval=true)
    public List<Orcamento> orcamentos;

 // Não crie os gets, sets e construtor na mão, use o Eclipse para criá-los pra vc, vá em:
   // source>>generate constructor using fields
   // Depois crie os gets e sets:
   // source>>generate getters and setters

}

Use notação Java para atributos, e no @Column vc coloca o nome que será usado para o nome da coluna no banco.

cristianogro 7 de nov. de 2010

Guevara tava seguindo suas sugestões e na Orçamento fiz assim: Orcamento:

@Id
    @GeneratedValue
    @Column(name = "OR_COD_ORCAMENTO")
    public int getCod_orcamento() {
        return cod_orcamento;
    }

    public void setCod_orcamento(int codOrcamento) {
        cod_orcamento = codOrcamento;
    }
    
    @ManyToOne
    private Cliente cliente;

    public Cliente getCliente() {
        return cliente;
    }

    public void setCliente(Cliente cliente) {
        this.cliente = cliente;

    @Column(name = "OR_COD_CLIENTE", nullable = false)
    public int getCod_cliente() {
        return cod_cliente;
    }

    public void setCod_cliente(int codCliente) {
        cod_cliente = codCliente;
    }
    }

Na cliente não consegui a propriedade orphanRemoval=true, pois ela não foi encontrada, tentei importá-la do pacote javax.persistente mas não encontrei, por enquanto deixei sem ela. Agora quando tento acessar a URL ocorre o seguinte:

org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'consultorController' defined in file [D:\TCC\vraptor-blank-project-3.1.1\build\web\WEB-INF\classes\br\bmweb\controller\ConsultorController.class]: Unsatisfied dependency expressed through constructor argument with index 3 of type [br.bmweb.dao.ProdutoDao]: : Error creating bean with name 'produtoDao' defined in file [D:\TCC\vraptor-blank-project-3.1.1\build\web\WEB-INF\classes\br\bmweb\dao\ProdutoDao.class]: Instantiation of bean failed; nested exception is org.springframework.beans.BeanInstantiationException: Could not instantiate bean class [br.bmweb.dao.ProdutoDao]: Constructor threw exception; nested exception is org.hibernate.MappingException: Could not determine type for: br.bmweb.bean.Cliente, at table: TB_ORCAMENTO, for columns: [org.hibernate.mapping.Column(cliente)]; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'produtoDao' defined in file [D:\TCC\vraptor-blank-project-3.1.1\build\web\WEB-INF\classes\br\bmweb\dao\ProdutoDao.class]: Instantiation of bean failed; nested exception is org.springframework.beans.BeanInstantiationException: Could not instantiate bean class [br.bmweb.dao.ProdutoDao]: Constructor threw exception; nested exception is org.hibernate.MappingException: Could not determine type for: br.bmweb.bean.Cliente, at table: TB_ORCAMENTO, for columns: [org.hibernate.mapping.Column(cliente)]
	org.springframework.beans.factory.support.ConstructorResolver.createArgumentArray(ConstructorResolver.java:698)
	org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:192)
	org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:984)
	org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:886)
	org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:479)
	org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:450)
	org.springframework.beans.factory.support.AbstractBeanFactory$2.getObject(AbstractBeanFactory.java:328)
	org.springframework.web.context.request.AbstractRequestAttributesScope.get(AbstractRequestAttributesScope.java:43)
	org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:324)
	org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:193)
	org.springframework.beans.factory.support.DefaultListableBeanFactory.getBeansOfType(DefaultListableBeanFactory.java:385)
	org.springframework.beans.factory.support.DefaultListableBeanFactory.getBeansOfType(DefaultListableBeanFactory.java:375)
	org.springframework.context.support.AbstractApplicationContext.getBeansOfType(AbstractApplicationContext.java:1069)
	org.springframework.beans.factory.BeanFactoryUtils.beansOfTypeIncludingAncestors(BeanFactoryUtils.java:221)
	br.com.caelum.vraptor.ioc.spring.VRaptorApplicationContext.getBean(VRaptorApplicationContext.java:244)
	br.com.caelum.vraptor.ioc.spring.SpringBasedContainer.instanceFor(SpringBasedContainer.java:59)
	br.com.caelum.vraptor.interceptor.InstantiateInterceptor.intercept(InstantiateInterceptor.java:41)
	br.com.caelum.vraptor.core.InstantiatedInterceptorHandler.execute(InstantiatedInterceptorHandler.java:47)
	br.com.caelum.vraptor.core.DefaultInterceptorStack.next(DefaultInterceptorStack.java:65)
	br.com.caelum.vraptor.interceptor.InterceptorListPriorToExecutionExtractor.intercept(InterceptorListPriorToExecutionExtractor.java:46)
	br.com.caelum.vraptor.core.ToInstantiateInterceptorHandler.execute(ToInstantiateInterceptorHandler.java:54)
	br.com.caelum.vraptor.core.DefaultInterceptorStack.next(DefaultInterceptorStack.java:65)
	br.com.caelum.vraptor.interceptor.FlashInterceptor.intercept(FlashInterceptor.java:80)
	br.com.caelum.vraptor.core.ToInstantiateInterceptorHandler.execute(ToInstantiateInterceptorHandler.java:54)
	br.com.caelum.vraptor.core.DefaultInterceptorStack.next(DefaultInterceptorStack.java:65)
	br.com.caelum.vraptor.interceptor.ResourceLookupInterceptor.intercept(ResourceLookupInterceptor.java:67)
	br.com.caelum.vraptor.core.ToInstantiateInterceptorHandler.execute(ToInstantiateInterceptorHandler.java:54)
	br.com.caelum.vraptor.core.DefaultInterceptorStack.next(DefaultInterceptorStack.java:65)
	br.com.caelum.vraptor.core.ToInstantiateInterceptorHandler.execute(ToInstantiateInterceptorHandler.java:56)
	br.com.caelum.vraptor.core.DefaultInterceptorStack.next(DefaultInterceptorStack.java:65)
	br.com.caelum.vraptor.core.DefaultRequestExecution.execute(DefaultRequestExecution.java:70)
	br.com.caelum.vraptor.VRaptor$1.insideRequest(VRaptor.java:92)
	br.com.caelum.vraptor.ioc.spring.SpringProvider.provideForRequest(SpringProvider.java:56)
	br.com.caelum.vraptor.VRaptor.doFilter(VRaptor.java:89)
root cause

org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'produtoDao' defined in file [D:\TCC\vraptor-blank-project-3.1.1\build\web\WEB-INF\classes\br\bmweb\dao\ProdutoDao.class]: Instantiation of bean failed; nested exception is org.springframework.beans.BeanInstantiationException: Could not instantiate bean class [br.bmweb.dao.ProdutoDao]: Constructor threw exception; nested exception is org.hibernate.MappingException: Could not determine type for: br.bmweb.bean.Cliente, at table: TB_ORCAMENTO, for columns: [org.hibernate.mapping.Column(cliente)]
	org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.instantiateBean(AbstractAutowireCapableBeanFactory.java:946)
	org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:890)
	org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:479)
	org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:450)
	org.springframework.beans.factory.support.AbstractBeanFactory$2.getObject(AbstractBeanFactory.java:328)
	org.springframework.web.context.request.AbstractRequestAttributesScope.get(AbstractRequestAttributesScope.java:43)
	org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:324)
	org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:189)
	org.springframework.beans.factory.support.DefaultListableBeanFactory.findAutowireCandidates(DefaultListableBeanFactory.java:820)
	org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:762)
	org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:680)
	org.springframework.beans.factory.support.ConstructorResolver.resolveAutowiredArgument(ConstructorResolver.java:771)
	org.springframework.beans.factory.support.ConstructorResolver.createArgumentArray(ConstructorResolver.java:691)
	org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:192)
	org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:984)
	org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:886)
	org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:479)
	org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:450)
	org.springframework.beans.factory.support.AbstractBeanFactory$2.getObject(AbstractBeanFactory.java:328)
	org.springframework.web.context.request.AbstractRequestAttributesScope.get(AbstractRequestAttributesScope.java:43)
	org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:324)
	org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:193)
	org.springframework.beans.factory.support.DefaultListableBeanFactory.getBeansOfType(DefaultListableBeanFactory.java:385)
	org.springframework.beans.factory.support.DefaultListableBeanFactory.getBeansOfType(DefaultListableBeanFactory.java:375)
	org.springframework.context.support.AbstractApplicationContext.getBeansOfType(AbstractApplicationContext.java:1069)
	org.springframework.beans.factory.BeanFactoryUtils.beansOfTypeIncludingAncestors(BeanFactoryUtils.java:221)
	br.com.caelum.vraptor.ioc.spring.VRaptorApplicationContext.getBean(VRaptorApplicationContext.java:244)
	br.com.caelum.vraptor.ioc.spring.SpringBasedContainer.instanceFor(SpringBasedContainer.java:59)
	br.com.caelum.vraptor.interceptor.InstantiateInterceptor.intercept(InstantiateInterceptor.java:41)
	br.com.caelum.vraptor.core.InstantiatedInterceptorHandler.execute(InstantiatedInterceptorHandler.java:47)
	br.com.caelum.vraptor.core.DefaultInterceptorStack.next(DefaultInterceptorStack.java:65)
	br.com.caelum.vraptor.interceptor.InterceptorListPriorToExecutionExtractor.intercept(InterceptorListPriorToExecutionExtractor.java:46)
	br.com.caelum.vraptor.core.ToInstantiateInterceptorHandler.execute(ToInstantiateInterceptorHandler.java:54)
	br.com.caelum.vraptor.core.DefaultInterceptorStack.next(DefaultInterceptorStack.java:65)
	br.com.caelum.vraptor.interceptor.FlashInterceptor.intercept(FlashInterceptor.java:80)
	br.com.caelum.vraptor.core.ToInstantiateInterceptorHandler.execute(ToInstantiateInterceptorHandler.java:54)
	br.com.caelum.vraptor.core.DefaultInterceptorStack.next(DefaultInterceptorStack.java:65)
	br.com.caelum.vraptor.interceptor.ResourceLookupInterceptor.intercept(ResourceLookupInterceptor.java:67)
	br.com.caelum.vraptor.core.ToInstantiateInterceptorHandler.execute(ToInstantiateInterceptorHandler.java:54)
	br.com.caelum.vraptor.core.DefaultInterceptorStack.next(DefaultInterceptorStack.java:65)
	br.com.caelum.vraptor.core.ToInstantiateInterceptorHandler.execute(ToInstantiateInterceptorHandler.java:56)
	br.com.caelum.vraptor.core.DefaultInterceptorStack.next(DefaultInterceptorStack.java:65)
	br.com.caelum.vraptor.core.DefaultRequestExecution.execute(DefaultRequestExecution.java:70)
	br.com.caelum.vraptor.VRaptor$1.insideRequest(VRaptor.java:92)
	br.com.caelum.vraptor.ioc.spring.SpringProvider.provideForRequest(SpringProvider.java:56)
	br.com.caelum.vraptor.VRaptor.doFilter(VRaptor.java:89)
root cause

org.springframework.beans.BeanInstantiationException: Could not instantiate bean class [br.bmweb.dao.ProdutoDao]: Constructor threw exception; nested exception is org.hibernate.MappingException: Could not determine type for: br.bmweb.bean.Cliente, at table: TB_ORCAMENTO, for columns: [org.hibernate.mapping.Column(cliente)]
	org.springframework.beans.BeanUtils.instantiateClass(BeanUtils.java:141)
	org.springframework.beans.factory.support.SimpleInstantiationStrategy.instantiate(SimpleInstantiationStrategy.java:72)
	org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.instantiateBean(AbstractAutowireCapableBeanFactory.java:938)
	org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:890)
	org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:479)
	org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:450)
	org.springframework.beans.factory.support.AbstractBeanFactory$2.getObject(AbstractBeanFactory.java:328)
	org.springframework.web.context.request.AbstractRequestAttributesScope.get(AbstractRequestAttributesScope.java:43)
	org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:324)
	org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:189)
	org.springframework.beans.factory.support.DefaultListableBeanFactory.findAutowireCandidates(DefaultListableBeanFactory.java:820)
	org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:762)
	org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:680)
	org.springframework.beans.factory.support.ConstructorResolver.resolveAutowiredArgument(ConstructorResolver.java:771)
	org.springframework.beans.factory.support.ConstructorResolver.createArgumentArray(ConstructorResolver.java:691)
	org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:192)
	org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:984)
	org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:886)
	org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:479)
	org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:450)
	org.springframework.beans.factory.support.AbstractBeanFactory$2.getObject(AbstractBeanFactory.java:328)
	org.springframework.web.context.request.AbstractRequestAttributesScope.get(AbstractRequestAttributesScope.java:43)
	org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:324)
	org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:193)
	org.springframework.beans.factory.support.DefaultListableBeanFactory.getBeansOfType(DefaultListableBeanFactory.java:385)
	org.springframework.beans.factory.support.DefaultListableBeanFactory.getBeansOfType(DefaultListableBeanFactory.java:375)
	org.springframework.context.support.AbstractApplicationContext.getBeansOfType(AbstractApplicationContext.java:1069)
	org.springframework.beans.factory.BeanFactoryUtils.beansOfTypeIncludingAncestors(BeanFactoryUtils.java:221)
	br.com.caelum.vraptor.ioc.spring.VRaptorApplicationContext.getBean(VRaptorApplicationContext.java:244)
	br.com.caelum.vraptor.ioc.spring.SpringBasedContainer.instanceFor(SpringBasedContainer.java:59)
	br.com.caelum.vraptor.interceptor.InstantiateInterceptor.intercept(InstantiateInterceptor.java:41)
	br.com.caelum.vraptor.core.InstantiatedInterceptorHandler.execute(InstantiatedInterceptorHandler.java:47)
	br.com.caelum.vraptor.core.DefaultInterceptorStack.next(DefaultInterceptorStack.java:65)
	br.com.caelum.vraptor.interceptor.InterceptorListPriorToExecutionExtractor.intercept(InterceptorListPriorToExecutionExtractor.java:46)
	br.com.caelum.vraptor.core.ToInstantiateInterceptorHandler.execute(ToInstantiateInterceptorHandler.java:54)
	br.com.caelum.vraptor.core.DefaultInterceptorStack.next(DefaultInterceptorStack.java:65)
	br.com.caelum.vraptor.interceptor.FlashInterceptor.intercept(FlashInterceptor.java:80)
	br.com.caelum.vraptor.core.ToInstantiateInterceptorHandler.execute(ToInstantiateInterceptorHandler.java:54)
	br.com.caelum.vraptor.core.DefaultInterceptorStack.next(DefaultInterceptorStack.java:65)
	br.com.caelum.vraptor.interceptor.ResourceLookupInterceptor.intercept(ResourceLookupInterceptor.java:67)
	br.com.caelum.vraptor.core.ToInstantiateInterceptorHandler.execute(ToInstantiateInterceptorHandler.java:54)
	br.com.caelum.vraptor.core.DefaultInterceptorStack.next(DefaultInterceptorStack.java:65)
	br.com.caelum.vraptor.core.ToInstantiateInterceptorHandler.execute(ToInstantiateInterceptorHandler.java:56)
	br.com.caelum.vraptor.core.DefaultInterceptorStack.next(DefaultInterceptorStack.java:65)
	br.com.caelum.vraptor.core.DefaultRequestExecution.execute(DefaultRequestExecution.java:70)
	br.com.caelum.vraptor.VRaptor$1.insideRequest(VRaptor.java:92)
	br.com.caelum.vraptor.ioc.spring.SpringProvider.provideForRequest(SpringProvider.java:56)
	br.com.caelum.vraptor.VRaptor.doFilter(VRaptor.java:89)
root cause

org.hibernate.MappingException: Could not determine type for: br.bmweb.bean.Cliente, at table: TB_ORCAMENTO, for columns: [org.hibernate.mapping.Column(cliente)]
	org.hibernate.mapping.SimpleValue.getType(SimpleValue.java:292)
	org.hibernate.mapping.SimpleValue.isValid(SimpleValue.java:276)
	org.hibernate.mapping.Property.isValid(Property.java:207)
	org.hibernate.mapping.PersistentClass.validate(PersistentClass.java:458)
	org.hibernate.mapping.RootClass.validate(RootClass.java:215)
	org.hibernate.cfg.Configuration.validate(Configuration.java:1135)
	org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1320)
	org.hibernate.cfg.AnnotationConfiguration.buildSessionFactory(AnnotationConfiguration.java:867)
	br.bmweb.util.AbreSession.getSession(AbreSession.java:11)
	br.bmweb.dao.ProdutoDao.<init>(ProdutoDao.java:19)
	sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
	sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
	sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
	java.lang.reflect.Constructor.newInstance(Constructor.java:513)
	org.springframework.beans.BeanUtils.instantiateClass(BeanUtils.java:126)
	org.springframework.beans.factory.support.SimpleInstantiationStrategy.instantiate(SimpleInstantiationStrategy.java:72)
	org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.instantiateBean(AbstractAutowireCapableBeanFactory.java:938)
	org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:890)
	org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:479)
	org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:450)
	org.springframework.beans.factory.support.AbstractBeanFactory$2.getObject(AbstractBeanFactory.java:328)
	org.springframework.web.context.request.AbstractRequestAttributesScope.get(AbstractRequestAttributesScope.java:43)
	org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:324)
	org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:189)
	org.springframework.beans.factory.support.DefaultListableBeanFactory.findAutowireCandidates(DefaultListableBeanFactory.java:820)
	org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:762)
	org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:680)
	org.springframework.beans.factory.support.ConstructorResolver.resolveAutowiredArgument(ConstructorResolver.java:771)
	org.springframework.beans.factory.support.ConstructorResolver.createArgumentArray(ConstructorResolver.java:691)
	org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:192)
	org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:984)
	org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:886)
	org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:479)
	org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:450)
	org.springframework.beans.factory.support.AbstractBeanFactory$2.getObject(AbstractBeanFactory.java:328)
	org.springframework.web.context.request.AbstractRequestAttributesScope.get(AbstractRequestAttributesScope.java:43)
	org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:324)
	org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:193)
	org.springframework.beans.factory.support.DefaultListableBeanFactory.getBeansOfType(DefaultListableBeanFactory.java:385)
	org.springframework.beans.factory.support.DefaultListableBeanFactory.getBeansOfType(DefaultListableBeanFactory.java:375)
	org.springframework.context.support.AbstractApplicationContext.getBeansOfType(AbstractApplicationContext.java:1069)
	org.springframework.beans.factory.BeanFactoryUtils.beansOfTypeIncludingAncestors(BeanFactoryUtils.java:221)
	br.com.caelum.vraptor.ioc.spring.VRaptorApplicationContext.getBean(VRaptorApplicationContext.java:244)
	br.com.caelum.vraptor.ioc.spring.SpringBasedContainer.instanceFor(SpringBasedContainer.java:59)
	br.com.caelum.vraptor.interceptor.InstantiateInterceptor.intercept(InstantiateInterceptor.java:41)
	br.com.caelum.vraptor.core.InstantiatedInterceptorHandler.execute(InstantiatedInterceptorHandler.java:47)
	br.com.caelum.vraptor.core.DefaultInterceptorStack.next(DefaultInterceptorStack.java:65)
	br.com.caelum.vraptor.interceptor.InterceptorListPriorToExecutionExtractor.intercept(InterceptorListPriorToExecutionExtractor.java:46)
	br.com.caelum.vraptor.core.ToInstantiateInterceptorHandler.execute(ToInstantiateInterceptorHandler.java:54)
	br.com.caelum.vraptor.core.DefaultInterceptorStack.next(DefaultInterceptorStack.java:65)
	br.com.caelum.vraptor.interceptor.FlashInterceptor.intercept(FlashInterceptor.java:80)
	br.com.caelum.vraptor.core.ToInstantiateInterceptorHandler.execute(ToInstantiateInterceptorHandler.java:54)
	br.com.caelum.vraptor.core.DefaultInterceptorStack.next(DefaultInterceptorStack.java:65)
	br.com.caelum.vraptor.interceptor.ResourceLookupInterceptor.intercept(ResourceLookupInterceptor.java:67)
	br.com.caelum.vraptor.core.ToInstantiateInterceptorHandler.execute(ToInstantiateInterceptorHandler.java:54)
	br.com.caelum.vraptor.core.DefaultInterceptorStack.next(DefaultInterceptorStack.java:65)
	br.com.caelum.vraptor.core.ToInstantiateInterceptorHandler.execute(ToInstantiateInterceptorHandler.java:56)
	br.com.caelum.vraptor.core.DefaultInterceptorStack.next(DefaultInterceptorStack.java:65)
	br.com.caelum.vraptor.core.DefaultRequestExecution.execute(DefaultRequestExecution.java:70)
	br.com.caelum.vraptor.VRaptor$1.insideRequest(VRaptor.java:92)
	br.com.caelum.vraptor.ioc.spring.SpringProvider.provideForRequest(SpringProvider.java:56)
	br.com.caelum.vraptor.VRaptor.doFilter(VRaptor.java:89)

Quando declaro

@ManyToOne
    private Cliente cliente;

eu não deveria definir um tipo de dado? Esse relacionamento ManyToOne deveria pertencer a coluna OR_COD_CLIENTE da tabela Orçamento, na classe esse relacionamento irá ser usado na variável cod_cliente da classe Orcamento, até coloquei ali em cima o trecho da classe.

cristianogro 7 de nov. de 2010

Bom, dando uma pesquisada por aí agora acho que estou perto da solução e tentei desta forma:

Classe Orçamento:

@Id
    @GeneratedValue
    @Column(name = "OR_COD_ORCAMENTO")
    public int getCod_orcamento() {
        return cod_orcamento;
    }

    public void setCod_orcamento(int codOrcamento) {
        cod_orcamento = codOrcamento;
    }

    @ManyToOne(targetEntity=Cliente.class, fetch = FetchType.LAZY)
    @JoinTable(name="tb_orcamento", joinColumns = @JoinColumn(name="OR_COD_CLIENTE"),inverseJoinColumns = @JoinColumn(name="CL_COD_CLIENTE"))
    private List<Cliente> cliente;

    @Column(name = "OR_COD_CLIENTE", nullable = false)
    public int getCod_cliente() {
        return cod_cliente;
    }

    public void setCod_cliente(int codCliente) {
        cod_cliente = codCliente;
    }

Mas ao acessar a URL acontece isso:

br.com.caelum.vraptor.InterceptionException: an exception was raised while executing resource method
	br.com.caelum.vraptor.interceptor.ExecuteMethodInterceptor.intercept(ExecuteMethodInterceptor.java:86)
	br.com.caelum.vraptor.core.ToInstantiateInterceptorHandler.execute(ToInstantiateInterceptorHandler.java:54)
	br.com.caelum.vraptor.core.DefaultInterceptorStack.next(DefaultInterceptorStack.java:65)
	br.com.caelum.vraptor.core.ToInstantiateInterceptorHandler.execute(ToInstantiateInterceptorHandler.java:56)
	br.com.caelum.vraptor.core.DefaultInterceptorStack.next(DefaultInterceptorStack.java:65)
	br.com.caelum.vraptor.interceptor.ParametersInstantiatorInterceptor.intercept(ParametersInstantiatorInterceptor.java:77)
	br.com.caelum.vraptor.core.ToInstantiateInterceptorHandler.execute(ToInstantiateInterceptorHandler.java:54)
	br.com.caelum.vraptor.core.DefaultInterceptorStack.next(DefaultInterceptorStack.java:65)
	br.com.caelum.vraptor.interceptor.InstantiateInterceptor.intercept(InstantiateInterceptor.java:42)
	br.com.caelum.vraptor.core.InstantiatedInterceptorHandler.execute(InstantiatedInterceptorHandler.java:47)
	br.com.caelum.vraptor.core.DefaultInterceptorStack.next(DefaultInterceptorStack.java:65)
	br.com.caelum.vraptor.interceptor.InterceptorListPriorToExecutionExtractor.intercept(InterceptorListPriorToExecutionExtractor.java:46)
	br.com.caelum.vraptor.core.ToInstantiateInterceptorHandler.execute(ToInstantiateInterceptorHandler.java:54)
	br.com.caelum.vraptor.core.DefaultInterceptorStack.next(DefaultInterceptorStack.java:65)
	br.com.caelum.vraptor.interceptor.FlashInterceptor.intercept(FlashInterceptor.java:80)
	br.com.caelum.vraptor.core.ToInstantiateInterceptorHandler.execute(ToInstantiateInterceptorHandler.java:54)
	br.com.caelum.vraptor.core.DefaultInterceptorStack.next(DefaultInterceptorStack.java:65)
	br.com.caelum.vraptor.interceptor.ResourceLookupInterceptor.intercept(ResourceLookupInterceptor.java:67)
	br.com.caelum.vraptor.core.ToInstantiateInterceptorHandler.execute(ToInstantiateInterceptorHandler.java:54)
	br.com.caelum.vraptor.core.DefaultInterceptorStack.next(DefaultInterceptorStack.java:65)
	br.com.caelum.vraptor.core.ToInstantiateInterceptorHandler.execute(ToInstantiateInterceptorHandler.java:56)
	br.com.caelum.vraptor.core.DefaultInterceptorStack.next(DefaultInterceptorStack.java:65)
	br.com.caelum.vraptor.core.DefaultRequestExecution.execute(DefaultRequestExecution.java:70)
	br.com.caelum.vraptor.VRaptor$1.insideRequest(VRaptor.java:92)
	br.com.caelum.vraptor.ioc.spring.SpringProvider.provideForRequest(SpringProvider.java:56)
	br.com.caelum.vraptor.VRaptor.doFilter(VRaptor.java:89)
root cause

org.hibernate.QueryException: could not resolve property: cliente of: br.bmweb.bean.Orcamento
	org.hibernate.persister.entity.AbstractPropertyMapping.propertyException(AbstractPropertyMapping.java:67)
	org.hibernate.persister.entity.AbstractPropertyMapping.toType(AbstractPropertyMapping.java:61)
	org.hibernate.persister.entity.AbstractEntityPersister.toType(AbstractEntityPersister.java:1385)
	org.hibernate.loader.criteria.CriteriaQueryTranslator.getPathEntityName(CriteriaQueryTranslator.java:227)
	org.hibernate.loader.criteria.CriteriaQueryTranslator.createCriteriaEntityNameMap(CriteriaQueryTranslator.java:214)
	org.hibernate.loader.criteria.CriteriaQueryTranslator.<init>(CriteriaQueryTranslator.java:104)
	org.hibernate.loader.criteria.CriteriaLoader.<init>(CriteriaLoader.java:82)
	org.hibernate.impl.SessionImpl.list(SessionImpl.java:1577)
	org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:306)
	br.bmweb.dao.OrcamentoDao.lista(OrcamentoDao.java:78)
	br.bmweb.controller.ConsultorController.Orcamentos(ConsultorController.java:162)
	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)
	br.com.caelum.vraptor.interceptor.ExecuteMethodInterceptor.intercept(ExecuteMethodInterceptor.java:57)
	br.com.caelum.vraptor.core.ToInstantiateInterceptorHandler.execute(ToInstantiateInterceptorHandler.java:54)
	br.com.caelum.vraptor.core.DefaultInterceptorStack.next(DefaultInterceptorStack.java:65)
	br.com.caelum.vraptor.core.ToInstantiateInterceptorHandler.execute(ToInstantiateInterceptorHandler.java:56)
	br.com.caelum.vraptor.core.DefaultInterceptorStack.next(DefaultInterceptorStack.java:65)
	br.com.caelum.vraptor.interceptor.ParametersInstantiatorInterceptor.intercept(ParametersInstantiatorInterceptor.java:77)
	br.com.caelum.vraptor.core.ToInstantiateInterceptorHandler.execute(ToInstantiateInterceptorHandler.java:54)
	br.com.caelum.vraptor.core.DefaultInterceptorStack.next(DefaultInterceptorStack.java:65)
	br.com.caelum.vraptor.interceptor.InstantiateInterceptor.intercept(InstantiateInterceptor.java:42)
	br.com.caelum.vraptor.core.InstantiatedInterceptorHandler.execute(InstantiatedInterceptorHandler.java:47)
	br.com.caelum.vraptor.core.DefaultInterceptorStack.next(DefaultInterceptorStack.java:65)
	br.com.caelum.vraptor.interceptor.InterceptorListPriorToExecutionExtractor.intercept(InterceptorListPriorToExecutionExtractor.java:46)
	br.com.caelum.vraptor.core.ToInstantiateInterceptorHandler.execute(ToInstantiateInterceptorHandler.java:54)
	br.com.caelum.vraptor.core.DefaultInterceptorStack.next(DefaultInterceptorStack.java:65)
	br.com.caelum.vraptor.interceptor.FlashInterceptor.intercept(FlashInterceptor.java:80)
	br.com.caelum.vraptor.core.ToInstantiateInterceptorHandler.execute(ToInstantiateInterceptorHandler.java:54)
	br.com.caelum.vraptor.core.DefaultInterceptorStack.next(DefaultInterceptorStack.java:65)
	br.com.caelum.vraptor.interceptor.ResourceLookupInterceptor.intercept(ResourceLookupInterceptor.java:67)
	br.com.caelum.vraptor.core.ToInstantiateInterceptorHandler.execute(ToInstantiateInterceptorHandler.java:54)
	br.com.caelum.vraptor.core.DefaultInterceptorStack.next(DefaultInterceptorStack.java:65)
	br.com.caelum.vraptor.core.ToInstantiateInterceptorHandler.execute(ToInstantiateInterceptorHandler.java:56)
	br.com.caelum.vraptor.core.DefaultInterceptorStack.next(DefaultInterceptorStack.java:65)
	br.com.caelum.vraptor.core.DefaultRequestExecution.execute(DefaultRequestExecution.java:70)
	br.com.caelum.vraptor.VRaptor$1.insideRequest(VRaptor.java:92)
	br.com.caelum.vraptor.ioc.spring.SpringProvider.provideForRequest(SpringProvider.java:56)
	br.com.caelum.vraptor.VRaptor.doFilter(VRaptor.java:89)

Basicamente ele não encontrou a entidade Cliente na classe Orçamento mas ainda estou tentando achar o que fiz de errado naquele relacionamento ManyToOne :( , se alguém puder me dar uma dica agradeço.

cristianogro 8 de nov. de 2010

Senhores, Bingo por aqui, com mais um pouco de pesquisa deixei assim:

Classe Orçamento:

@Id
    @GeneratedValue
    @Column(name = "OR_COD_ORCAMENTO")
    public int getCod_orcamento() {
        return cod_orcamento;
    }

    public void setCod_orcamento(int codOrcamento) {
        cod_orcamento = codOrcamento;
    }

    public Cliente cliente;
    @ManyToOne(targetEntity=Cliente.class, fetch = FetchType.LAZY)
    @JoinTable(name="tb_orcamento", joinColumns = @JoinColumn(name="OR_COD_CLIENTE"),inverseJoinColumns = @JoinColumn(name="CL_COD_CLIENTE"))
    public Cliente getCliente() {
        return cliente;
    }

    public void setCliente(Cliente cliente) {
        this.cliente = cliente;
    }

Acessei a URL mas a tela veio vazia :( mas no console ele montou esse SELECT:

select
        this_.OR_COD_ORCAMENTO as OR1_620_1_,
        this_.OR_COD_CLIENTE as OR2_620_1_,
        this_.OR_COD_FUNCIONARIO as OR3_620_1_,
        this_.OR_DATA_ALTERACAO as OR4_620_1_,
        this_.OR_DATA_FECHAMENTO as OR5_620_1_,
        this_.OR_DATA_ORCAMENTO as OR6_620_1_,
        this_.OR_DATA_VALIDADE as OR7_620_1_,
        this_.OR_STATUS_ORCAMENTO as OR8_620_1_,
        this_.OR_TIPO_ORCAMENTO as OR9_620_1_,
        this_.OR_VALOR_TOTAL as OR10_620_1_,
        this_.OR_VALOR_UNIT as OR11_620_1_,
        this_1_.CL_COD_CLIENTE as CL1_621_1_,
        cliente1_.CL_COD_CLIENTE as CL1_618_0_,
        cliente1_.CL_BAIRRO as CL2_618_0_,
        cliente1_.CL_CEP as CL3_618_0_,
        cliente1_.CL_CIDADE as CL4_618_0_,
        cliente1_.CL_CNPJ as CL5_618_0_,
        cliente1_.CL_COMPLEMENTO as CL6_618_0_,
        cliente1_.CL_CONTATO as CL7_618_0_,
        cliente1_.CL_CPF as CL8_618_0_,
        cliente1_.CL_DATA_CADASTRO as CL9_618_0_,
        cliente1_.CL_DATA_NASCIMENTO as CL10_618_0_,
        cliente1_.CL_DDD_CELULAR as CL11_618_0_,
        cliente1_.CL_DDD_COMERCIAL as CL12_618_0_,
        cliente1_.CL_DDD_RESIDENCIAL as CL13_618_0_,
        cliente1_.CL_EMAIL as CL14_618_0_,
        cliente1_.CL_ESTADO as CL15_618_0_,
        cliente1_.CL_FONE_CELULAR as CL16_618_0_,
        cliente1_.CL_FONE_COMERCIAL as CL17_618_0_,
        cliente1_.CL_FONE_RESIDENCIAL as CL18_618_0_,
        cliente1_.CL_LOGRADOURO as CL19_618_0_,
        cliente1_.CL_MERCADO as CL20_618_0_,
        cliente1_.CL_NEWS_LETTER as CL21_618_0_,
        cliente1_.CL_NOME as CL22_618_0_,
        cliente1_.CL_NUMERO as CL23_618_0_,
        cliente1_.CL_PLACA as CL24_618_0_,
        cliente1_.CL_PROFISSAO as CL25_618_0_,
        cliente1_.CL_RAMAL_COMERCIAL as CL26_618_0_,
        cliente1_.CL_RG as CL27_618_0_,
        cliente1_.CL_TIPO_CLIENTE as CL28_618_0_,
        cliente1_.CL_TIPO_ENDERECO as CL29_618_0_,
        cliente1_.CL_TITULO_LOGRADOURO as CL30_618_0_ 
    from
        bmweb.TB_ORCAMENTO this_ 
    left outer join
        tb_orcamento this_1_ 
            on this_.OR_COD_ORCAMENTO=this_1_.OR_COD_CLIENTE 
    inner join
        bmweb.TB_CLIENTE cliente1_ 
            on this_1_.CL_COD_CLIENTE=cliente1_.CL_COD_CLIENTE 
    where
        this_.OR_COD_ORCAMENTO=?

O SELECT acima não retornou nada mas por hj já posso ir dormir por ter conseguido usar Criteria no Hibernate, amanhã reviso o que montei de errado pra ajustar o SELECT e retornar os dados, Lucas e Guevara obrigado por mostrarem o caminho das pedras :D vou tentar arrumar aqui para o que eu preciso e qualquer coisa pergunto aqui novamente.

Guevara ainda ficou no ar minha dúvida sobre a propriedade orphanRemoval=true que vc sugeriu no relacionamento OneToMany da classe Cliente, para que serve esta propriedade?

cristianogro 8 de nov. de 2010

Analisando o meu SELECT na linha 48 ele faz isso: on this_.OR_COD_ORCAMENTO=this_1_.OR_COD_CLIENTE, ele deveria fazer algo como on Orcamento.OR_COD_CLIENTE=Cliente.CL_COD_CLIENTE, agora pergunto: Porque ele tentou fazer esse JOIN errado?

Meu mapeamento tá assim:

Orcamento:

public Cliente cliente; @ManyToOne(targetEntity=Cliente.class, fetch = FetchType.LAZY) @JoinTable(name="tb_orcamento", joinColumns = @JoinColumn(name="OR_COD_CLIENTE"),inverseJoinColumns = @JoinColumn(name="CL_COD_CLIENTE")) public Cliente getCliente() { return cliente; }
Cliente:

@OneToMany(targetEntity=Orcamento.class ,cascade = CascadeType.ALL, mappedBy = "cliente") public List<Orcamento> orcamentos;
É o meu relacionamento ManyToOne da classe Orcamento que tá errado?

cristianogro 9 de nov. de 2010

Realmente não sei fazer este relacionamento no Hibernate? Alguém aí tem alguma idéia ou palpite? Eu já não sei mais o que fazer.

Lucas_Cavalcanti 9 de nov. de 2010

cristiano, acho que é melhor vc aprender o hibernate desde o começo…

ficar indo na tentativa e erro, sem entender o que acontece, não vai te ajudar a mexer com o hibernate…

existem diversos tutorias por aí (aqui no guj inclusive), e a própria apostila do VRaptor tem uma introdução sobre o hibernate, recomendo que vc dê uma olhada:
http://www.caelum.com.br/curso/fj-28-vraptor-hibernate-ajax/

Guevara 9 de nov. de 2010

Na classe Orcamento podia ter deixado:

public class Orcamento {

@ManyToOne
private Cliente cliente;

// outros atributos
}

A anotação em cima do atributo private e sem todos aqueles parâmetros.

cristianogro 9 de nov. de 2010

Tentei mas deu esse erro:

root cause 

org.hibernate.QueryException: could not resolve property: cliente of: br.bmweb.bean.Orcamento
	org.hibernate.persister.entity.AbstractPropertyMapping.propertyException(AbstractPropertyMapping.java:67)
	org.hibernate.persister.entity.AbstractPropertyMapping.toType(AbstractPropertyMapping.java:61)
	org.hibernate.persister.entity.AbstractEntityPersister.toType(AbstractEntityPersister.java:1385)
	org.hibernate.loader.criteria.CriteriaQueryTranslator.getPathEntityName(CriteriaQueryTranslator.java:227)
	org.hibernate.loader.criteria.CriteriaQueryTranslator.createCriteriaEntityNameMap(CriteriaQueryTranslator.java:214)
	org.hibernate.loader.criteria.CriteriaQueryTranslator.<init>(CriteriaQueryTranslator.java:104)
	org.hibernate.loader.criteria.CriteriaLoader.<init>(CriteriaLoader.java:82)
	org.hibernate.impl.SessionImpl.list(SessionImpl.java:1577)
	org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:306)
	br.bmweb.dao.OrcamentoDao.lista(OrcamentoDao.java:80)
	br.bmweb.controller.ConsultorController.Orcamentos(ConsultorController.java:682)
	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)
	br.com.caelum.vraptor.interceptor.ExecuteMethodInterceptor.intercept(ExecuteMethodInterceptor.java:57)
	br.com.caelum.vraptor.core.ToInstantiateInterceptorHandler.execute(ToInstantiateInterceptorHandler.java:54)
	br.com.caelum.vraptor.core.DefaultInterceptorStack.next(DefaultInterceptorStack.java:65)
	br.com.caelum.vraptor.core.ToInstantiateInterceptorHandler.execute(ToInstantiateInterceptorHandler.java:56)
	br.com.caelum.vraptor.core.DefaultInterceptorStack.next(DefaultInterceptorStack.java:65)
	br.com.caelum.vraptor.interceptor.ParametersInstantiatorInterceptor.intercept(ParametersInstantiatorInterceptor.java:77)
	br.com.caelum.vraptor.core.ToInstantiateInterceptorHandler.execute(ToInstantiateInterceptorHandler.java:54)
	br.com.caelum.vraptor.core.DefaultInterceptorStack.next(DefaultInterceptorStack.java:65)
	br.com.caelum.vraptor.interceptor.InstantiateInterceptor.intercept(InstantiateInterceptor.java:42)
	br.com.caelum.vraptor.core.InstantiatedInterceptorHandler.execute(InstantiatedInterceptorHandler.java:47)
	br.com.caelum.vraptor.core.DefaultInterceptorStack.next(DefaultInterceptorStack.java:65)
	br.com.caelum.vraptor.interceptor.InterceptorListPriorToExecutionExtractor.intercept(InterceptorListPriorToExecutionExtractor.java:46)
	br.com.caelum.vraptor.core.ToInstantiateInterceptorHandler.execute(ToInstantiateInterceptorHandler.java:54)
	br.com.caelum.vraptor.core.DefaultInterceptorStack.next(DefaultInterceptorStack.java:65)
	br.com.caelum.vraptor.interceptor.FlashInterceptor.intercept(FlashInterceptor.java:80)
	br.com.caelum.vraptor.core.ToInstantiateInterceptorHandler.execute(ToInstantiateInterceptorHandler.java:54)
	br.com.caelum.vraptor.core.DefaultInterceptorStack.next(DefaultInterceptorStack.java:65)
	br.com.caelum.vraptor.interceptor.ResourceLookupInterceptor.intercept(ResourceLookupInterceptor.java:67)
	br.com.caelum.vraptor.core.ToInstantiateInterceptorHandler.execute(ToInstantiateInterceptorHandler.java:54)
	br.com.caelum.vraptor.core.DefaultInterceptorStack.next(DefaultInterceptorStack.java:65)
	br.com.caelum.vraptor.core.ToInstantiateInterceptorHandler.execute(ToInstantiateInterceptorHandler.java:56)
	br.com.caelum.vraptor.core.DefaultInterceptorStack.next(DefaultInterceptorStack.java:65)
	br.com.caelum.vraptor.core.DefaultRequestExecution.execute(DefaultRequestExecution.java:70)
	br.com.caelum.vraptor.VRaptor$1.insideRequest(VRaptor.java:92)
	br.com.caelum.vraptor.ioc.spring.SpringProvider.provideForRequest(SpringProvider.java:56)
	br.com.caelum.vraptor.VRaptor.doFilter(VRaptor.java:89)
	org.netbeans.modules.web.monitor.server.MonitorFilter.doFilter(MonitorFilter.java:390)

Minha DAO:

public List<Orcamento> lista() {
        System.out.println("Dao");
        Criteria crit = session.createCriteria(Orcamento.class);
        Criteria clienteCrit = crit.createCriteria("cliente");
        crit.add(Restrictions.eq("cod_orcamento", 11));
        //crit.add(Restrictions.like("status_orcamento", "Aber%"));
        return crit.list();
    }

Parece que é nessa linha

Criteria clienteCrit = crit.createCriteria("cliente");

, tentei assim:

Criteria clienteCrit = crit.createCriteria("Cliente");

mas nada.

Guevara 9 de nov. de 2010

Beleza, o problema não é a anotação, mas a sua Criteria.
Tente assim:

public List<Orcamento> lista() {
        Criteria crit = session.createCriteria(Orcamento.class).createAlias("cliente", "c");
        crit.add(Restrictions.eq("c.codOrcamento", new Integer(11)));
        return crit.list();
    }

Cuidado com esses nomes de atributos (cod_orcamento), vc tá colocando como se fosse nome de coluna de banco, têm que acostumar a usar notação Java, o Hibernate vai usar suas classes e seus atributos.

cristianogro 9 de nov. de 2010

Ocorreu o mesmo erro e o nome do meu atributo na classe é cod_cliente, estranho que o erro que acusa é como se ele não estivesse encontrando o relacionamento. Será que realmente tá certo o relacionamento?

Guevara 9 de nov. de 2010

É só conferir como vc deixou suas id’s, se batem com o que está na classe vai funcionar, o que pode estar ocorrendo é que vc possui coluna no banco com outro nome, veja lá se cada tabela possui apenas uma coluna com o nome da sua id que está na classe.
Se deixar aqueles atributos com aquela notação sql só vai ter problemas pra visualizar onde está o erro.
Deixe as classes com a notação que postei e a Criteria tb.

cristianogro 9 de nov. de 2010

Bom, parece estar tudo correto. Na classe Cliente tá assim:

@Id
    @GeneratedValue
    @Column(name = "CL_COD_CLIENTE", nullable = false)
    public int getCod_cliente() {
        return cod_cliente;
    }
    @OneToMany(targetEntity=Orcamento.class ,cascade = CascadeType.ALL, mappedBy = "cliente")
    public List<Orcamento> orcamentos;

Na tabela o nome da coluna é CL_COD_CLIENTE. Na classe Orcamento tá assim:

@Id
    @GeneratedValue
    @Column(name = "OR_COD_ORCAMENTO")
    public int getCod_orcamento() {
        return cod_orcamento;
    }

    public void setCod_orcamento(int codOrcamento) {
        cod_orcamento = codOrcamento;
    }
    @ManyToOne
    private Cliente cliente;
    
    @Column(name = "OR_COD_CLIENTE", nullable = false)
    public int getCod_cliente() {
        return cod_cliente;
    }

O nome da coluna do código do Cliente na tabela Orçamento é OR_COD_CLIENTE. Aparentemente tá certo.

cristianogro 9 de nov. de 2010

Consegui fazer funcionar mas alterei minha DAO para:

public List<Orcamento> lista() { Criteria crit = session.createCriteria(Orcamento.class); crit.add(Restrictions.eq("cod_orcamento", new Integer(11))); return crit.list(); }
Ou seja, removi o createAlias, mas não consegui descobrir o porque de não funcionar com o createAlias.

Guevara 10 de nov. de 2010

O alias só vai funcionar se o atributo que vc esta buscando existir na classe Cliente:

public List<Orcamento> lista() {
        Criteria crit = session.createCriteria(Orcamento.class).createAlias("cliente", "c");
        crit.add(Restrictions.eq("c.cod_orcamento", new Integer(11)));
        return crit.list();
    }

No exemplo anterior, estava pegando o cod_orcamento na classe Cliente, se cod_orcamento não existir vc busca pelo que existir lá.
Sem o alias funciona pq cod_orcamento esta na própria classe Orcamento, funcionou pq existe orçamento com código 11, se vc quiser pegar todos os orçamentos de um determinado cliente vc terá que passar o código do cliente por parâmetro para a Criteria encontrar e não dessa forma que vc está fazendo.

cristianogro 10 de nov. de 2010

Olha que estranho, fiz essa Criteria:

public List<Orcamento> lista() {
        System.out.println("Dao");
        Criteria crit = session.createCriteria(Orcamento.class);
        crit = crit.createCriteria("cliente");
        crit.add(Restrictions.eq("cod_cliente", 11));
        return crit.list();   
    }

Mandei buscar os Orçamentos do cliente de código 11, na minha tabela Orcamento existe a coluna cod_cliente. O mapeamento tá assim:

@ManyToOne()
    public Cliente cliente;

    @Column(name = "OR_COD_CLIENTE", nullable = false)
    public int getCod_cliente() {
        return cod_cliente;
    }

Ao tentar executar a criteria ainda persiste o erro:

org.hibernate.QueryException: could not resolve property: cliente of: br.bmweb.bean.Orcamento
	org.hibernate.persister.entity.AbstractPropertyMapping.propertyException(AbstractPropertyMapping.java:67)
	org.hibernate.persister.entity.AbstractPropertyMapping.toType(AbstractPropertyMapping.java:61)
	org.hibernate.persister.entity.AbstractEntityPersister.toType(AbstractEntityPersister.java:1385)

Ele não tá encontrando a propriedade cliente na classe Orcamento, do meu ponto de vista está tudo certo, pra montar a Criteria segui este tópico implementando o exemplo que o Paulo Silveira postou [url]http://www.guj.com.br/posts/list/41523.java[/url], deveria funcionar a Criteria não deveria?

Guevara 10 de nov. de 2010

Experimenta colocar as anotações em cima dos atributos e não em cima dos gets.

cristianogro 10 de nov. de 2010

Também não foi, o jeito é eu fechar esse tópico aqui e abrir um lá na parte de persistência pra ver se o pessoal tem idéia.

Guevara 10 de nov. de 2010

Mas vc não viu e nem postou a JSP com o Controller, como alguém vai adivinhar exatamente onde está o erro? Se vc postar lá e não mostrar o código ninguém vai adivinhar, além do mais, postar seu projeto war e esperar que alguém venha baixar e resolver pra vc fica inviável.

cristianogro 10 de nov. de 2010

Ok, não tinha postado o Controller porque o erro ocorre justamente na Criteria que está na DAO, então o JSP nem chega a ser processado e mostrado, se acesso a URL já vai direto para o erro, meu objetivo desde o início é fazer um SELECT que irá trazer uma lista de dados da tabela, estou tentando fazer esta Criteria simples entre tabela Cliente e Orcamento para depois montar a verdadeira Criteria que vou usar, a qual irá possuir relacionamento com 3 tabelas, seguem o meu Controller, DAO, JSP e classes mapeadas, vou postar apenas a parte de interessa do código:

ConsultorController:

public List<Orcamento> Orcamentos(){
        return orcamentodao.lista();
    }

OrcamentoDao:

public List<Orcamento> lista() {  
        Criteria crit = session.createCriteria(Orcamento.class);
        crit = crit.createCriteria("cliente");
        crit.add(Restrictions.eq("cod_cliente", 11));
        return crit.list();
    }

Orcamentos.jsp:

<table width="763">
                <c:forEach items="${orcamentoList}" var="orcamento">
                    <tr>
                    <td>
                    <input name="a" type="text" id="cod_orcamento" value="${orcamento.cod_orcamento}" />
                    </td>
                    </tr>
                </c:forEach>
            </table>

Cliente:

@Id
    @GeneratedValue
    @Column(name = "CL_COD_CLIENTE", nullable = false)
    public int getCod_cliente() {
        return cod_cliente;
    }

    public void setCod_cliente(int codCliente) {
        cod_cliente = codCliente;
    }
    @OneToMany(targetEntity=Orcamento.class ,cascade = CascadeType.ALL, mappedBy = "cliente")
    public List<Orcamento> orcamento;
    //...outros atributos...

Orcamento:

@Id
    @GeneratedValue
    @Column(name = "OR_COD_ORCAMENTO")
    public int getCod_orcamento() {
        return cod_orcamento;
    }

    public void setCod_orcamento(int codOrcamento) {
        cod_orcamento = codOrcamento;
    }
    @ManyToOne
    @Fetch(FetchMode.JOIN)
    private Cliente cliente;

O erro completo que ocorre é este:

br.com.caelum.vraptor.InterceptionException: an exception was raised while executing resource method
	br.com.caelum.vraptor.interceptor.ExecuteMethodInterceptor.intercept(ExecuteMethodInterceptor.java:86)
	br.com.caelum.vraptor.core.ToInstantiateInterceptorHandler.execute(ToInstantiateInterceptorHandler.java:54)
	br.com.caelum.vraptor.core.DefaultInterceptorStack.next(DefaultInterceptorStack.java:65)
	br.com.caelum.vraptor.core.ToInstantiateInterceptorHandler.execute(ToInstantiateInterceptorHandler.java:56)
	br.com.caelum.vraptor.core.DefaultInterceptorStack.next(DefaultInterceptorStack.java:65)
	br.com.caelum.vraptor.interceptor.ParametersInstantiatorInterceptor.intercept(ParametersInstantiatorInterceptor.java:77)
	br.com.caelum.vraptor.core.ToInstantiateInterceptorHandler.execute(ToInstantiateInterceptorHandler.java:54)
	br.com.caelum.vraptor.core.DefaultInterceptorStack.next(DefaultInterceptorStack.java:65)
	br.com.caelum.vraptor.interceptor.InstantiateInterceptor.intercept(InstantiateInterceptor.java:42)
	br.com.caelum.vraptor.core.InstantiatedInterceptorHandler.execute(InstantiatedInterceptorHandler.java:47)
	br.com.caelum.vraptor.core.DefaultInterceptorStack.next(DefaultInterceptorStack.java:65)
	br.com.caelum.vraptor.interceptor.InterceptorListPriorToExecutionExtractor.intercept(InterceptorListPriorToExecutionExtractor.java:46)
	br.com.caelum.vraptor.core.ToInstantiateInterceptorHandler.execute(ToInstantiateInterceptorHandler.java:54)
	br.com.caelum.vraptor.core.DefaultInterceptorStack.next(DefaultInterceptorStack.java:65)
	br.com.caelum.vraptor.interceptor.FlashInterceptor.intercept(FlashInterceptor.java:80)
	br.com.caelum.vraptor.core.ToInstantiateInterceptorHandler.execute(ToInstantiateInterceptorHandler.java:54)
	br.com.caelum.vraptor.core.DefaultInterceptorStack.next(DefaultInterceptorStack.java:65)
	br.com.caelum.vraptor.interceptor.ResourceLookupInterceptor.intercept(ResourceLookupInterceptor.java:67)
	br.com.caelum.vraptor.core.ToInstantiateInterceptorHandler.execute(ToInstantiateInterceptorHandler.java:54)
	br.com.caelum.vraptor.core.DefaultInterceptorStack.next(DefaultInterceptorStack.java:65)
	br.com.caelum.vraptor.core.ToInstantiateInterceptorHandler.execute(ToInstantiateInterceptorHandler.java:56)
	br.com.caelum.vraptor.core.DefaultInterceptorStack.next(DefaultInterceptorStack.java:65)
	br.com.caelum.vraptor.core.DefaultRequestExecution.execute(DefaultRequestExecution.java:70)
	br.com.caelum.vraptor.VRaptor$1.insideRequest(VRaptor.java:92)
	br.com.caelum.vraptor.ioc.spring.SpringProvider.provideForRequest(SpringProvider.java:56)
	br.com.caelum.vraptor.VRaptor.doFilter(VRaptor.java:89)
root cause

org.hibernate.QueryException: could not resolve property: cliente of: br.bmweb.bean.Orcamento
	org.hibernate.persister.entity.AbstractPropertyMapping.propertyException(AbstractPropertyMapping.java:67)
	org.hibernate.persister.entity.AbstractPropertyMapping.toType(AbstractPropertyMapping.java:61)
	org.hibernate.persister.entity.AbstractEntityPersister.toType(AbstractEntityPersister.java:1385)
	org.hibernate.loader.criteria.CriteriaQueryTranslator.getPathEntityName(CriteriaQueryTranslator.java:227)
	org.hibernate.loader.criteria.CriteriaQueryTranslator.createCriteriaEntityNameMap(CriteriaQueryTranslator.java:214)
	org.hibernate.loader.criteria.CriteriaQueryTranslator.<init>(CriteriaQueryTranslator.java:104)
	org.hibernate.loader.criteria.CriteriaLoader.<init>(CriteriaLoader.java:82)
	org.hibernate.impl.SessionImpl.list(SessionImpl.java:1577)
	org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:306)
	org.hibernate.impl.CriteriaImpl$Subcriteria.list(CriteriaImpl.java:481)
	br.bmweb.dao.OrcamentoDao.lista(OrcamentoDao.java:100)
	br.bmweb.controller.ConsultorController.Orcamentos(ConsultorController.java:682)
	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)
	br.com.caelum.vraptor.interceptor.ExecuteMethodInterceptor.intercept(ExecuteMethodInterceptor.java:57)
	br.com.caelum.vraptor.core.ToInstantiateInterceptorHandler.execute(ToInstantiateInterceptorHandler.java:54)
	br.com.caelum.vraptor.core.DefaultInterceptorStack.next(DefaultInterceptorStack.java:65)
	br.com.caelum.vraptor.core.ToInstantiateInterceptorHandler.execute(ToInstantiateInterceptorHandler.java:56)
	br.com.caelum.vraptor.core.DefaultInterceptorStack.next(DefaultInterceptorStack.java:65)
	br.com.caelum.vraptor.interceptor.ParametersInstantiatorInterceptor.intercept(ParametersInstantiatorInterceptor.java:77)
	br.com.caelum.vraptor.core.ToInstantiateInterceptorHandler.execute(ToInstantiateInterceptorHandler.java:54)
	br.com.caelum.vraptor.core.DefaultInterceptorStack.next(DefaultInterceptorStack.java:65)
	br.com.caelum.vraptor.interceptor.InstantiateInterceptor.intercept(InstantiateInterceptor.java:42)
	br.com.caelum.vraptor.core.InstantiatedInterceptorHandler.execute(InstantiatedInterceptorHandler.java:47)
	br.com.caelum.vraptor.core.DefaultInterceptorStack.next(DefaultInterceptorStack.java:65)
	br.com.caelum.vraptor.interceptor.InterceptorListPriorToExecutionExtractor.intercept(InterceptorListPriorToExecutionExtractor.java:46)
	br.com.caelum.vraptor.core.ToInstantiateInterceptorHandler.execute(ToInstantiateInterceptorHandler.java:54)
	br.com.caelum.vraptor.core.DefaultInterceptorStack.next(DefaultInterceptorStack.java:65)
	br.com.caelum.vraptor.interceptor.FlashInterceptor.intercept(FlashInterceptor.java:80)
	br.com.caelum.vraptor.core.ToInstantiateInterceptorHandler.execute(ToInstantiateInterceptorHandler.java:54)
	br.com.caelum.vraptor.core.DefaultInterceptorStack.next(DefaultInterceptorStack.java:65)
	br.com.caelum.vraptor.interceptor.ResourceLookupInterceptor.intercept(ResourceLookupInterceptor.java:67)
	br.com.caelum.vraptor.core.ToInstantiateInterceptorHandler.execute(ToInstantiateInterceptorHandler.java:54)
	br.com.caelum.vraptor.core.DefaultInterceptorStack.next(DefaultInterceptorStack.java:65)
	br.com.caelum.vraptor.core.ToInstantiateInterceptorHandler.execute(ToInstantiateInterceptorHandler.java:56)
	br.com.caelum.vraptor.core.DefaultInterceptorStack.next(DefaultInterceptorStack.java:65)
	br.com.caelum.vraptor.core.DefaultRequestExecution.execute(DefaultRequestExecution.java:70)
	br.com.caelum.vraptor.VRaptor$1.insideRequest(VRaptor.java:92)
	br.com.caelum.vraptor.ioc.spring.SpringProvider.provideForRequest(SpringProvider.java:56)
	br.com.caelum.vraptor.VRaptor.doFilter(VRaptor.java:89)

Linha 682 da ConsultorController:

return orcamentodao.lista();

Linha 100 da OrcamentoDao:

return crit.list();

Stacktrace:

18:19:47,111 DEBUG [VRaptor             ] VRaptor received a new request
18:19:47,259 DEBUG [DefaultRequestExecution] executing stack  DefaultRequestExecution
18:19:47,373 DEBUG [ToInstantiateInterceptorHandler] Invoking interceptor ResourceLookupInterceptor
18:19:47,374 DEBUG [DefaultResourceTranslator] trying to access /
18:19:47,445 DEBUG [DefaultResourceTranslator] found resource [DefaultResourceMethod: IndexController.indexIndexController.index()]
18:19:47,490 DEBUG [ToInstantiateInterceptorHandler] Invoking interceptor FlashInterceptor
18:19:47,501 DEBUG [ToInstantiateInterceptorHandler] Invoking interceptor InterceptorListPriorToExecutionExtractor
18:19:47,515 DEBUG [InstantiatedInterceptorHandler] Invoking interceptor InstantiateInterceptor
18:19:47,698 DEBUG [ToInstantiateInterceptorHandler] Invoking interceptor ParametersInstantiatorInterceptor
18:19:47,705 DEBUG [JstlLocalization    ] couldn't find message bundle, creating an empty one
18:19:47,706 DEBUG [AsmBasedTypeCreator ] Trying to make class for IndexController$index$715134878$1
18:19:47,743 DEBUG [ParanamerNameProvider] Found parameter names with paranamer for IndexController.index() as []
18:19:47,743 DEBUG [AsmBasedTypeCreator ] Parameter names found for creating type are: []
18:19:47,744 DEBUG [AsmBasedTypeCreator ] Methods: []
18:19:47,744 DEBUG [AsmBasedTypeCreator ] Fields: []
18:19:47,744 DEBUG [CacheBasedTypeCreator] cached generic type for method [DefaultResourceMethod: IndexController.indexIndexController.index()]
18:19:47,771 DEBUG [ParanamerNameProvider] Found parameter names with paranamer for IndexController.index() as []
18:19:47,829 DEBUG [ParametersInstantiatorInterceptor] Parameter values for [DefaultResourceMethod: IndexController.indexIndexController.index()] are []
18:19:48,052 DEBUG [ToInstantiateInterceptorHandler] Invoking interceptor ExecuteMethodInterceptor
18:19:48,052 DEBUG [ExecuteMethodInterceptor] Invoking IndexController.index()
18:19:48,068 DEBUG [ToInstantiateInterceptorHandler] Invoking interceptor OutjectResult
18:19:48,087 DEBUG [ToInstantiateInterceptorHandler] Invoking interceptor ForwardToDefaultViewInterceptor
18:19:48,087 DEBUG [ForwardToDefaultViewInterceptor] forwarding to the dafault page for this logic
18:19:48,117 DEBUG [DefaultPageResult   ] forwarding to /WEB-INF/jsp/index/index.jsp
18:19:48,157 DEBUG [DefaultStaticContentHandler] Deferring request to container: /BMWEB/WEB-INF/jsp/index/index.jsp 
18:19:48,394 DEBUG [VRaptor             ] VRaptor ended the request
18:19:56,090 DEBUG [VRaptor             ] VRaptor received a new request
18:19:56,091 DEBUG [DefaultRequestExecution] executing stack  DefaultRequestExecution
18:19:56,095 DEBUG [ToInstantiateInterceptorHandler] Invoking interceptor ResourceLookupInterceptor
18:19:56,096 DEBUG [DefaultResourceTranslator] trying to access /consultor/Orcamentos
18:19:56,097 DEBUG [DefaultResourceTranslator] found resource [DefaultResourceMethod: ConsultorController.OrcamentosConsultorController.Orcamentos()]
18:19:56,103 DEBUG [ToInstantiateInterceptorHandler] Invoking interceptor FlashInterceptor
18:19:56,108 DEBUG [ToInstantiateInterceptorHandler] Invoking interceptor InterceptorListPriorToExecutionExtractor
18:19:56,177 DEBUG [InstantiatedInterceptorHandler] Invoking interceptor InstantiateInterceptor
log4j:WARN No appenders could be found for logger (org.hibernate.cfg.annotations.Version).
log4j:WARN Please initialize the log4j system properly.
18:19:58,719 DEBUG [ToInstantiateInterceptorHandler] Invoking interceptor ParametersInstantiatorInterceptor
18:19:58,719 DEBUG [JstlLocalization    ] couldn't find message bundle, creating an empty one
18:19:58,719 DEBUG [AsmBasedTypeCreator ] Trying to make class for ConsultorController$Orcamentos$423645247$2
18:19:58,719 DEBUG [ParanamerNameProvider] Found parameter names with paranamer for ConsultorController.Orcamentos() as []
18:19:58,719 DEBUG [AsmBasedTypeCreator ] Parameter names found for creating type are: []
18:19:58,778 DEBUG [AsmBasedTypeCreator ] Methods: []
18:19:58,778 DEBUG [AsmBasedTypeCreator ] Fields: []
18:19:58,778 DEBUG [CacheBasedTypeCreator] cached generic type for method [DefaultResourceMethod: ConsultorController.OrcamentosConsultorController.Orcamentos()]
18:19:58,779 DEBUG [ParanamerNameProvider] Found parameter names with paranamer for ConsultorController.Orcamentos() as []
18:19:58,779 DEBUG [ParametersInstantiatorInterceptor] Parameter values for [DefaultResourceMethod: ConsultorController.OrcamentosConsultorController.Orcamentos()] are []
18:19:58,895 DEBUG [ToInstantiateInterceptorHandler] Invoking interceptor ExecuteMethodInterceptor
18:19:58,895 DEBUG [ExecuteMethodInterceptor] Invoking ConsultorController.Orcamentos()

cristianogro 11 de nov. de 2010

Encontrei a solução para meu problema, o erro estava nos mapeamentos, um amigo me deu a dica de criar uma projeto JPA no Eclipse para gerar os mapeamentos, segui a dica e ficou assim: Orcamento:

@Entity
@Table(name = "tb_orcamento")
public class Orcamento implements Serializable {

    private static final long serialVersionUID = 1L;
    @Id
    @GeneratedValue(strategy = GenerationType.AUTO)
    @Column(name = "OR_COD_ORCAMENTO")
    private int cod_orcamento;
    @Column(name = "OR_COD_FUNCIONARIO")
    private int cod_funcionario;
    @Temporal(TemporalType.DATE)
    @Column(name = "OR_DATA_ALTERACAO")
    private Date data_alteracao;
    @Temporal(TemporalType.DATE)
    @Column(name = "OR_DATA_FECHAMENTO")
    private Date data_fechamento;
    @Temporal(TemporalType.DATE)
    @Column(name = "OR_DATA_ORCAMENTO")
    private Date data_orcamento;
    @Temporal(TemporalType.DATE)
    @Column(name = "OR_DATA_VALIDADE")
    private Date data_validade;
    @Column(name = "OR_STATUS_ORCAMENTO")
    private String status_orcamento;
    @Column(name = "OR_TIPO_ORCAMENTO")
    private String tipo_orcamento;
    @Column(name = "OR_VALOR_TOTAL")
    private float valor_total;
    //bi-directional many-to-one association to ItemOrcamento
    @OneToMany(mappedBy = "Orcamento")
    private Set<ItemOrcamento> ItemOrcamentos;
    //bi-directional many-to-one association to Cliente
    @ManyToOne
    @JoinColumn(name = "OR_COD_CLIENTE")
    private Cliente Cliente;
    //bi-directional many-to-one association to Venda
    @OneToMany(mappedBy = "Orcamento")
    private Set<Venda> Venda;

    public Orcamento() {
    }    
     /...gets e sets

Cliente:

@Entity
@Table(name = "tb_cliente")
public class Cliente implements Serializable {

    private static final long serialVersionUID = 1L;
    @Id
    @GeneratedValue(strategy = GenerationType.AUTO)
    @Column(name = "CL_COD_CLIENTE")
    private int cod_cliente;
    @Column(name = "CL_BAIRRO")
    private String bairro;
    @Column(name = "CL_CEP")
    private String cep;
    @Column(name = "CL_CIDADE")
    private String cidade;
    @Column(name = "CL_CNPJ")
    private String cnpj;
    @Column(name = "CL_COMPLEMENTO")
    private String complemento;
    @Column(name = "CL_CONTATO")
    private String contato;
    @Column(name = "CL_CPF")
    private String cpf;
    @Temporal(TemporalType.DATE)
    @Column(name = "CL_DATA_CADASTRO")
    private Date data_cadastro;
    @Temporal(TemporalType.DATE)
    @Column(name = "CL_DATA_NASCIMENTO")
    private Date data_nascimento;
    @Column(name = "CL_DDD_CELULAR")
    private String ddd_celular;
    @Column(name = "CL_DDD_COMERCIAL")
    private String ddd_comercial;
    @Column(name = "CL_DDD_RESIDENCIAL")
    private String ddd_residencial;
    @Column(name = "CL_EMAIL")
    private String email;
    @Column(name = "CL_ESTADO")
    private String estado;
    @Column(name = "CL_FONE_CELULAR")
    private String fone_celular;
    @Column(name = "CL_FONE_COMERCIAL")
    private String fone_comercial;
    @Column(name = "CL_FONE_RESIDENCIAL")
    private String fone_residencial;
    @Column(name = "CL_LOGRADOURO")
    private String logradouro;
    @Column(name = "CL_MERCADO")
    private String mercado;
    @Column(name = "CL_NEWS_LETTER")
    private String newsletter;
    @Column(name = "CL_NOME")
    private String nome;
    @Column(name = "CL_NUMERO")
    private String numero;
    @Column(name = "CL_PLACA")
    private String placa;
    @Column(name = "CL_PROFISSAO")
    private String profissao;
    @Column(name = "CL_RAMAL_COMERCIAL")
    private String ramal_comercial;
    @Column(name = "CL_RG")
    private String rg;
    @Column(name = "CL_TIPO_CLIENTE")
    private String tipo_cliente;
    @Column(name = "CL_TIPO_ENDERECO")
    private String tipo_endereco;
    @Column(name = "CL_TITULO_LOGRADOURO")
    private String titulo_logradouro;
    //bi-directional many-to-one association to Orcamento
    @OneToMany(mappedBy = "Cliente")
    private Set<Orcamento> Orcamento;
    //bi-directional many-to-one association to Venda
    @OneToMany(mappedBy = "Cliente")
    private Set<Venda> Vendas;

    public Cliente() {
    }

DAO:

public List<Orcamento> lista() {
        Criteria crit = session.createCriteria(Orcamento.class);
        crit.add(Restrictions.eq("cod_orcamento", 10));
        crit = crit.createCriteria("ItemOrcamentos");
        crit = crit.createCriteria("Produto");
        return crit.list();
    }

Meus erros eram: 1) Nos mapeamentos do tipo OneToMany declarar a propriedade mappedBy e ao declarar a entidade usar o Set, ou seja, algo como por exemplo:

private Set<ItemOrcamento> ItemOrcamentos;

2) Nos relacionamentos ManyToOne utilizar a propriedade JoinColumn e não há necessidade de usar o Set ao declarar a entidade do relacionamento. 3) Sempre declarar o @Column nos próprios atributos da classe e não gets como eu estava fazendo. Guevara muito obrigado pelas dicas. Lucas obrigado pela indicação da apostila e eu já estava seguindo ela :)

Criado 6 de novembro de 2010

Ultima resposta 11 de nov. de 2010

Respostas 28

Participantes 3

28 Respostas

Topicos relacionados