ERROR: column 'id' not found while using nativequery in hibernate 5.4.14

See more:

Java

Hibernate

I'm getting:

ERROR: column 'id' not found while using session.createNativeQuery() in hibernate 5.4.14

What I have tried:

try (Session session = sessionFactory.openSession()) {
    var clients = session.createNativeQuery("select c.fullname, c.city from client c where c.id=:id")
            .addEntity("c", Client.class)
            .setParameter("id", id);

and there's filed "id" in entity and in a database too but getting:

Caused by: java.sql.SQLException: Column 'id' not found.

Here's entity class:

public class Client  implements java.io.Serializable {    

     private Integer id;
     private Product product;
     private String fullname;
     private String business;
     private String address;

Here's Client.hbm.xml :

<class name="javafxapplication.pojo.Client" table="client" catalog="clientie" optimistic-lock="version">
    <id name="id" type="java.lang.Integer">
        <column name="id" />
        <generator class="identity" />
    </id>

Here's how table is setup in a database https://i.stack.imgur.com/YCC6T.png[^]
Sometimes It's being cause if we import data from dump in a database I tried creating new table in new database but it won't solve.


I'm using MySQL 8.0.21 Hibernate 5.4.14 JDK 11.0.8+10
I won't use JPA Criteria cause I'm checking performance using NativeQuery.