I am getting an exception that there are no parameters to a native queries when there are

[lordofthejars]

Hi I have a project with Quarkus 3.21.0 with a native query, but when I execute it I got: java.lang.IllegalArgumentException: No parameter named ':day' in query with named parameters []

So it is like no parameters are detected:

The class is

package org.acme;

import io.quarkus.hibernate.orm.panache.PanacheEntity;
import jakarta.persistence.Entity;
import jakarta.persistence.NamedNativeQuery;

import java.time.Duration;
import java.time.LocalDate;
import java.time.LocalDateTime;
import java.util.List;

@Entity
@NamedNativeQuery(name = "select_by_day",
        query = "SELECT * FROM event WHERE EXTRACT(DAY FROM eventDate) = :day AND EXTRACT(MONTH FROM eventDate) = :month AND EXTRACT(YEAR FROM eventDate) = :year;",
        resultClass = Event.class
)
@NamedNativeQuery(name = "select_by_week",
        query = """
        SELECT *
        FROM event
        WHERE WEEK(eventDate) = :week_number
        AND YEAR(eventDate) = :year;
        """,
        resultClass = Event.class
)
public class Event extends PanacheEntity {

    public String title;
    public String attendee;
    public LocalDateTime eventDate;
    public Duration duration;

    public static List<Event> findEventsByWeekOfYear(int weekNumber, int year) {
        return getEntityManager()
                .createNativeQuery("select_by_week", Event.class)
                .setParameter("week_number", weekNumber)
                .setParameter("year", year)
                .getResultList();
    }

    public static List<Event> findEventsByDay(LocalDate localDate) {
        return getEntityManager()
                .createNativeQuery("select_by_day", Event.class)
                .setParameter("day", localDate.getDayOfMonth())
                .setParameter("month", localDate.getMonthValue())
                .setParameter("year", localDate.getYear())
                .getResultList();
    }

}

And the whole project is at https://github.com/lordofthejars-ai/applied-ai-for-enterprise-java-development-src/tree/main/ch09/scheduler-calendar

The test: https://github.com/lordofthejars-ai/applied-ai-for-enterprise-java-development-src/blob/main/ch09/scheduler-calendar/src/test/java/org/acme/EventQueryTest.java

And it is using H2 driver so nothing is required.

Thank you very much

[edeandrea]

You're using createNativeQuery not createNamedQuery. createNativeQuery expects the query itself, whereas createNamedQuery expects the name of a named query.

[lordofthejars]

Thank you very much mate. Yes similar method name but completely different purpose 😁 I burned my eyes trying to figure out why was not working. Thanks Enviat amb Gmail Mobile El dt, 1 abr. 2025 a les 19:02 Eric Deandrea ***@***.***> va escriure:

…

You're using createNativeQuery not createNamedQuery. createNativeQuery expects the query itself, whereas createNamedQuery expects the name of a named query. — Reply to this email directly, view it on GitHub <#47105 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AALSMYKOE2BQ7O36OZIHQ4L2XLBCHAVCNFSM6AAAAAB2HBSQJKVHI2DSMVQWIX3LMV43URDJONRXK43TNFXW4Q3PNVWWK3TUHMYTENRZGEZDMNY> . You are receiving this because you authored the thread.Message ID: ***@***.***>