field＆＃x27; playerId＆＃x27;没有默认值

Question

我有两个类，player和playergoalsprediction。

请求从前端发送，其中包含playerId和目标值。 playerId用于使用player使用player> PlayerGoalsPrediction，以及目标。

但是，当将对象保存到db时，返回错误（java.sql.sqleclection：field'playerId'没有默认值）。

我认为它一定来自playergoalsPrediction.player属性，但是该对象确实具有分配给它的playerId值，所以我不确定问题来自何处？

player.java

@Entity
@Table(name = "Players")
public class Player {
    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    @Column(name = "PlayerID")
    private long playerID;
    
    @Column(name = "Name")
    private String name;

    @OneToMany(
        targetEntity=PlayerGoalsPrediction.class,
        fetch=FetchType.LAZY,
        mappedBy="player"
    )
    private List<PlayerGoalsPrediction> predictions;

    // constructors, getters and setters
}

playergoalsPrediction.java

@Entity
@Table(name = "PlayerGoalsPredictions")
public class PlayerGoalsPrediction {
    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    @Column(name = "PlayerGoalsPredictionID")
    private long playerGoalsPredictionID;

    @ManyToOne(
        targetEntity=Player.class,
        fetch=FetchType.EAGER
    )
    @Column(name = "PlayerID")
    private Player player;

    @Column(name = "Goals")
    private long goals;

    // constructors, getters and setters
}

playerRepository.java

@Repository
public interface PlayerRepository extends JpaRepository<Player, String>{
    
    public Player findByPlayerID(long playerID);
}

playergoalsgoalsPredictionController.java

@CrossOrigin(origins = "*")
@RestController
@RequestMapping("/api/v1/playergoalsprediction")
public class PlayerGoalsPredictionController {

    @Autowired
    private PlayerRepository playerRepository;

    @Autowired
    private PlayerGoalsPredictionRepository playerGoalsPredictionRepository;

    @PostMapping("/postprediction")
    public void postPredictions(
            @Valid @RequestBody PlayerGoalsPredictionRequest playerGoalsPredictionRequest 
    ) {
        PlayerGoalsPrediction playerGoalsPrediction = new PlayerGoalsPrediction(
            playerRepository.findByPlayerID(playerGoalsPredictionRequest.getPlayerID()),
            playerGoalsPredictionRequest.getGoals()
        );
        playerGoalsPredictionRepository.save(playerGoalsPrediction);
    }
}