Discussoes de Programacao e Tecnologia

Dúvida com Restrictions

7 respostas
J
JonRocha

Olá pessoal,

Estou querendo listar os dados de uma tabela filtrando-os pelo status Ativo e pela FK com id 3, no caso.
Porém, ele não consegue filtrar pela linha .add(Restrictions.eq("soliFkDivisoes1Id", 3))
e gera o seguinte erro:

org.hibernate.PropertyAccessException: could not get a field value by reflection getter of br.com.catequese.to.Divisoes.diviPkId

Será que estou fazendo da forma correta?

public List<Solicitacao> listaSolicitacoesDimee() { return this.session.createCriteria(Solicitacao.class) .addOrder(Order.asc("soliDescricao")) .add(Restrictions.eq("soliStatus", "Ativo")) .add(Restrictions.eq("soliFkDivisoes1Id", 3)) .setMaxResults(20) .list(); }

Alura POO: o que é programação orientada a objetos? Aprenda os conceitos básicos da programação orientada a objetos, como classes, objetos, herança, encapsulamento e polimorfismo, com exemplos.

7 Respostas

otaviojava
otaviojava

Verifica as anotações da sua classe.
Lembre-se que ele faz o mapeamento objeto-relacional.
Então é necessário anotar com o objeto todos os campos do seu banco de dados.

J
JonRocha

mas que anotação eu devo fazer?

otaviojava
otaviojava

Me passe ai como vc documenta a classe Solicitacao

J
JonRocha

Quando eu dou este select no banco, ele funciona perfeitamente

SELECT 
  solicitacao.soli_fk_divisoes1_id, 
  divisoes.divi_pk_id, 
  divisoes.divi_codigo, 
  divisoes.divi_descricao, 
  divisoes.divi_nome
FROM 
  sigi.solicitacao, 
  sigi.divisoes
WHERE 
  solicitacao.soli_fk_divisoes1_id = divisoes.divi_pk_id;

/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */

package br.com.catequese.to;

import java.io.Serializable;
import java.util.Collection;
import java.util.Date;
import javax.persistence.Basic;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.JoinColumn;
import javax.persistence.ManyToOne;
import javax.persistence.NamedQueries;
import javax.persistence.NamedQuery;
import javax.persistence.OneToMany;
import javax.persistence.Table;
import javax.persistence.Temporal;
import javax.persistence.TemporalType;

/**
 *
 * @author agonia
 */
@Entity
@Table(name = "solicitacao", catalog = "nutec", schema = "sigi")
@NamedQueries({
    @NamedQuery(name = "Solicitacao.findAll", query = "SELECT s FROM Solicitacao s"),
    @NamedQuery(name = "Solicitacao.findBySoliPkId", query = "SELECT s FROM Solicitacao s WHERE s.soliPkId = :soliPkId"),
    @NamedQuery(name = "Solicitacao.findBySoliDataAtendimento", query = "SELECT s FROM Solicitacao s WHERE s.soliDataAtendimento = :soliDataAtendimento"),
    @NamedQuery(name = "Solicitacao.findBySoliDataContato", query = "SELECT s FROM Solicitacao s WHERE s.soliDataContato = :soliDataContato"),
    @NamedQuery(name = "Solicitacao.findBySoliDataDesativacao", query = "SELECT s FROM Solicitacao s WHERE s.soliDataDesativacao = :soliDataDesativacao"),
    @NamedQuery(name = "Solicitacao.findBySoliDataFinalizacao", query = "SELECT s FROM Solicitacao s WHERE s.soliDataFinalizacao = :soliDataFinalizacao"),
    @NamedQuery(name = "Solicitacao.findBySoliDataSolicitacao", query = "SELECT s FROM Solicitacao s WHERE s.soliDataSolicitacao = :soliDataSolicitacao"),
    @NamedQuery(name = "Solicitacao.findBySoliMotivoCancelamento", query = "SELECT s FROM Solicitacao s WHERE s.soliMotivoCancelamento = :soliMotivoCancelamento"),
    @NamedQuery(name = "Solicitacao.findBySoliNegociacao", query = "SELECT s FROM Solicitacao s WHERE s.soliNegociacao = :soliNegociacao"),
    @NamedQuery(name = "Solicitacao.findBySoliStatus", query = "SELECT s FROM Solicitacao s WHERE s.soliStatus = :soliStatus"),
    @NamedQuery(name = "Solicitacao.findBySoliStatusSolicitacaoCod", query = "SELECT s FROM Solicitacao s WHERE s.soliStatusSolicitacaoCod = :soliStatusSolicitacaoCod"),
    @NamedQuery(name = "Solicitacao.findBySoliStatusSolicitacaoLocal", query = "SELECT s FROM Solicitacao s WHERE s.soliStatusSolicitacaoLocal = :soliStatusSolicitacaoLocal"),
    @NamedQuery(name = "Solicitacao.findBySoliDescricao", query = "SELECT s FROM Solicitacao s WHERE s.soliDescricao = :soliDescricao"),
    @NamedQuery(name = "Solicitacao.findBySoliStatusSolicitacaoNome", query = "SELECT s FROM Solicitacao s WHERE s.soliStatusSolicitacaoNome = :soliStatusSolicitacaoNome")})
public class Solicitacao implements Serializable {
    private static final long serialVersionUID = 1L;
    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    @Basic(optional = false)
    @Column(name = "soli_pk_id", nullable = false)
    private Integer soliPkId;
    @Column(name = "soli_descricao", length = 255)
    private String soliDescricao;
    @Basic(optional = false)
    @Column(name = "soli_data_atendimento", nullable = false)
    @Temporal(TemporalType.DATE)
    private Date soliDataAtendimento;
    @Basic(optional = false)
    @Column(name = "soli_data_contato", nullable = false)
    @Temporal(TemporalType.DATE)
    private Date soliDataContato;
    @Column(name = "soli_data_desativacao")
    @Temporal(TemporalType.DATE)
    private Date soliDataDesativacao;
    @Column(name = "soli_data_finalizacao")
    @Temporal(TemporalType.DATE)
    private Date soliDataFinalizacao;
    @Column(name = "soli_data_solicitacao")
    @Temporal(TemporalType.DATE)
    private Date soliDataSolicitacao;
    @Column(name = "soli_motivo_cancelamento", length = 255)
    private String soliMotivoCancelamento;
    @Column(name = "soli_negociacao", length = 255)
    private String soliNegociacao;
    @Column(name = "soli_status", length = 255)
    private String soliStatus;
    @Column(name = "soli_status_solicitacao_cod", length = 255)
    private String soliStatusSolicitacaoCod;
    @Column(name = "soli_status_solicitacao_local", length = 255)
    private String soliStatusSolicitacaoLocal;
    @Column(name = "soli_status_solicitacao_nome", length = 255)
    private String soliStatusSolicitacaoNome;
    @OneToMany(mappedBy = "inteFkSolicitacaoId")
    private Collection<Intermediaria> intermediariaCollection;
    @JoinColumn(name = "soli_fk_cliente_fisica_id", referencedColumnName = "clfi_pk_id")
    @ManyToOne
    private ClienteFisica soliFkClienteFisicaId;
    @JoinColumn(name = "soli_fk_cliente_juridica_id", referencedColumnName = "clju_pk_id")
    @ManyToOne
    private ClienteJuridica soliFkClienteJuridicaId;
    @JoinColumn(name = "soli_fk_divisoes2_id", referencedColumnName = "divi_pk_id")
    @ManyToOne
    private Divisoes soliFkDivisoes2Id;
    @JoinColumn(name = "soli_fk_divisoes1_id", referencedColumnName = "divi_pk_id")
    @ManyToOne
    private Divisoes soliFkDivisoes1Id;
    @JoinColumn(name = "soli_fk_divisoes4_id", referencedColumnName = "divi_pk_id")
    @ManyToOne
    private Divisoes soliFkDivisoes4Id;
    @JoinColumn(name = "soli_fk_divisoes3_id", referencedColumnName = "divi_pk_id")
    @ManyToOne
    private Divisoes soliFkDivisoes3Id;
    @JoinColumn(name = "soli_fk_divisoes5_id", referencedColumnName = "divi_pk_id")
    @ManyToOne
    private Divisoes soliFkDivisoes5Id;
    @JoinColumn(name = "soli_fk_forma_contato_id", referencedColumnName = "foco_pk_id")
    @ManyToOne
    private FormaContato soliFkFormaContatoId;
    @JoinColumn(name = "soli_fk_funcionario_cadastrou_id", referencedColumnName = "func_pk_id")
    @ManyToOne
    private Funcionario soliFkFuncionarioCadastrouId;
    @JoinColumn(name = "soli_fk_funcionario_valor_id", referencedColumnName = "func_pk_id")
    @ManyToOne
    private Funcionario soliFkFuncionarioValorId;
/*    @JoinColumn(name = "soli_fk_servicos20_id", referencedColumnName = "smat_pk_id")
    @ManyToOne
    private ServicosDimat soliFkServicos20Id;
    @JoinColumn(name = "soli_fk_servicos3_id", referencedColumnName = "smat_pk_id")
    @ManyToOne
    private ServicosDimat soliFkServicos3Id;
    @JoinColumn(name = "soli_fk_servicos9_id", referencedColumnName = "smat_pk_id")
    @ManyToOne
    private ServicosDimat soliFkServicos9Id;
    @JoinColumn(name = "soli_fk_servicos18_id", referencedColumnName = "smat_pk_id")
    @ManyToOne
    private ServicosDimat soliFkServicos18Id;
    @JoinColumn(name = "soli_fk_servicos7_id", referencedColumnName = "smat_pk_id")
    @ManyToOne
    private ServicosDimat soliFkServicos7Id;
    @JoinColumn(name = "soli_fk_servicos15_id", referencedColumnName = "smat_pk_id")
    @ManyToOne
    private ServicosDimat soliFkServicos15Id;
    @JoinColumn(name = "soli_fk_servicos17_id", referencedColumnName = "smat_pk_id")
    @ManyToOne
    private ServicosDimat soliFkServicos17Id;
    @JoinColumn(name = "soli_fk_servicos1_id", referencedColumnName = "smat_pk_id")
    @ManyToOne
    private ServicosDimat soliFkServicos1Id;
    @JoinColumn(name = "soli_fk_servicos10_id", referencedColumnName = "smat_pk_id")
    @ManyToOne
    private ServicosDimat soliFkServicos10Id;
    @JoinColumn(name = "soli_fk_servicos23_id", referencedColumnName = "smat_pk_id")
    @ManyToOne
    private ServicosDimat soliFkServicos23Id;
    @JoinColumn(name = "soli_fk_servicos11_id", referencedColumnName = "smat_pk_id")
    @ManyToOne
    private ServicosDimat soliFkServicos11Id;
    @JoinColumn(name = "soli_fk_servicos6_id", referencedColumnName = "smat_pk_id")
    @ManyToOne
    private ServicosDimat soliFkServicos6Id;
    @JoinColumn(name = "soli_fk_servicos16_id", referencedColumnName = "smat_pk_id")
    @ManyToOne
    private ServicosDimat soliFkServicos16Id;
    @JoinColumn(name = "soli_fk_servicos8_id", referencedColumnName = "smat_pk_id")
    @ManyToOne
    private ServicosDimat soliFkServicos8Id;
    @JoinColumn(name = "soli_fk_servicos12_id", referencedColumnName = "smat_pk_id")
    @ManyToOne
    private ServicosDimat soliFkServicos12Id;
    @JoinColumn(name = "soli_fk_servicos4_id", referencedColumnName = "smat_pk_id")
    @ManyToOne
    private ServicosDimat soliFkServicos4Id;
    @JoinColumn(name = "soli_fk_servicos22_id", referencedColumnName = "smat_pk_id")
    @ManyToOne
    private ServicosDimat soliFkServicos22Id;
    @JoinColumn(name = "soli_fk_servicos21_id", referencedColumnName = "smat_pk_id")
    @ManyToOne
    private ServicosDimat soliFkServicos21Id;
    @JoinColumn(name = "soli_fk_servicos14_id", referencedColumnName = "smat_pk_id")
    @ManyToOne
    private ServicosDimat soliFkServicos14Id;
    @JoinColumn(name = "soli_fk_servicos2_id", referencedColumnName = "smat_pk_id")
    @ManyToOne
    private ServicosDimat soliFkServicos2Id;
    @JoinColumn(name = "soli_fk_servicos13_id", referencedColumnName = "smat_pk_id")
    @ManyToOne
    private ServicosDimat soliFkServicos13Id;
    @JoinColumn(name = "soli_fk_servicos19_id", referencedColumnName = "smat_pk_id")
    @ManyToOne
    private ServicosDimat soliFkServicos19Id;
    @JoinColumn(name = "soli_fk_servicos5_id", referencedColumnName = "smat_pk_id")
    @ManyToOne
    private ServicosDimat soliFkServicos5Id;
    @JoinColumn(name = "soli_fk_servicos30_id", referencedColumnName = "smee_pk_id")
    @ManyToOne
    private ServicosDimee soliFkServicos30Id;
    @JoinColumn(name = "soli_fk_servicos27_id", referencedColumnName = "smee_pk_id")
    @ManyToOne
    private ServicosDimee soliFkServicos27Id;
    @JoinColumn(name = "soli_fk_servicos24_id", referencedColumnName = "smee_pk_id")
    @ManyToOne
    private ServicosDimee soliFkServicos24Id;
    @JoinColumn(name = "soli_fk_servicos28_id", referencedColumnName = "smee_pk_id")
    @ManyToOne
    private ServicosDimee soliFkServicos28Id;
    @JoinColumn(name = "soli_fk_servicos31_id", referencedColumnName = "smee_pk_id")
    @ManyToOne
    private ServicosDimee soliFkServicos31Id;
    @JoinColumn(name = "soli_fk_servicos29_id", referencedColumnName = "smee_pk_id")
    @ManyToOne
    private ServicosDimee soliFkServicos29Id;
    @JoinColumn(name = "soli_fk_servicos25_id", referencedColumnName = "smee_pk_id")
    @ManyToOne
    private ServicosDimee soliFkServicos25Id;
    @JoinColumn(name = "soli_fk_servicos26_id", referencedColumnName = "smee_pk_id")
    @ManyToOne
    private ServicosDimee soliFkServicos26Id;*/
    @JoinColumn(name = "soli_fk_status_solicitacao_id", referencedColumnName = "stat_pk_id")
    @ManyToOne
    private StatusSolicitacao soliFkStatusSolicitacaoId;

    public Solicitacao() {
    }

    public Solicitacao(Integer soliPkId) {
        this.soliPkId = soliPkId;
    }

    public Solicitacao(Integer soliPkId, Date soliDataAtendimento, Date soliDataContato) {
        this.soliPkId = soliPkId;
        this.soliDataAtendimento = soliDataAtendimento;
        this.soliDataContato = soliDataContato;
    }

    public Integer getSoliPkId() {
        return soliPkId;
    }

    public String getSoliDescricao() {
        return soliDescricao;
    }

    public void setSoliDescricao(String soliDescricao) {
        this.soliDescricao = soliDescricao;
    }

    public void setSoliPkId(Integer soliPkId) {
        this.soliPkId = soliPkId;
    }

    public Date getSoliDataAtendimento() {
        return soliDataAtendimento;
    }

    public void setSoliDataAtendimento(Date soliDataAtendimento) {
        this.soliDataAtendimento = soliDataAtendimento;
    }

    public Date getSoliDataContato() {
        return soliDataContato;
    }

    public void setSoliDataContato(Date soliDataContato) {
        this.soliDataContato = soliDataContato;
    }

    public Date getSoliDataDesativacao() {
        return soliDataDesativacao;
    }

    public void setSoliDataDesativacao(Date soliDataDesativacao) {
        this.soliDataDesativacao = soliDataDesativacao;
    }

    public Date getSoliDataFinalizacao() {
        return soliDataFinalizacao;
    }

    public void setSoliDataFinalizacao(Date soliDataFinalizacao) {
        this.soliDataFinalizacao = soliDataFinalizacao;
    }

    public Date getSoliDataSolicitacao() {
        return soliDataSolicitacao;
    }

    public void setSoliDataSolicitacao(Date soliDataSolicitacao) {
        this.soliDataSolicitacao = soliDataSolicitacao;
    }

    public String getSoliMotivoCancelamento() {
        return soliMotivoCancelamento;
    }

    public void setSoliMotivoCancelamento(String soliMotivoCancelamento) {
        this.soliMotivoCancelamento = soliMotivoCancelamento;
    }

    public String getSoliNegociacao() {
        return soliNegociacao;
    }

    public void setSoliNegociacao(String soliNegociacao) {
        this.soliNegociacao = soliNegociacao;
    }

    public String getSoliStatus() {
        return soliStatus;
    }

    public void setSoliStatus(String soliStatus) {
        this.soliStatus = soliStatus;
    }

    public String getSoliStatusSolicitacaoCod() {
        return soliStatusSolicitacaoCod;
    }

    public void setSoliStatusSolicitacaoCod(String soliStatusSolicitacaoCod) {
        this.soliStatusSolicitacaoCod = soliStatusSolicitacaoCod;
    }

    public String getSoliStatusSolicitacaoLocal() {
        return soliStatusSolicitacaoLocal;
    }

    public void setSoliStatusSolicitacaoLocal(String soliStatusSolicitacaoLocal) {
        this.soliStatusSolicitacaoLocal = soliStatusSolicitacaoLocal;
    }

    public String getSoliStatusSolicitacaoNome() {
        return soliStatusSolicitacaoNome;
    }

    public void setSoliStatusSolicitacaoNome(String soliStatusSolicitacaoNome) {
        this.soliStatusSolicitacaoNome = soliStatusSolicitacaoNome;
    }

    public Collection<Intermediaria> getIntermediariaCollection() {
        return intermediariaCollection;
    }

    public void setIntermediariaCollection(Collection<Intermediaria> intermediariaCollection) {
        this.intermediariaCollection = intermediariaCollection;
    }

    public ClienteFisica getSoliFkClienteFisicaId() {
        return soliFkClienteFisicaId;
    }

    public void setSoliFkClienteFisicaId(ClienteFisica soliFkClienteFisicaId) {
        this.soliFkClienteFisicaId = soliFkClienteFisicaId;
    }

    public ClienteJuridica getSoliFkClienteJuridicaId() {
        return soliFkClienteJuridicaId;
    }

    public void setSoliFkClienteJuridicaId(ClienteJuridica soliFkClienteJuridicaId) {
        this.soliFkClienteJuridicaId = soliFkClienteJuridicaId;
    }

    public Divisoes getSoliFkDivisoes2Id() {
        return soliFkDivisoes2Id;
    }

    public void setSoliFkDivisoes2Id(Divisoes soliFkDivisoes2Id) {
        this.soliFkDivisoes2Id = soliFkDivisoes2Id;
    }

    public Divisoes getSoliFkDivisoes1Id() {
        return soliFkDivisoes1Id;
    }

    public void setSoliFkDivisoes1Id(Divisoes soliFkDivisoes1Id) {
        this.soliFkDivisoes1Id = soliFkDivisoes1Id;
    }

    public Divisoes getSoliFkDivisoes4Id() {
        return soliFkDivisoes4Id;
    }

    public void setSoliFkDivisoes4Id(Divisoes soliFkDivisoes4Id) {
        this.soliFkDivisoes4Id = soliFkDivisoes4Id;
    }

    public Divisoes getSoliFkDivisoes3Id() {
        return soliFkDivisoes3Id;
    }

    public void setSoliFkDivisoes3Id(Divisoes soliFkDivisoes3Id) {
        this.soliFkDivisoes3Id = soliFkDivisoes3Id;
    }

    public Divisoes getSoliFkDivisoes5Id() {
        return soliFkDivisoes5Id;
    }

    public void setSoliFkDivisoes5Id(Divisoes soliFkDivisoes5Id) {
        this.soliFkDivisoes5Id = soliFkDivisoes5Id;
    }

    public FormaContato getSoliFkFormaContatoId() {
        return soliFkFormaContatoId;
    }

    public void setSoliFkFormaContatoId(FormaContato soliFkFormaContatoId) {
        this.soliFkFormaContatoId = soliFkFormaContatoId;
    }

    public Funcionario getSoliFkFuncionarioCadastrouId() {
        return soliFkFuncionarioCadastrouId;
    }

    public void setSoliFkFuncionarioCadastrouId(Funcionario soliFkFuncionarioCadastrouId) {
        this.soliFkFuncionarioCadastrouId = soliFkFuncionarioCadastrouId;
    }

    public Funcionario getSoliFkFuncionarioValorId() {
        return soliFkFuncionarioValorId;
    }

    public void setSoliFkFuncionarioValorId(Funcionario soliFkFuncionarioValorId) {
        this.soliFkFuncionarioValorId = soliFkFuncionarioValorId;
    }

/*    public ServicosDimat getSoliFkServicos20Id() {
        return soliFkServicos20Id;
    }

    public void setSoliFkServicos20Id(ServicosDimat soliFkServicos20Id) {
        this.soliFkServicos20Id = soliFkServicos20Id;
    }

    public ServicosDimat getSoliFkServicos3Id() {
        return soliFkServicos3Id;
    }

    public void setSoliFkServicos3Id(ServicosDimat soliFkServicos3Id) {
        this.soliFkServicos3Id = soliFkServicos3Id;
    }

    public ServicosDimat getSoliFkServicos9Id() {
        return soliFkServicos9Id;
    }

    public void setSoliFkServicos9Id(ServicosDimat soliFkServicos9Id) {
        this.soliFkServicos9Id = soliFkServicos9Id;
    }

    public ServicosDimat getSoliFkServicos18Id() {
        return soliFkServicos18Id;
    }

    public void setSoliFkServicos18Id(ServicosDimat soliFkServicos18Id) {
        this.soliFkServicos18Id = soliFkServicos18Id;
    }

    public ServicosDimat getSoliFkServicos7Id() {
        return soliFkServicos7Id;
    }

    public void setSoliFkServicos7Id(ServicosDimat soliFkServicos7Id) {
        this.soliFkServicos7Id = soliFkServicos7Id;
    }

    public ServicosDimat getSoliFkServicos15Id() {
        return soliFkServicos15Id;
    }

    public void setSoliFkServicos15Id(ServicosDimat soliFkServicos15Id) {
        this.soliFkServicos15Id = soliFkServicos15Id;
    }

    public ServicosDimat getSoliFkServicos17Id() {
        return soliFkServicos17Id;
    }

    public void setSoliFkServicos17Id(ServicosDimat soliFkServicos17Id) {
        this.soliFkServicos17Id = soliFkServicos17Id;
    }

    public ServicosDimat getSoliFkServicos1Id() {
        return soliFkServicos1Id;
    }

    public void setSoliFkServicos1Id(ServicosDimat soliFkServicos1Id) {
        this.soliFkServicos1Id = soliFkServicos1Id;
    }

    public ServicosDimat getSoliFkServicos10Id() {
        return soliFkServicos10Id;
    }

    public void setSoliFkServicos10Id(ServicosDimat soliFkServicos10Id) {
        this.soliFkServicos10Id = soliFkServicos10Id;
    }

    public ServicosDimat getSoliFkServicos23Id() {
        return soliFkServicos23Id;
    }

    public void setSoliFkServicos23Id(ServicosDimat soliFkServicos23Id) {
        this.soliFkServicos23Id = soliFkServicos23Id;
    }

    public ServicosDimat getSoliFkServicos11Id() {
        return soliFkServicos11Id;
    }

    public void setSoliFkServicos11Id(ServicosDimat soliFkServicos11Id) {
        this.soliFkServicos11Id = soliFkServicos11Id;
    }

    public ServicosDimat getSoliFkServicos6Id() {
        return soliFkServicos6Id;
    }

    public void setSoliFkServicos6Id(ServicosDimat soliFkServicos6Id) {
        this.soliFkServicos6Id = soliFkServicos6Id;
    }

    public ServicosDimat getSoliFkServicos16Id() {
        return soliFkServicos16Id;
    }

    public void setSoliFkServicos16Id(ServicosDimat soliFkServicos16Id) {
        this.soliFkServicos16Id = soliFkServicos16Id;
    }

    public ServicosDimat getSoliFkServicos8Id() {
        return soliFkServicos8Id;
    }

    public void setSoliFkServicos8Id(ServicosDimat soliFkServicos8Id) {
        this.soliFkServicos8Id = soliFkServicos8Id;
    }

    public ServicosDimat getSoliFkServicos12Id() {
        return soliFkServicos12Id;
    }

    public void setSoliFkServicos12Id(ServicosDimat soliFkServicos12Id) {
        this.soliFkServicos12Id = soliFkServicos12Id;
    }

    public ServicosDimat getSoliFkServicos4Id() {
        return soliFkServicos4Id;
    }

    public void setSoliFkServicos4Id(ServicosDimat soliFkServicos4Id) {
        this.soliFkServicos4Id = soliFkServicos4Id;
    }

    public ServicosDimat getSoliFkServicos22Id() {
        return soliFkServicos22Id;
    }

    public void setSoliFkServicos22Id(ServicosDimat soliFkServicos22Id) {
        this.soliFkServicos22Id = soliFkServicos22Id;
    }

    public ServicosDimat getSoliFkServicos21Id() {
        return soliFkServicos21Id;
    }

    public void setSoliFkServicos21Id(ServicosDimat soliFkServicos21Id) {
        this.soliFkServicos21Id = soliFkServicos21Id;
    }

    public ServicosDimat getSoliFkServicos14Id() {
        return soliFkServicos14Id;
    }

    public void setSoliFkServicos14Id(ServicosDimat soliFkServicos14Id) {
        this.soliFkServicos14Id = soliFkServicos14Id;
    }

    public ServicosDimat getSoliFkServicos2Id() {
        return soliFkServicos2Id;
    }

    public void setSoliFkServicos2Id(ServicosDimat soliFkServicos2Id) {
        this.soliFkServicos2Id = soliFkServicos2Id;
    }

    public ServicosDimat getSoliFkServicos13Id() {
        return soliFkServicos13Id;
    }

    public void setSoliFkServicos13Id(ServicosDimat soliFkServicos13Id) {
        this.soliFkServicos13Id = soliFkServicos13Id;
    }

    public ServicosDimat getSoliFkServicos19Id() {
        return soliFkServicos19Id;
    }

    public void setSoliFkServicos19Id(ServicosDimat soliFkServicos19Id) {
        this.soliFkServicos19Id = soliFkServicos19Id;
    }

    public ServicosDimat getSoliFkServicos5Id() {
        return soliFkServicos5Id;
    }

    public void setSoliFkServicos5Id(ServicosDimat soliFkServicos5Id) {
        this.soliFkServicos5Id = soliFkServicos5Id;
    }

    public ServicosDimee getSoliFkServicos30Id() {
        return soliFkServicos30Id;
    }

    public void setSoliFkServicos30Id(ServicosDimee soliFkServicos30Id) {
        this.soliFkServicos30Id = soliFkServicos30Id;
    }

    public ServicosDimee getSoliFkServicos27Id() {
        return soliFkServicos27Id;
    }

    public void setSoliFkServicos27Id(ServicosDimee soliFkServicos27Id) {
        this.soliFkServicos27Id = soliFkServicos27Id;
    }

    public ServicosDimee getSoliFkServicos24Id() {
        return soliFkServicos24Id;
    }

    public void setSoliFkServicos24Id(ServicosDimee soliFkServicos24Id) {
        this.soliFkServicos24Id = soliFkServicos24Id;
    }

    public ServicosDimee getSoliFkServicos28Id() {
        return soliFkServicos28Id;
    }

    public void setSoliFkServicos28Id(ServicosDimee soliFkServicos28Id) {
        this.soliFkServicos28Id = soliFkServicos28Id;
    }

    public ServicosDimee getSoliFkServicos31Id() {
        return soliFkServicos31Id;
    }

    public void setSoliFkServicos31Id(ServicosDimee soliFkServicos31Id) {
        this.soliFkServicos31Id = soliFkServicos31Id;
    }

    public ServicosDimee getSoliFkServicos29Id() {
        return soliFkServicos29Id;
    }

    public void setSoliFkServicos29Id(ServicosDimee soliFkServicos29Id) {
        this.soliFkServicos29Id = soliFkServicos29Id;
    }

    public ServicosDimee getSoliFkServicos25Id() {
        return soliFkServicos25Id;
    }

    public void setSoliFkServicos25Id(ServicosDimee soliFkServicos25Id) {
        this.soliFkServicos25Id = soliFkServicos25Id;
    }

    public ServicosDimee getSoliFkServicos26Id() {
        return soliFkServicos26Id;
    }

    public void setSoliFkServicos26Id(ServicosDimee soliFkServicos26Id) {
        this.soliFkServicos26Id = soliFkServicos26Id;
    }
*/
    public StatusSolicitacao getSoliFkStatusSolicitacaoId() {
        return soliFkStatusSolicitacaoId;
    }

    public void setSoliFkStatusSolicitacaoId(StatusSolicitacao soliFkStatusSolicitacaoId) {
        this.soliFkStatusSolicitacaoId = soliFkStatusSolicitacaoId;
    }

    @Override
    public int hashCode() {
        int hash = 0;
        hash += (soliPkId != null ? soliPkId.hashCode() : 0);
        return hash;
    }

    @Override
    public boolean equals(Object object) {
        // TODO: Warning - this method won't work in the case the id fields are not set
        if (!(object instanceof Solicitacao)) {
            return false;
        }
        Solicitacao other = (Solicitacao) object;
        if ((this.soliPkId == null && other.soliPkId != null) || (this.soliPkId != null && !this.soliPkId.equals(other.soliPkId))) {
            return false;
        }
        return true;
    }

    @Override
    public String toString() {
        return "Codigo" + soliPkId;
    }

    public void getSoliPkId(int i) {
        throw new UnsupportedOperationException("Not yet implemented");
    }

}
J
JonRocha

Olá pessoal, como posso fazer uma criteria com o select abaixo select?

SELECT solicitacao.soli_fk_divisoes1_id, divisoes.divi_pk_id, divisoes.divi_codigo, divisoes.divi_descricao, divisoes.divi_nome FROM sigi.solicitacao, sigi.divisoes WHERE solicitacao.soli_fk_divisoes1_id = divisoes.divi_pk_id;

J
JonRocha

ENCONTREI A SOLUÇÃO!!!

Na verdade, dentro do método .add(Restrictions.eq("soliFkDivisoes1Id", 3))

o parâmetro soliFkDivisoes1Id é uma FK, então nesse caso é necessário por a PK (diviPkId) da tabela (Divisoes) a qual esta FK está se referenciando:

soliFkDivisoes1Id.diviPkId

O códogo fica assim:

public List<Solicitacao> listaSolicitacoesDimee() {
        return this.session.createCriteria(Solicitacao.class)
                .addOrder(Order.asc("soliDescricao"))
                .add(Restrictions.eq("soliStatus", "Ativo"))
                .add(Restrictions.eq("soliFkDivisoes1Id.diviPkId", 3))
                .setMaxResults(20)
                .list();
    }
Priuli
Priuli

Segue material para agilizar e simplificar as consultas com hibernate de qualquer aplicação java.
Caso interrese alguem.

http://felipepriuli.wordpress.com/2010/10/12/priuli-filter/

http://www.guj.com.br/java/221618-filter-dinamico-para-hibernate

Criado 27 de janeiro de 2011
Ultima resposta 11 de fev. de 2011
Respostas 7
Participantes 3

Topicos relacionados

Componente de forum 4 respostas Consultar CPF pelo nome na Receita Federal 5 respostas Pegadinhas que se fazem com os pobres estagiários 62 respostas [Resolvido] Como comparar Strings em C? 6 respostas Converter pixels para centímetros 9 respostas
Lumina Lumina: a IA que te traz resultados Prompts prontos por especialistas. Resolva seus problemas de verdade.
Fiap Graduacao em Tecnologia — FIAP Analise e Desenvolvimento de Sistemas, Engenharia de Software e mais