: Link to Liquibase/WildFly article added.Meanwhile I’ve written another article covering Liquibase as database migration framework and Wildfly as application server: “ Java EE 7 Database Migrations with Liquibase and Wildfly“. Embedded GlassFish Maven Project Documentation.We should now be able to run the servlet when opening the following URL in a browser: (or git clone https: // /hascode /flyway-migrations-tutorial.git Resources
INFO: Successfully applied 4 migrations to schema "APP" (execution time 00:00.540s ). INFO: Migrating schema "APP" to version 201305162030Ħ: 14: 50 PM .command.DbMigrate logSummary INFO: Migrating schema "APP" to version 201305011700 INFO: Migrating schema "APP" to version 201304171620 INFO: Migrating schema "APP" to version 201304161230 "schema_version"Ħ: 14: 50 PM .command.DbMigrate migrateĦ: 14: 50 PM .command.DbMigrate applyMigration INFO: migrate task: 201306252219 : Do some stuff from file: V201306252219_Do_some_stuff.sqlĦ: 14: 50 PM .metadatatable.MetaDataTableImpl createIfNotExists INFO: migrate task: 201305162030 : Insert additional books from file: db.migration.V201305162030_Insert_additional_books
INFO: migrate task: 201305011700 : Alter book table add author from file: V201305011700_Alter_book_table_add_author.sql Migration file added: V201304161230_Create_book_table.sqlĦ: 14: 50 PM onStartup We’re adding three SQL scripts here: Creating a Table Most times I’m using the current date in the format yyyyMMddhhmm as number e.g. in src/main/resources and add a file in the format V_A_descriptive_title.sql to this directory. 2.1.1 glassfish-embedded-all 3.1.2.2 provided org.hibernate hibernate-entitymanager 4.2.0.Final flyway-core $ SQL Script MigrationsĪdding SQL scripts for database migrations is simple: Just add a directory db/migration e.g.
0 kommentar(er)
