Spring JPA@OneToMany参数值[]与预期类型不匹配

Question

我在请求服务线路时收到此错误：

List<Order> orders = ordersRepository.getByCustomerId(id);

错误：组织。springframework。道。InvalidDataAccessApiUsageException：参数值[5]与预期类型[nz.webshop.models.Customer.Customers（不适用）]不匹配；嵌套的异常是java。lang.IllegalArgumentException：参数值[5]与预期类型[nz.webshop.models.Customer.Customers（不适用）]

存储库：

public interface OrdersRepository extends JpaRepository<Order, Integer> {
    List <Order> getByCustomerId(Integer customerId);
}

实体：

@EntityA:
@Table(name = "orders")
public class Order {
@ManyToOne(targetEntity=Customers.class)
   @JoinColumn (name = "customer_id", referencedColumnName="customer_id")
    private Integer customerId;

...getters/setters




@EntityB:
@Table (name ="customer")
public class Customers {
    @Id
    @GeneratedValue(strategy=GenerationType.AUTO)
    @Column(name = "customer_id")
    private Integer customerId;

    @OneToMany(targetEntity = Order.class, mappedBy = "customerId")
    private List<Order> Order;

...getters/setters

桌子是这样的：

CREATE TABLE orders
(
  order_id           INT AUTO_INCREMENT PRIMARY KEY,
  customer_id INT,
 FOREIGN KEY (customer_id) REFERENCES customer (customer_id)
);


CREATE TABLE customer
(
  customer_id INT AUTO_INCREMENT PRIMARY KEY,
  first_name  VARCHAR(50) ,
  last_name   VARCHAR(50) 

    );

更新：我将EntityA更改如下：

@EntityA:
@Table(name = "orders")
public class Order {

@Column(name = "customer_id") 
private Integer customerId;

@ManyToOne(targetEntity=Customers.class)
    private Customer customer;

...getters/setters

但是当请求相同的服务行时，会出现新的错误：org。springframework。道。InvalidDataAccessResourceUsageException：无法提取结果集；SQL[n/a]；嵌套异常为org。冬眠例外SQLGrammarException：无法提取结果集。原因：com。mysql。jdbc。例外情况。jdbc4.MySQLSyntaxErrorException：未知列“order0\u0”。“字段列表”中的“customer\u customer\u id”。

问题出在哪里？

Answer 1

看起来像是订单。customerId属性设置不正确。您要求多人根据客户的ID查找客户模型，但随后您将模型作为整数加载。试试这个：

@ManyToOne
@JoinColumn(name = "customer_id", referencedColumnName="customer_id")
private Customer customer;

让我知道这是否可行，如果不行，我们可以解决更多问题。