Я настроил свое приложение 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'```
Flyway не создает таблицы при запуске приложения ⇐ JAVA
Программисты JAVA общаются здесь
-
Anonymous
1777418500
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'```
Ответить
1 сообщение
• Страница 1 из 1
Перейти
- Кемерово-IT
- ↳ Javascript
- ↳ C#
- ↳ JAVA
- ↳ Elasticsearch aggregation
- ↳ Python
- ↳ Php
- ↳ Android
- ↳ Html
- ↳ Jquery
- ↳ C++
- ↳ IOS
- ↳ CSS
- ↳ Excel
- ↳ Linux
- ↳ Apache
- ↳ MySql
- Детский мир
- Для души
- ↳ Музыкальные инструменты даром
- ↳ Печатная продукция даром
- Внешняя красота и здоровье
- ↳ Одежда и обувь для взрослых даром
- ↳ Товары для здоровья
- ↳ Физкультура и спорт
- Техника - даром!
- ↳ Автомобилистам
- ↳ Компьютерная техника
- ↳ Плиты: газовые и электрические
- ↳ Холодильники
- ↳ Стиральные машины
- ↳ Телевизоры
- ↳ Телефоны, смартфоны, плашеты
- ↳ Швейные машинки
- ↳ Прочая электроника и техника
- ↳ Фототехника
- Ремонт и интерьер
- ↳ Стройматериалы, инструмент
- ↳ Мебель и предметы интерьера даром
- ↳ Cантехника
- Другие темы
- ↳ Разное даром
- ↳ Давай меняться!
- ↳ Отдам\возьму за копеечку
- ↳ Работа и подработка в Кемерове
- ↳ Давай с тобой поговорим...
Мобильная версия