2018-02-22 08:04:58.889  INFO 5524 --- [main] o.s.jdbc.datasource.init.ScriptUtils     : Executing SQL script from URL [file:/C:/workspace/MSprueba/target/classes/schema.sql]
2018-02-22 08:04:58.898  INFO 5524 --- [main] o.s.jdbc.datasource.init.ScriptUtils     : Executed SQL script from URL [file:/C:/workspace/MSprueba/target/classes/schema.sql] in 9 ms.

@Configuration
@EnableTransactionManagement
public class Configuracion {

    @Bean(name = "mysqlMysql")
    @Primary
    @ConfigurationProperties(prefix = "spring.mysql")
    public DataSource mysqlDataSourceMysql() {
        return DataSourceBuilder.create().build();
    }

    @Bean(name = "jdbcTemplateMysql")
    public JdbcTemplate jdbcTemplateMysql(@Qualifier("mysqlMysql") DataSource dsMySQL) {
        return new JdbcTemplate(dsMySQL);
    }

    @Bean(name = "transactionManagerMysql")
    public PlatformTransactionManager transactionManagerMysql(@Qualifier("mysqlMysql") DataSource dsMySQL) {
        return new DataSourceTransactionManager(dsMySQL);
    }

    @Bean(name = "transactionTemplateMysql")
    public TransactionTemplate transactionTemplateMysql(@Qualifier("transactionManagerMysql")PlatformTransactionManager platformTransactionManager) {
        return new TransactionTemplate(platformTransactionManager);
    }

    /*H2*/

    @Bean(name = "mysqlH2")
    @ConfigurationProperties(prefix = "spring.datasource")
    public DataSource mysqlDataSourceH2() {
        return DataSourceBuilder.create().build();
    }

    @Bean(name = "jdbcTemplateH2")
    public JdbcTemplate jdbcTemplateH2(@Qualifier("mysqlH2") DataSource dsMySQL) {
        return new JdbcTemplate(dsMySQL);
    }

    @Bean(name = "transactionManagerH2")
    public PlatformTransactionManager transactionManagerH2(@Qualifier("mysqlH2") DataSource dsMySQL) {
        return new DataSourceTransactionManager(dsMySQL);
    }

    @Bean(name = "transactionTemplateH2")
    public TransactionTemplate transactionTemplateH2(@Qualifier("transactionManagerH2")PlatformTransactionManager platformTransactionManager) {
        return new TransactionTemplate(platformTransactionManager);
    }

}

spring:
  mysql:
    url: jdbc:mysql://localhost:3306/banco?useOldAliasMetadataBehavior=true&noAccessToProcedureBodies=true&useUnicode=yes&characterEncoding=utf8&useSSL=false
    username: user
    password: pass
    driver-class-name: com.mysql.jdbc.Driver
  datasource:
    url: jdbc:h2:mem:test
    username: sa
    password:
    driver-class-name: org.h2.Driver
  h2:
    console:
      enabled: true
      path: /h2
server:
  port: 7878

create table if not exists student
(
   id integer not null,
   name varchar(255) not null,
   passport_number varchar(255) not null,
   primary key(id)
);