cydwJ9Lh

1java.sql.SQLIntegrityConstraintViolationException: Cannot add or update a child row: a foreign key constraint fails (`smartphones`.`smartphone`, CONSTRAINT `fk_smartphone_resolution1` FOREIGN KEY (`resolution_id`) REFERENCES `resolution` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION)
2	
3CREATE TABLE IF NOT EXISTS `smartphones`.`smartphone` (
4      `id` INT(11) NOT NULL AUTO_INCREMENT,
5      `name` VARCHAR(45) NULL DEFAULT NULL,
6      `resolution_id` INT(11) NOT NULL,
7               ...other
8      PRIMARY KEY (`id`, `resolution_id`),
9      UNIQUE INDEX `id_UNIQUE` (`id` ASC),
10      INDEX `fk_smartphone_resolution1_idx` (`resolution_id` ASC),
11      CONSTRAINT `fk_smartphone_resolution1`
12        FOREIGN KEY (`resolution_id`)
13        REFERENCES `smartphones`.`resolution` (`id`)
14        ON DELETE NO ACTION
15        ON UPDATE NO ACTION)
16	
17package com.project.model;
18
19import javax.persistence.*;
20
21@Entity
22public class Smartphone {
23    private int id;
24    private String name;
25    private Resolution resolutionId;
26
27    @Id
28    @Column(name = "id")
29    public int getId() {
30        return id;
31    }
32
33    public void setId(int id) {
34        this.id = id;
35    }
36
37    @Basic
38    @Column(name = "name")
39    public String getName() {
40        return name;
41    }
42
43    public void setName(String name) {
44        this.name = name;
45    }
46
47    @ManyToOne(fetch=FetchType.EAGER, cascade=CascadeType.PERSIST)
48    @JoinColumn(name = "resolution_id", referencedColumnName = "id", nullable = false)
49    public Resolution getResolutionId() {
50        return resolutionId;
51    }
52
53    public void setResolutionId(Resolution resolutionId) {
54        this.resolutionId = resolutionId;
55    }
56}