M7Eyb4zJ

12018-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]
22018-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.
3	
4@Configuration
5@EnableTransactionManagement
6public class Configuracion {
7
8    @Bean(name = "mysqlMysql")
9    @Primary
10    @ConfigurationProperties(prefix = "spring.mysql")
11    public DataSource mysqlDataSourceMysql() {
12        return DataSourceBuilder.create().build();
13    }
14
15    @Bean(name = "jdbcTemplateMysql")
16    public JdbcTemplate jdbcTemplateMysql(@Qualifier("mysqlMysql") DataSource dsMySQL) {
17        return new JdbcTemplate(dsMySQL);
18    }
19
20    @Bean(name = "transactionManagerMysql")
21    public PlatformTransactionManager transactionManagerMysql(@Qualifier("mysqlMysql") DataSource dsMySQL) {
22        return new DataSourceTransactionManager(dsMySQL);
23    }
24
25    @Bean(name = "transactionTemplateMysql")
26    public TransactionTemplate transactionTemplateMysql(@Qualifier("transactionManagerMysql")PlatformTransactionManager platformTransactionManager) {
27        return new TransactionTemplate(platformTransactionManager);
28    }
29
30    /*H2*/
31
32    @Bean(name = "mysqlH2")
33    @ConfigurationProperties(prefix = "spring.datasource")
34    public DataSource mysqlDataSourceH2() {
35        return DataSourceBuilder.create().build();
36    }
37
38    @Bean(name = "jdbcTemplateH2")
39    public JdbcTemplate jdbcTemplateH2(@Qualifier("mysqlH2") DataSource dsMySQL) {
40        return new JdbcTemplate(dsMySQL);
41    }
42
43    @Bean(name = "transactionManagerH2")
44    public PlatformTransactionManager transactionManagerH2(@Qualifier("mysqlH2") DataSource dsMySQL) {
45        return new DataSourceTransactionManager(dsMySQL);
46    }
47
48    @Bean(name = "transactionTemplateH2")
49    public TransactionTemplate transactionTemplateH2(@Qualifier("transactionManagerH2")PlatformTransactionManager platformTransactionManager) {
50        return new TransactionTemplate(platformTransactionManager);
51    }
52
53}
54	
55spring:
56  mysql:
57    url: jdbc:mysql://localhost:3306/banco?useOldAliasMetadataBehavior=true&noAccessToProcedureBodies=true&useUnicode=yes&characterEncoding=utf8&useSSL=false
58    username: user
59    password: pass
60    driver-class-name: com.mysql.jdbc.Driver
61  datasource:
62    url: jdbc:h2:mem:test
63    username: sa
64    password:
65    driver-class-name: org.h2.Driver
66  h2:
67    console:
68      enabled: true
69      path: /h2
70server:
71  port: 7878
72	
73create table if not exists student
74(
75   id integer not null,
76   name varchar(255) not null,
77   passport_number varchar(255) not null,
78   primary key(id)
79);