EntityManager query cannot resolve property

Question

I am using JPA to query an OracleSQL database. However, I am getting the error:

Request processing failed; nested exception is java.lang.IllegalArgumentException: org.hibernate.QueryException: could not resolve property: CLIENT_ID of: com.fdmgroup.pojo.File [SELECT c FROM com.fdmgroup.pojo.File c WHERE c.CLIENT_ID = :clientId]

When I write the following query

String sqlQuery = "SELECT c FROM XD_FILES c WHERE c.CLIENT_ID = :clientId";
TypedQuery<File> query = em.createQuery(sqlQuery, File.class);
query = query.setParameter("clientId", clientId);
ArrayList<File> clientFiles = (ArrayList<File>) query.getResultList();

File has this column

@ManyToOne(targetEntity = Client.class)
@JoinColumn(name = "CLIENT_ID")
private Client client;

I am unsure why as it appears to have the field "client" linked to "CLIEND_ID".

What is the column name? – Pritam Banerjee Nov 19 '16 at 00:43 — Pritam Banerjee, Nov 19 '16 at 00:43
your "sqlQuery" is SQL but you use the API for JPQL! – Neil Stockton Nov 19 '16 at 05:46 — Neil Stockton, Nov 19 '16 at 05:46

score 1 · Answer 1 · answered Nov 19 '16 at 00:46

1

You will need to mention the property name in the query and not the column name.

So the query should look like the following:

String sqlQuery = "SELECT c FROM XD_FILES c WHERE c.clientId = :clientId";

answered Nov 19 '16 at 00:46

Pritam Banerjee

17,953
10
93
108

score 1 · Answer 2 · answered Nov 19 '16 at 10:00

Your query seems native query and not a JPQL, you can solve this in two ways.

1) change em.createQuery(sqlQuery, File.class); to em.createNativeQuery(sqlQuery, File.class);

2) Change your query from native query to JPQL, your query should be like

select c from File c where c.client.clientID=:clientId
(Assuming clientID is primary key column name in Client class)

EntityManager query cannot resolve property

2 Answers2