我想Map两个列，所以我创建了一个Java类（pojo），其中包含两个元素（id和test1）

package com.rpImmo.BackServer.payload.request;

import com.fasterxml.jackson.annotation.JsonProperty;

import jakarta.persistence.Column;

public class TestRequestDB {
    @JsonProperty("id")
    @Column(name = "`id`")
    private Long id;

    @JsonProperty("test1")
    @Column(name = "`test1`")
    private String test1;

    public TestRequestDB(Long id, String test1) {
        this.id = id;
        this.test1 = test1;
    }

    public Long getId() {
        return id;
    }

    public void setId(Long id) {
        this.id = id;
    }

    public String getTest1() {
        return test1;
    }

    public void setTest1(String test1) {
        this.test1 = test1;
    }
    
}

之后，我用我的请求创建了一个新的仓库：

@Query(value = "SELECT new com.rpImmo.BackServer.payload.request.TestRequestDB(t.id, t.test1) FROM test t WHERE id = 1", nativeQuery = true)
    List<TestRequestDB> getTestV2();

我的控制器：

@GetMapping("/findAllV2")
    ResponseEntity<List<TestRequestDB>> findAllAnnounceV2() {
        List<TestRequestDB> response_ = testRepository.getTestV2();
        if(response_.size() > 0)
            return new ResponseEntity<>(response_, HttpStatus.OK);
        return new ResponseEntity<>(response_, HttpStatus.NOT_FOUND);
    }

错误：

2023-08-14T18:00:10.739+02:00  WARN 23742 --- [nio-8080-exec-3] o.h.engine.jdbc.spi.SqlExceptionHelper   : SQL Error: 1064, SQLState: 42000
2023-08-14T18:00:10.739+02:00 ERROR 23742 --- [nio-8080-exec-3] o.h.engine.jdbc.spi.SqlExceptionHelper   : (conn=147) You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '.rpImmo.BackServer.payload.request.TestRequestDB(t.id, t.test1) FROM test t W...' at line 1
2023-08-14T18:00:10.756+02:00 ERROR 23742 --- [nio-8080-exec-3] o.a.c.c.C.[.[.[.[dispatcherServlet]      : Servlet.service() for servlet [dispatcherServlet] in context with path [/api_dev] threw exception [Request processing failed: org.springframework.dao.InvalidDataAccessResourceUsageException: JDBC exception executing SQL [SELECT new com.rpImmo.BackServer.payload.request.TestRequestDB(t.id, t.test1) FROM test t WHERE id = 1] [(conn=147) You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '.rpImmo.BackServer.payload.request.TestRequestDB(t.id, t.test1) FROM test t W...' at line 1] [n/a]; SQL [n/a]] with root cause

java.sql.SQLSyntaxErrorException: (conn=147) You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '.rpImmo.BackServer.payload.request.TestRequestDB(t.id, t.test1) FROM test t W...' at line 1

但对我来说，这个请求是可以的，因为在终端上它工作正常

MariaDB [backServerRpImmo]> select t.id, t.test1 from test t where id = 1;
+----+-------+
| id | test1 |
+----+-------+
|  1 | 1     |
+----+-------+
1 row in set (0,000 sec)

但我不能得到一个战利品在一个解决方案在1周的（后我的工作日），但我不能修复它...你能帮我吗？如果你还需要什么别犹豫
ps：它是maven 3.1.2和java 17
做一个端点Ir的测试，但我想Map数据库上的表数据，使一些请求不同的默认情况下

**编辑

我已经在MariaDB上激活了请求的日志跟踪，我使用了另一个正常工作的项目：范例：
@Query(value = "SELECT new com.backEnd.coachingval.coachingval.model.Products(p.uuid, p.name, p.optn, p.price, p.ref, p.plans, p.promo, p.pricePromo) from Products p WHERE p.plans.id=:id ORDER BY p.name") List<Products> getProductsByID(@Param(value = "id") int id);
没有nativeQuery = true，MariaDb日志上的请求是好的：
select products0_.uuid as col_0_0_, products0_.name as col_1_0_, products0_.optn as col_2_0_, products0_.price as col_3_0_, products0_.ref as col_4_0_, products0_.plans_id as col_5_0_, products0_.promo as col_6_0_, products0_.price_promo as col_7_0_ from products products0_ inner join plans plans1_ on products0_.plans_id=plans1_.id where products0_.plans_id=1 order by products0_.name
请求是好的，但是当添加nativeQuery = true时，在mariaDB日志上获得此请求：
SELECT new com.backEnd.coachingval.coachingval.model.Products(p.uuid, p.name, p.optn, p.price, p.ref, p.plans, p.promo, p.pricePromo) from Products p WHERE p.plans.id=1 ORDER BY p.name
所以我需要删除nativeQuery = true，但在我的实际项目中，当删除nativeQuery = true时，我会得到这个错误，我不知道如何修复它
Exception encountered during context initialization - cancelling refresh attempt: org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'testController' defined in file [/home/kevin/Desktop/rpImmo/back_RPimmo/target/classes/com/rpImmo/BackServer/controllers/TestController.class]: Unsatisfied dependency expressed through constructor parameter 0: Error creating bean with name 'testRepository' defined in com.rpImmo.BackServer.repository.TestRepository defined in @EnableJpaRepositories declared on JpaRepositoriesRegistrar.EnableJpaRepositoriesConfiguration: Could not create query for public abstract com.rpImmo.BackServer.payload.request.TestRequestDB com.rpImmo.BackServer.repository.TestRepository.getTestV2(); Reason: Validation failed for query for method public abstract com.rpImmo.BackServer.payload.request.TestRequestDB com.rpImmo.BackServer.repository.TestRepository.getTestV2()
有人能帮我吗，谢谢