jpql 매핑 어덯게 해야하는지 알려주세요

Question

Query 에다가 dto 매핑 할려고 하는데 자꾸 매핑타입이랑 맞지 않다고 떠서 chatgpt 한태도 물어보니깐 dto 안에 class는 $ 붙여서 사용해야한다고 해서 그걸로도 했는데도 에러가 뜨더라고요 혹시 제가 놓친 부분이나 아니면 원래 안돼는건지 궁금합니다아래가 Jpql@Query("SELECT new com.model.domain.conversation.entity.dto.ConversationDetailDto(c.id, c.name, c.lastUpdated, c.companyId, " + "new com.model.domain.conversation.entity.dto.ConversationDetailDto$ConverUserDetails(u.id, u.username)) " + "FROM Conversation c " + "JOIN c.conversationUserList cu " + "JOIN cu.user u " + "WHERE c.id = :conversationId") List findBasicConversationDetailById(@Param("conversationId")Long conversationId);아래는 매핑할려는 dtopackage com.model.domain.conversation.entity.dto.; @Data @NoArgsConstructor @AllArgsConstructor public class ConversationDetailDto{ private Long conversationId; private String conversationName; private Date lastUpdated; private Long companyId; private List users; @Data @AllArgsConstructor public static class ConverUserDetails{ private Long userId; private String userName; } public ConversationDetailDto(Long conversationId, String conversationName, Date lastUpdated, Long companyId) { this.conversationId = conversationId; this.conversationName = conversationName; this.lastUpdated = lastUpdated; this.companyId = companyId; } }에러코드 2024-04-23T13:40:28.654+09:00 ERROR 24496 --- [nio-8081-exec-2] o.a.c.c.C.[.[.[/].[dispatcherServlet] : Servlet.service() for servlet [dispatcherServlet] in context with path [] threw exception [Request processing failed: org.springframework.orm.jpa.JpaSystemException: Cannot set field 'UserDetails' to instantiate 'com.model.domain.conversation.entity.dto.ConversationDetailDto'] with root causeorg.hibernate.query.sqm.sql.internal.InstantiationException: Cannot set field 'ConverUserDetails' to instantiate 'com.model.domain.conversation.entity.dto.ConversationDetailDto' at org.hibernate.sql.results.graph.instantiation.internal.DynamicInstantiationAssemblerInjectionImpl.lambda$new$0(DynamicInstantiationAssemblerInjectionImpl.java:84) ~[hibernate-core-6.3.1.Final.jar:6.3.1.Final]

팩트폭행범 · Answer

에러로그도 올려보세요

jpql 매핑 어덯게 해야하는지 알려주세요

1개의 답변

#jpql 목록