在启动Spring Boot应用程序后,MySQL数据库中未创建表格。

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

Table not created in MySql DB after starting Spring Boot application

问题

项目使用了MySQL数据库和Open Server。以下是我的application.properties文件:

  1. spring.jpa.hibernate.ddl-auto=update
  2. spring.datasource.url=jdbc:mysql://${MYSQL_HOST:localhost}:8888/citatnik_bd
  3. spring.datasource.username=root
  4. spring.datasource.password=
  5. spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver
  6. #spring.jpa.show-sql: true

这是我的实体类:

  1. import javax.persistence.*;
  2. @Entity
  3. @Table(name="Quotes")
  4. public class Quotes {
  5. @Id
  6. @GeneratedValue(strategy = GenerationType.AUTO)
  7. private Long ID;
  8. private String ru, by, ua, en;
  9. public Long GetID() { return ID; }
  10. public void SetID(Long ID) { this.ID = ID; }
  11. public String GetBy() { return by; }
  12. public void SetBy(String by) { this.by = by; }
  13. public String GetRu() { return ru; }
  14. public void SetRu(String ru) { this.ru = ru; }
  15. public String GetUa() { return ua; }
  16. public void SetUa(String ua) { this.ua = ua; }
  17. public String GetEn() { return en; }
  18. public void SetEn(String en) { this.by = en; }
  19. }

顺便提一下,pom.xml文件中的所有必要依赖项都正确注册:

  1. <?xml version="1.0" encoding="UTF-8"?>
  2. <project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  3. xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 https://maven.apache.org/xsd/maven-4.0.0.xsd">
  4. <modelVersion>4.0.0</modelVersion>
  5. <parent>
  6. <groupId>org.springframework.boot</groupId>
  7. <artifactId>spring-boot-starter-parent</artifactId>
  8. <version>3.1.2</version>
  9. <relativePath/> <!-- lookup parent from repository -->
  10. </parent>
  11. <groupId>com.Citatnik</groupId>
  12. <artifactId>Citatnik</artifactId>
  13. <version>0.0.1-SNAPSHOT</version>
  14. <name>Citatnik</name>
  15. <description>Citatnik project</description>
  16. <properties>
  17. <java.version>17</java.version>
  18. </properties>
  19. <dependencies>
  20. <dependency>
  21. <groupId>org.springframework.boot</groupId>
  22. <artifactId>spring-boot-starter-thymeleaf</artifactId>
  23. </dependency>
  24. <dependency>
  25. <groupId>org.springframework.boot</groupId>
  26. <artifactId>spring-boot-starter-web</artifactId>
  27. </dependency>
  28. <dependency>
  29. <groupId>org.springframework.boot</groupId>
  30. <artifactId>spring-boot-starter-data-jpa</artifactId>
  31. </dependency>
  32. <dependency>
  33. <groupId>mysql</groupId>
  34. <artifactId>mysql-connector-java</artifactId>
  35. <scope>runtime</scope>
  36. <version>8.0.30</version>
  37. </dependency>
  38. <dependency>
  39. <groupId>javax.persistence</groupId>
  40. <artifactId>javax.persistence-api</artifactId>
  41. <version>2.2</version>
  42. </dependency>
  43. <dependency>
  44. <groupId>org.springframework.boot</groupId>
  45. <artifactId>spring-boot-devtools</artifactId>
  46. <scope>runtime</scope>
  47. <optional>true</optional>
  48. </dependency>
  49. <dependency>
  50. <groupId>org.springframework.boot</groupId>
  51. <artifactId>spring-boot-starter-test</artifactId>
  52. <scope>test</scope>
  53. <exclusions>
  54. <exclusion>
  55. <groupId>org.junit.vintage</groupId>
  56. <artifactId>junit-vintage-engine</artifactId>
  57. </exclusion>
  58. </exclusions>
  59. </dependency>
  60. </dependencies>
  61. <build>
  62. <plugins>
  63. <plugin>
  64. <groupId>org.springframework.boot</groupId>
  65. <artifactId>spring-boot-maven-plugin</artifactId>
  66. </plugin>
  67. </plugins>
  68. </build>
  69. </project>

这是Spring应用程序的日志输出:

  1. :: Spring Boot :: (v3.1.2)
  2. 2023-07-31T19:01:34.457+03:00 INFO 3336 --- [ restartedMain] c.Citatnik.Citatnik.CitatnikApplication : Starting CitatnikApplication using Java 17.0.6 with PID 3336 (C:\Users\dddry\OneDrive\Рабочий столитатник\Citatnik\target\classes started by dddry in C:\Users\dddry\OneDrive\Рабочий столитатник\Citatnik)
  3. 2023-07-31T19:01:34.461+03:00 INFO 3336 --- [ restartedMain] c.Citatnik.Citatnik.CitatnikApplication : No active profile set, falling back to 1 default profile: "default"
  4. 2023-07-31T19:01:34.539+03:00 INFO 3336 --- [ restartedMain] .e.DevToolsPropertyDefaultsPostProcessor : Devtools property defaults active! Set 'spring.devtools.add-properties' to 'false' to disable
  5. 2023-07-31T19:01:34.539+03:00 INFO 3336 --- [ restartedMain] .e.DevToolsPropertyDefaultsPostProcessor : For additional web related logging consider setting the 'logging.level.web' property to 'DEBUG'
  6. 2023-07-31T19:01:35.213+03:00 INFO 3336 --- [ restartedMain] .s.d.r.c.RepositoryConfigurationDelegate : Bootstrapping Spring Data JPA repositories in DEFAULT mode.
  7. 2023-07-31T19:01:35.232+03:00 INFO 3336 --- [ restartedMain] .s.d.r.c.RepositoryConfigurationDelegate : Finished Spring Data repository scanning in 11 ms. Found 0 JPA repository interfaces.
  8. 2023-07-31T19:01:35.866+03:00 INFO 3336 --- [ restartedMain] o.s.b.w.embedded.tomcat.TomcatWebServer : Tomcat initialized with port(s): 8080 (http)
  9. 2023-07-31T19:01:35.876+03:00 INFO 3336 --- [ restartedMain] o.apache.catalina.core.StandardService : Starting service [Tomcat]
  10. 2023-07-31T19:01:35.876+03:00 INFO 3336 --- [ restartedMain] o.apache.catalina.core.StandardEngine : Starting Servlet engine: [Apache Tomcat/10.1.11]
  11. 2023-07-31T19:01:35.945+03:00 INFO 3336 ---
  12. <details>
  13. <summary>英文:</summary>
  14. The project uses a database MySql, Open Server. Here is my application.properties file:

spring.jpa.hibernate.ddl-auto=update
spring.datasource.url=jdbc:mysql://${MYSQL_HOST:localhost}:8888/citatnik_bd
spring.datasource.username=root
spring.datasource.password=
spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver
#spring.jpa.show-sql: true

  1. Here is my entity:

import javax.persistence.*;

@Entity
@Table(name="Quotes")
public class Quotes {

  1. @Id
  2. @GeneratedValue(strategy = GenerationType.AUTO)
  3. private Long ID;
  4. private String ru, by, ua, en;
  5. public Long GetID() { return ID; }
  6. public void SetID(Long ID) { this.ID = ID; }
  7. public String GetBy() { return by; }
  8. public void SetBy(String by) { this.by = by; }
  9. public String GetRu() { return ru; }
  10. public void SetRu(String ru) { this.ru = ru; }
  11. public String GetUa() { return ua; }
  12. public void SetUa(String ua) { this.ua = ua; }
  13. public String GetEn() { return en; }
  14. public void SetEn(String en) { this.by = en; }

}

  1. By the way, everything is fine in the pom.xml file, all the necessary dependencies are registered:

<?xml version="1.0" encoding="UTF-8"?>
<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 https://maven.apache.org/xsd/maven-4.0.0.xsd&quot;>
<modelVersion>4.0.0</modelVersion>
<parent>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-parent</artifactId>
<version>3.1.2</version>
<relativePath/> <!-- lookup parent from repository -->
</parent>
<groupId>com.Citatnik</groupId>
<artifactId>Citatnik</artifactId>
<version>0.0.1-SNAPSHOT</version>
<name>Citatnik</name>
<description>Citatnik project</description>
<properties>
<java.version>17</java.version>
</properties>

  1. &lt;dependencies&gt;
  2. &lt;dependency&gt;
  3. &lt;groupId&gt;org.springframework.boot&lt;/groupId&gt;
  4. &lt;artifactId&gt;spring-boot-starter-thymeleaf&lt;/artifactId&gt;
  5. &lt;/dependency&gt;
  6. &lt;dependency&gt;
  7. &lt;groupId&gt;org.springframework.boot&lt;/groupId&gt;
  8. &lt;artifactId&gt;spring-boot-starter-web&lt;/artifactId&gt;
  9. &lt;/dependency&gt;
  10. &lt;dependency&gt;
  11. &lt;groupId&gt;org.springframework.boot&lt;/groupId&gt;
  12. &lt;artifactId&gt;spring-boot-starter-data-jpa&lt;/artifactId&gt;
  13. &lt;/dependency&gt;
  14. &lt;dependency&gt;
  15. &lt;groupId&gt;mysql&lt;/groupId&gt;
  16. &lt;artifactId&gt;mysql-connector-java&lt;/artifactId&gt;
  17. &lt;scope&gt;runtime&lt;/scope&gt;
  18. &lt;version&gt;8.0.30&lt;/version&gt;
  19. &lt;/dependency&gt;
  20. &lt;dependency&gt;
  21. &lt;groupId&gt;javax.persistence&lt;/groupId&gt;
  22. &lt;artifactId&gt;javax.persistence-api&lt;/artifactId&gt;
  23. &lt;version&gt;2.2&lt;/version&gt;
  24. &lt;/dependency&gt;
  25. &lt;dependency&gt;
  26. &lt;groupId&gt;org.springframework.boot&lt;/groupId&gt;
  27. &lt;artifactId&gt;spring-boot-devtools&lt;/artifactId&gt;
  28. &lt;scope&gt;runtime&lt;/scope&gt;
  29. &lt;optional&gt;true&lt;/optional&gt;
  30. &lt;/dependency&gt;
  31. &lt;dependency&gt;
  32. &lt;groupId&gt;org.springframework.boot&lt;/groupId&gt;
  33. &lt;artifactId&gt;spring-boot-starter-test&lt;/artifactId&gt;
  34. &lt;scope&gt;test&lt;/scope&gt;
  35. &lt;exclusions&gt;
  36. &lt;exclusion&gt;
  37. &lt;groupId&gt;org.junit.vintage&lt;/groupId&gt;
  38. &lt;artifactId&gt;junit-vintage-engine&lt;/artifactId&gt;
  39. &lt;/exclusion&gt;
  40. &lt;/exclusions&gt;
  41. &lt;/dependency&gt;
  42. &lt;/dependencies&gt;
  43. &lt;build&gt;
  44. &lt;plugins&gt;
  45. &lt;plugin&gt;
  46. &lt;groupId&gt;org.springframework.boot&lt;/groupId&gt;
  47. &lt;artifactId&gt;spring-boot-maven-plugin&lt;/artifactId&gt;
  48. &lt;/plugin&gt;
  49. &lt;/plugins&gt;
  50. &lt;/build&gt;

</project>

  1. Here is logging out from Spring application:

:: Spring Boot :: (v3.1.2)

2023-07-31T19:01:34.457+03:00 INFO 3336 --- [ restartedMain] c.Citatnik.Citatnik.CitatnikApplication : Starting CitatnikApplication using Java 17.0.6 with PID 3336 (C:\Users\dddry\OneDrive\Рабочий стол\Цитатник\Citatnik\target\classes started by dddry in C:\Users\dddry\OneDrive\Рабочий стол\Цитатник\Citatnik)
2023-07-31T19:01:34.461+03:00 INFO 3336 --- [ restartedMain] c.Citatnik.Citatnik.CitatnikApplication : No active profile set, falling back to 1 default profile: "default"
2023-07-31T19:01:34.539+03:00 INFO 3336 --- [ restartedMain] .e.DevToolsPropertyDefaultsPostProcessor : Devtools property defaults active! Set 'spring.devtools.add-properties' to 'false' to disable
2023-07-31T19:01:34.539+03:00 INFO 3336 --- [ restartedMain] .e.DevToolsPropertyDefaultsPostProcessor : For additional web related logging consider setting the 'logging.level.web' property to 'DEBUG'
2023-07-31T19:01:35.213+03:00 INFO 3336 --- [ restartedMain] .s.d.r.c.RepositoryConfigurationDelegate : Bootstrapping Spring Data JPA repositories in DEFAULT mode.
2023-07-31T19:01:35.232+03:00 INFO 3336 --- [ restartedMain] .s.d.r.c.RepositoryConfigurationDelegate : Finished Spring Data repository scanning in 11 ms. Found 0 JPA repository interfaces.
2023-07-31T19:01:35.866+03:00 INFO 3336 --- [ restartedMain] o.s.b.w.embedded.tomcat.TomcatWebServer : Tomcat initialized with port(s): 8080 (http)
2023-07-31T19:01:35.876+03:00 INFO 3336 --- [ restartedMain] o.apache.catalina.core.StandardService : Starting service [Tomcat]
2023-07-31T19:01:35.876+03:00 INFO 3336 --- [ restartedMain] o.apache.catalina.core.StandardEngine : Starting Servlet engine: [Apache Tomcat/10.1.11]
2023-07-31T19:01:35.945+03:00 INFO 3336 --- [ restartedMain] o.a.c.c.C.[Tomcat].[localhost].[/] : Initializing Spring embedded WebApplicationContext
2023-07-31T19:01:35.946+03:00 INFO 3336 --- [ restartedMain] w.s.c.ServletWebServerApplicationContext : Root WebApplicationContext: initialization completed in 1405 ms
2023-07-31T19:01:36.094+03:00 INFO 3336 --- [ restartedMain] o.hibernate.jpa.internal.util.LogHelper : HHH000204: Processing PersistenceUnitInfo [name: default]
2023-07-31T19:01:36.148+03:00 INFO 3336 --- [ restartedMain] org.hibernate.Version : HHH000412: Hibernate ORM core version 6.2.6.Final
2023-07-31T19:01:36.149+03:00 INFO 3336 --- [ restartedMain] org.hibernate.cfg.Environment : HHH000406: Using bytecode reflection optimizer
2023-07-31T19:01:36.272+03:00 INFO 3336 --- [ restartedMain] o.h.b.i.BytecodeProviderInitiator : HHH000021: Bytecode provider name : bytebuddy
2023-07-31T19:01:36.396+03:00 INFO 3336 --- [ restartedMain] o.s.o.j.p.SpringPersistenceUnitInfo : No LoadTimeWeaver setup: ignoring JPA class transformer
2023-07-31T19:01:36.409+03:00 INFO 3336 --- [ restartedMain] com.zaxxer.hikari.HikariDataSource : HikariPool-1 - Starting...
2023-07-31T19:01:36.664+03:00 INFO 3336 --- [ restartedMain] com.zaxxer.hikari.pool.HikariPool : HikariPool-1 - Added connection com.mysql.cj.jdbc.ConnectionImpl@41c02a96
2023-07-31T19:01:36.666+03:00 INFO 3336 --- [ restartedMain] com.zaxxer.hikari.HikariDataSource : HikariPool-1 - Start completed.
2023-07-31T19:01:36.824+03:00 INFO 3336 --- [ restartedMain] o.h.b.i.BytecodeProviderInitiator : HHH000021: Bytecode provider name : bytebuddy
2023-07-31T19:01:37.044+03:00 INFO 3336 --- [ restartedMain] o.h.e.t.j.p.i.JtaPlatformInitiator : HHH000490: Using JtaPlatform implementation: [org.hibernate.engine.transaction.jta.platform.internal.NoJtaPlatform]
2023-07-31T19:01:37.048+03:00 INFO 3336 --- [ restartedMain] j.LocalContainerEntityManagerFactoryBean : Initialized JPA EntityManagerFactory for persistence unit 'default'
2023-07-31T19:01:37.094+03:00 WARN 3336 --- [ restartedMain] 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
2023-07-31T19:01:37.542+03:00 INFO 3336 --- [ restartedMain] o.s.b.d.a.OptionalLiveReloadServer : LiveReload server is running on port 35729
2023-07-31T19:01:37.574+03:00 INFO 3336 --- [ restartedMain] o.s.b.w.embedded.tomcat.TomcatWebServer : Tomcat started on port(s): 8080 (http) with context path ''
2023-07-31T19:01:37.585+03:00 INFO 3336 --- [ restartedMain] c.Citatnik.Citatnik.CitatnikApplication : Started CitatnikApplication in 3.679 seconds (process running for 4.084)

  1. I checked the port, database name, username and password - everything is correct. However, when I run the application and go to phpMyAdmin, I see a message that no tables were found in the database. What could be the issue here?
  2. </details>
  3. # 答案1
  4. **得分**: 1
  5. 你正在使用spring-boot 3.1.2,这意味着你应该将你的
  6. import javax.persistence.*;
  7. 替换为
  8. import jakarta.persistence.*;
  9. 关于你的Maven依赖,你应该移除这个
  10. <dependency>
  11. <groupId>javax.persistence</groupId>
  12. <artifactId>javax.persistence-api</artifactId>
  13. <version>2.2</version>
  14. </dependency>
  15. 因为你使用了
  16. spring-boot-starter-data-jpa
  17. 它依赖于HibernateHibernate然后依赖于jakarta.persistence API,使其类可用于你的应用程序代码。
  18. 关于你的问题,应用程序启动后你看不到表格。
  19. 只需尝试替换应用程序属性参数
  20. spring.jpa.hibernate.ddl-auto=create
  21. 在首次运行应用程序后,将其替换为 `update`
  22. <details>
  23. <summary>英文:</summary>
  24. Your are using spring-boot 3.1.2, it mean you should replace your
  25. import javax.persistence.*;
  26. with
  27. import jakarta.persistence.*;
  28. About your maven dependency you should to remove this one
  29. &lt;dependency&gt;
  30. &lt;groupId&gt;javax.persistence&lt;/groupId&gt;
  31. &lt;artifactId&gt;javax.persistence-api&lt;/artifactId&gt;
  32. &lt;version&gt;2.2&lt;/version&gt;
  33. &lt;/dependency&gt;
  34. because you use
  35. spring-boot-starter-data-jpa
  36. it has dependencies on Hibernate. Hibernate then has a dependency on the jakarta.persistence API which makes its classes available to your application&#39;s code.
  37. About your problem, you don&#39;t see the tables after application start.
  38. Just try to replace an application properties param
  39. spring.jpa.hibernate.ddl-auto=create
  40. And after first run of application
  41. replace with `update`
  42. </details>

huangapple
  • 本文由 发表于 2023年7月31日 23:49:53
  • 转载请务必保留本文链接:https://go.coder-hub.com/76805217.html
匿名

发表评论

匿名网友

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

确定