mangusbrother mangusbrother - 5 months ago 157
SQL Question

No Query defined for that name, when using Entity Manager

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;
}

}

Answer

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