spring-boot with flyway and how to get your tests working

spring-boot with flyway and how to get your tests working published on No Comments on spring-boot with flyway and how to get your tests working

Problem You have a spring boot application with flyway migration scripts for a MySQL database. Now your tests are failing because you don’t have the database available during unit testing and flyway is complaining. Solution Use an in memory H2 database in MySql mode. How Create a file called flyway_init.sql in src/test/resources with the following… Continue reading spring-boot with flyway and how to get your tests working

Force an unlock of MySQL tables if locked

Force an unlock of MySQL tables if locked published on No Comments on Force an unlock of MySQL tables if locked

How to fix an unlocked table. Sometimes you have a locked table when something went wrong and you can not go on without it being unlocked. here is how to do that. 1) Enter MySQL mysql -u your_user -p 2) Let’s see the list of locked tables show open tables where in_use>0; 3) Look at… Continue reading Force an unlock of MySQL tables if locked

Creating a MySQL DataSource using WebSphere Application Server

Creating a MySQL DataSource using WebSphere Application Server published on No Comments on Creating a MySQL DataSource using WebSphere Application Server

Problem You want to add a MySQL DataSource to your WebSphere Application Server. Solution Creating a JDBC MySQL data source involves three independent steps, all accomplished with the WebSphere Application Server’s Administrative Console facility. In order, these three steps are: * Create a MySQL JDBC provider. * Create the basic MySQL data source configuration. *… Continue reading Creating a MySQL DataSource using WebSphere Application Server