「SPRING BOOT2 プログラミング入門」という本を進めています。
そこで6章最後にエラーにあたり解決できずにいます。
spring_bootを起動すると下記ログが出てエラーが含まれています
コンソールログ全て
. ____ _ __ _ _ /\ / ___'_ __ _ _(_)_ __ __ _ \ \ \ \ ( ( )\___ | '_ | '_| | '_ / _` | \ \ \ \ \/ ___)| |_)| | | | | || (_| | ) ) ) ) ' |____| .__|_| |_|_| |_\__, | / / / / =========|_|==============|___/=/_/_/_/ :: Spring Boot :: (v2.1.7.RELEASE) . . . 2019-08-14 10:33:32.376 INFO 1300 --- [ main] org.hibernate.dialect.Dialect : HHH000400: Using dialect: org.hibernate.dialect.HSQLDialect 2019-08-14 10:33:32.798 WARN 1300 --- [ main] o.h.t.s.i.ExceptionHandlerLoggedImpl : GenerationTarget encountered exception accepting command : Error executing DDL "alter table msgdata drop constraint FKamgt1k8o4mna8bjm9195rjdky" via JDBC Statement org.hibernate.tool.schema.spi.CommandAcceptanceException: Error executing DDL "alter table msgdata drop constraint FKamgt1k8o4mna8bjm9195rjdky" via JDBC Statement at org.hibernate.tool.schema.internal.exec.GenerationTargetToDatabase.accept(GenerationTargetToDatabase.java:67) ~[hibernate-core-5.3.10.Final.jar:5.3.10.Final] at org.hibernate.tool.schema.internal.SchemaDropperImpl.applySqlString(SchemaDropperImpl.java:375) ~[hibernate-core-5.3.10.Final.jar:5.3.10.Final] at org.hibernate.tool.schema.internal.SchemaDropperImpl.applySqlStrings(SchemaDropperImpl.java:359) ~[hibernate-core-5.3.10.Final.jar:5.3.10.Final] at org.hibernate.tool.schema.internal.SchemaDropperImpl.applyConstraintDropping(SchemaDropperImpl.java:331) ~[hibernate-core-5.3.10.Final.jar:5.3.10.Final] a . . .
一応DBを使わない操作はうまくいきます。
しかし、DBを使う操作をすると値がない的なエラーが出ます。
内容見ると下記が原因のようです。
Error executing DDL "alter table msgdata drop constraint FKamgt1k8o4mna8bjm9195rjdky" via JDBC Statement
MyDataテーブルとMsgDataテーブルのアソシエーションで外部キーが問題のようですが、わからないためお力を貸して下さい。
環境
・DB:hsqldb
MyDataソースコード
java
1// MyData.java 2package com.tuyano.springboot; 3 4import javax.persistence.Column; 5import javax.persistence.Entity; 6import javax.persistence.GeneratedValue; 7import javax.persistence.GenerationType; 8import javax.persistence.Id; 9import javax.persistence.Table; 10import javax.validation.constraints.Min; 11import javax.validation.constraints.Max; 12import javax.validation.constraints.NotNull; 13import org.hibernate.validator.constraints.Email; 14import org.hibernate.validator.constraints.NotEmpty; 15import java.util.List; 16import javax.persistence.CascadeType; 17import javax.persistence.OneToMany; 18 19@Entity 20@Table(name="mydata") 21public class MyData { 22 23 @Id 24 @GeneratedValue(strategy = GenerationType.AUTO) 25 @Column 26 @NotNull 27 private long id; 28 29 @Column(length = 50, nullable = false) 30 @NotEmpty 31 private String name; 32 33 @Column(length = 200, nullable = true) 34 @Email 35 private String mail; 36 37 @Column(nullable = true) 38 @Min(value=0) 39 @Max(value=200) 40 private Integer age; 41 42 @Column(nullable = true) 43 @Phone 44 private String memo; 45 46 @OneToMany(cascade=CascadeType.ALL) 47 @Column(nullable=true) 48 private List<MsgData> msgdatas; 49 50 public List<MsgData> getMsgdatas(){ return msgdatas; } 51 public void setMsgdatas(List<MsgData> msgdatas) { this.msgdatas = msgdatas; } 52 53 public long getId() { return id; } 54 public void setId(long id) { this.id = id; } 55 public String getName() { return name; } 56 public void setName(String name) { this.name = name; } 57 public String getMail() { return mail; } 58 public void setMail(String mail) { this.mail = mail; } 59 public Integer getAge() { return age; } 60 public void setAge(Integer age) { this.age = age; } 61 public String getMemo() { return memo; } 62 public void setMemo(String memo) { this.memo = memo; } 63}
MsgDataテーブル
java
1// MsgData.java 2package com.tuyano.springboot; 3 4import javax.persistence.Column; 5import javax.persistence.Entity; 6import javax.persistence.GeneratedValue; 7import javax.persistence.GenerationType; 8import javax.persistence.Id; 9import javax.persistence.ManyToOne; 10import javax.persistence.Table; 11import javax.validation.constraints.NotNull; 12 13import org.hibernate.validator.constraints.NotEmpty; 14 15@Entity 16@Table(name="msgdata") 17public class MsgData { 18 @Id 19 @GeneratedValue(strategy = GenerationType.AUTO) 20 @Column 21 @NotNull 22 private long id; 23 24 @Column 25 private String title; 26 27 @Column(nullable = false) 28 @NotEmpty 29 private String message; 30 31 @ManyToOne 32 private MyData mydata; 33 34 public MsgData() { 35 super(); 36 mydata = new MyData(); 37 } 38 39 public long getId() { return id; } 40 public void setId(long id) { this.id = id; } 41 public String getTitle() { return title; } 42 public void setTitle(String title) { this.title = title; } 43 public String getMessage() { return message; } 44 public void setMessage(String message) { this.message = message; } 45 public MyData getMydata() { return mydata; } 46 public void setMydata(MyData mydata) { this.mydata = mydata; } 47 48}
あなたの回答
tips
プレビュー