Pessoal, é o seguinte:
tenho uma classe Passagens outra Paciente, onde a classe Passagens tem N Pacientes e Paciente tem 1 Passagem!
No entanto, Depois que fiz a associação, minha aplicação nao funciona! está fazendo o Select em Passagem e Paciente. Não lista mais os pacientes.Alguém pode me dá uma força?! Obrigado.
O Erro:
Hibernate:
select
this_.id_paciente as id1_1_1_,
this_.bairro_acomp as bairro2_1_1_,
this_.bairro_paci as bairro3_1_1_,
this_.cor_acomp as cor4_1_1_,
this_.cor_paci as cor5_1_1_,
this_.cpf_acomp as cpf6_1_1_,
this_.cpf_paci as cpf7_1_1_,
this_.data_nas as data8_1_1_,
this_.data_nasacomp as data9_1_1_,
this_.nome_acomp as nome10_1_1_,
this_.nome_paci as nome11_1_1_,
this_.numero_acomp as numero12_1_1_,
this_.numero_paci as numero13_1_1_,
this_.passagens_idpassage as passagens20_1_1_,
this_.rg_acomp as rg14_1_1_,
this_.rg_paci as rg15_1_1_,
this_.rua_acomp as rua16_1_1_,
this_.rua_paci as rua17_1_1_,
this_.sexo_acomp as sexo18_1_1_,
this_.sexo_paci as sexo19_1_1_,
passagens2_.idpassage as idpassage2_0_,
passagens2_.desembarque_ida as desembar2_2_0_,
passagens2_.desembarque_volta as desembar3_2_0_,
passagens2_.destino_ida as destino4_2_0_,
passagens2_.destino_volta as destino5_2_0_,
passagens2_.dt_ida as dt6_2_0_,
passagens2_.dt_volta as dt7_2_0_,
passagens2_.empresa as empresa2_0_,
passagens2_.hora_ida as hora9_2_0_,
passagens2_.hora_volta as hora10_2_0_,
passagens2_.id_paciente as id11_2_0_,
passagens2_.mes as mes2_0_,
passagens2_.nome_paci as nome13_2_0_,
passagens2_.situacao as situacao2_0_,
passagens2_.valor as valor2_0_
from
paciente this_
left outer join
passagens passagens2_
on this_.passagens_idpassage=passagens2_.idpassage
18:18:44,421 WARN JDBCExceptionReporter:77 - SQL Error: 1054, SQLState: 42S22
18:18:44,421 ERROR JDBCExceptionReporter:78 - Unknown column 'this_.passagens_idpassage' in 'field list'
n?o tem Paciente Cadastrado! org.hibernate.exception.SQLGrammarException: could not execute query
Codigo da classe Passagens:
@Entity
@Table (name = "passagens")
public class Passagens implements Serializable {
private static final long serialVersionUID = 1L;
@Id
@GeneratedValue
private int idpassage;
private int id_paciente;
private String nome_paci;
private String destino_ida;
@Temporal(TemporalType.DATE)
...
@OneToMany(mappedBy="passagens")
private List<Paciente> pacientes ;
gets/sets
...
public List<Paciente> getPacientes(){
return pacientes;
}
public void setPacientes(List<Paciente> pacientes){
this.pacientes = pacientes;
}
Agora a classe Paciente:
@Entity
@Table(name="paciente")
public class Paciente implements Serializable {
private static final long serialVersionUID = 1L;
@Id
@GeneratedValue
private Integer id_paciente;
private String nome_paci;
@Temporal(TemporalType.DATE)
private Date data_nas;
private String rg_paci;
private String cpf_paci;
private String sexo_paci;
private String cor_paci;
private String rua_paci;
private String numero_paci;
private String bairro_paci;
private String nome_acomp;
@Temporal(TemporalType.DATE)
private Date data_nasacomp;
private String rg_acomp;
private String cpf_acomp;
private String sexo_acomp;
private String cor_acomp;
private String rua_acomp;
private String numero_acomp;
private String bairro_acomp;
private static Paciente instance = new Paciente();
@ManyToOne
private Passagens passagens;
gets/sets
...
public Passagens getPassagens(){
return passagens;
}
public void setPassagens(Passagens passagens){
this.passagens = passagens;
}