質問編集履歴
1
エラーメッセージ・dbなど追記しました。
title
CHANGED
|
File without changes
|
body
CHANGED
|
@@ -2,19 +2,63 @@
|
|
|
2
2
|
|
|
3
3
|
SpringBootの勉強中です。
|
|
4
4
|
1つのフォームで、2つのテーブルの内容を登録したくて、OneToOne結合しています。
|
|
5
|
-
主のテーブルの自動採番は
|
|
5
|
+
主のテーブルの自動採番（mst_sensorのsensor_id、mst_mailのmail_id）はinsert文に表示されていますが、その採番されたID（sensor_id）を結合先のテーブル（mst_mail）に登録したいのですが、nullとなり登録できずに困っています。
|
|
6
6
|
よろしくお願いします。
|
|
7
7
|
|
|
8
8
|
### 発生している問題・エラーメッセージ
|
|
9
|
+
```
|
|
10
|
+
10. insert into mst_sensor (sensor_name, updatedata, sensor_id) values ('AA11', '05/25/2018 09:54:22.253', 36) {executed in 66 msec}
|
|
9
11
|
|
|
10
|
-
|
|
12
|
+
10. insert into mst_mail (sensor_id, sendmail_address, sendmail_threshold, updatedata, mail_id) values (NULL, NULL, 1, '05/25/2018 09:54:22.047', 11) {FAILED after 47 msec}
|
|
13
|
+
|
|
11
14
|
org.postgresql.util.PSQLException: ERROR: null value in column "sensor_id" violates not-null constraint
|
|
12
|
-
詳細: Failing row contains (null, 0, 1, null, 2018-05-
|
|
15
|
+
詳細: Failing row contains (null, 0, 1, null, 2018-05-25 09:54:22.047, 11).
|
|
13
16
|
```
|
|
14
17
|
|
|
15
18
|
### 該当のソースコード
|
|
19
|
+
postgresql
|
|
20
|
+
```
|
|
21
|
+
\d mst_sensor
|
|
22
|
+
Table "public.mst_sensor"
|
|
23
|
+
Column | Type | Collation | Nullable | Default
|
|
24
|
+
-------+------+-----------+----------+--------------------
|
|
25
|
+
sensor_id | integer | | not null | nextval('mst_sensor_sensor_id_seq'::regclass)
|
|
26
|
+
sensor_name | character varying(30) | | not null |
|
|
27
|
+
updatedata | timestamp without time zone | | not null |
|
|
28
|
+
Indexes:
|
|
29
|
+
"mst_sensor_pkey" PRIMARY KEY, btree (sensor_id)
|
|
16
30
|
|
|
31
|
+
|
|
32
|
+
\d mst_sensor_sensor_id_seq
|
|
33
|
+
Sequence "public.mst_sensor_sensor_id_seq"
|
|
34
|
+
Type | Start | Minimum | Maximum | Increment | Cycles? | Cache
|
|
35
|
+
-----+-------+---------+---------+-----------+---------+-------
|
|
36
|
+
integer | 1 | 1 | 2147483647 | 1 | no | 1
|
|
37
|
+
Owned by: public.mst_sensor.sensor_id
|
|
38
|
+
|
|
39
|
+
|
|
40
|
+
\d mst_mail
|
|
41
|
+
Table "public.mst_mail"
|
|
42
|
+
Column | Type | Collation | Nullable | Default
|
|
43
|
+
-------+------+-----------+----------+-----------------------
|
|
44
|
+
sensor_id | integer | | not null |
|
|
45
|
+
sendmail_threshold | integer | | |
|
|
46
|
+
sendmail_address | character varying(128) | | |
|
|
47
|
+
updatedata | timestamp without time zone | | not null |
|
|
48
|
+
mail_id | integer | | not null | nextval('mst_mail_mail_id_seq'::regclass)
|
|
49
|
+
Indexes:
|
|
50
|
+
"mst_mail_pkey" PRIMARY KEY, btree (mail_id)
|
|
51
|
+
|
|
52
|
+
|
|
53
|
+
\d mst_mail_mail_id_seq
|
|
54
|
+
Sequence "public.mst_mail_mail_id_seq"
|
|
55
|
+
Type | Start | Minimum | Maximum | Increment | Cycles? | Cache
|
|
56
|
+
-----+-------+---------+---------+-----------+---------+-------
|
|
57
|
+
bigint | 1 | 1 | 9223372036854775807 | 1 | no | 1
|
|
58
|
+
```
|
|
59
|
+
|
|
17
|
-
|
|
60
|
+
Machine.java
|
|
61
|
+
```java
|
|
18
62
|
@Data
|
|
19
63
|
@NoArgsConstructor
|
|
20
64
|
@AllArgsConstructor
|
|
@@ -71,7 +115,8 @@
|
|
|
71
115
|
}
|
|
72
116
|
```
|
|
73
117
|
|
|
74
|
-
|
|
118
|
+
MachineMailAdd.java
|
|
119
|
+
```java
|
|
75
120
|
@Data
|
|
76
121
|
@NoArgsConstructor
|
|
77
122
|
@AllArgsConstructor
|
|
@@ -130,7 +175,8 @@
|
|
|
130
175
|
}
|
|
131
176
|
```
|
|
132
177
|
|
|
133
|
-
|
|
178
|
+
MachineController.java
|
|
179
|
+
```java
|
|
134
180
|
@RequestMapping("add")
|
|
135
181
|
String create(Model model) {
|
|
136
182
|
return "admin/machine/add";
|