o.h.engine.jdbc.spi.SqlExceptionHelper ： 错误：语法错误在"("或附近

Question

我正在尝试创建一个用户API，但我的简单查询出现了上述错误。请找到我的以下代码。

在日志中，我将此作为错误

Hibernate: Select new  UserResponse(u.user_id,u.user_name,u.password) from public."DetailsCompany" u where user_id =?
2020-08-26 20:31:49.078  WARN 26274 --- [nio-7071-exec-2] o.h.engine.jdbc.spi.SqlExceptionHelper   : SQL Error: 0, SQLState: 42601
2020-08-26 20:31:49.078 ERROR 26274 --- [nio-7071-exec-2] o.h.engine.jdbc.spi.SqlExceptionHelper   : ERROR: syntax error at or near "("

@Repository
public interface UserRepository extends JpaRepository<UserEntity, Long>{
@Query(value="Select new  UserResponse(u.user_id,u.user_name,u.password) from public."DetailsCompany" u where user_id =:id",nativeQuery = true)
public UserResponse findUserById(@Param("id")Integer id);
}
UserResponse.java
package com.company.user.Response;
import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;
@Data
@NoArgsConstructor
@AllArgsConstructor
public class UserResponse{
private Integer userId;
private String userName;
private String password;
}
#As requested Entity Class Details#
#UserEntity.java#
package com.company.user.Entity;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.Table;
import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;
@Data
@NoArgsConstructor
@AllArgsConstructor
@Entity
@Table(name="DetailsCompany", schema = "public")
public class UserEntity {
@Id
@GeneratedValue(strategy = GenerationType.IDENTITY)
@Column(name = "user_id")
private Integer userId;
@Column(name = "user_name")
private String userName;
@Column(name = "password")
private String password;
}

Answer 1

构造函数名称必须是完全限定的。尝试使用com.your.package.UserResponse

Answer 2

您正在将HQL传递给本机查询。将nativeQuery更改为false。

将查询更改为

@Query(value="Select new  com.company.user.Response.UserResponse(u.userId,u.userName,u.password) from UserEntity u where u.userId =:id",nativeQuery = false)