Home / Questions / 366
Accepted
hecnabae
Asked: 2020-12-04 07:56:31 +0800 CST 2020-12-04 07:56:31 +0800 CST

org.hibernate.MappingException: Named query not known

  • 772

When invoking a query with specified name the system throws the exception: org.hibernate.MappingException: Named query not known. I've given it several turns but I can't find where the problem is.

Consumption.java

@Entity
@Table( name = "consumo" )
@NamedQueries( {
        @NamedQuery(
                name = "Consumo.findConsumoPasoHistorico",
                query = "SELECT c FROM Consumo c WHERE c.fecha < :fechaTope ORDER BY c.fecha, c.id" )
} )
public class Consumo implements Serializable {

    @Id
    @Basic( optional = false )
    @Column( name = "id" )
    @GeneratedValue( strategy = GenerationType.IDENTITY )
    private Long id;

    @Temporal( TemporalType.TIMESTAMP )
    @Column( name = "fecha" )
    private Date fecha;

    @Column( name = "valor" )
    private double valor;

    @Temporal( TemporalType.TIMESTAMP )
    @Column( name = "created" )
    private Date created;

    @Temporal( TemporalType.TIMESTAMP )
    @Column( name = "updated" )
    private Date updated;

    //Getters y setters
}

The method from which I call the function:

public List<Consumo> findConsumoPasoHistorico(Date fechaTope) {
    Query query = getSession().getNamedQuery("Consumo.findConsumoPasoHistorico");
    query.setParameter("fechaTope", fechaTope);
    return query.list();
}

I have made sure that the configuration file hibernate.cfg.xmlcontains the reference to map the Consumption class:

<mapping class="es.kestrel.monitorizador.modelo.Consumo"/>
java

2 Answers

  1. Best Answer

    Try changing the marked part, since you don't need to indicate the class:

    public List<Consumo> findConsumoPasoHistorico(Date fechaTope) {
    //Query query = getSession().getNamedQuery("Consumo.findConsumoPasoHistorico");
    Query query = getSession().getNamedQuery("findConsumoPasoHistorico");
    query.setParameter("fechaTope", fechaTope);
    return query.list();
}
    • 0

  2. I normally call them using the createNamedQuerydel method Entity Manager.

    Query query = em.createNamedQuery("Consumo.findConsumoPasoHistorico", Consumo.class);
List resultados = query.getResultList();

    For more information you can consult http://www.objectdb.com/java/jpa/query/named .

    • 0