我有这样的结构
车辆品牌

@Entity
@Getter
@Setter
public class VehicleBrand {
    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    private Long id;

    private String name;

    private String otherInfo;
}

车辆型号

@Entity
@Getter
@Setter
public class VehicleModel {

    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    private Long id;

    @ManyToOne
    private VehicleBrand brand;

    private String name;

    private String otherInfo;
}

我也有我想使用的Dto对象，因为我想得到一个连接查询，它将从两个表返回数据，
ModelDto

@Getter
@Setter
public class ModelDto {

    private Long id;
    private String name;
    private long brand_id;
}

@Getter
@Setter
public class VehicleBrandModelDto {

    private Long id;
    private String name;
    List<ModelDto> model;
}

我想用jpa执行的查询如下
选择 vb.id，vm从车辆品牌vb加入车辆型号vm在vb. id = vm.品牌id组通过vb.id，vb，vm，vm.品牌id;
现在，当我在数据库上执行这个命令时，我有1122条记录，但是只有85个不同的汽车品牌
我希望得到的结果是public class VehicleBrandModelDto {

private Long id;
    private String name;
    List<ModelDto> model;
}

其中有85个品牌，并且在每个对象内有属于该品牌的型号列表。

Currently i have tried the following solutions 

@Repository
public class VehicleBrandRepository {

    @Autowired
    private EntityManager entityManager;

    public List getSuggestionList() {
        Query nativeQuery = entityManager.createNativeQuery("select vb.name, vm as model from 
      vehicle_brand  vb join vehicle_model vm on vb.id = vm.brand_id group by vb.name, vm");
        return nativeQuery.getResultList();
    }
//    public List<VehicleBrandModelDto> getSuggestionList() {
//        Query nativeQuery = entityManager.createQuery("select vb.id, vb.name, vm as model from 
         VehicleBrand  vb join VehicleModel vm on vb.id = vm.brand.id group by vb.id, vb.name, vm");
//        return nativeQuery.getResultList();
//    }
}

第二个解决方案与createQuery给出了1122记录的结果，我试图使用流API分组，但我有类转换异常，第一个查询返回错误

org.springframework.orm.jpa.JpaSystemException: No Dialect mapping for JDBC type: 2002; nested exception is org.hibernate.MappingException: No Dialect mapping for JDBC type: 2002

任何建议我如何才能实现这一点或可能这是不可能的？
数据库属性

spring.datasource.url=jdbc:postgresql://changed.compute-1.amazonaws.com:5432/changed
spring.jpa.properties.hibernate.jdbc.lob.non_contextual_creation=false
spring.datasource.username=changed
 spring.datasource.password=changed
spring.jpa.properties.hibernate.hbm2ddl.auto=update
spring.jpa.properties.connection.pool_size=17
spring.jpa.properties.hibernate.dialect =org.hibernate.dialect.PostgreSQLDialect
spring.datasource.driverClassName=org.postgresql.Driver

DB版本postgress 12