· 8 years ago · Apr 20, 2018, 09:02 PM
1Hibernate: alter table subject drop constraint FKdvgvxo0oxhxeepkkwug7vg4w4
2Hibernate: alter table subject_group drop constraint FK8v7h1pu0ewqq6v6nky8jfwh1l
3Hibernate: alter table subject_group drop constraint FK6xmk79mni0ym06e6wsiycs7hi
4Hibernate: drop table if exists group cascade
5Hibernate: drop table if exists subject cascade
621-Apr-2018 00:37:52.520 ERROR [RMI TCP Connection(76)-127.0.0.1] org.hibernate.tool.hbm2ddl.SchemaExport.perform HHH000389: Unsuccessful: alter table subject_group drop constraint FK8v7h1pu0ewqq6v6nky8jfwh1l
721-Apr-2018 00:37:52.521 ERROR [RMI TCP Connection(76)-127.0.0.1] org.hibernate.tool.hbm2ddl.SchemaExport.perform ОШИБКÐ: ограничение "fk8v7h1pu0ewqq6v6nky8jfwh1l" в таблице "subject_group" не ÑущеÑтвует
821-Apr-2018 00:37:52.522 ERROR [RMI TCP Connection(76)-127.0.0.1] org.hibernate.tool.hbm2ddl.SchemaExport.perform HHH000389: Unsuccessful: drop table if exists group cascade
921-Apr-2018 00:37:52.522 ERROR [RMI TCP Connection(76)-127.0.0.1] org.hibernate.tool.hbm2ddl.SchemaExport.perform ОШИБКÐ: ошибка ÑинтакÑиÑа (примерное положение: "group")
10ПозициÑ: 22
11Hibernate: drop table if exists subject_group cascade
12Hibernate: drop table if exists teacher cascade
13Hibernate: create table group (id int8 not null, id_rasp int8, name varchar(255), primary key (id))
1421-Apr-2018 00:37:52.531 ERROR [RMI TCP Connection(76)-127.0.0.1] org.hibernate.tool.hbm2ddl.SchemaExport.perform HHH000389: Unsuccessful: create table group (id int8 not null, id_rasp int8, name varchar(255), primary key (id))
1521-Apr-2018 00:37:52.531 ERROR [RMI TCP Connection(76)-127.0.0.1] org.hibernate.tool.hbm2ddl.SchemaExport.perform ОШИБКÐ: ошибка ÑинтакÑиÑа (примерное положение: "group")
16ПозициÑ: 14
17Hibernate: create table subject (id int8 not null, title varchar(255), type varchar(255), teacher_id int8, primary key (id))
18Hibernate: create table subject_group (subject_id int8 not null, group_id int8 not null)
19Hibernate: create table teacher (id int8 not null, first_name varchar(50) not null, id_rasp int4, last_name varchar(50) not null, login varchar(50), middle_name varchar(50), password varchar(50), primary key (id))
20Hibernate: alter table subject add constraint FKdvgvxo0oxhxeepkkwug7vg4w4 foreign key (teacher_id) references teacher
2121-Apr-2018 00:37:52.714 ERROR [RMI TCP Connection(76)-127.0.0.1] org.hibernate.tool.hbm2ddl.SchemaExport.perform HHH000389: Unsuccessful: alter table subject_group add constraint FK8v7h1pu0ewqq6v6nky8jfwh1l foreign key (group_id) references group
2221-Apr-2018 00:37:52.714 ERROR [RMI TCP Connection(76)-127.0.0.1] org.hibernate.tool.hbm2ddl.SchemaExport.perform ОШИБКÐ: ошибка ÑинтакÑиÑа (примерное положение: "group")
23 Hibernate: alter table subject_group add constraint FK8v7h1pu0ewqq6v6nky8jfwh1l foreign key (group_id) references group
24 Hibernate: alter table subject_group add constraint FK6xmk79mni0ym06e6wsiycs7hi foreign key (subject_id) references subject
25ПозициÑ: 104
26
27@Entity
28@Table(name = "subject")
29public class Subject {
30
31@Id
32@GeneratedValue(generator = "increment")
33@GenericGenerator(name = "increment", strategy = "increment")
34private long id;
35
36@Column(name = "title")
37private String title;
38
39@Column(name = "type")
40private String type;
41
42@ManyToOne(fetch = FetchType.EAGER)
43@JoinColumn(name = "teacher_id")
44@JsonBackReference
45private Teacher teacher;
46
47@ManyToMany(cascade = {CascadeType.ALL})
48@JoinTable(name = "subject_group",
49joinColumns = @JoinColumn(name = "subject_id"),
50inverseJoinColumns = @JoinColumn(name = "group_id"))
51private List<Group> groups = new ArrayList<>();
52
53public void addGroup(Group group) {
54 groups.add(group);
55 group.getSubjects().add(this);
56}
57
58public void removeGroup(Group group) {
59 groups.remove(group);
60 group.getSubjects().remove(this);
61}
62
63public List<Group> getGroups() {
64 return groups;
65}
66
67public void setGroups(List<Group> groups) {
68 this.groups = groups;
69}
70
71public Subject() {
72}
73
74@Entity
75@Table(name = "group")
76public class Group {
77
78@Id
79@GeneratedValue(generator = "increment")
80@GenericGenerator(name = "increment", strategy = "increment")
81private long id;
82
83@Column(name = "name")
84private String name;
85
86@Column(name = "id_rasp")
87private long idRasp;
88
89@ManyToMany(mappedBy = "groups")
90private List<Subject> subjects = new ArrayList<>();
91
92public Group(){}
93
94
95public List<Subject> getSubjects() {
96 return subjects;
97}
98
99public void setSubjects(List<Subject> subjects) {
100 this.subjects = subjects;
101}