Dúvida com Restrictions

JonRocha · Janeiro 27, 2011, 12:42pm

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(); }

otaviojava · Janeiro 27, 2011, 12:49pm

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.

JonRocha · Janeiro 27, 2011, 1:34pm

mas que anotação eu devo fazer?

otaviojava · Janeiro 27, 2011, 3:13pm

Me passe ai como vc documenta a classe Solicitacao

JonRocha · Janeiro 27, 2011, 4:43pm

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;

[code]/*

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 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 getIntermediariaCollection() {
return intermediariaCollection;
}

public void setIntermediariaCollection(Collection 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");
}

}
[/code]

JonRocha · Janeiro 27, 2011, 4:53pm

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;

JonRocha · Janeiro 28, 2011, 3:25pm

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 · Fevereiro 11, 2011, 2:00pm

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

system · Janeiro 6, 2016, 3:30am

Dúvida com Restrictions

Cursos de Mobile

Cursos de Programação

Cursos de Front-end

Cursos de DevOps

Cursos de Design & UX

Cursos de Business

Cursos de Data & BI