Getting 'Named query not found' with Spring framework

Question

I have a Java class (Entity) with a set of named queries. When the Spring tries to inject the related bean, it is not finding one of the queries.

As example:

@NamedQueries({
        @NamedQuery(name = "Query1", query = "..."),
        @NamedQuery(name = "Query2", query = "..."),
        @NamedQuery(name = "Query3", query = "..."),
        @NamedQuery(name = "Query4", query = "..."),
        @NamedQuery(name = "Query5", query = "...")
})

When Spring tries to inject the bean, I´m getting:

org.springframework.beans.factory.BeanCreationException: Error creating bean
with name 'myBean': Injection of resource methods failed;nested exception is
java.lang.IllegalArgumentException: Named query not found: Query3 at ...

I´m sure the queries are correct (all the unit tests for them are passing).

Does anybody know the root cause for it?

how are you unit-testing them? Using the spring JUnit runner? — Bozho
– Bozho, Commented Jul 1, 2010 at 14:31
Bozho, he is using AbstractTransactionalJUnit4SpringContextTests to test it. — rafa.ferreira
– rafa.ferreira, Commented Jul 2, 2010 at 20:26

Bozho · Accepted Answer · 2010-07-01 13:47:23Z

5

make sure your entity has been mapped / scanned. Is it annotated with @Entity, is it added to the persistence.xml or to the relevant provider configuration, or is it automatically scanned.
I'd prefix the name of the class to the query - i.e. MyEntity.Query1, MyEntity.Query1 etc.
verify whether there aren't deployment errors - i.e. that your query is correct

edited Jul 1, 2010 at 13:47

answered Jul 1, 2010 at 5:44

Bozho

599k147 gold badges1.1k silver badges1.2k bronze badges

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

2 Comments

Felipe Arenales Over a year ago

Bozho: 1)Yes, my entity is annotated with @Entity. The main point is that only ONE query is not being found. All the others are. 2)In my real project, I name my query as constants, such as QUERY1. So, when I call one query in another class, it´s in the form: MyEntity.QUERY1. So, I still have no solution for my problem. Thank you anyway.

Felipe Arenales Over a year ago

Your third point is answered in my edited question description. Thank you one more time.

Felipe Arenales · Accepted Answer · 2010-07-02 18:50:51Z

Well, I´ve got the error. What was happening is as follows:

In my class there was one method annotated with @Resource, which called the named query declared in another class annotated with @Entity).

So, when Spring injects and runs the method, it tries to use the named query. However, the query is not 'ready' to be used, and the exception throwed is that the query was not found.

To solve this, I have to run a different method called when the Spring injections are finished, i.e., my class has to implement the interface org.springframework.context.ApplicationListener and the method onApplicationEvent waits for a org.springframework.context.event.ContextRefreshedEvent event.

That´s all guys. Thank you Bozho for your help.

Collectives™ on Stack Overflow

Getting 'Named query not found' with Spring framework

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related