No Query defined for that name, when using Entity Manager

Question

I have the following entity:

package com.server.models;
@Entity
@Table(name="users")
@NamedQueries({
    @NamedQuery(name=User.QUERY_FIND_USER,query="SELECT c FROM user c WHERE c.username = :username")
})
public class User {

    public static final String QUERY_FIND_USER = "LoginFindUser";
    //  ...
}

And then using the Entity Manager (em) i'm doing the following:

package com.server.controllers;
@Service
@Transactional
@RestController
@RequestMapping("/user")
public class LoginController {
    @PersistenceContext
    private EntityManager em;
 // my code
    TypedQuery<User> queries = em.createNamedQuery(User.QUERY_FIND_USER,User.class).setParameter("username", username);
    List<User> users = queries.getResultList();
}

However I am getting the following error:

java.lang.IllegalArgumentException: No query defined for that name [LoginFindUser]

Here's my spring-boot Configuration. This should include the scanning of the entity.

package com.server.boot;

@Configuration
@ComponentScan({"com.server"})
@EnableAutoConfiguration
public class Starter {
    public static void main(String[] args){
        SpringApplication.run(Starter.class,args);
        System.out.println("started application");
    }

    @Bean
    public LoginController loginController(){
        return new LoginController();
    }

    @Bean
    public HibernateJpaSessionFactoryBean sessionFactory(EntityManagerFactory emf) {
         HibernateJpaSessionFactoryBean factory = new HibernateJpaSessionFactoryBean();
         factory.setEntityManagerFactory(emf);
         return factory;
    }

}

Does it work when you put a simple String as name? If yes, it's probably some evaluation time difference — Predrag Maric
– Predrag Maric, Commented Nov 25, 2014 at 11:00
Then check if User entity is defined in your persistence unit. — Predrag Maric
– Predrag Maric, Commented Nov 25, 2014 at 11:11
I'm using spring-boot so the persistence is autodefined. The Context Scan should be including it — mangusbrother
– mangusbrother, Commented Nov 25, 2014 at 11:12
And BTW, if the entity was mapped, you would get an exception because the query is invalid. user != User. — JB Nizet
– JB Nizet, Commented Nov 25, 2014 at 11:20

mangusbrother · Accepted Answer · 2014-11-25 11:23:35Z

21

Found it. Thanks to the guys in the comments

Add

@EntityScan("com.server.models")

to your configuration class

and I had an error in the query cause user needed to be User

answered Nov 25, 2014 at 11:23

mangusbrother

4,17611 gold badges56 silver badges111 bronze badges

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

2 Comments

Jess Over a year ago

what is the version of persistence has this annotation ?

Shilan Over a year ago

or to <property name="packagesToScan" value="com.servers.model" /> if you are using old dispatcher-servlet.xml

Rasheed · Accepted Answer · 2016-06-09 08:01:53Z

8

Okay, this might be an issue with you persistence configuration. If your models definitions are all in a separate ejb, make sure to add them in the persistence.xml in the persistence-unit

answered Jun 9, 2016 at 8:01

Rasheed

1,0511 gold badge13 silver badges18 bronze badges

Comments

David Buck · Accepted Answer · 2020-07-16 18:30:04Z

1

You can do by below configuration.

private static final String[] ENTITYMANAGER_PACKAGES_TO_SCAN = { "a.b.c.entity" };

@Bean
public LocalContainerEntityManagerFactoryBean entityManagerFactoryBean() {

    LocalContainerEntityManagerFactoryBean entityManagerFactoryBean = new LocalContainerEntityManagerFactoryBean();
    entityManagerFactoryBean.setJpaVendorAdapter(vendorAdaptor());
    entityManagerFactoryBean.setDataSource(dataSource());
    entityManagerFactoryBean.setPersistenceProviderClass(HibernatePersistenceProvider.class);
    entityManagerFactoryBean.setPackagesToScan(ENTITYMANAGER_PACKAGES_TO_SCAN);
    entityManagerFactoryBean.setJpaProperties(jpaHibernateProperties());

    return entityManagerFactoryBean;
}

edited Jul 16, 2020 at 18:30

David Buck

3,87740 gold badges54 silver badges73 bronze badges

answered Jul 16, 2020 at 18:10

Shreyas Shet

112 bronze badges

Comments

Sercan Noyan Germiyanoğlu · Accepted Answer · 2019-08-27 22:47:49Z

0

You can use this code snippet shown below.

<property name="packagesToScan" value="com.servers.model" />

answered Aug 27, 2019 at 22:47

Sercan Noyan Germiyanoğlu

2,9185 gold badges58 silver badges130 bronze badges

Comments

Shubhashish Mishra · Accepted Answer · 2019-10-04 20:32:38Z

0

Add

entitymanager.packagesToScan:com.server.models

to your application.properties file.

answered Oct 4, 2019 at 20:32

Shubhashish Mishra

4887 silver badges10 bronze badges

Collectives™ on Stack Overflow

No Query defined for that name, when using Entity Manager

5 Answers 5

2 Comments

Comments

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

2 Comments

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related