“spring boot not creating all tables – Spring Boot, MySQL, jpa”

huangapple
go评论115阅读模式
英文:

spring boot not creating all tables - Spring Boot, MySQL, jpa

问题

我已经映射了4个类，然后启动了控制台答案：

  1. .   ____          _            __ _ _
  2.  /\ / ___'_ __ _ _(_)_ __  __ _ \ \ \ \
  3. ( ( )\___ | '_ | '_| | '_ \/ _` | \ \ \ \
  4.  \/  ___)| |_)| | | | | || (_| |  ) ) ) )
  5.   '  |____| .__|_| |_|_| |_\__, | / / / /
  6.  =========|_|==============|___/=/_/_/_/
  7.  :: Spring Boot ::        (v2.3.4.RELEASE)
  9. 2020-10-27 11:34:29.432  INFO 6612 --- [           main] b.c.n.i.IndividualProjectApplication     : Starting IndividualProjectApplication on Othon-NoteAMD with PID 6612 (D:\programacao\Qualiti\individualProject\target\classes started by othon in D:\programacao\Qualiti\individualProject)
  10. 2020-10-27 11:34:29.435  INFO 6612 --- [           main] b.c.n.i.IndividualProjectApplication     : No active profile set, falling back to default profiles: default
  11. 2020-10-27 11:34:30.197  INFO 6612 --- [           main] .s.d.r.c.RepositoryConfigurationDelegate : Bootstrapping Spring Data JPA repositories in DEFERRED mode.
  12. 2020-10-27 11:34:30.232  INFO 6612 --- [           main] .s.d.r.c.RepositoryConfigurationDelegate : Finished Spring Data repository scanning in 20ms. Found 0 JPA repository interfaces.
  13. 2020-10-27 11:34:31.420  INFO 6612 --- [           main] o.s.b.w.embedded.tomcat.TomcatWebServer  : Tomcat initialized with port(s): 8080 (http)
  14. 2020-10-27 11:34:31.437  INFO 6612 --- [           main] o.apache.catalina.core.StandardService   : Starting service [Tomcat]
  15. ...

然后我逐个注释了其他类并逐个启动，

创建了以下内容：

  1. package br.com.negromonte.individualProject.model;
  3. import java.sql.Date;
  4. import java.util.List;
  6. import javax.persistence.Column;
  7. import javax.persistence.Entity;
  8. import javax.persistence.FetchType;
  9. import javax.persistence.Id;
  10. import javax.persistence.OneToMany;
  11. import javax.persistence.Table;
  13. @Entity
  14. @Table(name = "client")
  15. public class Client {
  16.     
  17.     @Id
  18.     @Column(name = "cpf", unique = true, nullable = false, length = 20)
  19.     private String cpf;
  20.     
  21.     @Column(name = "name", nullable = false, length = 100)
  22.     private String name;
  23.     
  24.     @Column(name = "email", nullable = false, length = 100)
  25.     private String email;
  26.     
  27.     @Column(name = "password",nullable = false, length = 64)
  28.     private String password;
  30.     @Column(name = "phone",nullable = false, length = 20)
  31.     private String phone;
  32.     
  33.     @Column(name = "birth_day", nullable = false, columnDefinition = "DATE")
  34.     private Date birthday;
  35.     
  36.     @Column(nullable = false)
  37.     private boolean fidelity;
  38.     
  39.     // @OneToMany(fetch = FetchType.LAZY, mappedBy = "Client")
  40.     // private List<Reservation> reservations;
  41.     
  42.     public Client() {
  43.         super();
  44.     }
  46.     // 其他 getter 和 setter 方法...
  47. }
  49. // 同样的格式，省略了其他类的内容

但是这个类：

  1. package br.com.negromonte.individualProject.model;
  3. import javax.persistence.Column;
  4. import javax.persistence.Entity;
  5. import javax.persistence.FetchType;
  6. import javax.persistence.ManyToOne;
  7. import javax.persistence.Table;
  9. @Entity
  10. @Table(name = "prices")
  11. public class Prices {
  12.     
  13.     @Column(nullable = false)
  14.     private double weekday;
  15.     
  16.     @Column(nullable = false)
  17.     private double weekend;
  18.     
  19.     @Column(name = "weekday_fidelity", nullable = false)
  20.     private double weekdayFidelity;
  21.     
  22.     @Column(name = "weekend_fidelity",nullable = false)
  23.     private double weekendFidelity;
  24.     
  25.     // @ManyToOne(fetch = FetchType.EAGER, optional = false)
  26.     // private Hotel hotels;
  27.     
  28.     public Prices() {
  29.         super();
  30.     }
  32.     // 其他 getter 和 setter 方法...
  33. }
  35. // 同样的格式，省略了其他类的内容

以及这个类：

  1. package br.com.negromonte.individualProject.model;
  3. import javax.persistence.Column;
  4. import javax.persistence.Entity;
  5. import javax.persistence.FetchType;
  6. import javax.persistence.ManyToOne;
  7. import javax.persistence.Table;
  9. import java.sql.Timestamp;
  11. @Entity
  12. @Table(name = "reservation")
  13. public class Reservation {
  14.     
  15.     @Column(nullable = false, columnDefinition = "DATETIME")
  16.     private Timestamp checkin;
  17.     
  18.     @Column(nullable = false, columnDefinition = "DATETIME")
  19.     private Timestamp checkout;
  20.     
  21.     @Column(name = "dailys_weekday", nullable = false)
  22.     private int dailysWeekday;
  23.     
  24.     @Column(name = "dailys_weekend", nullable = false)
  25.     private int dailysWeekend;
  26.     
  27.     @Column(name = "total_payed", nullable = false)
  28.     private double totalPayed;
  29.     
  30.     @Column(name = "was_fidelity", nullable = false)
  31.     private boolean wasFidelity;
  32.     
  33.     // @ManyToOne(fetch = FetchType.EAGER, optional = false)
  34.     // private Client client;
  35.     
  36.     // @ManyToOne(fetch = FetchType.EAGER, optional = false)
  37.     // private Hotel hotel;
  38.     
  39.     public Reservation() {
  40.         super();
  41.     }
  43.     // 其他 getter 和 setter 方法...
  44. }

没有被创建。当这两个类被取消注释时，没有任何表被创建。有关模型的问题吗？是否有错误的注解？

英文:

I've mapped 4 classes then started up with this console answer:

  1.   .   ____          _            __ _ _
  2.  /\\ / ___&#39;_ __ _ _(_)_ __  __ _ \ \ \ \
  3. ( ( )\___ | &#39;_ | &#39;_| | &#39;_ \/ _` | \ \ \ \
  4.  \\/  ___)| |_)| | | | | || (_| |  ) ) ) )
  5.   &#39;  |____| .__|_| |_|_| |_\__, | / / / /
  6.  =========|_|==============|___/=/_/_/_/
  7.  :: Spring Boot ::        (v2.3.4.RELEASE)
  9. 2020-10-27 11:34:29.432  INFO 6612 --- [           main] b.c.n.i.IndividualProjectApplication     : Starting IndividualProjectApplication on Othon-NoteAMD with PID 6612 (D:\programacao\Qualiti\individualProject\target\classes started by othon in D:\programacao\Qualiti\individualProject)
  10. 2020-10-27 11:34:29.435  INFO 6612 --- [           main] b.c.n.i.IndividualProjectApplication     : No active profile set, falling back to default profiles: default
  11. 2020-10-27 11:34:30.197  INFO 6612 --- [           main] .s.d.r.c.RepositoryConfigurationDelegate : Bootstrapping Spring Data JPA repositories in DEFERRED mode.
  12. 2020-10-27 11:34:30.232  INFO 6612 --- [           main] .s.d.r.c.RepositoryConfigurationDelegate : Finished Spring Data repository scanning in 20ms. Found 0 JPA repository interfaces.
  13. 2020-10-27 11:34:31.420  INFO 6612 --- [           main] o.s.b.w.embedded.tomcat.TomcatWebServer  : Tomcat initialized with port(s): 8080 (http)
  14. 2020-10-27 11:34:31.437  INFO 6612 --- [           main] o.apache.catalina.core.StandardService   : Starting service [Tomcat]
  15. 2020-10-27 11:34:31.437  INFO 6612 --- [           main] org.apache.catalina.core.StandardEngine  : Starting Servlet engine: [Apache Tomcat/9.0.38]
  16. 2020-10-27 11:34:31.604  INFO 6612 --- [           main] o.a.c.c.C.[Tomcat].[localhost].[/]       : Initializing Spring embedded WebApplicationContext
  17. 2020-10-27 11:34:31.604  INFO 6612 --- [           main] w.s.c.ServletWebServerApplicationContext : Root WebApplicationContext: initialization completed in 2110 ms
  18. 2020-10-27 11:34:31.908  INFO 6612 --- [           main] o.s.s.concurrent.ThreadPoolTaskExecutor  : Initializing ExecutorService &#39;applicationTaskExecutor&#39;
  19. 2020-10-27 11:34:31.922  INFO 6612 --- [           main] com.zaxxer.hikari.HikariDataSource       : HikariPool-1 - Starting...
  20. 2020-10-27 11:34:32.942  INFO 6612 --- [           main] com.zaxxer.hikari.HikariDataSource       : HikariPool-1 - Start completed.
  21. 2020-10-27 11:34:32.997  INFO 6612 --- [         task-1] o.hibernate.jpa.internal.util.LogHelper  : HHH000204: Processing PersistenceUnitInfo [name: default]
  22. 2020-10-27 11:34:33.026  WARN 6612 --- [           main] JpaBaseConfiguration$JpaWebConfiguration : spring.jpa.open-in-view is enabled by default. Therefore, database queries may be performed during view rendering. Explicitly configure spring.jpa.open-in-view to disable this warning
  23. 2020-10-27 11:34:33.118  INFO 6612 --- [         task-1] org.hibernate.Version                    : HHH000412: Hibernate ORM core version 5.4.21.Final
  24. 2020-10-27 11:34:33.412  INFO 6612 --- [         task-1] o.hibernate.annotations.common.Version   : HCANN000001: Hibernate Commons Annotations {5.1.0.Final}
  25. 2020-10-27 11:34:33.606  INFO 6612 --- [           main] o.s.b.w.embedded.tomcat.TomcatWebServer  : Tomcat started on port(s): 8080 (http) with context path &#39;&#39;
  26. 2020-10-27 11:34:33.610  INFO 6612 --- [           main] DeferredRepositoryInitializationListener : Triggering deferred initialization of Spring Data repositories…
  27. 2020-10-27 11:34:33.611  INFO 6612 --- [           main] DeferredRepositoryInitializationListener : Spring Data repositories initialized!
  28. 2020-10-27 11:34:33.627  INFO 6612 --- [           main] b.c.n.i.IndividualProjectApplication     : Started IndividualProjectApplication in 4.645 seconds (JVM running for 5.232)
  29. 2020-10-27 11:34:33.670  INFO 6612 --- [         task-1] org.hibernate.dialect.Dialect            : HHH000400: Using dialect: org.hibernate.dialect.MySQL8Dialect

Then I've commented all others classes and started one-by-one,

this was created:

  1. package br.com.negromonte.individualProject.model;
  3. import java.sql.Date;
  4. import java.util.List;
  6. import javax.persistence.Column;
  7. import javax.persistence.Entity;
  8. import javax.persistence.FetchType;
  9. import javax.persistence.Id;
  10. import javax.persistence.OneToMany;
  11. import javax.persistence.Table;
  13. @Entity
  14. @Table(name = &quot;client&quot;)
  15. public class Client {
  16. 	
  17. 	@Id
  18. 	@Column(name = &quot;cpf&quot;, unique = true, nullable = false, length = 20)
  19. 	private String cpf;
  20. 	
  21. 	@Column(name = &quot;name&quot;, nullable = false, length = 100)
  22. 	private String name;
  23. 	
  24. 	@Column(name = &quot;email&quot;, nullable = false, length = 100)
  25. 	private String email;
  26. 	
  27. 	@Column(name = &quot;password&quot;,nullable = false, length = 64)
  28. 	private String password;
  30. 	@Column(name = &quot;phone&quot;,nullable = false, length = 20)
  31. 	private String phone;
  32. 	
  33. 	@Column(name = &quot;birth_day&quot;, nullable = false, columnDefinition = &quot;DATE&quot;)
  34. 	private Date birthday;
  35. 	
  36. 	@Column(nullable = false)
  37. 	private boolean fidelity;
  38. 	
  39. //	@OneToMany(fetch = FetchType.LAZY, mappedBy = &quot;Client&quot;)
  40. //	private List&lt;Reservation&gt; reservations;
  41. 	
  42. 	public Client() {
  43. 		super();
  44. 	}
  46. 	public Client(String cpf, String name, String email, String password, String phone, Date birthday,
  47. 			boolean fidelity) {
  48. 		super();
  49. 		this.cpf = cpf;
  50. 		this.name = name;
  51. 		this.email = email;
  52. 		this.password = password;
  53. 		this.phone = phone;
  54. 		this.birthday = birthday;
  55. 		this.fidelity = fidelity;
  56. 	}
  58. 	public String getCpf() {
  59. 		return cpf;
  60. 	}
  62. 	public void setCpf(String cpf) {
  63. 		this.cpf = cpf;
  64. 	}
  66. 	public String getName() {
  67. 		return name;
  68. 	}
  70. 	public void setName(String name) {
  71. 		this.name = name;
  72. 	}
  74. 	public String getEmail() {
  75. 		return email;
  76. 	}
  78. 	public void setEmail(String email) {
  79. 		this.email = email;
  80. 	}
  82. 	public String getPassword() {
  83. 		return password;
  84. 	}
  86. 	public void setPassword(String password) {
  87. 		this.password = password;
  88. 	}
  90. 	public String getPhone() {
  91. 		return phone;
  92. 	}
  94. 	public void setPhone(String phone) {
  95. 		this.phone = phone;
  96. 	}
  98. 	public Date getBirthday() {
  99. 		return birthday;
  100. 	}
  102. 	public void setBirthday(Date birthday) {
  103. 		this.birthday = birthday;
  104. 	}
  106. 	public boolean isFidelity() {
  107. 		return fidelity;
  108. 	}
  110. 	public void setFidelity(boolean fidelity) {
  111. 		this.fidelity = fidelity;
  112. 	}
  114. //	public List&lt;Reservation&gt; getReservations() {
  115. //		return reservations;
  116. //	}
  117. //
  118. //	public void setReservations(List&lt;Reservation&gt; reservations) {
  119. //		this.reservations = reservations;
  120. //	}
  121. 	
  122. }

then this other too:

  1. package br.com.negromonte.individualProject.model;
  3. import java.util.List;
  5. import javax.persistence.Column;
  6. import javax.persistence.Entity;
  7. import javax.persistence.FetchType;
  8. import javax.persistence.Id;
  9. import javax.persistence.OneToMany;
  10. import javax.persistence.Table;
  12. @Entity
  13. @Table(name = &quot;hotel&quot;)
  14. public class Hotel {
  15. 	
  16. 	@Id
  17. 	@Column(name = &quot;cnpj&quot;, unique = true, nullable = false, length = 20)
  18. 	private String cnpj;
  19. 	
  20. 	// Length not informed once in the db is set to 255
  21. 	@Column(name = &quot;name&quot;, nullable = false)
  22. 	private String name;
  23. 	
  24. 	@Column(name = &quot;email&quot;, nullable = false, length = 100)
  25. 	private String email;
  26. 	
  27. 	@Column(name = &quot;phone&quot;, nullable = false, length = 20)
  28. 	private String phone;
  29. 	
  30. 	@Column(nullable = false)
  31. 	private double rating;
  32. 	
  33. //	@OneToMany(fetch = FetchType.LAZY, mappedBy = &quot;Hotel&quot;)
  34. //	private List&lt;Reservation&gt; reservations;
  35. //	
  36. //	@OneToMany(fetch = FetchType.LAZY, mappedBy = &quot;Hotel&quot;)
  37. //	private List&lt;Prices&gt; prices;
  38. 	
  39. 	public Hotel() {
  40. 		super();
  41. 	}
  43. 	public Hotel(String cnpj, String name, String email, String phone, double rating) {
  44. 		super();
  45. 		this.cnpj = cnpj;
  46. 		this.name = name;
  47. 		this.email = email;
  48. 		this.phone = phone;
  49. 		this.rating = rating;
  50. 	}
  52. 	public String getCnpj() {
  53. 		return cnpj;
  54. 	}
  56. 	public void setCnpj(String cnpj) {
  57. 		this.cnpj = cnpj;
  58. 	}
  60. 	public String getName() {
  61. 		return name;
  62. 	}
  64. 	public void setName(String name) {
  65. 		this.name = name;
  66. 	}
  68. 	public String getEmail() {
  69. 		return email;
  70. 	}
  72. 	public void setEmail(String email) {
  73. 		this.email = email;
  74. 	}
  76. 	public String getPhone() {
  77. 		return phone;
  78. 	}
  80. 	public void setPhone(String phone) {
  81. 		this.phone = phone;
  82. 	}
  84. 	public double getRating() {
  85. 		return rating;
  86. 	}
  88. 	public void setRating(double rating) {
  89. 		this.rating = rating;
  90. 	}
  92. //	public List&lt;Reservation&gt; getReservations() {
  93. //		return reservations;
  94. //	}
  95. //
  96. //	public void setReservations(List&lt;Reservation&gt; reservations) {
  97. //		this.reservations = reservations;
  98. //	}
  99. //
  100. //	public List&lt;Prices&gt; getPrices() {
  101. //		return prices;
  102. //	}
  103. //
  104. //	public void setPrices(List&lt;Prices&gt; prices) {
  105. //		this.prices = prices;
  106. //	}
  107. 	
  108. 	
  109. 	
  110. 	
  111. }

but this:

  1. package br.com.negromonte.individualProject.model;
  3. import javax.persistence.Column;
  4. import javax.persistence.Entity;
  5. import javax.persistence.FetchType;
  6. import javax.persistence.ManyToOne;
  7. import javax.persistence.Table;
  9. @Entity
  10. @Table(name = &quot;prices&quot;)
  11. public class Prices {
  12. 	
  13. 	@Column(nullable = false)
  14. 	private double weekday;
  15. 	
  16. 	@Column(nullable = false)
  17. 	private double weekend;
  18. 	
  19. 	@Column(name = &quot;weekday_fidelity&quot;, nullable = false)
  20. 	private double weekdayFidelity;
  21. 	
  22. 	@Column(name = &quot;weekend_fidelity&quot;,nullable = false)
  23. 	private double weekendFidelity;
  24. 	
  25. //	@ManyToOne(fetch = FetchType.EAGER, optional = false)
  26. //	private Hotel hotels;
  27. 	
  28. 	public Prices() {
  29. 		super();
  30. 	}
  32. 	public Prices(double weekday, double weekend, double weekdayFidelity, double weekendFidelity) {
  33. 		super();
  34. 		this.weekday = weekday;
  35. 		this.weekend = weekend;
  36. 		this.weekdayFidelity = weekdayFidelity;
  37. 		this.weekendFidelity = weekendFidelity;
  38. 	}
  40. 	public double getWeekday() {
  41. 		return weekday;
  42. 	}
  44. 	public void setWeekday(double weekday) {
  45. 		this.weekday = weekday;
  46. 	}
  48. 	public double getWeekend() {
  49. 		return weekend;
  50. 	}
  52. 	public void setWeekend(double weekend) {
  53. 		this.weekend = weekend;
  54. 	}
  56. 	public double getWeekday_fidelity() {
  57. 		return weekdayFidelity;
  58. 	}
  60. 	public void setWeekday_fidelity(double weekdayFidelity) {
  61. 		this.weekdayFidelity = weekdayFidelity;
  62. 	}
  64. 	public double getWeekend_fidelity() {
  65. 		return weekendFidelity;
  66. 	}
  68. 	public void setWeekend_fidelity(double weekendFidelity) {
  69. 		this.weekendFidelity = weekendFidelity;
  70. 	}
  72. //	public Hotel getHotels() {
  73. //		return hotels;
  74. //	}
  75. //
  76. //	public void setHotels(Hotel hotels) {
  77. //		this.hotels = hotels;
  78. //	}
  80. }

and this:

  1. package br.com.negromonte.individualProject.model;
  3. import javax.persistence.Column;
  4. import javax.persistence.Entity;
  5. import javax.persistence.FetchType;
  6. import javax.persistence.ManyToOne;
  7. import javax.persistence.Table;
  9. import java.sql.Timestamp;
  11. @Entity
  12. @Table(name = &quot;reservation&quot;)
  13. public class Reservation {
  14. 	
  15. 	@Column(nullable = false, columnDefinition = &quot;DATETIME&quot;)
  16. 	private Timestamp checkin;
  17. 	
  18. 	@Column(nullable = false, columnDefinition = &quot;DATETIME&quot;)
  19. 	private Timestamp checkout;
  20. 	
  21. 	@Column(name = &quot;dailys_weekday&quot;, nullable = false)
  22. 	private int dailysWeekday;
  23. 	
  24. 	@Column(name = &quot;dailys_weekend&quot;, nullable = false)
  25. 	private int dailysWeekend;
  26. 	
  27. 	@Column(name = &quot;total_payed&quot;, nullable = false)
  28. 	private double totalPayed;
  29. 	
  30. 	@Column(name = &quot;was_fidelity&quot;, nullable = false)
  31. 	private boolean wasFidelity;
  32. 	
  33. //	@ManyToOne(fetch = FetchType.EAGER, optional = false)
  34. //	private Client client;
  35. 	
  36. //	@ManyToOne(fetch = FetchType.EAGER, optional = false)
  37. //	private Hotel hotel;
  38. 	
  39. 	public Reservation() {
  40. 		super();
  41. 	}
  43. 	public Reservation(Timestamp checkin, Timestamp checkout, int dailysWeekday, int dailysWeekend, double totalPayed,
  44. 			boolean wasFidelity) {
  45. 		super();
  46. 		this.checkin = checkin;
  47. 		this.checkout = checkout;
  48. 		this.dailysWeekday = dailysWeekday;
  49. 		this.dailysWeekend = dailysWeekend;
  50. 		this.totalPayed = totalPayed;
  51. 		this.wasFidelity = wasFidelity;
  52. 	}
  54. 	public Timestamp getCheckin() {
  55. 		return checkin;
  56. 	}
  58. 	public void setCheckin(Timestamp checkin) {
  59. 		this.checkin = checkin;
  60. 	}
  62. 	public Timestamp getCheckout() {
  63. 		return checkout;
  64. 	}
  66. 	public void setCheckout(Timestamp checkout) {
  67. 		this.checkout = checkout;
  68. 	}
  70. 	public int getDailysWeekday() {
  71. 		return dailysWeekday;
  72. 	}
  74. 	public void setDailysWeekday(int dailysWeekday) {
  75. 		this.dailysWeekday = dailysWeekday;
  76. 	}
  78. 	public int getDailysWeekend() {
  79. 		return dailysWeekend;
  80. 	}
  82. 	public void setDailysWeekend(int dailysWeekend) {
  83. 		this.dailysWeekend = dailysWeekend;
  84. 	}
  86. 	public double getTotalPayed() {
  87. 		return totalPayed;
  88. 	}
  90. 	public void setTotalPayed(double totalPayed) {
  91. 		this.totalPayed = totalPayed;
  92. 	}
  94. 	public boolean isWasFidelity() {
  95. 		return wasFidelity;
  96. 	}
  98. 	public void setWasFidelity(boolean wasFidelity) {
  99. 		this.wasFidelity = wasFidelity;
  100. 	}
  102. //	public Client getClient() {
  103. //		return client;
  104. //	}
  105. //
  106. //	public void setClient(Client client) {
  107. //		this.client = client;
  108. //	}
  109. //
  110. //	public Hotel getHotel() {
  111. //		return hotel;
  112. //	}
  113. //
  114. //	public void setHotel(Hotel hotel) {
  115. //		this.hotel = hotel;
  116. //	}
  117. }

did not get created.
here the output when creation works:

  1.   .   ____          _            __ _ _
  2.  /\\ / ___&#39;_ __ _ _(_)_ __  __ _ \ \ \ \
  3. ( ( )\___ | &#39;_ | &#39;_| | &#39;_ \/ _` | \ \ \ \
  4.  \\/  ___)| |_)| | | | | || (_| |  ) ) ) )
  5.   &#39;  |____| .__|_| |_|_| |_\__, | / / / /
  6.  =========|_|==============|___/=/_/_/_/
  7.  :: Spring Boot ::        (v2.3.4.RELEASE)
  9. 2020-10-27 11:41:25.213  INFO 8904 --- [           main] b.c.n.i.IndividualProjectApplication     : Starting IndividualProjectApplication on Othon-NoteAMD with PID 8904 (D:\programacao\Qualiti\individualProject\target\classes started by othon in D:\programacao\Qualiti\individualProject)
  10. 2020-10-27 11:41:25.217  INFO 8904 --- [           main] b.c.n.i.IndividualProjectApplication     : No active profile set, falling back to default profiles: default
  11. 2020-10-27 11:41:26.016  INFO 8904 --- [           main] .s.d.r.c.RepositoryConfigurationDelegate : Bootstrapping Spring Data JPA repositories in DEFERRED mode.
  12. 2020-10-27 11:41:26.051  INFO 8904 --- [           main] .s.d.r.c.RepositoryConfigurationDelegate : Finished Spring Data repository scanning in 20ms. Found 0 JPA repository interfaces.
  13. 2020-10-27 11:41:27.272  INFO 8904 --- [           main] o.s.b.w.embedded.tomcat.TomcatWebServer  : Tomcat initialized with port(s): 8080 (http)
  14. 2020-10-27 11:41:27.290  INFO 8904 --- [           main] o.apache.catalina.core.StandardService   : Starting service [Tomcat]
  15. 2020-10-27 11:41:27.291  INFO 8904 --- [           main] org.apache.catalina.core.StandardEngine  : Starting Servlet engine: [Apache Tomcat/9.0.38]
  16. 2020-10-27 11:41:27.422  INFO 8904 --- [           main] o.a.c.c.C.[Tomcat].[localhost].[/]       : Initializing Spring embedded WebApplicationContext
  17. 2020-10-27 11:41:27.423  INFO 8904 --- [           main] w.s.c.ServletWebServerApplicationContext : Root WebApplicationContext: initialization completed in 2139 ms
  18. 2020-10-27 11:41:27.724  INFO 8904 --- [           main] o.s.s.concurrent.ThreadPoolTaskExecutor  : Initializing ExecutorService &#39;applicationTaskExecutor&#39;
  19. 2020-10-27 11:41:27.746  INFO 8904 --- [           main] com.zaxxer.hikari.HikariDataSource       : HikariPool-1 - Starting...
  20. 2020-10-27 11:41:28.695  INFO 8904 --- [           main] com.zaxxer.hikari.HikariDataSource       : HikariPool-1 - Start completed.
  21. 2020-10-27 11:41:28.754  INFO 8904 --- [         task-1] o.hibernate.jpa.internal.util.LogHelper  : HHH000204: Processing PersistenceUnitInfo [name: default]
  22. 2020-10-27 11:41:28.780  WARN 8904 --- [           main] JpaBaseConfiguration$JpaWebConfiguration : spring.jpa.open-in-view is enabled by default. Therefore, database queries may be performed during view rendering. Explicitly configure spring.jpa.open-in-view to disable this warning
  23. 2020-10-27 11:41:28.857  INFO 8904 --- [         task-1] org.hibernate.Version                    : HHH000412: Hibernate ORM core version 5.4.21.Final
  24. 2020-10-27 11:41:29.135  INFO 8904 --- [         task-1] o.hibernate.annotations.common.Version   : HCANN000001: Hibernate Commons Annotations {5.1.0.Final}
  25. 2020-10-27 11:41:29.342  INFO 8904 --- [           main] o.s.b.w.embedded.tomcat.TomcatWebServer  : Tomcat started on port(s): 8080 (http) with context path &#39;&#39;
  26. 2020-10-27 11:41:29.345  INFO 8904 --- [           main] DeferredRepositoryInitializationListener : Triggering deferred initialization of Spring Data repositories…
  27. 2020-10-27 11:41:29.346  INFO 8904 --- [           main] DeferredRepositoryInitializationListener : Spring Data repositories initialized!
  28. 2020-10-27 11:41:29.362  INFO 8904 --- [           main] b.c.n.i.IndividualProjectApplication     : Started IndividualProjectApplication in 4.646 seconds (JVM running for 5.185)
  29. 2020-10-27 11:41:29.375  INFO 8904 --- [         task-1] org.hibernate.dialect.Dialect            : HHH000400: Using dialect: org.hibernate.dialect.MySQL8Dialect
  30. Hibernate: create table client (cpf varchar(20) not null, birth_day DATE not null, email varchar(100) not null, fidelity bit not null, name varchar(100) not null, password varchar(64) not null, phone varchar(20) not null, primary key (cpf)) engine=InnoDB
  31. Hibernate: create table hotel (cnpj varchar(20) not null, email varchar(100) not null, name varchar(255) not null, phone varchar(20) not null, rating double precision not null, primary key (cnpj)) engine=InnoDB
  32. 2020-10-27 11:41:32.030  INFO 8904 --- [         task-1] o.h.e.t.j.p.i.JtaPlatformInitiator       : HHH000490: Using JtaPlatform implementation: [org.hibernate.engine.transaction.jta.platform.internal.NoJtaPlatform]
  33. 2020-10-27 11:41:32.040  INFO 8904 --- [         task-1] j.LocalContainerEntityManagerFactoryBean : Initialized JPA EntityManagerFactory for persistence unit &#39;default&#39;

to have success on creation I have to comment Prices.java and Reservation.java which doesn't let any tables to be created when uncommented, is there a problem with my modeling? any wrong annotation?

答案1

得分: 0

你需要将 @Id 注解添加到与已成功创建的表类似的 id 字段上。

根据 JPA 2 规范（2.4 主键和实体标识），该类必须具有唯一的 ID。

英文:

You need to add an @Id annotation to the id field similar to the successfully created tables.

In accordance with the JPA 2 specification (2.4 Primary Keys and Entity Identity), the class must have a unique ID.

huangapple
  • 本文由 发表于 2020年10月27日 22:47:38
  • 转载请务必保留本文链接：https://go.coder-hub.com/64556927.html
  • java
  • spring
  • spring-boot
匿名

发表评论

匿名网友

:?: :razz: :sad: :evil: :!: :smile: :oops: :grin: :eek: :shock: :???: :cool: :lol: :mad: :twisted: :roll: :wink: :idea: :arrow: :neutral: :cry: :mrgreen:

确定