Flyway не создает таблицы при запуске приложенияJAVA

Программисты JAVA общаются здесь
Ответить
Anonymous
 Flyway не создает таблицы при запуске приложения

Сообщение Anonymous »

Я настроил свое приложение Spring для взаимодействия с Flyway для миграции данных, но Flyway, похоже, не работает. Мой файл application.properties находится в пакете ресурсов
spring.application.name=com.codefinity.firstrestapiooks

spring.flyway.url=jdbc:mysql://localhost:3306/my_database
spring.flyway.user=root
spring.flyway.password=1234

spring.datasource.url=jdbc:mysql://localhost:3306/my_database
spring.datasource.username=root
spring.datasource.password=1234
spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver

spring.flyway.locations=classpath:db/migration


мой pom.xml имеет все правильные зависимости

xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 https://maven.apache.org/xsd/maven-4.0.0.xsd">
4.0.0

org.springframework.boot
spring-boot-starter-parent
4.0.6


org.codefinity
first-rest-api-books
0.0.1-SNAPSHOT
com.codefinity.firstrestapiooks
com.codefinity.firstrestapiooks














25



org.springframework.boot
spring-boot-starter-webmvc
4.1.0-RC1
compile



org.springdoc
springdoc-openapi-starter-webmvc-ui
3.0.3
compile



org.springframework.boot
spring-boot-starter-data-jpa
4.1.0-RC1
compile


org.springframework.boot
spring-boot-starter-webmvc-test
4.1.0-RC1
test



com.mysql
mysql-connector-j
9.7.0
compile



org.modelmapper
modelmapper
3.2.6
compile


org.flywaydb
flyway-mysql
12.4.0
compile


org.flywaydb
flyway-core
12.4.0
compile



org.projectlombok
lombok
1.18.46
compile







org.springframework.boot
spring-boot-maven-plugin






и мой файл таблицы .sql находится в пакете db.migration. Он называется v1__create_table_books.sql
CREATE TABLE books (
id VARCHAR(255) PRIMARY KEY,
name VARCHAR(255) NOT NULL,
author VARCHAR(255),
price DECIMAL(10, 2)
);

Поэтому я не знаю, почему таблица не создается, если все правильно.
Я не уверен, где Flyway будет хранить журналы, но это мой журнал консоли
:: Spring Boot :: (v4.0.6)

2026-04-28T18:14:31.215-05:00 INFO 25776 --- [com.codefinity.firstrestapiooks] [ main] o.c.c.c.firstrestapibooks.Application : Starting Application using Java 25.0.2 with PID 25776 (C:\Users\johnr\IdeaProjects\com.codefinity.firstrestapiooks\target\classes started by johnr in C:\Users\johnr\IdeaProjects\com.codefinity.firstrestapiooks)
2026-04-28T18:14:31.222-05:00 INFO 25776 --- [com.codefinity.firstrestapiooks] [ main] o.c.c.c.firstrestapibooks.Application : No active profile set, falling back to 1 default profile: "default"
2026-04-28T18:14:32.937-05:00 INFO 25776 --- [com.codefinity.firstrestapiooks] [ main] .s.d.r.c.RepositoryConfigurationDelegate : Bootstrapping Spring Data JPA repositories in DEFAULT mode.
2026-04-28T18:14:32.979-05:00 INFO 25776 --- [com.codefinity.firstrestapiooks] [ main] .s.d.r.c.RepositoryConfigurationDelegate : Finished Spring Data repository scanning in 26 ms. Found 0 JPA repository interfaces.
2026-04-28T18:14:33.897-05:00 INFO 25776 --- [com.codefinity.firstrestapiooks] [ main] o.s.boot.tomcat.TomcatWebServer : Tomcat initialized with port 8080 (http)
2026-04-28T18:14:33.923-05:00 INFO 25776 --- [com.codefinity.firstrestapiooks] [ main] o.apache.catalina.core.StandardService : Starting service [Tomcat]
2026-04-28T18:14:33.924-05:00 INFO 25776 --- [com.codefinity.firstrestapiooks] [ main] o.apache.catalina.core.StandardEngine : Starting Servlet engine: [Apache Tomcat/11.0.21]
2026-04-28T18:14:34.053-05:00 INFO 25776 --- [com.codefinity.firstrestapiooks] [ main] b.w.c.s.WebApplicationContextInitializer : Root WebApplicationContext: initialization completed in 2698 ms
2026-04-28T18:14:34.356-05:00 INFO 25776 --- [com.codefinity.firstrestapiooks] [ main] com.zaxxer.hikari.HikariDataSource : HikariPool-1 - Starting...
2026-04-28T18:14:35.202-05:00 INFO 25776 --- [com.codefinity.firstrestapiooks] [ main] com.zaxxer.hikari.pool.HikariPool : HikariPool-1 - Added connection com.mysql.cj.jdbc.ConnectionImpl@508ad266
2026-04-28T18:14:35.206-05:00 INFO 25776 --- [com.codefinity.firstrestapiooks] [ main] com.zaxxer.hikari.HikariDataSource : HikariPool-1 - Start completed.
2026-04-28T18:14:35.266-05:00 INFO 25776 --- [com.codefinity.firstrestapiooks] [ main] org.hibernate.orm.jpa : HHH008540: Processing PersistenceUnitInfo [name: default]
2026-04-28T18:14:35.400-05:00 INFO 25776 --- [com.codefinity.firstrestapiooks] [ main] org.hibernate.orm.core : HHH000001: Hibernate ORM core version 7.2.12.Final
2026-04-28T18:14:36.382-05:00 INFO 25776 --- [com.codefinity.firstrestapiooks] [ main] o.s.o.j.p.SpringPersistenceUnitInfo : No LoadTimeWeaver setup: ignoring JPA class transformer
2026-04-28T18:14:36.638-05:00 INFO 25776 --- [com.codefinity.firstrestapiooks] [ main] org.hibernate.orm.connections.pooling : HHH10001005: Database info:
Database JDBC URL [jdbc:mysql://localhost:3306/my_database]
Database driver: MySQL Connector/J
Database dialect: MySQLDialect
Database version: 8.0.46
Default catalog/schema: my_database/undefined
Autocommit mode: undefined/unknown
Isolation level: REPEATABLE_READ [default REPEATABLE_READ]
JDBC fetch size: none
Pool: DataSourceConnectionProvider
Minimum pool size: undefined/unknown
Maximum pool size: undefined/unknown
2026-04-28T18:14:37.463-05:00 INFO 25776 --- [com.codefinity.firstrestapiooks] [ main] org.hibernate.orm.core : HHH000489: No JTA platform available (set 'hibernate.transaction.jta.platform' to enable JTA platform integration)
2026-04-28T18:14:37.481-05:00 INFO 25776 --- [com.codefinity.firstrestapiooks] [ main] j.LocalContainerEntityManagerFactoryBean : Initialized JPA EntityManagerFactory for persistence unit 'default'
2026-04-28T18:14:37.704-05:00 WARN 25776 --- [com.codefinity.firstrestapiooks] [ 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
2026-04-28T18:14:38.112-05:00 INFO 25776 --- [com.codefinity.firstrestapiooks] [ main] o.s.boot.tomcat.TomcatWebServer : Tomcat started on port 8080 (http) with context path '/'
2026-04-28T18:14:38.117-05:00 INFO 25776 --- [com.codefinity.firstrestapiooks] [ main] o.c.c.c.firstrestapibooks.Application : Started Application in 8.265 seconds (process running for 9.983)
2026-04-28T18:14:38.120-05:00 WARN 25776 --- [com.codefinity.firstrestapiooks] [ main] o.s.core.events.SpringDocAppInitializer : SpringDoc /v3/api-docs endpoint is enabled by default. To disable it in production, set the property 'springdoc.api-docs.enabled=false'
2026-04-28T18:14:38.120-05:00 WARN 25776 --- [com.codefinity.firstrestapiooks] [ main] o.s.core.events.SpringDocAppInitializer : SpringDoc /swagger-ui.html endpoint is enabled by default. To disable it in production, set the property 'springdoc.swagger-ui.enabled=false'```
Ответить

Быстрый ответ

Изменение регистра текста: 
Смайлики
:) :( :oops: :roll: :wink: :muza: :clever: :sorry: :angel: :read: *x)
Ещё смайлики…
   
К этому ответу прикреплено по крайней мере одно вложение.

Если вы не хотите добавлять вложения, оставьте поля пустыми.

Максимально разрешённый размер вложения: 15 МБ.

Вернуться в «JAVA»