JPA: Errors in named query

Question

I get the exception org.hibernate.HibernateException: Errors in named queries: ElaborazionePagamentiMaggioriOneri.estrai but the named query looks correct to me. I also get

org.hibernate.hql.ast.QuerySyntaxException: ElaborazionePagamentiMaggioriOneri is not mapped [FROM ElaborazionePagamentiMaggioriOneri e  WHERE e.dataInizioLancio IS NULL AND e.dataFineLancio IS NULL AND e.distinta IS NULL]

My entity is the following:

@Entity(name="ELABORAZIONE_PAGAMENTI")
@Table(name="ELABORAZIONE_PAGAMENTI")
@NamedQuery(name="ElaborazionePagamentiMaggioriOneri.estrai", 
query="FROM ElaborazionePagamentiMaggioriOneri e  WHERE e.dataInizioLancio IS NULL AND e.dataFineLancio IS NULL AND e.distinta IS NULL")
public class ElaborazionePagamentiMaggioriOneri {
    @Id
    @GeneratedValue
    @Column(name="ID_ELABORAZIONE")
    private long idElaborazione;

    @ManyToOne(fetch=FetchType.LAZY)
    @JoinColumn(name="ID_INTERVALLO")
    private Intervallo intervallo;

    @Column(name="IMPORTO_MINIMO")
    private BigDecimal importoMinimo;

    @Column(name="IMPORTO_MASSIMO")
    private BigDecimal importoMassimo;

    @Column(name="LIMITE_DISPOSIZIONI")
    private Long limiteDisposizioni;

    @Column(name="DATA_INIZIO_LANCIO")
    private Calendar dataInizioLancio;

    @Column(name="DATA_FINE_LANCIO")
    private Calendar dataFineLancio;

    @OneToOne(fetch=FetchType.LAZY)
    @JoinColumn(name="ID_DISTINTA")
    private DistintaMaggioriOneri distinta;

What is the origin of the error? I have double checked the JPQL syntax.

Vitaly Olegovitch · Accepted Answer · 2014-05-14 14:05:26Z

13

Entity name used with @Entity and the name of the entity you are using inside Select query should be same, if you are not using entity name with @Entity then class name should be used with the Select query. Check this properly.

edited May 14, 2014 at 14:05

Vitaly Olegovitch

3,5576 gold badges35 silver badges56 bronze badges

answered May 14, 2014 at 13:54

Karibasappa G C

2,7322 gold badges21 silver badges27 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

VAdaihiep Over a year ago

Unbelievable it works like a charm. Thanks in advance!

Vitaly Olegovitch · Accepted Answer · 2014-05-14 13:50:56Z

3

The problem is that if you put the annotation @Entity(name="ELABORAZIONE_PAGAMENTI") you set the name of the entity to be ELABORAZIONE_PAGAMENTI. There are two solutions:

modify the named query into FROM ELABORAZIONE_PAGAMENTI e WHERE e.dataInizioLancio IS NULL AND e.dataFineLancio IS NULL AND e.distinta IS NULL
modify the @Entity annotation by removing the name property

answered May 14, 2014 at 13:50

Vitaly Olegovitch

3,5576 gold badges35 silver badges56 bronze badges

Comments

A. Agarwal · Accepted Answer · 2014-05-14 13:43:18Z

2

You are missing SELECT in your query.

query="SELECT e FROM ElaborazionePagamentiMaggioriOneri e  WHERE

answered May 14, 2014 at 13:43

A. Agarwal

4154 silver badges12 bronze badges

1 Comment

nyxz Over a year ago

The missing SELECT e is valid Hibernate syntax.

tzimnoch · Accepted Answer · 2014-05-14 13:48:11Z

1

In addition to missing SELECT, the "is not mapped" error is probably because you don't have the class registered in persistence.xml.

answered May 14, 2014 at 13:48

tzimnoch

2161 silver badge15 bronze badges

Collectives™ on Stack Overflow

JPA: Errors in named query

4 Answers 4

1 Comment

Comments

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

1 Comment

Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related