Native query not working when specifying column name

Question

I am trying to fetch data using native query method. I am able to fetch data using spring data JPA repository declared methods (findAll() etc) and using JPQL Queries.

When I am using Native query method , "select * from" is working. But when I am specifying "select username from " method is not working. Means When specifying column name, it is not working.

I am adding my code like this,

@Query(value = "select u.username from users u" , nativeQuery = true)
List<Users> findByUsername();

But the query using select * from users is working with no problem. Is this native query nature? Or is there any limited type of format the provider defines?

ahmetcetin · Accepted Answer · 2017-11-22 11:00:41Z

3

I think the problem is with your return variable. When you run "*select * from...*" query, you can return list of Users.

However, you want to fetch a column which is probably a varchar, so that you should return List of String:

@Query(value = "select u.username from users u" , nativeQuery = true)
List<String> findByUsername();

answered Nov 22, 2017 at 11:00

ahmetcetin

3,0201 gold badge26 silver badges39 bronze badges

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

Collectives™ on Stack Overflow

Native query not working when specifying column name

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related