hi there!

first, sorry for my poor english.

i am working with MySQL 5 and Hibernate 3.2 with annotations.

i have one table like this:
DROP TABLE IF EXISTS regla_condicion;
create table regla_condicion(
id_regla_condicion int not null auto_increment primary key,
id_regla_facturacion int not null,
id_metadato int not null,
id int not null,
foreign key (id_regla_facturacion) REFERENCES regla_facturacion (id_regla_facturacion),
foreign key (id_metadato) REFERENCES metadato (id_metadato)
) ENGINE=INNODB;

and hibernate make me this pojo:
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import static javax.persistence.GenerationType.IDENTITY;
import javax.persistence.Id;
import javax.persistence.Table;

/**
* ReglaCondicion generated by hbm2java
*/
@Entity
@Table(name = "regla_condicion", catalog = "iglabws")
public class ReglaCondicion implements java.io.Serializable {
private Integer idReglaCondicion;
private int idReglaFacturacion;
private int idMetadato;
private int id;

public ReglaCondicion() {
}

public ReglaCondicion(int idReglaFacturacion, int idMetadato, int id) {
this.idReglaFacturacion = idReglaFacturacion;
this.idMetadato = idMetadato;
this.id = id;
}

public ReglaCondicion(int idReglaFacturacion, int idMetadato, int id) {
this.idReglaFacturacion = idReglaFacturacion;
this.idMetadato = idMetadato;
this.id = id;
}

@Id
@GeneratedValue(strategy = IDENTITY)
@Column(name = "id_regla_condicion", unique = true, nullable = false)
public Integer getIdReglaCondicion() {
return this.idReglaCondicion;
}

public void setIdReglaCondicion(Integer idReglaCondicion) {
this.idReglaCondicion = idReglaCondicion;
}

@Column(name = "id_regla_facturacion", nullable = false)
public int getIdReglaFacturacion() {
return this.idReglaFacturacion;
}

public void setIdReglaFacturacion(int idReglaFacturacion) {
this.idReglaFacturacion = idReglaFacturacion;
}

@Column(name = "id_metadato", nullable = false)
public int getIdMetadato() {
return this.idMetadato;
}

public void setIdMetadato(int idMetadato) {
this.idMetadato = idMetadato;
}

@Column(name = "id", nullable = false)
public int getId() {
return this.id;
}

public void setId(int id) {
this.id = id;
}
}

when i try to execute a query, hibernate says:
org.hibernate.ObctNotFoundException: No row with the given identifier exists: [com.ig.h.pojo.Replicacion#149]

i have written and read all the rows name and they are well. my table has a row name called "id". when i change this name, for example, id_p, it works fine. i can't change all my tables because there are a lot of apps using these tables.

i think there is a problem when there is a row name called "id".

can anydoby help me please?

thank you very much

QuiQue

Check this page:

http://www.hibernate.org/hib_docs/v3/reference/en-US/html/queryhql-identifier-property.html



You may have to use the latest hibernate version.

Christophe

Hi,

the message says that there is no record (row) in the database where the identifying column (idReglaCondicion in your case) has the value you were looking for.

Regards,
Frank

Thanks Christophe,

I wasn't aware of that fact. So my prior posting might be irrelevant to QuiQue' problem.

Frank

yeahhhhhhhhhhhhhhh

thank you very much Christophe!!

regards

QuiQue