Spring JPA/Hibernate findby column name return empty collection

Question

I have table with 2 columns store_number and manager_id and I created an entity and a repository class for the this table.

I'm trying to query manager_id by store_number using repository method below

Bean class:

@Entity public class StoreManagers { @Id @GeneratedValue @Column(name="store_number") private String storeNumber; private String managerId; public StoreManagers() { } public String getStoreNumber() { return storeNumber; } public void setStoreNumber(String storeNumber) { this.storeNumber = storeNumber; } public String getManagerId() { return managerId; } public void setManagerId(String managerId) { this.managerId = managerId; } @Override public String toString() { return "StoreManagers [storeNumber=" + storeNumber + ", manageId=" + managerId + "]"; } } public interface StoreManagersRepository extends JpaRepository<StoreManagers, String> { List<StoreManagers> findByStoreNumber(String storeNumber); }

Here is the hibernate query and result

Hibernate: select storemanag0_.manager_discount_id as manager_1_2_, storemanag0_.store_number as store_nu2_2_ from storemanagers storemanag0_ where storemanag0_.store_number=? 2016-12-23 12:16:15.763 TRACE 644 --- [nio-4000-exec-1] o.h.type.descriptor.sql.BasicBinder : binding parameter [1] as [VARCHAR] - [00012] : []

It's returning an empty List, but when I execute above query directly I'm getting results.

Please help me with this. Wat am I doing wrong here?

Either you're not passing the same storeNumber, or you and the app are not using the same database, or the data you're seeing has been inserted but not committed yet. — JB Nizet
– JB Nizet, Commented Dec 23, 2016 at 7:10
And please, don't overwrite the edits I made if it makes the post look worse. — JB Nizet
– JB Nizet, Commented Dec 23, 2016 at 7:12
I'm using the same database and storeNumber, aslo i'm just reading the existing data from DB. — Hanumanthraju
– Hanumanthraju, Commented Dec 23, 2016 at 7:12
Try running commit command directly and restart your app and check the results. Try printing the query after setting params. — Kiran Kumar
– Kiran Kumar, Commented Dec 23, 2016 at 7:13

Kihats · Accepted Answer · 2016-12-23 07:57:24Z

5

If you wish to keep the underscored field names in your database annotate your entity fields using @Column(name="store_number") and rename you field to be in camel-case.

@Column(name="store_number") private int storeNumber;

In your repository, you can use the method

findByStoreNumber(int storeNumber)

answered Dec 23, 2016 at 7:57

Kihats

3,5486 gold badges36 silver badges49 bronze badges

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

3 Comments

Hanumanthraju Over a year ago

using the same..please see the entity class code in the question section

richersoon Over a year ago

By default he can use underscore in the database, camel case will be split into underscore. stackoverflow.com/a/29088398/3448799

Kihats Over a year ago

Try changing your storeNumber to an int or long or if your storeNumber is alphanumeric, provide another field that will be the id and annotated by @GeneratedValue

Collectives™ on Stack Overflow

Spring JPA/Hibernate findby column name return empty collection

1 Answer 1

3 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Linked

Related