spring boot with hibernate and postgres giving exception column name not found even it is present

Question

I'm using native query as below in spring boot with postgres and hibernate.

@Query(value = "SELECT json_data from xxxschema.roles where role_id =?1", nativeQuery = true) Role getRolePrivilegesByRoleId(int id);

I'm getting following errors not sure why ?

org.postgresql.util.PSQLException: The column name role_id was not found in this ResultSet. at org.postgresql.jdbc.PgResultSet.findColumn(PgResultSet.java:2748) ~[postgresql-42.2.16.jar:42.2.16]

Simon Martinelli · Accepted Answer · 2022-09-30 13:10:08Z

1

You are returning Role but do not return all columns from the query mapped in the Role entity.

answered Sep 30, 2022 at 13:10

Simon Martinelli

36.6k6 gold badges62 silver badges92 bronze badges

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

Collectives™ on Stack Overflow

spring boot with hibernate and postgres giving exception column name not found even it is present

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