I have some problems with this named query (I'm using JBoss 4.2.2 with Hibernate embedded).
I want to retrieve just the entities, where the week of the year for the Calendar match the Integer passed as parameter :weekInput. Apparently the sintax is fine, the jar runs correctly. But during the test I found out an incorrect behavior, I have a record which as the week property equals to the 16 of June, that corresponds to the week of the year 25. This query returns that resulset even if the week of the year passed is 24. Have you got any suggestions?