title: H2 Embedded database not picking up properties during test on spring boot
body: <p>I am trying to create a test that uses an embedded H2 database. But I have to change the spring.datasource.url, I cannot use the default one that is created by spring boot. (this is because I have to change the mode of the H2 database to MYSQL)</p>
  
  <p>This is my <code>test class</code>:</p>
  
  <pre><code>@JdbcTest
  @RunWith(SpringRunner.class)
  @ActiveProfiles("test")
  public class DemoApplicationTests {
  
      @Autowired
      JdbcTemplate jdbcTemplate;
  
      @Autowired
      DataSource dataSource;
  
      @Test
      public void contextLoads() {
          System.out.println(dataSource);
     }
  }
  </code></pre>
  
  <p>This is my <code>application-test.properties</code>:</p>
  
  <pre><code> spring.datasource.url=jdbc:h2:mem:testdb;DB_CLOSE_DELAY=-1;DB_CLOSE_ON_EXIT=FALSE;MODE=MYSQL
   spring.datasource.username=dbuser
   spring.datasource.password=dbpass
  </code></pre>
  
  <p>My dependencies:</p>
  
  <pre><code>compile('org.springframework.boot:spring-boot-starter-batch')
  runtime('com.h2database:h2')
  compile group: 'org.springframework.boot', name: 'spring-boot-starter-jdbc', version: '1.5.3.RELEASE'
  compile group: 'org.springframework.boot', name: 'spring-boot-starter-test', version: '1.5.3.RELEASE'
  </code></pre>
  
  <p>The console output:</p>
  
  <blockquote>
    <p>Starting embedded database: url='jdbc:h2:mem:bfad6b71-3e2d-4a47-a32d-c76988b3c5f6;DB_CLOSE_DELAY=-1;DB_CLOSE_ON_EXIT=false', username='sa'</p>
  </blockquote>
  
  <p>I would expect the url to be something like this: <code>jdbc:h2:mem:testdb</code>, I also want it to pick up the <code>MODE=MYSQL</code> setting.</p>
  
  <p>I tried to follow <a href="https://stackoverflow.com/questions/42364935/how-to-add-the-mode-mysql-to-embedded-h2-db-in-spring-boot-1-4-1-for-datajpates">this post</a>, but it didn't work.</p>