Spring Boot Repository Native Query for DTO in Postgresql Issue

Question

I have a problem about writing a native query for dto in Spring Boot with the usage of Postgresql.

Here is the dto shown below.

@Data
@AllArgsConstructor
@NoArgsConstructor
public class UserCommentsResponse {
    private String placeName;
    private String text;
}

Here is the native query shown below.

@Query(value="SELECT new com.demo.project.dao.UserCommentsResponse(placeName, text) FROM comment c inner join place p on p.id = c.place_id where customer_id = :id", nativeQuery=true)
List<UserCommentsResponse> getUsersComments(int id);

Here is the error message shown below.

org.postgresql.util.PSQLException: ERROR: syntax error at or near "."

How can I fix it?

Ion Gatman · Accepted Answer · 2023-01-08 17:18:40Z

1

Try this

@Query(value="SELECT UserCommentsResponse(placeName, text) FROM comment c inner join place p on p.id = c.place_id where customer_id = :id", nativeQuery=true)

instead of your original query

answered Jan 8, 2023 at 17:18

Ion Gatman

364 bronze badges

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

1 Comment

Sercan Noyan Germiyanoğlu Over a year ago

it didn't help me fix the issue.

Collectives™ on Stack Overflow

Spring Boot Repository Native Query for DTO in Postgresql Issue

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related