Skip to main content

You are not logged in. Your edit will be placed in a queue until it is peer reviewed.

We welcome edits that make the post easier to understand and more valuable for readers. Because community members review edits, please try to make the post substantially better than how you found it, for example, by fixing grammar or adding additional resources and hyperlinks.

Required fields*

5
  • Do you have access to database? It seems there is a "PR_0000000288" in your table? Commented Oct 11, 2019 at 23:30
  • @aksappy I do have access to the DB and provider_id is "PR_0000000288" and that column datatype is varchar(100) Commented Oct 11, 2019 at 23:32
  • What is the Id for Member class? Commented Oct 11, 2019 at 23:38
  • @aksappy memberId for this row is 18468 which is bigInt. I run the query in the DB it works fine but not with jpa Commented Oct 11, 2019 at 23:40
  • Kindly share the Provider entity class too as it looks like you have the Id field in the Provider class as Long and the ProductWallet has a providerId as String. Hence the former is taken in the query and so the error. Commented Oct 12, 2019 at 7:04